|
SELECT (CASE WHEN BU_SECURITY = 'Y' THEN 'BUSINESS_UNIT' ELSE ' ' END) FIELDNAME1 FROM PS_INSTALLATION_FS WHERE SECURITY_TYPE<>'N' UNION SELECT (CASE WHEN SETID_SECURITY = 'Y' THEN 'SETID' ELSE ' ' END) FIELDNAME1 FROM PS_INSTALLATION_FS WHERE SECURITY_TYPE<>'N' UNION SELECT (CASE WHEN LEDGER_SECURITY = 'Y' THEN 'LEDGER' ELSE ' ' END) FIELDNAME1 FROM PS_INSTALLATION_FS WHERE SECURITY_TYPE<>'N' UNION SELECT (CASE WHEN BOOK_SECURITY = 'Y' THEN 'BOOK' ELSE ' ' END) FIELDNAME1 FROM PS_INSTALLATION_FS WHERE SECURITY_TYPE<>'N' UNION SELECT (CASE WHEN PYCYCL_SECURITY = 'Y' THEN 'PAY_CYCLE' ELSE ' ' END) FIELDNAME1 FROM PS_INSTALLATION_FS WHERE SECURITY_TYPE<>'N' UNION SELECT (CASE WHEN PL_PRBINS_SECURITY = 'Y' THEN 'PROBINST' ELSE ' ' END) FIELDNAME1 FROM PS_INSTALLATION_FS WHERE SECURITY_TYPE<>'N' UNION SELECT (CASE WHEN PROJECT_SECURITY = 'Y' THEN 'PROJECT_ID' ELSE ' ' END) FIELDNAME1 FROM PS_INSTALLATION_FS WHERE SECURITY_TYPE<>'N'
|