View: CE_AP_FC_PAYMENTS_V

Product:	CE - Cash Management
Description:	Forecasting source - AP payments
Implementation/DBA Data:	APPS.CE_AP_FC_PAYMENTS_V

View Text

SELECT AC.CHECK_ID
, NVL(NVL(AC.CLEARED_BASE_AMOUNT
, AC.CLEARED_AMOUNT)
, NVL(BASE_AMOUNT
, AMOUNT))
, NVL(AC.CLEARED_AMOUNT
, AC.AMOUNT)
, AC.CURRENCY_CODE
, NVL(PVS.PAYMENT_PRIORITY
, 99)
, NVL(PV.VENDOR_TYPE_LOOKUP_CODE
, '-1')
, NVL(PVS.PAY_GROUP_LOOKUP_CODE
, '-1')
, AC.CLEARED_DATE
, AC.FUTURE_PAY_DUE_DATE
, AC.CHECK_DATE
, AC.ACTUAL_VALUE_DATE
, AC.ANTICIPATED_VALUE_DATE
, AC.STATUS_LOOKUP_CODE
, BAU.BANK_ACCOUNT_ID
, AC.PAYMENT_METHOD_CODE
, AC.ORG_ID
, AC.CHECK_NUMBER
, AC.CHECK_ID
FROM AP_CHECKS_ALL AC
, CE_BANK_ACCT_USES_ALL BAU
, PO_VENDOR_SITES_ALL PVS
, PO_VENDORS PV
WHERE AC.VENDOR_SITE_ID = PVS.VENDOR_SITE_ID
AND AC.CE_BANK_ACCT_USE_ID = BAU.BANK_ACCT_USE_ID
AND (PVS.ORG_ID = AC.ORG_ID OR PVS.ORG_ID IS NULL)
AND PVS.VENDOR_ID = PV.VENDOR_ID
AND (( AC.STATUS_LOOKUP_CODE IN ('NEGOTIABLE'
, 'CLEARED'
, 'CLEARED BUT UNACCOUNTED'
, 'RECONCILED'
, 'RECONCILED UNACCOUNTED')) OR ( AC.STATUS_LOOKUP_CODE = 'ISSUED'
AND AC.FUTURE_PAY_DUE_DATE IS NOT NULL))
AND NOT EXISTS (SELECT NULL
FROM CE_BANK_ACCOUNTS BA
WHERE BA.BANK_ACCOUNT_ID = BAU.BANK_ACCOUNT_ID
AND BA.NETTING_ACCT_FLAG = 'Y')

Columns