SELECT ASI.INVOICE_NUM
, ASI.INVOICE_ID, ASI.INVOICE_AMOUNT
, AI.INVOICE_CURRENCY_CODE
, AI.INVOICE_TYPE_LOOKUP_CODE
, ASI.INVOICE_DATE
, AI.VOUCHER_NUM
, ASI.DISCOUNT_AMOUNT
, AI.VAT_CODE
, AI.TAX_AMOUNT
, ASIC.CHECKRUN_NAME
, ASI.AMOUNT_PAID
, ASI.DISCOUNT_AMOUNT_TAKEN
, ASI.DUE_DATE
, ASI.DISCOUNT_DATE
, ASI.INVOICE_DESCRIPTION
, ASI.PAYMENT_PRIORITY
, ASI.AMOUNT_REMAINING
, ASI.PAYMENT_NUM
, ASI.INVOICE_EXCHANGE_RATE
, ASI.PROPOSED_PAYMENT_AMOUNT
, ASI.PAY_SELECTED_CHECK_ID
, ASI.PRINT_SELECTED_CHECK_ID
, ASI.WITHHOLDING_AMOUNT
, AISC.CHECKRUN_ID
FROM AP_INVOICE_SELECTION_CRITERIA AISC
, AP_SELECTED_INVOICE_CHECKS ASIC
, AP_SELECTED_INVOICES ASI
, AP_INVOICES AI
WHERE ASI.CHECKRUN_NAME = AISC.CHECKRUN_NAME
AND ASIC.CHECKRUN_NAME= AISC.CHECKRUN_NAME
AND ASIC.SELECTED_CHECK_ID = ASI.PAY_SELECTED_CHECK_ID
AND ASIC.SELECTED_CHECK_ID = ASI.PRINT_SELECTED_CHECK_ID
AND ASIC.OK_TO_PAY_FLAG IN ('Y'
, 'F')
AND ASI.OK_TO_PAY_FLAG IN ('Y'
, 'F')
AND ASI.INVOICE_ID = AI.INVOICE_ID
