VIEW: APPS.CE_FC_PAB_DISC_V

Source

View Text - Preformatted

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'))

View Text - HTML Formatted

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'))