eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: AP_XML_INVOICE2_LEVEL_V

Product:	AP - Payables
Description:
Implementation/DBA Data:	APPS.AP_XML_INVOICE2_LEVEL_V

View Text

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

Columns

Name
INVOICE_NUM
INVOICE_ID
INVOICE_AMOUNT
INVOICE_CURRENCY_CODE
INVOICE_TYPE
INVOICE_DATE
INVOICE_VOUCHER_NUM
DISCOUNT_AMOUNT
VAT_CODE
TAX_AMOUNT
BATCH_NAME
AMOUNT_PAID
DISCOUNT_AMOUNT_TAKEN
DUE_DATE
DISCOUNT_DATE
INVOICE_DESCRIPTION
PAYMENT_PRIORITY
AMOUNT_REMAINING
PAYMENT_NUMBER
INVOICE_EXCHANGE_RATE
PROPOSED_PAYMENT_AMOUNT
PAY_SELECTED_CHECK_ID
PRINT_SELECTED_CHECK_ID
WITHHOLDING_AMOUNT
BATCH_ID