VIEW: APPS.AP_XML_INVOICE2_LEVEL_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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