EM_RPITMSRCH_VW

(SQL View)
 Index Back

PO-Receive Item search


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 , B.PO_ID , A.RECEIPT_DT , F.NAME1 , A.ORIGIN , B.CURRENCY_CD , C.SETID , C.INV_ITEM_ID , D.DESCR ,B.LINE_NBR ,B.SCHED_NBR , B.QTY_SH_ACCPT_VUOM - H.QTY_MATCHED , B.PRICE_PO , I.UNIT_OF_MEASURE , B.PACKSLIP_NO , B.CURRENCY_CD ,%Round( %DecMult((B.QTY_SH_ACCPT_VUOM - H.QTY_MATCHED), B.PRICE_PO),3) , I.MFG_ID , I.MFG_ITM_ID , I.UPN_TYPE_CD , I.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 , PS_PO_LINE_FS I WHERE B.BUSINESS_UNIT = A.BUSINESS_UNIT AND B.RECEIVER_ID = A.RECEIVER_ID AND I.BUSINESS_UNIT=B.BUSINESS_UNIT_PO AND I.PO_ID=B.PO_ID AND I.LINE_NBR = B.LINE_NBR 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

# 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 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
10 RECEIPT_DT Date(10) DATE Received Date
11 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
12 ORIGIN Character(3) VARCHAR2(3) NOT NULL Origin
13 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
14 SETID Character(5) VARCHAR2(5) NOT NULL SetID
15 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
16 DESCR Character(30) VARCHAR2(30) NOT NULL Description
17 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
18 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
19 QTY_VCHR Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity Vouchered
20 UNIT_PRICE Signed Number(17,5) DECIMAL(15,5) NOT NULL Unit Price
21 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
22 PACKSLIP_NO Character(22) VARCHAR2(22) NOT NULL Packing Slip Number
23 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency
24 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
25 MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer ID
26 MFG_ITM_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer's Item ID
27 UPN_TYPE_CD Character(4) VARCHAR2(4) NOT NULL Universal Product Number Format Type
28 UPN_ID Character(20) VARCHAR2(20) NOT NULL Universal Product Number