SELECT ASIC.CHECKRUN_NAME
, AISC.CHECKRUN_ID, ASIC.SELECTED_CHECK_ID
, ASIC.VENDOR_AMOUNT
, ASIC.CHECK_AMOUNT
, ASIC.CHECK_NUMBER
, ASIC.DUE_DATE
, ASIC.PAYMENT_DATE
, ASIC.CURRENCY_CODE
, TRUNC(AISC.EXCHANGE_RATE
, 9)
, ACF.SEPARATE_REMITTANCE_ADVICE
, ASIC.CUSTOMER_NUM
, ASIC.VENDOR_NAME
, ASIC.VENDOR_NUM
, ASIC.CITY
, ASIC.STATE
, ASIC.ZIP
, ASIC.COUNTRY
, PVS.EDI_REMITTANCE_METHOD
, PVS.EDI_REMITTANCE_INSTRUCTION
, NULL
, DECODE(APBV.PAYMENT_CATEGORY
, 'ACH'
, DECODE(PV.VENDOR_TYPE_LOOKUP_CODE
, 'VENDOR'
, 'CTX'
, 'EMPLOYEE'
, 'PPD'
, NULL)
, NULL)
, PVS.BANK_CHARGE_BEARER
, DECODE(APBV.PAYMENT_CATEGORY
, 'ACH'
, 'N'
, DECODE(AISC.TRANSFER_PRIORITY
, 'EXPRESS'
, 'Y'
, 'N'))
, ABA.BANK_ACCOUNT_NUM
, ABA.BANK_ACCOUNT_TYPE
, ABA.CHECK_DIGITS
, ABA.CURRENCY_CODE
, ABA.BANK_ACCOUNT_NAME
, ABB.BANK_BRANCH_TYPE
, ABB.BANK_NUMBER
, ABB.BANK_NAME
, ABB.BANK_BRANCH_NAME
, ABB.BANK_NUM
, ABB.CONTACT_TITLE
, ABB.PHONE
, ABB.CITY
, ABB.ZIP
, ABB.STATE
, ABB.COUNTRY
, ABB.EFT_SWIFT_CODE
, ASIC.ADDRESS_LINE1||'
, '||ASIC.ADDRESS_LINE2
, ABB.CONTACT_FIRST_NAME||' '||ABB.CONTACT_LAST_NAME
, ABB.ADDRESS_LINE1||'
, '||ABB.ADDRESS_LINE2
FROM AP_SELECTED_INVOICE_CHECKS ASIC
, AP_INVOICE_SELECTION_CRITERIA AISC
, AP_BANK_ACCOUNTS ABA
, AP_BANK_BRANCHES ABB
, AP_CHECK_STOCKS ACS
, AP_CHECK_FORMATS ACF
, PO_VENDOR_SITES PVS
, PO_VENDORS PV
, AP_XML_BATCHLEVEL2_V APBV
WHERE ACS.CHECK_STOCK_ID = AISC.CHECK_STOCK_ID
AND ACS.CHECK_FORMAT_ID = ACF.CHECK_FORMAT_ID
AND ASIC.EXTERNAL_BANK_ACCOUNT_ID = ABA.BANK_ACCOUNT_ID
AND ASIC.CHECKRUN_NAME = AISC.CHECKRUN_NAME
AND ASIC.VENDOR_SITE_ID=PVS.VENDOR_SITE_ID
AND PVS.VENDOR_ID = PV.VENDOR_ID
AND PV.VENDOR_ID = ASIC.VENDOR_ID
AND ASIC.OK_TO_PAY_FLAG IN ('Y'
, 'F')
AND ABA.BANK_BRANCH_ID = ABB.BANK_BRANCH_ID
AND APBV.BATCH_NAME=AISC.CHECKRUN_NAME
