AX Views (70)

AX - Global Accounting Engine — documented views from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.

View	Description
`AXBV_ACCOUNTING_ENTRY_LINES`
`AXBV_ACCOUNT_BALANCES`
`AXBV_CONTROL_ACCOUNTS`
`AXBV_DOCUMENT_HISTORIES`
`AXBV_NON_CONTROL_ACCOUNTS`
`AXBV_TRADING_PARTNERS`
`AXBV_TRADING_PARTNER_SITES`
`AXFV_ACCOUNTING_ENTRY_LINES`
`AXFV_ACCOUNT_BALANCES`
`AXFV_CONTROL_ACCOUNTS`
`AXFV_DOCUMENT_HISTORIES`
`AXFV_NON_CONTROL_ACCOUNTS`
`AXFV_TRADING_PARTNERS`
`AXFV_TRADING_PARTNER_SITES`
`AX_AP_ACCOUNTING_EVENTS_ALL_V`	Replacement for the AP table, AP_ACCOUNTING_EVENTS_ALL, when the AX accounting engine is used.
`AX_AP_AE_HEADERS_ALL_V`	Replacement for the AP table, AP_AE_HEADERS_ALL, when the AX accounting engine is used.
`AX_AP_AE_LINES_ALL_V`	Replacement for the AP table, AP_AE_LINES_ALL, when the AX accounting engine is used.
`AX_AP_CHECK_ASSET_V`	Bank, clearing, and future clearing asset accounts for an Oracle Payables check
`AX_AP_TAXABLE_V`
`AX_AR_RACTLA_RACTLGDA_V`	Use for Oracle Receivables rules creation
`AX_BALANCES_SRS_V`	Use to improve performance of queries of balances by reports
`AX_COLUMNS_V`	Use by the Setup Query Chains form
`AX_CONTEXT_TABLES_V`	Use by the Setup Query Chains form
`AX_CST_ACTUAL_COST_DETAILS_V1`	Sending and receiving transactions of an inter organization transfer
`AX_CST_COST_DETAILS_V1`	Transaction cost and actual cost of transactions
`AX_CST_ITEM_COST_DETAILS_V1`	Standard cost and/or average cost of items
`AX_CST_QUANTITY_LAYERS_V1`	Layer IDs of cost groups or subinventory
`AX_CST_QUANTITY_LAYERS_V2`	Provides the same information as AX_CST_QUANTITY_LAYERS_V1
`AX_CST_TXN_COST_DETAILS_V1`	Use for inventory organization transfers
`AX_EVENTS_V1`
`AX_EVENT_CATEGORY_V`
`AX_EVENT_TYPES_V`
`AX_INTERNAL_LOOKUPS`	Internal Lookups
`AX_IT_AR_CMAPPTRX_V`	Use for Italian rules creation
`AX_IT_FND_DOCSEQ_V`	Registered document sequences used for Italian rules
`AX_LOOKUPS`	Lookup codes
`AX_MC_AP_TAXABLE_V`
`AX_MC_AR_RACTLA_RACTLGDA_V`	Use for Oracle Receivables MRC rules creation
`AX_MTL_CATEGORY_ACCOUNTS_V1`	material accounts by subinventory code or cost group
`AX_MTL_CATEGORY_ACCOUNTS_V2`	Duplicate of AX_MTL_CATEGORY_ACCOUNTS_V1
`AX_MTL_INTERORG_PARAMETERS_V1`	Subset of columns from the MTL_INTERORG_PARAMTERS table
`AX_MTL_ITEM_CATEGORIES_V1`	View of the MTL_ITEMS_CATEGORIES table
`AX_MTL_SECONDARY_INV_V1`	Secondary inventory organizations by organization and cost group identifier
`AX_MTL_SECONDARY_INV_V2`	Provide the same information ax AX_MTL_SECONDARY_INV_V1
`AX_MTL_SYSTEM_ITEMS_KFV_V2`
`AX_NPI_ACCOUNTS_V1`	All information in the table AX_NPI_ACCOUNTS table
`AX_ORGS_SOBS_V`	SOBs and Orgs relationships in subledger applications
`AX_ORGS_SUBS_V`	ID, Name, and Org ID of the 3rd Party Subidentifiers
`AX_QUERY_CHAINS_V`	Query chains available in a translation scheme
`AX_QUERY_TABLES_V`	Tables belonging to a query chain
`AX_RCV_TRANSACTIONS_V1`	Duplicate information from a subset of columns of table RCV_TRANSACTIONS
`AX_RCV_TRANSACTIONS_V2`
`AX_RULES_V`	Duplicate of all rows of a subset of columns of table AX_RULES
`AX_SCHEME_CONTEXTS_V`
`AX_SETUP_BOOKS_V`
`AX_SETUP_INV_ORG_PROCS_V`
`AX_SETUP_POSTING_BOOKS_V`
`AX_SETUP_SUBLEDGERS_V`
`AX_SLE_HEADERS_V`	Entry headers
`AX_SLE_LINES_V`	Entry lines
`AX_SUBS_V`	ID and Name of the 3rd Party Subidentifiers
`AX_TABLES_V`
`AX_TAX_CODES_V`	This view contains the subledger tax codes per application and set of books
`AX_THIRD_PARTIES_SUBS_V`
`AX_THIRD_PARTIES_V`	ID and name of the 3rd Party Identifiers
`AX_TRANS_PROGRAMS_V`
`AX_TRANS_SCHEMES_V`
`AX_TRIAL_BALANCE_FORM_V`
`AX_WIP_JOBS_V1`	standard and repetitive jobs information
`AX_WIP_TRANSACTION_ACCOUNTS_V1`	Account code combinations of each WIP transaction source