SELECT TO_CHAR(SRC.REFERENCE_ID) , SRC.RECEIPT_NUMBER , SRC.AMOUNT , NVL(SRC.BASE_AMOUNT , SRC.AMOUNT) , L.MEANING , ARM.NAME , HR.NAME FROM CE_AR_FC_RECEIPTS_V SRC , FND_LOOKUP_VALUES L , AR_RECEIPT_METHODS ARM , HR_OPERATING_UNITS HR WHERE L.LOOKUP_TYPE = 'RECEIPT_CREATION_STATUS' AND L.LOOKUP_CODE(+) = SRC.STATUS AND L.LANGUAGE = USERENV('LANG') AND ARM.RECEIPT_METHOD_ID = SRC.RECEIPT_METHOD_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'))