View: CE_CP_DISC_ARR_V

Product:	CE - Cash Management
Description:	Cash Positioning Discoverer View for AR Receipts
Implementation/DBA Data:	APPS.CE_CP_DISC_ARR_V

View Text

SELECT WSL.WORKSHEET_HEADER_ID
, AR.BANK_ACCOUNT_ID
, WSL.WORKSHEET_LINE_ID
, WSL.DESCRIPTION
, AR.RECEIPT_NUMBER
, DECODE(AR.CURRENCY_CODE
, XBA.CURRENCY_CODE
, AR.AMOUNT
, AR.BASE_AMOUNT) BALANCE
, AR.REFERENCE_ID FROM CE_AR_FC_RECEIPTS_V AR
, CE_CP_WORKSHEET_LINES WSL
, CE_CP_XTR_BANK_ACCOUNTS_V XBA
WHERE AR.CASH_ACTIVITY_DATE = TRUNC(SYSDATE) AND WSL.SOURCE_TYPE = 'ARR' AND WSL.INCLUDE_FLAG = 'Y' AND (WSL.CLEARED_TRX_FLAG = 'Y' OR AR.STATUS NOT IN ('CLEARED'
, 'RISK_ELIMINATED')) AND (WSL.RECEIPT_METHOD_ID IS NULL OR AR.RECEIPT_METHOD_ID = WSL.RECEIPT_METHOD_ID) AND AR.BANK_ACCOUNT_ID = XBA.BANK_ACCOUNT_ID

Columns