VIEW: APPS.CE_FC_ARI_DISC_V

Source

View Text - Preformatted

SELECT to_char(src.reference_id), src.trx_number, src.amount, src.profile_class, src.dispute_amount, hr.name from ce_ar_fc_invoices_v src, hr_operating_units hr WHERE 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 'PA' || src.project_id || 'X' || src.trx_number || 'X' || src.line_num, to_char(src.trx_number), src.amount, cp_class.name, to_number(null), hr.name from pa_ce_invoices_v src, hz_cust_profile_classes cp_class, hr_operating_units hr where cp_class.profile_class_id = src.profile_class_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'))

View Text - HTML Formatted

SELECT TO_CHAR(SRC.REFERENCE_ID)
, SRC.TRX_NUMBER
, SRC.AMOUNT
, SRC.PROFILE_CLASS
, SRC.DISPUTE_AMOUNT
, HR.NAME
FROM CE_AR_FC_INVOICES_V SRC
, HR_OPERATING_UNITS HR
WHERE 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 'PA' || SRC.PROJECT_ID || 'X' || SRC.TRX_NUMBER || 'X' || SRC.LINE_NUM
, TO_CHAR(SRC.TRX_NUMBER)
, SRC.AMOUNT
, CP_CLASS.NAME
, TO_NUMBER(NULL)
, HR.NAME
FROM PA_CE_INVOICES_V SRC
, HZ_CUST_PROFILE_CLASSES CP_CLASS
, HR_OPERATING_UNITS HR
WHERE CP_CLASS.PROFILE_CLASS_ID = SRC.PROFILE_CLASS_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'))