SCP_POA_BO_VWFL

(SQL View)
 Index Back

Buying Organization

POA - Buying Organization

SELECT DISTINCT A.OPRID , B.BUSINESS_UNIT_PO FROM PS_SCPVNDUSR_VW_FL A , PS_PO_POA_SRCH_VW9 B WHERE A.SETID=B.VENDOR_SETID AND A.VENDOR_ID=B.VENDOR_ID UNION SELECT 'ALL' ,'All' FROM PS_INSTALLATION

# 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_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit