PO_RTV_DIS_EVW1

(SQL View)
 Index Back

RTV Dispatch Stage View

This view is used in the RTV Message definition SELECT A.BUSINESS_UNIT , A.RTV_ID , C.VENDOR_SETID , C.VENDOR_ID , C.VNDR_LOC , A.RTV_LN_NBR , A.RTV_DISTRIB_NUM , A.QTY_AM_RETRN_VUOM , A.LOT_ID , A.SERIAL_ID , A.PROCESS_INSTANCE , A.AUDIT_ACTN , A.IN_PROCESS_FLG FROM PS_RTV_DISPDIST_EC A , PS_RTV_DISPLN_EC B , PS_RTV_DISPHDR_EC C WHERE C.EIP_CTL_ID = B.EIP_CTL_ID AND B.EIP_CTL_ID = A.EIP_CTL_ID AND C.BUSINESS_UNIT = B.BUSINESS_UNIT AND B.BUSINESS_UNIT = A.BUSINESS_UNIT AND C.RTV_ID = B.RTV_ID AND B.RTV_ID = A.RTV_ID AND B.RTV_LN_NBR = A.RTV_LN_NBR

SELECT A.BUSINESS_UNIT , A.RTV_ID , A.VENDOR_SETID , A.VENDOR_ID , A.VNDR_LOC , A.RTV_LN_NBR , A.RTV_DISTRIB_NUM , A.QTY_AM_RETRN_VUOM , A.LOT_ID , A.SERIAL_ID , A.PROCESS_INSTANCE , A.AUDIT_ACTN , A.IN_PROCESS_FLG FROM PS_RTV_DISPDIST_EC A

# 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 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
4 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
5 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
6 RTV_LN_NBR Number(5,0) INTEGER NOT NULL Return To Vendor Line
7 RTV_DISTRIB_NUM Number(5,0) INTEGER NOT NULL RTV Distribution Number
8 QTY_AM_RETRN_VUOM Number(16,4) DECIMAL(15,4) NOT NULL Vendor Returned Qty
9 LOT_ID Character(15) VARCHAR2(15) NOT NULL Lot ID
10 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID
11 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
12 AUDIT_ACTN Character(1) VARCHAR2(1) NOT NULL Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
A=Add
C=Change Old (PPR Only)
D=Delete
K=Change - Old Values
N=Change - New Values
O=Change - Original Values
13 IN_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL In process flag