VIEW: APPS.CE_FC_XTR_DISC_V

Source

View Text - Preformatted

SELECT to_char(src.reference_id), src.deal_number, src.amount, src.amount, src.dda_deal_type_name, src.dda_deal_subtype_name, src.counterparty, src.amount_type_name, src.transaction_number from ce_xtr_cashflows_v src WHERE (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 = 'LEGAL_ENTITY'))

View Text - HTML Formatted

SELECT TO_CHAR(SRC.REFERENCE_ID)
, SRC.DEAL_NUMBER
, SRC.AMOUNT
, SRC.AMOUNT
, SRC.DDA_DEAL_TYPE_NAME
, SRC.DDA_DEAL_SUBTYPE_NAME
, SRC.COUNTERPARTY
, SRC.AMOUNT_TYPE_NAME
, SRC.TRANSACTION_NUMBER
FROM CE_XTR_CASHFLOWS_V SRC
WHERE (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 = 'LEGAL_ENTITY'))