View: CE_CP_APP_V

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

View Text

SELECT AC.CHECK_ID
, AC.BANK_ACCOUNT_ID
, NVL(AC.ACTUAL_VALUE_DATE
, NVL(AC.ANTICIPATED_VALUE_DATE
, NVL(AC.FUTURE_PAY_DUE_DATE
, AC.CHECK_DATE)))
, AC.CHECK_NUMBER
, -NVL(NVL(AC.CLEARED_BASE_AMOUNT
, AC.CLEARED_AMOUNT)
, NVL(AC.BASE_AMOUNT
, AC.AMOUNT))
, AC.STATUS_LOOKUP_CODE
, AC.PAYMENT_METHOD_LOOKUP_CODE FROM AP_CHECKS_ALL AC
WHERE AC.STATUS_LOOKUP_CODE IN ('NEGOTIABLE'
, 'CLEARED'
, 'CLEARED BUT UNACCOUNTED'
, 'RECONCILED'
, 'RECONCILED UNACCOUNTED') AND AC.VENDOR_SITE_ID IS NOT NULL UNION ALL SELECT AC.CHECK_ID
, AC.BANK_ACCOUNT_ID
, NVL(AC.ACTUAL_VALUE_DATE
, NVL(AC.ANTICIPATED_VALUE_DATE
, NVL(AC.FUTURE_PAY_DUE_DATE
, AC.CHECK_DATE)))
, AC.CHECK_NUMBER
, -NVL(NVL(AC.CLEARED_BASE_AMOUNT
, AC.CLEARED_AMOUNT)
, NVL(AC.BASE_AMOUNT
, AC.AMOUNT))
, AC.STATUS_LOOKUP_CODE
, AC.PAYMENT_METHOD_LOOKUP_CODE FROM AP_CHECKS_ALL AC WHERE AC.FUTURE_PAY_DUE_DATE IS NOT NULL AND AC.STATUS_LOOKUP_CODE = 'ISSUED' AND AC.VENDOR_SITE_ID IS NOT NULL

Columns