PV_RTV_HDR_VW

(SQL View)
 Index Back

Return Search View

Based on RTV_HDR_VW used for ePro prompt due to label change

SELECT DISTINCT H.BUSINESS_UNIT , H.RTV_ID , H.BUYER_ID , A.NAME1 , A.VENDOR_NAME_SHORT , H.CARRIER_ID , H.FREIGHT_TERMS , L.PO_ID , L.RECEIVER_ID , L.RMA_ID , H.RTV_STATUS , H.SHIP_TYPE_ID , H.VENDOR_SETID , H.VENDOR_ID FROM PS_RTV_HDR H ,PS_RTV_LN L ,PS_VENDOR A WHERE H.rtv_status IN ('O','S') AND H.BUSINESS_UNIT = L.BUSINESS_UNIT AND H.RTV_ID = L.RTV_ID AND H.VENDOR_SETID = A.SETID AND H.VENDOR_ID = A.VENDOR_ID

# 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

Default Value: NEXT

3 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer
4 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
5 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name
6 CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier ID

Prompt Table: CARRIER_ID_VW

7 FREIGHT_TERMS Character(10) VARCHAR2(10) NOT NULL Freight Terms Code

Prompt Table: FREIGHT_TERMS

8 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
9 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number
10 RMA_ID Character(10) VARCHAR2(10) NOT NULL RMA Number
11 RTV_STATUS Character(1) VARCHAR2(1) NOT NULL Return Status
C=Closed
O=Open
S=Shipped
X=Cancelled

Default Value: O

12 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code

Prompt Table: SHIP_METHOD_VW

13 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
14 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

Prompt Table: VENDOR_VW