SP_BUINPM_OPRVW

(SQL View)
 Index Back

SELECT B.OPRID , A.BUSINESS_UNIT , A.DESCR FROM PS_BUS_UNIT_TBL_FS A , PS_SEC_BU_OPR B WHERE A.BUSINESS_UNIT=B.BUSINESS_UNIT AND (EXISTS( SELECT 'X' FROM PS_BUS_UNIT_TBL_IN WHERE BUSINESS_UNIT=A.BUSINESS_UNIT AND BU_STATUS='1') OR EXISTS( SELECT 'X' FROM PS_BUS_UNIT_TBL_PM WHERE BUSINESS_UNIT=A.BUSINESS_UNIT))

# 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description