View Definition AP_XML_PAYMENTLEVEL_V

 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