|
SELECT A.SETID , A.CATALOG_ID , 'C' , ' ' , 'REQUESTOR_ID' , A.REQUESTOR_ID FROM PS_REQUESTOR_CAT A , PS_REQUESTOR_TBL B WHERE A.REQUESTOR_ID = B.REQUESTOR_ID AND B.ACTIVE_FLG = 'Y' AND B.USE_ASSGN_CAT_ONLY = 'Y' UNION SELECT L.SETID ,L.PV_REQ_CAT_DESCR , L.CATALOG_TYPE , L.SETID_SECTYPE , L.PV_SECURITY_TYPE , L.PV_VALUE FROM PS_PV_CAT_SEC_LINE L , PS_PV_CAT_SEC_HDR H WHERE H.SETID_SECTYPE= L.SETID_SECTYPE AND H.PV_SECURITY_TYPE = L.PV_SECURITY_TYPE AND H.PV_VALUE = L.PV_VALUE AND H.PV_ENABLED = 'Y' AND L.PV_SECURITY_TYPE = 'REQUESTOR_ID'
|