VIEW: APPS.CE_CP_APP_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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