VIEW: APPS.CE_AP_FC_PAYMENTS_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')