[Home] [Help]
View: CE_CP_XTI_V
Product: | CE - Cash Management |
Description: | Cash Positioning source for Discoverer - Treasury Inflow |
Implementation/DBA Data: |
APPS.CE_CP_XTI_V
|
View Text
SELECT DDA.DEAL_DATE_AMOUNT_ID
, BANK_ACCOUNT_ID
, NVL(DDA.ACTUAL_SETTLEMENT_DATE
, DDA.AMOUNT_DATE)
, DDA.DEAL_NUMBER
, DDA.CASHFLOW_AMOUNT
, DECODE(DDA.DEAL_TYPE
, 'EXP'
, DECODE(DDA.DEAL_SUBTYPE
, 'INDIC'
, 'Y'
, 'N')
, 'N')
, DDA.DEAL_TYPE
, DDA.RECONCILED_REFERENCE FROM XTR_DEAL_DATE_AMOUNTS DDA
, CE_BANK_ACCTS_GT_V CBA
, XTR_PARTY_INFO XP
WHERE DDA.STATUS_CODE <> 'CANCELLED' AND DDA.CASHFLOW_AMOUNT > 0
AND XP.LEGAL_ENTITY_ID = CBA.ACCOUNT_OWNER_ORG_ID AND XP.PARTY_CODE(+) = DDA.COMPANY_CODE AND NVL(DDA.MULTIPLE_SETTLEMENTS
, 'N') = 'N' AND CBA.CURRENCY_CODE(+) = DDA.CURRENCY AND CBA.BANK_ACCOUNT_NUM(+) = DDA.ACCOUNT_NO
Columns
Name |
REFERENCE_ID |
BANK_ACCOUNT_ID |
CASH_ACTIVITY_DATE |
DEAL_NUMBER |
BASE_AMOUNT |
INDICATIVE_FLAG |
DEAL_TYPE |
RECONCILED_REFERENCE |