[Home] [Help]
View: CE_CP_DISC_CEI_V
Product: | CE - Cash Management |
Description: | Cash Positioning Discoverer View for Cash management infows |
Implementation/DBA Data: |
APPS.CE_CP_DISC_CEI_V
|
View Text
SELECT WSL.WORKSHEET_HEADER_ID
, CF.CASHFLOW_BANK_ACCOUNT_ID
, WSL.WORKSHEET_LINE_ID
, WSL.DESCRIPTION
, TO_CHAR(CF.CASHFLOW_ID)
, DECODE(CF.CASHFLOW_CURRENCY_CODE
, CBA.CURRENCY_CODE
, CF.CASHFLOW_AMOUNT
, CF.BASE_AMOUNT)
, CF.CASHFLOW_ID FROM CE_CASHFLOWS CF
, CE_CP_WORKSHEET_LINES WSL
, CE_BANK_ACCOUNTS_V CBA
WHERE WSL.SOURCE_TYPE = 'CEI' AND WSL.INCLUDE_FLAG = 'Y' AND CF.CASHFLOW_BANK_ACCOUNT_ID = CBA.BANK_ACCOUNT_ID AND (WSL.CLEARED_TRX_FLAG = 'Y' OR CF.CASHFLOW_STATUS_CODE = 'CREATED') AND (WSL.TRXN_SUBTYPE_CODE_ID IS NULL OR CF.SOURCE_TRXN_SUBTYPE_CODE_ID = WSL.TRXN_SUBTYPE_CODE_ID) AND CF.CASHFLOW_STATUS_CODE <> 'CANCELED' AND CF.CASHFLOW_DIRECTION = 'RECEIPT'
Columns
Name |
WORKSHEET_HEADER_ID |
BANK_ACCOUNT_ID |
WORKSHEET_LINE_ID |
DESCRIPTION |
DETAIL |
BALANCE |
REFERENCE_ID |