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]

Table: AP_INV_SELECTION_CRITERIA_ALL

Product:	AP - Payables
Description:	Payment batch invoice selection criteria
Implementation/DBA Data:	AP.AP_INV_SELECTION_CRITERIA_ALL

Primary Key: AP_INVOICE_SELECTION_CRITER_PK

CHECKRUN_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
AP_INV_SELECTION_CRITERIA_ALL	AP_CHECK_STOCKS_ALL	AP_INV_SELECTION_CRITERIA_ALL.CHECK_STOCK_ID
AP_INV_SELECTION_CRITERIA_ALL	FND_CURRENCIES	AP_INV_SELECTION_CRITERIA_ALL.CURRENCY_CODE
AP_INV_SELECTION_CRITERIA_ALL	GL_DAILY_CONVERSION_TYPES	AP_INV_SELECTION_CRITERIA_ALL.EXCHANGE_RATE_TYPE
AP_INV_SELECTION_CRITERIA_ALL	AP_BANK_ACCOUNTS_ALL	AP_INV_SELECTION_CRITERIA_ALL.BANK_ACCOUNT_ID
AP_INV_SELECTION_CRITERIA_ALL	AP_PBATCH_SETS_ALL	AP_INV_SELECTION_CRITERIA_ALL.BATCH_SET_ID
AP_INV_SELECTION_CRITERIA_ALL	AP_PBATCH_SET_LINES_ALL	AP_INV_SELECTION_CRITERIA_ALL.BATCH_SET_LINE_ID
AP_AWT_TEMP_DISTRIBUTIONS_ALL	AP_INV_SELECTION_CRITERIA_ALL	AP_AWT_TEMP_DISTRIBUTIONS_ALL.CHECKRUN_NAME
AP_CHECKRUN_CONC_PROCESSES_ALL	AP_INV_SELECTION_CRITERIA_ALL	AP_CHECKRUN_CONC_PROCESSES_ALL.CHECKRUN_NAME
AP_CHECKRUN_CONFIRMATIONS_ALL	AP_INV_SELECTION_CRITERIA_ALL	AP_CHECKRUN_CONFIRMATIONS_ALL.CHECKRUN_NAME
AP_CHECKS_ALL	AP_INV_SELECTION_CRITERIA_ALL	AP_CHECKS_ALL.CHECKRUN_ID
AP_CHECKS_ALL	AP_INV_SELECTION_CRITERIA_ALL	AP_CHECKS_ALL.CHECKRUN_NAME
AP_CURRENCY_GROUP	AP_INV_SELECTION_CRITERIA_ALL	AP_CURRENCY_GROUP.CHECKRUN_ID
AP_LE_GROUP	AP_INV_SELECTION_CRITERIA_ALL	AP_LE_GROUP.CHECKRUN_ID
AP_OU_GROUP	AP_INV_SELECTION_CRITERIA_ALL	AP_OU_GROUP.CHECKRUN_ID
AP_PAY_GROUP	AP_INV_SELECTION_CRITERIA_ALL	AP_PAY_GROUP.CHECKRUN_ID
AP_SELECTED_INVOICES_ALL	AP_INV_SELECTION_CRITERIA_ALL	AP_SELECTED_INVOICES_ALL.CHECKRUN_NAME
AP_SELECTED_INVOICE_CHECKS_ALL	AP_INV_SELECTION_CRITERIA_ALL	AP_SELECTED_INVOICE_CHECKS_ALL.CHECKRUN_NAME
AP_UNSELECTED_INVOICES_ALL	AP_INV_SELECTION_CRITERIA_ALL	AP_UNSELECTED_INVOICES_ALL.CHECKRUN_ID
FV_AAN_MATCHES_TEMP	AP_INV_SELECTION_CRITERIA_ALL	FV_AAN_MATCHES_TEMP.CHECKRUN_NAME
FV_AP_CASH_POS_TEMP	AP_INV_SELECTION_CRITERIA_ALL	FV_AP_CASH_POS_TEMP.CHECKRUN_ID