CUSTPO_SS_VW

(SQL View)
 Index Back

View PO's for A Customer

View PO's for A Customer from the Sales Order

SELECT DISTINCT C.OPRID , S.BUSINESS_UNIT , S.CUSTOMER_PO , S.SHIP_TO_CUST_ID FROM PS_ORD_SCHEDULE S , PS_CUST_SSSHIP_VW C , PS_SET_CNTRL_REC R WHERE S.CUSTOMER_PO <> ' ' AND S.SHIP_TO_CUST_ID = C.SHIP_TO_CUST_ID AND R.RECNAME = 'CUSTOMER' AND R.SETCNTRLVALUE = S.BUSINESS_UNIT AND R.SETID = C.SETID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 CUSTOMER_PO Character(25) VARCHAR2(25) NOT NULL Customer PO
4 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer

Prompt Table: CUST_SSSHIP_VW