SELECT TO_CHAR(SRC.REFERENCE_ID) , SRC.REQ_NUM , -SRC.AMOUNT , SRC.LINE_NUMBER , L.MEANING , HR.NAME FROM CE_PO_FC_REQUISITIONS_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.REQ_NUM , -SRC.AMOUNT , SRC.LINE_NUMBER , L.MEANING , HR.NAME FROM CE_PO_FC_REQUISITIONS_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'))