[Home] [Help]
View: CE_FC_XTR_DISC_V
View Text
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'))
Columns
| Name |
| REFERENCE_ID |
| DEAL_NUMBER |
| TRX_AMOUNT |
| BANK_ACCOUNT_AMOUNT |
| DEAL_TYPE |
| DEAL_SUBTYPE |
| COUNTERPARTY |
| AMOUNT_TYPE |
| TRANSACTION_NUMBER |
APPS.CE_FC_XTR_DISC_V