SELECT SRC.PROJECT_ID || 'X' || SRC.EVENT_NUM , SRC.EVENT_NUM , SRC.AMOUNT , SRC.TRX_NUMBER , SRC.LINE_NUM , L.MEANING , HR.NAME FROM PA_CE_BILLING_EVENTS_V SRC , FND_LOOKUP_VALUES L , HR_OPERATING_UNITS HR WHERE L.LOOKUP_TYPE = 'INVOICE LINE TYPE' AND L.LOOKUP_CODE = SRC.INVOICE_LINE_TYPE 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'))