SP_AMPO2_NONVW

(SQL View)
Index Back

Security View/ CON PO BUs


SELECT DISTINCT A.BUSINESS_UNIT_PO , A.PO_ID FROM PS_INTFC_PHY_A A WHERE A.PO_ID <> ' ' AND A.LOAD_STATUS = 'NEW'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order