[Home] [Help]
| Product: | AP - Payables |
|---|---|
| Description: | |
| Implementation/DBA Data: | Not implemented in this database |
SELECT ASIC.BANK_NUM
, ASIC.BANK_ACCOUNT_NUM
, ASIC.CHECK_NUMBER
, ASIC.VENDOR_ID
, ASIC.VENDOR_NAME
, ASIC.CHECK_AMOUNT
, ASIC.DUE_DATE
, ASIC.PAYMENT_DATE
, ASIC.CHECKRUN_NAME
, ASIC.SELECTED_CHECK_ID
, AISC.CHECKRUN_ID
, ABA.BANK_ACCOUNT_TYPE
, ABB.BANK_BRANCH_TYPE
, ABB.BANK_NAME
, ABB.BANK_BRANCH_ID
, ABB.BANK_BRANCH_NAME
, ABB.BANK_NUMBER
, ASIC.CUSTOMER_NUM
, ABB.ADDRESS_LINE1
, ABB.CITY
, ABB.COUNTRY
, ABB.ZIP
, ABB.STATE
, ASIC.CURRENCY_CODE
FROM AP_SELECTED_INVOICE_CHECKS ASIC
, AP_INVOICE_SELECTION_CRITERIA AISC
, AP_BANK_ACCOUNTS ABA
, AP_BANK_BRANCHES ABB
WHERE ASIC.EXTERNAL_BANK_ACCOUNT_ID = ABA.BANK_ACCOUNT_ID
AND ASIC.CHECKRUN_NAME = AISC.CHECKRUN_NAME
AND ASIC.OK_TO_PAY_FLAG IN ('Y'
, 'F')
AND ABA.BANK_BRANCH_ID = ABB.BANK_BRANCH_ID