EM_RCITMSRCH_VW

(SQL View)
 Index Back

SELECT G.OPRID , A.VENDOR_SETID , F.VENDOR_ID , A.BUSINESS_UNIT , A.RECEIVER_ID , B.RECV_LN_NBR , B.RECV_SHIP_SEQ_NBR , B.BUSINESS_UNIT_PO , A.RECEIPT_DT , F.NAME1 , A.ORIGIN , B.CURRENCY_CD , C.SETID , C.INV_ITEM_ID , D.DESCR , B.QTY_SH_ACCPT_VUOM - H.QTY_MATCHED , B.PRICE_PO , B.RECEIVE_UOM , B.PACKSLIP_NO , B.CURRENCY_CD ,%Round( %DecMult((B.QTY_SH_ACCPT_VUOM - H.QTY_MATCHED), B.PRICE_PO),3) , B.MFG_ID , B.MFG_ITM_ID , B.UPN_TYPE_CD , B.UPN_ID FROM PS_RECV_HDR_FS A , PS_RECV_LN_SHIP_FS B , PS_ITM_VENDOR C , PS_PURCH_ITEM_ATTR D , PS_MASTER_ITEM_TBL E , PS_VENDOR F , PS_VENDOR_USER G , PS_RECV_LN_SHP_MTH H WHERE B.BUSINESS_UNIT = A.BUSINESS_UNIT AND B.RECEIVER_ID = A.RECEIVER_ID AND C.VENDOR_SETID = A.VENDOR_SETID AND C.VENDOR_ID = A.VENDOR_ID AND B.INV_ITEM_ID = C.INV_ITEM_ID AND B.ITM_SETID = C.SETID AND D.SETID = C.SETID AND D.INV_ITEM_ID = C.INV_ITEM_ID AND E.SETID = D.SETID AND E.INV_ITEM_ID = D.INV_ITEM_ID AND E.ITM_STATUS_CURRENT = '1' AND F.SETID = A.VENDOR_SETID AND F.VENDOR_ID = A.VENDOR_ID AND G.VENDOR_ID = A.VENDOR_ID AND H.BUSINESS_UNIT = B.BUSINESS_UNIT AND H.RECEIVER_ID = B.RECEIVER_ID AND H.RECV_LN_NBR = B.RECV_LN_NBR AND B.QTY_SH_ACCPT_VUOM <> 0 AND NOT EXISTS ( SELECT 'X' FROM PS_PO_HDR_FS POHDR WHERE B.BUSINESS_UNIT_PO = POHDR.BUSINESS_UNIT AND B.PO_ID = POHDR.PO_ID AND POHDR.CC_USE_FLAG = 'Y')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
3 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
4 BUSINESS_UNIT_RECV Character(5) VARCHAR2(5) NOT NULL Receiving Business Unit
5 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number
6 RECV_LN_NBR Number(5,0) INTEGER NOT NULL Receipt Line
7 RECV_SHIP_SEQ_NBR Number(3,0) SMALLINT NOT NULL Receiver Shipping Sequence
8 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
9 RECEIPT_DT Date(10) DATE Received Date
10 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
11 ORIGIN Character(3) VARCHAR2(3) NOT NULL Origin
12 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
13 SETID Character(5) VARCHAR2(5) NOT NULL SetID
14 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
15 DESCR Character(30) VARCHAR2(30) NOT NULL Description
16 QTY_VCHR Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity Vouchered
17 UNIT_PRICE Signed Number(17,5) DECIMAL(15,5) NOT NULL Unit Price
18 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
19 PACKSLIP_NO Character(22) VARCHAR2(22) NOT NULL Packing Slip Number
20 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency
21 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
22 MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer ID
23 MFG_ITM_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer's Item ID
24 UPN_TYPE_CD Character(4) VARCHAR2(4) NOT NULL Universal Product Number Format Type
25 UPN_ID Character(20) VARCHAR2(20) NOT NULL Universal Product Number