View: CE_CP_DISC_APP_V

Product:	CE - Cash Management
Description:	Cash Positioning Discoverer View for AP Payments
Implementation/DBA Data:	APPS.CE_CP_DISC_APP_V

View Text

SELECT WSL.WORKSHEET_HEADER_ID
, AP.BANK_ACCOUNT_ID
, WSL.WORKSHEET_LINE_ID
, WSL.DESCRIPTION
, TO_CHAR(AP.CHECK_NUMBER)
, -DECODE(AP.CURRENCY_CODE
, XBA.CURRENCY_CODE
, AP.AMOUNT
, AP.BASE_AMOUNT) BALANCE
, AP.REFERENCE_ID FROM CE_AP_FC_PAYMENTS_V AP
, CE_CP_WORKSHEET_LINES WSL
, CE_CP_XTR_BANK_ACCOUNTS_V XBA
WHERE NVL(AP.ACTUAL_VALUE_DATE
, NVL(AP.ANTICIPATED_VALUE_DATE
, NVL(AP.MATURITY_DATE
, AP.PAYMENT_DATE))) = TO_DATE(SYSDATE
, 'YYYY/MM/DD') AND WSL.SOURCE_TYPE = 'APP' AND WSL.INCLUDE_FLAG = 'Y' AND (WSL.CLEARED_TRX_FLAG = 'Y' OR AP.STATUS = 'NEGOTIABLE') AND (WSL.PAYMENT_METHOD IS NULL OR AP.PAYMENT_METHOD = WSL.PAYMENT_METHOD) AND AP.BANK_ACCOUNT_ID = XBA.BANK_ACCOUNT_ID

Columns