|
SELECT DISTINCT SU.OPRID ,SU.SETID , SU.ACCOUNT FROM PS_SEC_ACCT_USER SU , PS_GL_ACCOUNT_TBL CF1 , PS_INSTALLATION_FS I1 , PS_SEC_CF_PROD SP1 , PS_SEC_FIELDS_TBL SF1 WHERE SU.SETID = CF1.SETID AND SU.ACCOUNT = CF1.ACCOUNT AND SU.PRODSRCID = SP1.PRODSRCID AND I1.CF_SECURITY = '1' AND SP1.PRODSRCID='FGL' AND SP1.ACTIVE_PROD='A' AND SF1.FIELDNAME='ACCOUNT' AND SF1.ACTIVE_FLAG='A' UNION SELECT DISTINCT RU.ROLEUSER ,SR.SETID , SR.ACCOUNT FROM PS_SEC_ACCT_ROLE SR , PS_GL_ACCOUNT_TBL CF2 , PS_INSTALLATION_FS I2 , PS_SEC_CF_PROD SP2 , PS_SEC_FIELDS_TBL SF2 , PSROLEUSER RU WHERE SR.SETID = CF2.SETID AND SR.ACCOUNT = CF2.ACCOUNT AND SR.PRODSRCID = SP2.PRODSRCID AND I2.CF_SECURITY = '2' AND SP2.PRODSRCID='FGL' AND SP2.ACTIVE_PROD='A' AND SF2.FIELDNAME='ACCOUNT' AND SF2.ACTIVE_FLAG='A' AND RU.ROLENAME = SR.ROLENAME UNION SELECT DISTINCT OP.OPRID ,SC.SETID , SC.ACCOUNT FROM PS_SEC_ACCT_PERM SC , PS_GL_ACCOUNT_TBL CF3 , PS_INSTALLATION_FS I3 , PS_SEC_CF_PROD SP3 , PS_SEC_FIELDS_TBL SF3 , PSOPRDEFN OP WHERE SC.SETID = CF3.SETID AND SC.ACCOUNT = CF3.ACCOUNT AND SC.PRODSRCID = SP3.PRODSRCID AND I3.CF_SECURITY = '3' AND SP3.PRODSRCID='FGL' AND SP3.ACTIVE_PROD='A' AND SF3.FIELDNAME='ACCOUNT' AND SF3.ACTIVE_FLAG='A' AND OP.ROWSECCLASS = SC.ROWSECCLASS UNION SELECT DISTINCT 'ALLUSERS' AS OPRID , CF4.SETID , CF4.ACCOUNT FROM PS_GL_ACCOUNT_TBL CF4 , PS_INSTALLATION_FS I4 , PS_SEC_CF_PROD SP4 , PS_SEC_FIELDS_TBL SF4 WHERE I4.CF_SECURITY = '0' OR (SP4.PRODSRCID = 'FGL' AND SP4.ACTIVE_PROD = 'I') OR (SP4.PRODSRCID = 'FGL' AND SP4.ACTIVE_PROD = 'A' AND SF4.FIELDNAME='ACCOUNT' AND SF4.ACTIVE_FLAG='I') UNION SELECT DISTINCT 'ALLUSERS' AS OPRID , CF5.SETID , ' ' AS ACCOUNT FROM PS_GL_ACCOUNT_TBL CF5 UNION SELECT 'ALLUSERS' AS OPRID , ' ' AS SETID , ' ' AS ACCOUNT FROM PS_INSTALLATION_FS
|
USERID