INV_RTV_FS

(SQL View)
 Index Back

Inventory RTV Selection View -


SELECT C.BUSINESS_UNIT , C.RTV_ID , C.RTV_LN_NBR , C.RTV_DISTRIB_NUM , B.INV_ITEM_ID , 'N' , B.ITM_SETID , C.LOT_ID , C.SERIAL_ID , (C.QTY_AM_RETRN_SUOM - C.QTY_AM_SHIP_SUOM) , C.QTY_AM_RETRN_SUOM , C.QTY_AM_RETRN_VUOM , B.UNIT_MEASURE_STD , B.CONVERSION_RATE , C.BUSINESS_UNIT_IN , C.BUSINESS_UNIT_RECV , C.RECV_SHIP_SEQ_NBR , C.REQUEST_DATE , A.VENDOR_SETID , A.VENDOR_ID , B.RMA_ID , B.RMA_LINE_NBR , C.SHIP_DATE , B.SHIP_TYPE_ID , C.RTV_DIST_STATUS , C.QTY_AM_SHIP_SUOM , C.QTY_AM_SHIP_VUOM , B.UNIT_MEASURE_VNDR , B.CARRIER_ID , B.PRICE_PO , B.IST_TXN_FLG FROM PS_RTV_HDR A , PS_RTV_LN B , PS_RTV_LN_DISTRIB C WHERE A.RTV_STATUS = 'O' AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.RTV_ID = B.RTV_ID AND B.BUSINESS_UNIT = C.BUSINESS_UNIT AND B.RTV_ID = C.RTV_ID AND B.RTV_LN_NBR = C.RTV_LN_NBR AND B.INV_FLG = 'Y' AND ( B.RTV_LN_STATUS = 'O' OR B.RTV_LN_STATUS = 'S' ) AND B.DISPOSITION_TYPE <> '1' AND ( C.RTV_DIST_STATUS = 'O' OR C.RTV_DIST_STATUS = 'S' ) AND C.QTY_AM_RETRN_SUOM > C.QTY_AM_SHIP_SUOM

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 RTV_ID Character(10) VARCHAR2(10) NOT NULL Return To Vendor ID
3 RTV_LN_NBR Number(5,0) INTEGER NOT NULL Return To Vendor Line
4 RTV_DISTRIB_NUM Number(5,0) INTEGER NOT NULL RTV Distribution Number
5 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
6 CB_SELECT_RTV Character(1) VARCHAR2(1) NOT NULL Select Return to Vendor

Y/N Table Edit

Default Value: N

7 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
8 LOT_ID Character(15) VARCHAR2(15) NOT NULL Lot ID
9 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID
10 QTY_RETRN_INV Signed Number(17,4) DECIMAL(15,4) NOT NULL Inventory Return Qty
11 QTY_AM_RETRN_SUOM Number(16,4) DECIMAL(15,4) NOT NULL Std Returned Qty
12 QTY_AM_RETRN_VUOM Number(16,4) DECIMAL(15,4) NOT NULL Vendor Returned Qty
13 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure
14 CONVERSION_RATE Signed Number(17,8) DECIMAL(15,8) NOT NULL Conversion Rate
15 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit
16 BUSINESS_UNIT_RECV Character(5) VARCHAR2(5) NOT NULL Receiving Business Unit
17 RECV_SHIP_SEQ_NBR Number(3,0) SMALLINT NOT NULL Receiver Shipping Sequence
18 REQUEST_DATE Date(10) DATE Requested
19 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
20 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
21 RMA_ID Character(10) VARCHAR2(10) NOT NULL RMA Number
22 RMA_LINE_NBR Number(5,0) INTEGER NOT NULL RMA Line Number
23 SHIP_DATE Date(10) DATE Item Shipping Date
24 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code
25 RTV_DIST_STATUS Character(1) VARCHAR2(1) NOT NULL RTV Distribution Status
C=Closed
O=Open
S=Shipped
X=Cancelled
26 QTY_AM_SHIP_SUOM Number(16,4) DECIMAL(15,4) NOT NULL Returned Base
27 QTY_AM_SHIP_VUOM Number(16,4) DECIMAL(15,4) NOT NULL Supplier Shipped Qty
28 UNIT_MEASURE_VNDR Character(3) VARCHAR2(3) NOT NULL Vendor Unit of Measure
29 CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier ID
30 PRICE_PO Signed Number(17,5) DECIMAL(15,5) NOT NULL Purchase Order Price
31 IST_TXN_FLG Character(1) VARCHAR2(1) NOT NULL Intrastat Transaction Flag
N=No
Y=Yes