VIEW: APPS.CE_CP_DISC_APP_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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