SELECT TO_CHAR(SRC.REFERENCE_ID) , SRC.PO_NUM , -SRC.AMOUNT , SRC.LINE_NUMBER , L.MEANING , SRC.PAYMENT_PRIORITY , SRC.VENDOR_TYPE , SRC.PAYGROUP , NULL , HR.NAME FROM CE_PO_FC_ORDERS_V SRC , FND_LOOKUP_VALUES L , HR_OPERATING_UNITS HR WHERE L.LOOKUP_TYPE = 'AUTHORIZATION STATUS' AND L.LOOKUP_CODE = SRC.STATUS AND L.LANGUAGE = USERENV('LANG') AND HR.ORGANIZATION_ID(+) = SRC.ORG_ID AND (SRC.ORG_ID IS NULL OR EXISTS (SELECT NULL FROM CE_SECURITY_PROFILES_V SEC WHERE SEC.ORGANIZATION_ID = SRC.ORG_ID AND SEC.ORGANIZATION_TYPE = 'OPERATING_UNIT')) UNION ALL SELECT TO_CHAR(SRC.REFERENCE_ID) , SRC.PO_NUM , -SRC.AMOUNT , SRC.LINE_NUMBER , L.MEANING , SRC.PAYMENT_PRIORITY , SRC.VENDOR_TYPE , SRC.PAYGROUP , AP.NAME , HR.NAME FROM CE_PO_FC_ORDERS_TERMS_V SRC , FND_LOOKUP_VALUES L , AP_TERMS AP , HR_OPERATING_UNITS HR WHERE L.LOOKUP_TYPE = 'AUTHORIZATION STATUS' AND L.LOOKUP_CODE = SRC.STATUS AND L.LANGUAGE = USERENV('LANG') AND AP.TERM_ID = SRC.TERM_ID AND HR.ORGANIZATION_ID(+) = SRC.ORG_ID AND (SRC.ORG_ID IS NULL OR EXISTS (SELECT NULL FROM CE_SECURITY_PROFILES_V SEC WHERE SEC.ORGANIZATION_ID = SRC.ORG_ID AND SEC.ORGANIZATION_TYPE = 'OPERATING_UNIT')) UNION ALL SELECT TO_CHAR(SRC.REFERENCE_ID) , SRC.PO_NUM , -SRC.AMOUNT , SRC.LINE_NUMBER , L.MEANING , SRC.PAYMENT_PRIORITY , SRC.VENDOR_TYPE , SRC.PAYGROUP , NULL , HR.NAME FROM CE_PO_FC_ORDERS_TEMP_V SRC , FND_LOOKUP_VALUES L , HR_OPERATING_UNITS HR WHERE L.LOOKUP_TYPE = 'AUTHORIZATION STATUS' AND L.LOOKUP_CODE = SRC.STATUS AND L.LANGUAGE = USERENV('LANG') AND HR.ORGANIZATION_ID(+) = SRC.ORG_ID AND (SRC.ORG_ID IS NULL OR EXISTS (SELECT NULL FROM CE_SECURITY_PROFILES_V SEC WHERE SEC.ORGANIZATION_ID = SRC.ORG_ID AND SEC.ORGANIZATION_TYPE = 'OPERATING_UNIT')) UNION ALL SELECT TO_CHAR(SRC.REFERENCE_ID) , SRC.PO_NUM , -SRC.AMOUNT , SRC.LINE_NUMBER , L.MEANING , SRC.PAYMENT_PRIORITY , SRC.VENDOR_TYPE , SRC.PAYGROUP , AP.NAME , HR.NAME FROM CE_PO_FC_ORDERS_TERMS_TEMP_V SRC , FND_LOOKUP_VALUES L , AP_TERMS AP , HR_OPERATING_UNITS HR WHERE L.LOOKUP_TYPE = 'AUTHORIZATION STATUS' AND L.LOOKUP_CODE = SRC.STATUS AND L.LANGUAGE = USERENV('LANG') AND AP.TERM_ID = SRC.TERM_ID AND HR.ORGANIZATION_ID(+) = SRC.ORG_ID AND (SRC.ORG_ID IS NULL OR EXISTS (SELECT NULL FROM CE_SECURITY_PROFILES_V SEC WHERE SEC.ORGANIZATION_ID = SRC.ORG_ID AND SEC.ORGANIZATION_TYPE = 'OPERATING_UNIT'))