VIEW: APPS.CE_CP_DISC_ARR_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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