RTV_DST_INV_VW2

(SQL View)
 Index Back

RTV View of INV trans

RTV Distribution view of INV related transactions.

SELECT A.BUSINESS_UNIT , A.RTV_ID , A.RTV_LN_NBR , A.RTV_DISTRIB_NUM , A.BUSINESS_UNIT_IN , A.QTY_AM_SHIP_SUOM , A.QTY_AM_SHIP_VUOM , A.SHIP_DATE , A.RTV_DIST_STATUS FROM PS_RTV_LN_DISTRIB A , PS_RTV_LN B WHERE A.RTV_DIST_STATUS = 'O' AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.RTV_ID = B.RTV_ID AND A.RTV_LN_NBR = B.RTV_LN_NBR AND B.INV_FLG = 'Y' AND B.RTV_INV_OPTION IN ('1', '2') AND B.RTV_INV_STAT <> '9' AND B.DISPOSITION_TYPE = '0'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO 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 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit

Prompt Table: %EDIT_BU_IN

6 QTY_AM_SHIP_SUOM Number(16,4) DECIMAL(15,4) NOT NULL Returned Base
7 QTY_AM_SHIP_VUOM Number(16,4) DECIMAL(15,4) NOT NULL Supplier Shipped Qty
8 SHIP_DATE Date(10) DATE Item Shipping Date
9 RTV_DIST_STATUS Character(1) VARCHAR2(1) NOT NULL RTV Distribution Status
C=Closed
O=Open
S=Shipped
X=Cancelled