VIEW: APPS.CE_FC_API_DISC_V

Source

View Text - Preformatted

SELECT to_char(src.reference_id), src.invoice_num, -src.amount, src.payment_priority, src.vendor_type, src.paygroup, decode(src.on_hold,'Y','Yes','No'), hr.name from ce_ap_fc_due_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 to_char(src.reference_id), src.invoice_num, -src.amount, src.payment_priority, src.vendor_type, src.paygroup, decode(src.on_hold,'Y','Yes','No'), hr.name from ce_due_project_inv_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'))

View Text - HTML Formatted

SELECT TO_CHAR(SRC.REFERENCE_ID)
, SRC.INVOICE_NUM
, -SRC.AMOUNT
, SRC.PAYMENT_PRIORITY
, SRC.VENDOR_TYPE
, SRC.PAYGROUP
, DECODE(SRC.ON_HOLD
, 'Y'
, 'YES'
, 'NO')
, HR.NAME
FROM CE_AP_FC_DUE_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 TO_CHAR(SRC.REFERENCE_ID)
, SRC.INVOICE_NUM
, -SRC.AMOUNT
, SRC.PAYMENT_PRIORITY
, SRC.VENDOR_TYPE
, SRC.PAYGROUP
, DECODE(SRC.ON_HOLD
, 'Y'
, 'YES'
, 'NO')
, HR.NAME
FROM CE_DUE_PROJECT_INV_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'))