VIEW: APPS.CE_FC_POP_DISC_V

Source

View Text - Preformatted

SELECT to_char(src.reference_id), src.po_num, -src.amount, src.line_number, l.meaning, src.payment_priority, src.vendor_type, src.paygroup, null, hr.name from ce_po_fc_orders_v src, fnd_lookup_values l, hr_operating_units hr WHERE l.lookup_type = 'AUTHORIZATION STATUS' and l.lookup_code = src.status 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')) UNION ALL SELECT to_char(src.reference_id), src.po_num, -src.amount, src.line_number, l.meaning, src.payment_priority, src.vendor_type, src.paygroup, ap.name, hr.name from ce_po_fc_orders_terms_v src, fnd_lookup_values l, ap_terms ap, hr_operating_units hr where l.lookup_type = 'AUTHORIZATION STATUS' and l.lookup_code = src.status and l.language = userenv('LANG') and ap.term_id = src.term_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')) UNION ALL SELECT to_char(src.reference_id), src.po_num, -src.amount, src.line_number, l.meaning, src.payment_priority, src.vendor_type, src.paygroup, null, hr.name from ce_po_fc_orders_temp_v src, fnd_lookup_values l, hr_operating_units hr where l.lookup_type = 'AUTHORIZATION STATUS' and l.lookup_code = src.status 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')) UNION ALL SELECT to_char(src.reference_id), src.po_num, -src.amount, src.line_number, l.meaning, src.payment_priority, src.vendor_type, src.paygroup, ap.name, hr.name from ce_po_fc_orders_terms_temp_v src, fnd_lookup_values l, ap_terms ap, hr_operating_units hr where l.lookup_type = 'AUTHORIZATION STATUS' and l.lookup_code = src.status and l.language = userenv('LANG') and ap.term_id = src.term_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.PO_NUM
, -SRC.AMOUNT
, SRC.LINE_NUMBER
, L.MEANING
, SRC.PAYMENT_PRIORITY
, SRC.VENDOR_TYPE
, SRC.PAYGROUP
, NULL
, HR.NAME
FROM CE_PO_FC_ORDERS_V SRC
, FND_LOOKUP_VALUES L
, HR_OPERATING_UNITS HR
WHERE L.LOOKUP_TYPE = 'AUTHORIZATION STATUS'
AND L.LOOKUP_CODE = SRC.STATUS
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')) UNION ALL SELECT TO_CHAR(SRC.REFERENCE_ID)
, SRC.PO_NUM
, -SRC.AMOUNT
, SRC.LINE_NUMBER
, L.MEANING
, SRC.PAYMENT_PRIORITY
, SRC.VENDOR_TYPE
, SRC.PAYGROUP
, AP.NAME
, HR.NAME
FROM CE_PO_FC_ORDERS_TERMS_V SRC
, FND_LOOKUP_VALUES L
, AP_TERMS AP
, HR_OPERATING_UNITS HR
WHERE L.LOOKUP_TYPE = 'AUTHORIZATION STATUS'
AND L.LOOKUP_CODE = SRC.STATUS
AND L.LANGUAGE = USERENV('LANG')
AND AP.TERM_ID = SRC.TERM_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')) UNION ALL SELECT TO_CHAR(SRC.REFERENCE_ID)
, SRC.PO_NUM
, -SRC.AMOUNT
, SRC.LINE_NUMBER
, L.MEANING
, SRC.PAYMENT_PRIORITY
, SRC.VENDOR_TYPE
, SRC.PAYGROUP
, NULL
, HR.NAME
FROM CE_PO_FC_ORDERS_TEMP_V SRC
, FND_LOOKUP_VALUES L
, HR_OPERATING_UNITS HR
WHERE L.LOOKUP_TYPE = 'AUTHORIZATION STATUS'
AND L.LOOKUP_CODE = SRC.STATUS
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')) UNION ALL SELECT TO_CHAR(SRC.REFERENCE_ID)
, SRC.PO_NUM
, -SRC.AMOUNT
, SRC.LINE_NUMBER
, L.MEANING
, SRC.PAYMENT_PRIORITY
, SRC.VENDOR_TYPE
, SRC.PAYGROUP
, AP.NAME
, HR.NAME
FROM CE_PO_FC_ORDERS_TERMS_TEMP_V SRC
, FND_LOOKUP_VALUES L
, AP_TERMS AP
, HR_OPERATING_UNITS HR
WHERE L.LOOKUP_TYPE = 'AUTHORIZATION STATUS'
AND L.LOOKUP_CODE = SRC.STATUS
AND L.LANGUAGE = USERENV('LANG')
AND AP.TERM_ID = SRC.TERM_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'))