SCP_SE1_BO_VWFL

(SQL View)
 Index Back

Buying Organization

Multi Supplier - Buying Organization

SELECT DISTINCT '' AS OPRID , A.BUSINESS_UNIT AS BUSINESS_UNIT_SS FROM PS_SCP_SEC_AUC_VW A UNION SELECT 'ALL' AS OPRID ,'All' AS BUSINESS_UNIT_SS 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_SS Character(5) VARCHAR2(5) NOT NULL Strategic Sourcing BU