VIEW: APPS.CE_CP_DISC_CEO_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'