SELECT 	asic.checkrun_name C_CHECKRUN_NAME,
	asic.check_number C_CHECK_NUMBER,
	asic.check_amount C_CHECK_AMOUNT,
	asic.status_lookup_code C_STATUS_LOOKUP_CODE,
	asic.vendor_num C_VENDOR_NUMBER,
	asic.vendor_name C_VENDOR_NAME,
	asic.vendor_site_code C_VENDOR_SITE_CODE,
	asic.customer_num C_CUSTOMER_NUMBER,
	asic.address_line1 C_ADDRESS_LINE1,
	asic.address_line2 C_ADDRESS_LINE2,
	asic.address_line3 C_ADDRESS_LINE3,
	asic.city C_CITY,
	NVL(asic.state, asic.province) C_STATE,
	asic.zip C_ZIP,
	asic.province C_PROVINCE,
	asic.country C_COUNTRY,
	t.territory_short_name C_COUNTRY_NAME,
	asic.withholding_status_lookup_code C_WH_STATUS_LOOKUP_CODE,
	asic.attention_ar_flag C_ATTENTION_AR_FLAG,
	lc.displayed_field C_WITHHOLDING_STATUS,
	asic.void_flag C_VOID_FLAG,
	asic.selected_check_id C_CHECK_ID,
	asic.currency_code C_CURRENCY_CODE,
	asic.BANK_ACCOUNT_NUM C_BANK_ACCOUNT_NUMBER,
	asic.bank_num C_BANK_NUMBER,
	asic.BANK_ACCOUNT_TYPE C_BANK_ACCOUNT_TYPE,
	asic.CHECK_VOUCHER_NUM C_CHECK_VOUCHER_NUMBER,
	asic.due_date C_DUE_DATE,
	asic.payment_date C_PAYMENT_DATE,
    DECODE(asic.status_lookup_code,'UNCONFIRMED SET UP','Y','N') C_SETUP
  FROM 	ap_selected_invoice_checks_all asic,
       	ap_inv_selection_criteria_all aisc,
		po_vendor_sites_all pvs,
		fnd_territories_vl t,
		ap_lookup_codes lc
 WHERE 	---aisc.checkrun_name = :P_PAYMENT_BATCH AND  
        asic.checkrun_name = aisc.checkrun_name
   AND 	(asic.ok_to_pay_flag IN ('Y','F') OR asic.status_lookup_code = 'UNCONFIRMED SET UP')
   AND 	asic.check_number BETWEEN aisc.start_print_document AND aisc.end_print_document
   AND  pvs.vendor_site_id (+) = asic.vendor_site_id
   AND  t.territory_code (+) = asic.country 
   AND  lc.lookup_code (+) = asic.withholding_status_lookup_code
   AND  lc.lookup_type (+) = 'WITHHOLDING STATUS'
 ORDER BY check_number