View: CE_CP_DISC_CEO_V

Product:	CE - Cash Management
Description:	Cash Positioning Discoverer View for Cash management outflows
Implementation/DBA Data:	APPS.CE_CP_DISC_CEO_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 = 'CEO' 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 = 'PAYMENT'

Columns