Key Tables and Views

Sections:

  • Accounts Payable
    • Expense Reports
      • AP_EXPENSE_REPORT_HEADERS_ALL (report_header_id)
      • AP_EXPENSE_REPORT_LINES_ALL (report_header_id)
      • AP_WEB_SIGNING_LIMITS_ALL
    • Invoices
      • AP_INVOICES_ALL (invoice_id)
      • AP_INVOICE_LINES_ALL (invoice_id, line_number)
      • AP_INVOICE_DISTRIBUTIONS_ALL (invoice_distribution_id)
    • Invoices Interface
      • AP_INVOICES_INTERFACE (invoice_id, load_request_id)
      • AP_INVOICE_LINES_INTERFACE (invoice_line_id)
    • Payment Runs
      • AP_INV_SELECTION_CRITERIA_ALL (checkrun_id)
      • AP_CHECKS_ALL (check_id)
      • AP_INVOICE_PAYMENTS_ALL (invoice_payment_id)
    • Payment Templates / Payments Setup
      • AP_PAYMENT_TEMPLATES (template_id)
      • IBY_ACCT_PMT_PROFILES_B (payment_profile_id)
      • IBY_ACCT_PMT_PROFILES_TL (payment_profile_id, language)
      • IBY_EXTRACTS_B (extract_id)
      • IBY_EXTRACTS_TL (extract_id, language)
      • IBY_FORMATS_B (format_code)
      • IBY_FORMATS_TL (format_code, language)
      • IBY_SYS_PMT_PROFILES_VL (system_profile_code)
    • Suppliers (R12)
      • AP_SUPPLIERS (vendor_id)
      • AP_SUPPLIER_SITES_ALL (vendor_site_id)
    • Suppliers (11i)
      • PO_VENDORS (vendor_id)
      • PO_VENDOR_SITES_ALL (vendor_site_id)
  • Accounts Receivable
    • Applications
      • AR_RECEIVABLE_APPLICATIONS_ALL
    • Batch Sources
      • RA_BATCH_SOURCES_ALL
    • Customers
      • AR_COLLECTORS (collector_id)
      • AR_CUSTOMER_PROFILE_CLASSES_V
      • HZ_CONTACT_POINTS
      • HZ_CUST_ACCOUNT_ROLES
      • HZ_CUST_ACCOUNTS (cust_account_id)
      • HZ_CUST_ACCT_SITES_ALL (cust_acct_site_id)
      • HZ_CUST_SITE_USES_ALL (site_use_id)
      • HZ_CUSTOMER_PROFILES
      • HZ_LOCATIONS (location_id)
      • HZ_PARTIES (party_id)
      • HZ_PARTY_SITE (party_site_id)
    • Payment Schedules
      • AR_PAYMENT_SCHEDULES_ALL (payment_schedule_id)
    • Payment Terms
      • RA_TERMS_B (term_id)
      • RA_TERMS_TL (term_id)
    • Receipts / Receipt Batches
      • AR_BATCHES_ALL (batch_id)
      • AR_CASH_RECEIPTS_ALL (cash_receipt_id)
      • AR_CASH_RECEIPT_HISTORY_ALL (cash_receipt_history_id)
      • AR_DISTRIBUTIONS_ALL (line_id)
      • AR_MISC_CASH_DISTRIBUTIONS_ALL (misc_cash_distribution_id)
      • AR_RECEIPT_METHODS (receipt_method_id)
      • AR_RECEIPT_CLASSES (receipt_class_id)
    • Receivables Activities
      • AR_RECEIVABLES_TRX_ALL (receivables_trx_id, org_id)
    • Statement Cycles
      • AR_STATEMENT_CYCLE_DATES_ALL (statement_cycle_date_id)
    • Transaction Interface
      • RA_INTERFACE_LINES_ALL (interface_line_id)
    • Transaction Types
      • RA_CUST_TRX_TYPES_ALL (cust_trx_type_seq_id)
    • Transactions / Batches
      • AR_TRX_BAL_SUMMARY (cust_account_id, site_use_id, currency, org_id)
      • RA_BATCHES_ALL (batch_id)
      • RA_BATCH_SOURCES_ALL (batch_source_seq_id)
      • RA_CUSTOMER_TRX_ALL (customer_trx_id)
      • RA_CUSTOMER_TRX_LINES_ALL (customer_trx_line_id)
      • RA_CUST_TRX_LINE_GL_DIST_ALL (cust_trx_line_gl_dist_id)
  • Advanced Collections
    • Collectors
      • AR_COLLECTORS (resource_id)
    • Delinquencies
      • IEX_DELINQUENCIES_ALL (delinquency_id)
    • Notes
      • JTF_NOTE_CONTEXTS
      • JTF_NOTES_TL
      • JTF_NOTES_TL
    • Promises
      • IEX_PROMISE_DETAILS (promise_detail_id)
    • Strategies
      • IEX_STRATEGIES (strategy_id)
      • IEX_STRATEGY_WORK_ITEMS (work_item_id)
    • Tasks
      • IEX_TASKS_MAIN_V
    • XML Request Histories (related to dunning runs?)
      • IEX_XML_REQUEST_HISTORIES (xml_request_id)
  • Cash Management
    • Banks and Bank Accounts
      • CE_BANK_ACCOUNTS (bank_account_id)
      • CE_BANK_ACCT_USES_ALL (bank_acct_use_id)
      • CE_BANKS_V
      • CE_BANK_BRANCHES_V
    • Statement Mapping (http://www.shareoracleapps.com/2012/04/tables-involved-in-bank-statement-open.html)
      • CE_BANK_STMT_INT_MAP (Stores the definitions of the mapping templates)
      • CE_BANK_STMT_MAP_HDR (Maps the columns the Bank Statement Headers Interface table (CE_STATEMENT_HEADERS_INT_ALL) to the columns in the intermediate table (CE_STMT_INT_TMP))
      • CE_BANK_STMT_MAP_LINE (Maps the columns in the Bank Statement Lines Interface table (CE_STATEMENT_LINES_INTERFACE) to the columns in the intermediate table (CE_STMT_INT_TMP))
      • CE_TRANSACTION_CODES (This table stores pre-determined codes between you and your bank to identify the types of transactions for matching statement lines)
      • CE_STMT_INT_TMP (Intermediate table, which stores the information loaded from a bank statement file. This table is populated by the SQL*Loader script.)
      • CE_SQLLDR_ERRORS (Records the errors encountered by the Bank Statement Loader program when loading data from the bank statement file into the intermediate table)
    • Statements
      • CE_STATEMENT_HEADERS_ALL (statement_header_id)
      • CE_STATEMENT_LINES (statement_line_id)
      • CE_STATEMENT_RECONCILS_ALL (statement_line_id)
      • CE_RECONCILIATION_ERRORS
    • Statements Interface
      • CE_STATEMENT_HEADERS_INT_ALL
      • CE_STATEMENT_LINES_INTERFACE
    • Statements Interface – Errors
      • CE_HEADER_INTERFACE_ERRORS
      • CE_LINE_INTERFACE_ERRORS
  • Enterprise Asset Management
    • Assets
      • MTL_EAM_ASSET_NUMBERS_ALL_V (inventory_item_id)
    • Maintenance Routings
      • BOM_OPERATIONAL_ROUTINGS_V
      • BOM_OPERATION_SEQUENCES_V
      • BOM_OPERATION_RESOURCES_V
    • WIP Cost Transaction Interface
      • WIP_COST_TXN_INTERFACE
    • Work Order Transactions
      • WIP_TRANSACTIONS
      • WIP_TRANSACTION_ACCOUNTS
    • Work Orders and Work Requests
      • WIP_EAM_DIRECT_ITEMS direct items linked to work order
      • WIP_EAM_WORK_REQUESTS work orders (work_request_id)
      • WIP_ENTITIES work orders (wip_entity_id)
      • WIP_DISCRETE_JOBS
      • WIP_OPERATIONS_V operations
      • WIP_OPERATION_RESOURCES_V resources
      • WIP_REQUIREMENT_OPERATIONS material requirements linked to work order
  • General Ledger
    • Code Combinations
      • GL_CODE_COMBINATIONS (code_combination_id)
      • GL_CODE_COMBINATIONS_KFV useful for accessing `concatenated_segments` (code_combination_id)
    • Cross Validation Rules
      • FND_FLEX_VDATION_RULES_VL
      • FND_FLEX_VALIDATION_RULE_LINES
    • Daily Rates
      • GL_DAILY_RATES (from_currency, to_currency, conversion_date, conversion_type)
    • Encumbrance Types
      • GL_ENCUMBRANCE_TYPES (encumbrance_type_id)
    • GL Interface
      • GL_INTERFACE
    • GL Security Rules
      • FND_FLEX_VALUE_RULES
      • FND_FLEX_VALUE_RULES_TL
      • FND_FLEX_VALUE_RULE_USAGES
    • Journal Approval Limits
      • GL_AUTHORIZATION_LIMITS
    • Journals
      • GL_JE_BATCHES (je_batch_id)
      • GL_JE_CATEGORIES_TL (je_category_name)
      • GL_JE_HEADERS (je_header_id)
      • GL_JE_LINES (je_header_id, je_line_num)
      • GL_JE_SOURCES_TL (je_source_name)
    • Periods
      • GL_PERIOD_STATUSES (application_id, ledger_id, period_name)
    • Web ADI
      • BNE_ASYNC_UPLOAD_JOBS
      • BNE_INTEGRATORS_B
      • BNE_INTEGRATORS_TL
      • BNE_LAYOUTS_B
      • BNE_LAYOUTS_TL
  • HRMS
    • HR Operating Units
      • HR_OPERATING_UNITS
    • HR Organizations
      • HR_ALL_ORGANIZATION_UNITS (organization_id)
    • HR Locations
      • HR_LOCATIONS_ALL (location_id)
    • People
      • People
        • PER_ALL_PEOPLE_F (person_id)
        • PER_PEOPLE_X – view on top of per_people_f which displays date tracked records effective as of sysdate (person_id)
        • PER_PERSON_TYPE_USAGES_F
        • PER_PERSON_TYPES_TL
      • People Assignments
        • PER_ALL_ASSIGNMENTS_F (assignment_id)
        • PER_ASSIGNMENTS_X – view on top of per_all_assignments_f which displays date tracked records effective as of sysdate (assignment_id)
        • PER_ASSIGNMENT_STATUS_TYPES
    • Jobs, Grades, Positions
      • PER_GRADES
      • PER_JOBS
      • PER_JOB_DEFINITIONS
      • PER_POSITIONS
  • Inventory
    • Accounting Periods
      • ORG_ACCT_PERIODS
    • Assignment Sets
      • MRP_SR_ASSIGNMENTS
      • MRP_ASSIGNMENT_SETS (assignment_set_id)
    • Inventory Items
      • MTL_SYSTEM_ITEMS_B (inventory_item_id)
    • Inventory Orgs
      • MTL_PARAMETERS
    • Organization Access
      • ORG_ACCESS
    • Material Transactions
      • MTL_MATERIAL_TRANSACTIONS (transaction_id)
      • MTL_TRANSACTION_ACCOUNTS
      • MTL_TRANSACTION_TYPES (transaction_type_id)
    • Units of Measure
      • MTL_UNITS_OF_MEASURE_TL (unit_of_measure)
      • MTL_UOM_CONVERSIONS (unit_of_measure)
  • Projects
    • Project Autoaccounting Rules
      • PA_RULES (rule_id)
      • PA_SEGMENT_RULE_PAIRINGS_ALL
      • PA_FUNCTIONS
      • PA_FUNCTION_TRANSACTIONS_ALL
    • Project Agrements, Budgets and Funding
      • PA_AGREEMENTS_ALL (agreement_id)
      • PA_BUDGET_LINES (budget_version_id )
      • PA_BUDGET_TYPES
      • PA_BUDGET_VERSIONS
      • PA_PROJECT_FUNDINGS
      • PA_RESOURCE_ASSIGNMENTS
    • Project Billing
      • Events
        • PA_EVENTS (event_id)
      • Invoices
        • PA_DRAFT_INVOICE_ITEMS
        • PA_DRAFT_INVOICES_ALL
      • Revenues
        • PA_CUST_REV_DIST_LINES_ALL
        • PA_DRAFT_REVENUE_ITEMS
        • PA_DRAFT_REVENUES_ALL
    • Project Expenditure Items
      • PA_COST_DISTRIBUTION_LINES_ALL
      • PA_EXPENDITURE_ITEMS_ALL (expenditure_item_id)
      • PA_EXPENDITURES_ALL (expenditure_id)
      • PA_EXPENDITURE_COMMENTS (expenditure_item_id)
      • PA_EXPENDITURE_GROUPS_ALL
      • PA_EXPENDITURE_TYPES (expenditure_type)
    • Project Key Members
      • PA_PROJECT_PARTIES
      • PA_ROLE_CONTROLS
      • PA_PROJECT_ROLE_TYPES_B
      • PA_PROJECT_ROLE_TYPES_TL
    • Project Transactions Interface
      • PA_TRANSACTION_INTERFACE_ALL
    • Projects
      • PA_PROJECTS_ALL (project_id)
      • PA_TASKS (task_id)
    • Projects and Customers
      • PA_CUSTOMERS_V
      • PA_PROJECT_CUSTOMERS
    • Projects Setup
      • Billing Cycles
        • PA_BILLING_CYCLES (billing_cycle_id)
      • Budget Entry Methods
        • PA_BUDGET_ENTRY_METHODS
      • Burden Schedules
        • PA_IND_RATE_SCHEDULES_ALL
      • Project Classification
        • PA_PROJECT_CLASSES_V
      • Project Lookups
        • PA_LOOKUPS
      • Project Organizations
        • PA_ORGANIZATIONS_V
      • Project Types
        • PA_PROJECT_TYPES_ALL (project_type)
      • Project Statuses
        • PA_PROJECT_STATUSES (project_status_code)
      • Transaction Sources
        • PA_TRANSACTION_SOURCES (transaction_source)
  • Purchasing
    • Approval Limits
      • PO_CONTROL_FUNCTIONS
      • PO_CONTROL_GROUPS_ALL
      • PO_CONTROL_RULES
      • PO_POSITION_CONTROLS_ALL
    • Approved Supplier Lists
      • PO_APPROVED_SUPPLIER_LIST (asl_id)
      • PO_ASL_ATTRIBUTES
    • Buyers
      • PO_AGENTS
      • PO_AGENTS_V
    • Commodities
      • PO_COMMODITIES_B
      • PO_COMMODITIES_TL
      • PO_COMMODITY_CATEGORIES
    • Information Templates / Smart Forms
      • POR_TEMPLATE_ATTRIBUTES_TL
      • POR_TEMPLATE_ATTRIBUTES_B
      • POR_TEMPLATES_ALL_TL
    • Purchase Categories
      • MTL_CATEGORIES_B
      • MTL_CATEGORIES_TL
      • MTL_CATEGORY_SETS_B
      • MTL_CATEGORY_SETS_TL
    • Purchase Orders
      • PO_HEADERS_ALL (po_header_id)
      • PO_LINE_LOCATIONS_ALL (po_line_location_id)
      • PO_LINES_ALL (po_line_id)
      • PO_DISTRIBUTIONS_ALL (po_distribution_id)
    • Receipts
      • RCV_SHIPMENT_HEADERS
      • RCV_SHIPMENT_LINES
      • RCV_TRANSACTIONS
    • Requisitions
      • PO_REQ_DISTRIBUTIONS_ALL
      • PO_REQUISITION_HEADERS_ALL (requisition_header_id)
      • PO_REQUISITION_LINES_ALL (requisition_line_id)
  • Sub-Ledger Architecture
    • SLA Tables
      • XLA_ACCOUNTING_ERRORS
      • XLA_AE_HEADERS
      • XLA_AE_LINES
      • XLA_DISTRIBUTION_LINKS
      • XLA_EVENTS
      • XLA_TRANSACTION_ENTITIES
  • SysAdmin
    • Applications
      • FND_APPLICATION (application_id)
      • FND_APPLICATION_TL (application_id)
    • Attachments
      • FND_DOCUMENTS
      • FND_DOCUMENTS_TL
      • FND_DOCUMENT_CATEGORIES_TL
      • FND_DOCUMENT_DATATYPES
      • FND_DOCUMENT_ENTITIES_TL
    • Concurrent Programs
      • FND_CONCURRENT_PROGRAMS (concurrent_program_id)
      • FND_CONCURRENT_PROGRAMS_TL (concurrent_program_id)
    • Concurrent Requests
      • FND_CONCURRENT_REQUESTS (request_id)
      • FND_CONC_PP_ACTIONS
      • FND_CONC_RELEASE_CLASSES (release_class_id)
    • Executables
      • FND_EXECUTABLES (executable_id)
      • FND_EXECUTABLES_TL (executable_id)
    • Flexfields
      • FND_DESCRIPTIVE_FLEXS_VL
      • FND_DESCR_FLEX_COL_USAGE_VL
      • FND_DESCR_FLEX_CONTEXTS_VL
      • FND_FLEX_VALIDATION_TABLES
      • FND_FLEX_VALUES
      • FND_FLEX_VALUES_TL
      • FND_FLEX_VALUE_SETS
      • FND_ID_FLEXS
      • FND_ID_FLEX_SEGMENTS
      • FND_ID_FLEX_SEGMENTS_VL
      • FND_ID_FLEX_STRUCTURES
      • FND_ID_FLEX_STRUCTURES_VL
      • FND_SEGMENT_ATTRIBUTE_VALUES
    • Folders
      • FND_DEFAULT_FOLDERS
      • FND_FOLDERS
      • FND_FOLDER_COLUMNS
    • Lookups
      • FND_LOOKUP_TYPES
      • FND_LOOKUP_TYPES_TL
      • FND_LOOKUP_VALUES
    • Menus and Functions
      • FND_FORM_FUNCTIONS_VL
      • FND_MENUS_VL
      • FND_MENU_ENTRIES_VL
    • Profiles
      • FND_PROFILE_OPTIONS
      • FND_PROFILE_OPTIONS_TL
      • FND_PROFILE_OPTION_VALUES
    • Responsibilities etc.
      • Menus
        • FND_MENUS(menu_id)
        • FND_MENUS_TL(menu_id)
      • Request Groups
        • FND_REQUEST_GROUP_UNITS
        • FND_REQUEST_GROUPS (request_group_id)
      • Request Sets
        • FND_REQUEST_SETS
        • FND_REQUEST_SETS_TL
      • Responsibilities
        • FND_RESPONSIBILITY (responsibility_id)
        • FND_RESPONSIBILITY_TL (responsibility_id)
      • Responsibilities – Exclusions
        • FND_RESP_FUNCTIONS
    • Users
      • FND_USER (user_id)
    • Various
      • FND_DATA_GROUPS (data_group_id)
    • Workflow
      • WF_ACTIVITIES_VL
      • WF_ITEMS (item_type, item_key)
      • WF_ITEM_ATTRIBUTES
      • WF_ITEM_ATTRIBUTES_TL
      • WF_ITEM_ATTRIBUTE_VALUES
      • WF_ITEM_TYPES_TL
      • WF_LOCAL_ROLES
      • WF_PROCESS_ACTIVITIES
  • SysAdmin
    • XML Publisher Templates
      • XDO_TEMPLATES_B
      • XDO_TEMPLATES_VL