Oracle Apps iExpenses Tables...Useful

Table Name

Description

AP_EXPENSE_REPORT_HEADERS_ALL

Expense report header information

AP_EXPENSE_REPORT_LINES_ALL

Expense report lines information

AP_EXP_REPORT_DISTS_ALL

Expense report distribution information. It contains the accounts against each expense report line.

AP_CREDIT_CARD_TRXNS_ALL

Table to store the corporate credit card transactions that are sent by the banks. These lines are saved as expense lines when the user creates the expense lines for credit cards

AP_NOTES

Table to store the comments entered by approvers and auditors

Setup tables

AP_EXPENSE_REPORTS_ALL

This table contains the header level information about the expense templates

AP_EXPENSE_REPORT_PARAMS_ALL

This table contains the detail level information about the expense templates

AP_POL_CAT_OPTIONS_ALL

Table to store the policy options

AP_POL_CONTEXT

Table to store the policy context

AP_POL_LOCATIONS_TL

Table to store the locations for which policies have been defined.

AP_POL_VIOLATIONS_ALL

Table to store the lines for which the defined policies have been violated

AP_POL_ITEMIZATIONS

AP_POL_SCHEDULE_PERIODS

AP_POL_EXRATE_OPTIONS_ALL

Table to store the exchange rate tolerance

AP_POL_HEADERS

Table to store all the policy headers

AP_POL_LINES

Table to store all the policy details

AP_CARDS_ALL

Table to store the corporate credit card details for the employees

AP_EXPENSE_REPORTS_ALL

Table to store the expense report templates that can be used by employees from different operating units

AP_WEB_DISC_HEADERS_GT

AP_POL_SCHEDULE_OPTIONS

Table to store the basis of the policy created, E.g. location, currency, etc.

AP_EXPENSE_REPORT_PARAMS_ALL

Table to store the expense template detailed information

Audit tables

AP_AUD_AUDITORS

Table to store auditor id and security_profile_id

AP_AUD_AUDIT_REASONS

Table containing the expense report header id and audit reason id and code

AP_AUD_AUTO_AUDITS

Table to store the employees who are auditors. This table is updated through the seeded package,AP_WEB_AUDIT_PROCESS.add_to_audit_list

AP_AUD_QUEUES

AP_AUD_RULE_ASSIGNMENTS_ALL

Table containing audit rule assignments

AP_AUD_RULE_SETS

Table containing audit rules