RTV_RMA_VW

(SQL View)
 Index Back

SELECT DISTINCT A.RMA_ID , B.RTV_ID FROM PS_RTV_LN A , PS_RTV_HDR B , PSOPRDEFN O WHERE A.RTV_ID=B.RTV_ID AND B.RTV_STATUS IN ('O','S') AND A.BUSINESS_UNIT=B.BUSINESS_UNIT AND B.BUYER_ID=O.OPRID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RMA_ID Character(10) VARCHAR2(10) NOT NULL RMA Number
2 RTV_ID Character(10) VARCHAR2(10) NOT NULL Return To Vendor ID

Default Value: NEXT