A List of Source Tables
Here's the list of tables and offering names associated with EBS Domains, Common, GL, AP, AR, EE, PR, SLA, FA, Proc, and Projects modules.
| Datastore Name | App Code | Application Name |
|---|---|---|
|
AP_AGING_PERIOD_LINES |
SQLAP |
Payables |
|
AP_TERMS_TL |
SQLAP |
Payables |
|
AR_AGING_BUCKETS |
AR |
Receivables |
|
AR_AGING_BUCKET_LINES_B |
AR |
Receivables |
|
AR_AGING_BUCKET_LINES_TL |
AR |
Receivables |
|
AR_RECEIPT_METHODS |
AR |
Receivables |
|
BOM_RESOURCES |
BOM |
Bills of Material |
|
CR_RSRC_CLS_B |
GMP |
Process Manufacturing Process Planning |
|
CR_RSRC_MST_TL |
GMP |
Process Manufacturing Process Planning |
|
CST_COST_ELEMENTS |
BOM |
Bills of Material |
|
FA_BOOK_CONTROLS |
OFA |
Assets |
|
FA_LEASES |
OFA |
Assets |
|
FA_LOOKUPS_VL |
OFA |
Assets |
|
FA_WARRANTIES |
OFA |
Assets |
|
FND_APPLICATION_TL |
FND |
Application Object Library |
|
FND_CURRENCIES_TL |
FND |
Application Object Library |
|
FND_FLEX_VALUES |
FND |
Application Object Library |
|
FND_FLEX_VALUES_TL |
FND |
Application Object Library |
|
FND_ID_FLEX_SEGMENTS |
FND |
Application Object Library |
|
FND_ID_FLEX_STRUCTURES |
FND |
Application Object Library |
|
FND_ID_FLEX_STRUCTURES_TL |
FND |
Application Object Library |
|
FND_LOOKUP_VALUES |
FND |
Application Object Library |
|
FND_TERRITORIES_TL |
FND |
Application Object Library |
|
GL_BUDGETS |
SQLGL |
General Ledger |
|
GL_BUDGET_VERSIONS |
SQLGL |
General Ledger |
|
GL_DAILY_CONVERSION_TYPES |
SQLGL |
General Ledger |
|
GL_ENCUMBRANCE_TYPES |
SQLGL |
General Ledger |
|
GL_JE_SOURCES_TL |
SQLGL |
General Ledger |
|
GL_LEDGERS |
SQLGL |
General Ledger |
|
HZ_RELATIONSHIP_TYPES |
AR |
Receivables |
|
IBY_PAYMENT_METHODS_TL |
IBY |
Payments |
|
MTL_CATEGORIES_TL |
INV |
Inventory |
|
MTL_CATEGORY_SETS_B |
INV |
Inventory |
|
MTL_CATEGORY_SETS_TL |
INV |
Inventory |
|
MTL_ITEM_CATALOG_GROUPS_TL |
INV |
Inventory |
|
MTL_ITEM_STATUS_VL |
INV |
Inventory |
|
MTL_PARAMETERS |
INV |
Inventory |
|
MTL_TRANSACTION_REASONS |
INV |
Inventory |
|
MTL_TRANSACTION_TYPES_VL |
INV |
Inventory |
|
MTL_TXN_SOURCE_TYPES_VL |
INV |
Inventory |
|
MTL_UNITS_OF_MEASURE_TL |
INV |
Inventory |
|
PAY_US_COUNTIES |
PAY |
Payroll |
|
PAY_US_STATES |
PAY |
Payroll |
|
PA_AGREEMENT_TYPES |
PA |
Projects |
|
PA_BUDGET_TYPES |
PA |
Projects |
|
PA_CLASS_CATEGORIES |
PA |
Projects |
|
PA_CLASS_CODES |
PA |
Projects |
|
PA_EGO_LIFECYCLES_PHASES_V |
PA |
Projects |
|
PA_EVENT_TYPES |
PA |
Projects |
|
PA_EXPENDITURE_CATEGORIES |
PA |
Projects |
|
PA_EXPENDITURE_TYPES |
PA |
Projects |
|
PA_FIN_PLAN_TYPES_TL |
PA |
Projects |
|
PA_NON_LABOR_RESOURCES |
PA |
Projects |
|
PA_PROJECTS_ALL |
PA |
Projects |
|
PA_PROJECT_ROLE_TYPES_B |
PA |
Projects |
|
PA_PROJECT_ROLE_TYPES_TL |
PA |
Projects |
|
PA_PROJECT_STATUSES |
PA |
Projects |
|
PA_PROJECT_TYPES_ALL |
PA |
Projects |
|
PA_RESOURCE_CLASSES_B |
PA |
Projects |
|
PA_RESOURCE_CLASSES_TL |
PA |
Projects |
|
PA_SYSTEM_LINKAGES |
PA |
Projects |
|
PA_TASK_TYPES |
PA |
Projects |
|
PA_WORK_TYPES_TL |
PA |
Projects |
|
PON_AUC_DOCTYPES_TL |
PON |
Sourcing |
|
PON_DOCTYPE_STYLES |
PON |
Sourcing |
|
PON_NEGOTIATION_STYLES_TL |
PON |
Sourcing |
|
PO_DOC_STYLE_LINES_TL |
PO |
Purchasing |
|
PO_HAZARD_CLASSES_TL |
PO |
Purchasing |
|
PO_LINE_TYPES_TL |
PO |
Purchasing |
|
RA_CUST_TRX_TYPES_ALL |
AR |
Receivables |
|
RA_TERMS_TL |
AR |
Receivables |
|
XLA_ACCTG_METHODS_TL |
XLA |
Subledger Accounting |
|
XLA_SUBLEDGERS |
XLA |
Subledger Accounting |
Unique offering Names: Payables, Receivables, Bills of Material, Process Manufacturing Process Planning, Assets, Application Object Library, General Ledger, Payments, Inventory, Payroll, Projects, Sourcing, Purchasing, Subledger Accounting
EBS Common table list and associated offerings:
| Datastore Name | App Code | Application Name |
|---|---|---|
|
AP_EXPENSE_REPORT_PARAMS_ALL |
SQLAP |
Payables |
|
AP_SUPPLIERS |
SQLAP |
Payables |
|
AP_SUPPLIER_SITES_ALL |
SQLAP |
Payables |
|
AP_TERMS_LINES |
SQLAP |
Payables |
|
AP_TERMS_TL |
SQLAP |
Payables |
|
AR_RECEIPT_METHODS |
AR |
Receivables |
|
BOM_DEPARTMENTS |
BOM |
Bills of Material |
|
BOM_RESOURCES |
BOM |
Bills of Material |
|
CE_BANK_ACCOUNTS |
CE |
Cash Management |
|
CE_CONTACT_ASSIGNMENTS |
CE |
Cash Management |
|
CM_CMPT_DTL |
GMF |
Process Manufacturing Financials |
|
CM_CMPT_MST_B |
GMF |
Process Manufacturing Financials |
|
CM_MTHD_MST |
GMF |
Process Manufacturing Financials |
|
CR_RSRC_CLS_B |
GMP |
Process Manufacturing Process Planning |
|
CR_RSRC_DTL |
GMP |
Process Manufacturing Process Planning |
|
CR_RSRC_MST_B |
GMP |
Process Manufacturing Process Planning |
|
CST_COST_ELEMENTS |
BOM |
Bills of Material |
|
FND_FLEX_VALUES |
FND |
Application Object Library |
|
FND_FLEX_VALUES_TL |
FND |
Application Object Library |
|
FND_FLEX_VALUE_CHILDREN_V |
FND |
Application Object Library |
|
FND_FLEX_VALUE_NORM_HIERARCHY |
FND |
Application Object Library |
|
FND_FLEX_VALUE_SETS |
FND |
Application Object Library |
|
FND_ID_FLEX_SEGMENTS |
FND |
Application Object Library |
|
FND_LOOKUP_VALUES |
FND |
Application Object Library |
|
FND_SEGMENT_ATTRIBUTE_VALUES |
FND |
Application Object Library |
|
FND_USER |
FND |
Application Object Library |
|
FV_FACTS_FEDERAL_ACCOUNTS |
FV |
Federal Financials |
|
FV_FUND_PARAMETERS |
FV |
Federal Financials |
|
FV_TREASURY_SYMBOLS |
FV |
Federal Financials |
|
GL_BUDGETS |
SQLGL |
General Ledger |
|
GL_BUDGET_VERSIONS |
SQLGL |
General Ledger |
|
GL_CODE_COMBINATIONS |
SQLGL |
General Ledger |
|
GL_CODE_COMBINATIONS_KFV |
SQLGL |
General Ledger |
|
GL_DAILY_RATES |
SQLGL |
General Ledger |
|
GL_ENCUMBRANCE_TYPES |
SQLGL |
General Ledger |
|
GL_IMPORT_REFERENCES |
SQLGL |
General Ledger |
|
GL_JE_BATCHES |
SQLGL |
General Ledger |
|
GL_JE_HEADERS |
SQLGL |
General Ledger |
|
GL_JE_LINES |
SQLGL |
General Ledger |
|
GL_LEDGERS |
SQLGL |
General Ledger |
|
GL_LEDGER_CONFIG_DETAILS |
SQLGL |
General Ledger |
|
GL_LEGAL_ENTITIES_BSVS |
SQLGL |
General Ledger |
|
GL_PERIODS |
SQLGL |
General Ledger |
|
GL_PERIOD_SETS |
SQLGL |
General Ledger |
|
GL_PERIOD_STATUSES |
SQLGL |
General Ledger |
|
GL_PERIOD_TYPES |
SQLGL |
General Ledger |
|
GL_SETS_OF_BOOKS |
SQLGL |
General Ledger |
|
GL_XFR_CALENDAR_MAPPINGS |
SQLGL |
General Ledger |
|
GL_XFR_CCID_MAPPINGS |
SQLGL |
General Ledger |
|
GL_XFR_LEDGER_MAPPINGS |
SQLGL |
General Ledger |
|
GL_XFR_PERIOD_MAPPINGS |
SQLGL |
General Ledger |
|
GMD_QUALITY_CONFIG |
GMD |
Process Manufacturing Product Development |
|
GMF_FISCAL_POLICIES |
GMF |
Process Manufacturing Financials |
|
GMF_PERIOD_STATUSES |
GMF |
Process Manufacturing Financials |
|
HR_ALL_ORGANIZATION_UNITS |
AS |
Sales Foundation |
|
HR_ALL_ORGANIZATION_UNITS |
PER |
Human Resources |
|
HR_ALL_ORGANIZATION_UNITS_TL |
PER |
Human Resources |
|
HR_ALL_POSITIONS_F |
PER |
Human Resources |
|
HR_LOCATIONS_ALL |
PER |
Human Resources |
|
HR_LOCATIONS_ALL_TL |
PER |
Human Resources |
|
HR_ORGANIZATION_INFORMATION |
PER |
Human Resources |
|
HXT_PROJECTS |
HXT |
Time and Labor |
|
HXT_TASKS |
HXT |
Time and Labor |
|
HZ_CODE_ASSIGNMENTS |
AR |
Receivables |
|
HZ_CONTACT_POINTS |
AR |
Receivables |
|
HZ_CUST_ACCOUNTS |
AR |
Receivables |
|
HZ_CUST_ACCOUNT_ROLES |
AR |
Receivables |
|
HZ_CUST_ACCT_SITES_ALL |
AR |
Receivables |
|
HZ_CUST_SITE_USES_ALL |
AR |
Receivables |
|
HZ_HIERARCHY_NODES |
AR |
Receivables |
|
HZ_LOCATIONS |
AR |
Receivables |
|
HZ_ORGANIZATION_PROFILES |
AR |
Receivables |
|
HZ_ORG_CONTACTS |
AR |
Receivables |
|
HZ_PARTIES |
AR |
Receivables |
|
HZ_PARTY_SITES |
AR |
Receivables |
|
HZ_PERSON_PROFILES |
AR |
Receivables |
|
HZ_RELATIONSHIPS |
AR |
Receivables |
|
IBY_ACCOUNT_OWNERS |
IBY |
Payments |
|
IBY_EXTERNAL_PAYEES_ALL |
IBY |
Payments |
|
IBY_EXT_BANK_ACCOUNTS |
IBY |
Payments |
|
IBY_EXT_PARTY_PMT_MTHDS |
IBY |
Payments |
|
IBY_PAYMENT_METHODS_B |
IBY |
Payments |
|
IBY_PAYMENT_METHODS_TL |
IBY |
Payments |
|
JTF_RS_GROUPS_B |
JTF |
CRM Foundation |
|
JTF_RS_GROUPS_TL |
JTF |
CRM Foundation |
|
JTF_RS_RESOURCE_EXTNS |
JTF |
CRM Foundation |
|
JTF_RS_SALESREPS |
JTF |
CRM Foundation |
|
MTL_CATEGORIES_B |
INV |
Inventory |
|
MTL_CATEGORIES_TL |
INV |
Inventory |
|
MTL_CATEGORY_SETS_B |
INV |
Inventory |
|
MTL_CATEGORY_SET_VALID_CATS |
INV |
Inventory |
|
MTL_CST_ACTUAL_COST_DETAILS |
INV |
Inventory |
|
MTL_ITEM_CATALOG_GROUPS_B_KFV |
INV |
Inventory |
|
MTL_ITEM_CATEGORIES |
INV |
Inventory |
|
MTL_ITEM_LOCATIONS |
INV |
Inventory |
|
MTL_ITEM_LOCATIONS_KFV |
INV |
Inventory |
|
MTL_MATERIAL_TRANSACTIONS |
INV |
Inventory |
|
MTL_PARAMETERS |
INV |
Inventory |
|
MTL_SAFETY_STOCKS |
INV |
Inventory |
|
MTL_SECONDARY_INVENTORIES |
INV |
Inventory |
|
MTL_SYSTEM_ITEMS_B |
INV |
Inventory |
|
MTL_SYSTEM_ITEMS_TL |
INV |
Inventory |
|
MTL_TRANSACTION_REASONS |
INV |
Inventory |
|
MTL_TRANSACTION_TYPES_VL |
INV |
Inventory |
|
MTL_UNITS_OF_MEASURE_VL |
INV |
Inventory |
|
MTL_UOM_CLASS_CONVERSIONS |
INV |
Inventory |
|
MTL_UOM_CONVERSIONS |
INV |
Inventory |
|
ORG_ORGANIZATION_DEFINITIONS |
INV |
Inventory |
|
PA_CLASS_CATEGORIES |
PA |
Projects |
|
PA_CLASS_CODES |
PA |
Projects |
|
PA_EVENT_TYPES |
PA |
Projects |
|
PA_EXPENDITURE_CATEGORIES |
PA |
Projects |
|
PA_EXPENDITURE_TYPES |
PA |
Projects |
|
PA_IMPLEMENTATIONS_ALL |
PA |
Projects |
|
PA_LOCATIONS |
PA |
Projects |
|
PA_NON_LABOR_RESOURCES |
PA |
Projects |
|
PA_OBJECT_RELATIONSHIPS |
PA |
Projects |
|
PA_PROJECTS_ALL |
PA |
Projects |
|
PA_PROJECT_CLASSES |
PA |
Projects |
|
PA_PROJECT_CUSTOMERS |
PA |
Projects |
|
PA_PROJECT_FUNDINGS |
PA |
Projects |
|
PA_PROJECT_PARTIES |
PA |
Projects |
|
PA_PROJECT_ROLE_TYPES_B |
PA |
Projects |
|
PA_PROJECT_ROLE_TYPES_TL |
PA |
Projects |
|
PA_PROJECT_STATUSES |
PA |
Projects |
|
PA_PROJECT_TYPES_ALL |
PA |
Projects |
|
PA_PROJ_ELEMENTS |
PA |
Projects |
|
PA_PROJ_ELEMENT_VERSIONS |
PA |
Projects |
|
PA_PROJ_ELEM_VER_SCHEDULE |
PA |
Projects |
|
PA_PROJ_ELEM_VER_STRUCTURE |
PA |
Projects |
|
PA_RESOURCE_CLASSES_B |
PA |
Projects |
|
PA_SYSTEM_LINKAGES |
PA |
Projects |
|
PA_TASKS |
PA |
Projects |
|
PA_TASK_TYPES |
PA |
Projects |
|
PER_ADDRESSES |
PER |
Human Resources |
|
PER_ALL_ASSIGNMENTS_F |
PER |
Human Resources |
|
PER_ALL_PEOPLE_F |
PER |
Human Resources |
|
PER_ASSIGNMENT_STATUS_TYPES |
PER |
Human Resources |
|
PER_CONTRACTS_F |
PER |
Human Resources |
|
PER_JOBS |
PER |
Human Resources |
|
PER_ORGANIZATION_STRUCTURES |
PER |
Human Resources |
|
PER_ORG_STRUCTURE_ELEMENTS |
PER |
Human Resources |
|
PER_ORG_STRUCTURE_VERSIONS |
PER |
Human Resources |
|
PER_PERIODS_OF_SERVICE |
PER |
Human Resources |
|
PER_PERSON_TYPES |
PER |
Human Resources |
|
PER_PHONES |
PER |
Human Resources |
|
PER_WORKFORCE_CURRENT_X |
PER |
Human Resources |
|
PON_DOCTYPE_STYLES |
PON |
Sourcing |
|
POS_BUS_CLASS_ATTR |
POS |
iSupplier Portal |
|
PO_AGENTS |
PO |
Purchasing |
|
PO_APPROVED_SUPPLIER_LIST |
PO |
Purchasing |
|
PO_ASL_ATTRIBUTES |
PO |
Purchasing |
|
PO_ASL_STATUSES |
PO |
Purchasing |
|
PO_DOCUMENT_TYPES_ALL_B |
PO |
Purchasing |
|
PO_DOCUMENT_TYPES_ALL_TL |
PO |
Purchasing |
|
PO_DOC_STYLE_LINES_B |
PO |
Purchasing |
|
PO_LINE_TYPES_B |
PO |
Purchasing |
|
PO_LINE_TYPES_TL |
PO |
Purchasing |
|
PO_VENDORS |
PO |
Purchasing |
|
PO_VENDORS |
SQLAP |
Payables |
|
RA_CUST_TRX_TYPES_ALL |
AR |
Receivables |
|
RA_TERMS_B |
AR |
Receivables |
|
RA_TERMS_LINES |
AR |
Receivables |
|
XLA_ACCTG_METHODS_TL |
XLA |
Subledger Accounting |
|
XLA_AE_HEADERS |
XLA |
Subledger Accounting |
|
XLA_AE_LINES |
XLA |
Subledger Accounting |
|
XLA_DISTRIBUTION_LINKS |
XLA |
Subledger Accounting |
|
XLE_ENTITY_PROFILES |
XLE |
Legal Entity Configurator |
|
XLE_REGISTRATIONS |
XLE |
Legal Entity Configurator |
Unique Offering names: Cash Management, CRM Foundation, Federal Financials, Human Resources, iSupplier Portal, Legal Entity Configurator, Process Manufacturing Financials, Process Manufacturing Product Development, Sales Foundation, Time and Labor
EBS GL (General Ledger) table list and associated offerings:
| Datastore Name | App Code | Application Name |
|---|---|---|
|
FND_DUAL |
FND |
Application Object Library |
|
GL_BALANCES |
SQLGL |
General Ledger |
|
GL_CODE_COMBINATIONS |
SQLGL |
General Ledger |
|
GL_ENCUMBRANCE_TYPES |
SQLGL |
General Ledger |
|
GL_LEDGERS |
SQLGL |
General Ledger |
|
GL_PERIODS |
SQLGL |
General Ledger |
EBS AP (Accounts Payable) table list and associated offerings:
| Datastore Name | App Code | Application Name |
|---|---|---|
|
AP_AGING_PERIODS |
SQLAP |
Payables |
|
AP_AGING_PERIOD_LINES |
SQLAP |
Payables |
|
AP_CHECKS_ALL |
SQLAP |
Payables |
|
AP_HOLDS_ALL |
SQLAP |
Payables |
|
AP_HOLD_CODES |
SQLAP |
Payables |
|
AP_INVOICES_ALL |
SQLAP |
Payables |
|
AP_INVOICE_DISTRIBUTIONS_ALL |
SQLAP |
Payables |
|
AP_INVOICE_PAYMENTS_ALL |
SQLAP |
Payables |
|
AP_PAYMENT_HISTORY_ALL |
SQLAP |
Payables |
|
AP_PAYMENT_HIST_DISTS |
SQLAP |
Payables |
|
AP_PAYMENT_SCHEDULES_ALL |
SQLAP |
Payables |
|
AP_PREPAY_APP_DISTS |
SQLAP |
Payables |
|
AP_SYSTEM_PARAMETERS_ALL |
SQLAP |
Payables |
|
CE_BANK_ACCT_USES_ALL |
CE |
Cash Management |
|
FND_DUAL |
FND |
Application Object Library |
|
GL_LEDGERS |
SQLGL |
General Ledger |
|
PO_DISTRIBUTIONS_ALL |
PO |
Purchasing |
|
PO_HEADERS_ALL |
PO |
Purchasing |
|
PO_LINES_ALL |
PO |
Purchasing |
|
XLA_AE_HEADERS |
XLA |
Subledger Accounting |
|
XLA_AE_LINES |
XLA |
Subledger Accounting |
EBS AR (Accounts Receivable) table list and associated offerings:
| Datastore Name | App Code | Application Name |
|---|---|---|
|
AR_ADJUSTMENTS_ALL |
AR |
Receivables |
|
AR_AGING_BUCKETS |
AR |
Receivables |
|
AR_AGING_BUCKET_LINES_B |
AR |
Receivables |
|
AR_CASH_RECEIPTS_ALL |
AR |
Receivables |
|
AR_CASH_RECEIPT_HISTORY_ALL |
AR |
Receivables |
|
AR_COLLECTORS |
AR |
Receivables |
|
AR_DISTRIBUTIONS_ALL |
AR |
Receivables |
|
AR_PAYMENT_SCHEDULES_ALL |
AR |
Receivables |
|
AR_RECEIVABLE_APPLICATIONS_ALL |
AR |
Receivables |
|
CE_BANK_ACCT_USES_ALL |
CE |
Cash Management |
|
GL_LEDGERS |
SQLGL |
General Ledger |
|
HZ_CUSTOMER_PROFILES |
AR |
Receivables |
|
HZ_CUST_ACCOUNTS |
AR |
Receivables |
|
HZ_CUST_PROFILE_AMTS |
AR |
Receivables |
|
HZ_CUST_SITE_USES_ALL |
AR |
Receivables |
|
HZ_PARTIES |
AR |
Receivables |
|
JTF_RS_SALESREPS |
JTF |
CRM Foundation |
|
PA_AGREEMENTS_ALL |
PA |
Projects |
|
RA_CUSTOMER_TRX_ALL |
AR |
Receivables |
|
RA_CUST_TRX_LINE_GL_DIST_ALL |
AR |
Receivables |
|
RA_CUST_TRX_TYPES_ALL |
AR |
Receivables |
|
XLA_EVENTS |
XLA |
Subledger Accounting |
|
XLA_TRANSACTION_ENTITIES |
XLA |
Subledger Accounting |
EBS EE (Employee Expenses) table list and associated offerings:
| Datastore Name | App Code | Application Name |
|---|---|---|
|
AP_CARDS_ALL |
SQLAP |
Payables |
|
AP_CREDIT_CARD_TRXNS_ALL |
SQLAP |
Payables |
|
AP_EXPENSE_REPORT_HEADERS_ALL |
SQLAP |
Payables |
|
AP_EXPENSE_REPORT_LINES_ALL |
SQLAP |
Payables |
|
AP_EXP_REPORT_DISTS_ALL |
SQLAP |
Payables |
|
AP_INVOICES_ALL |
SQLAP |
Payables |
|
AP_NOTES |
SQLAP |
Payables |
|
AP_POL_VIOLATIONS_ALL |
SQLAP |
Payables |
|
FND_ID_FLEX_SEGMENTS |
FND |
Application Object Library |
|
FND_SEGMENT_ATTRIBUTE_VALUES |
FND |
Application Object Library |
|
FND_USER |
FND |
Application Object Library |
|
GL_LEDGERS |
SQLGL |
General Ledger |
|
HR_ORGANIZATION_INFORMATION |
PER |
Human Resources |
EBS PR (Profitability) table list and associated offerings:
| Datastore Name | App Code | Application Name |
|---|---|---|
|
AR_ADJUSTMENTS_ALL |
AR |
Receivables |
|
AR_DISTRIBUTIONS_ALL |
AR |
Receivables |
|
GL_LEDGERS |
SQLGL |
General Ledger |
|
GL_SETS_OF_BOOKS |
SQLGL |
General Ledger |
|
HR_ORGANIZATION_INFORMATION |
PER |
Human Resources |
|
HZ_CUST_SITE_USES_ALL |
AR |
Receivables |
|
JTF_RS_SALESREPS |
JTF |
CRM Foundation |
|
MTL_MATERIAL_TRANSACTIONS |
INV |
Inventory |
|
MTL_PARAMETERS |
INV |
Inventory |
|
MTL_TRANSACTION_ACCOUNTS |
INV |
Inventory |
|
OE_ORDER_HEADERS_ALL |
ONT |
Order Management |
|
OE_ORDER_LINES_ALL |
ONT |
Order Management |
|
ORG_ACCT_PERIODS |
INV |
Inventory |
|
ORG_ORGANIZATION_DEFINITIONS |
INV |
Inventory |
|
RA_CUSTOMER_TRX_ALL |
AR |
Receivables |
|
RA_CUSTOMER_TRX_LINES_ALL |
AR |
Receivables |
|
RA_CUST_TRX_LINE_GL_DIST_ALL |
AR |
Receivables |
|
RA_TERRITORIES |
AR |
Receivables |
Unique Offering Name: Order Management
EBS SLA (Subledger Accounting) table list and associated offerings:
| Datastore Name | App Code | Application Name |
|---|---|---|
|
AP_INVOICES_ALL |
SQLAP |
Payables |
|
FND_APPLICATION |
FND |
Application Object Library |
|
GL_CODE_COMBINATIONS |
SQLGL |
General Ledger |
|
GL_IMPORT_REFERENCES |
SQLGL |
General Ledger |
|
GL_JE_HEADERS |
SQLGL |
General Ledger |
|
GL_LEDGERS |
SQLGL |
General Ledger |
|
GL_PERIODS |
SQLGL |
General Ledger |
|
RA_CUSTOMER_TRX_ALL |
AR |
Receivables |
|
XLA_AC_BALANCES |
XLA |
Subledger Accounting |
|
XLA_AE_HEADERS |
XLA |
Subledger Accounting |
|
XLA_AE_LINES |
XLA |
Subledger Accounting |
|
XLA_AE_LINE_ACS |
XLA |
Subledger Accounting |
|
XLA_CONTROL_BALANCES |
XLA |
Subledger Accounting |
|
XLA_DISTRIBUTION_LINKS |
XLA |
Subledger Accounting |
|
XLA_SUBLEDGERS |
XLA |
Subledger Accounting |
|
XLA_TRANSACTION_ENTITIES |
XLA |
Subledger Accounting |
EBS FA (Fixed Assets) table list and associated offerings:
| Datastore Name | App Code | Application Name |
|---|---|---|
|
FA_ADDITIONS_B |
OFA |
Assets |
|
FA_ADDITIONS_TL |
OFA |
Assets |
|
FA_ADD_WARRANTIES |
OFA |
Assets |
|
FA_ADJUSTMENTS |
OFA |
Assets |
|
FA_AMORT_SCHEDULES |
OFA |
Assets |
|
FA_ASSET_HISTORY |
OFA |
Assets |
|
FA_BOOKS |
OFA |
Assets |
|
FA_BOOK_CONTROLS |
OFA |
Assets |
|
FA_CATEGORIES_B |
OFA |
Assets |
|
FA_CATEGORIES_TL |
OFA |
Assets |
|
FA_DEPRN_DETAIL |
OFA |
Assets |
|
FA_DEPRN_PERIODS |
OFA |
Assets |
|
FA_DISTRIBUTION_HISTORY |
OFA |
Assets |
|
FA_LEASES |
OFA |
Assets |
|
FA_LEASE_PAYMENTS |
OFA |
Assets |
|
FA_LEASE_PAYMENT_ITEMS |
OFA |
Assets |
|
FA_LEASE_SCHEDULES |
OFA |
Assets |
|
FA_LOCATIONS |
OFA |
Assets |
|
FA_RETIREMENTS |
OFA |
Assets |
|
FA_TRANSACTION_HEADERS |
OFA |
Assets |
|
FA_WARRANTIES |
OFA |
Assets |
|
GL_SETS_OF_BOOKS |
SQLGL |
General Ledger |
EBS Projects (Projects) table list and associated offerings:
| Datastore Name | App Code | Application Name |
|---|---|---|
|
AP_INVOICES_ALL |
SQLAP |
Payables |
|
AP_INVOICE_DISTRIBUTIONS_ALL |
SQLAP |
Payables |
|
BOM_RESOURCES |
BOM |
Bills of Material |
|
FA_ASSET_HISTORY |
OFA |
Assets |
|
FND_LOOKUP_VALUES |
FND |
Application Object Library |
|
GL_LEDGERS |
SQLGL |
General Ledger |
|
HR_ORGANIZATION_INFORMATION |
PER |
Human Resources |
|
JTF_CALENDARS_B |
JTF |
CRM Foundation |
|
JTF_CAL_EXCEPTIONS_B |
JTF |
CRM Foundation |
|
JTF_CAL_EXCEPTION_ASSIGN |
JTF |
CRM Foundation |
|
JTF_CAL_RESOURCE_ASSIGN |
JTF |
CRM Foundation |
|
JTF_CAL_SHIFT_ASSIGN |
JTF |
CRM Foundation |
|
JTF_CAL_SHIFT_CONSTRUCTS |
JTF |
CRM Foundation |
|
MTL_UNITS_OF_MEASURE_TL |
INV |
Inventory |
|
PAY_PEOPLE_GROUPS |
PAY |
Payroll |
|
PA_AGREEMENTS_ALL |
PA |
Projects |
|
PA_BUDGET_ENTRY_METHODS |
PA |
Projects |
|
PA_BUDGET_LINES |
PA |
Projects |
|
PA_BUDGET_TYPES |
PA |
Projects |
|
PA_BUDGET_VERSIONS |
PA |
Projects |
|
PA_CAPITAL_EVENTS |
PA |
Projects |
|
PA_CC_DIST_LINES_ALL |
PA |
Projects |
|
PA_COMMITMENT_TXNS |
PA |
Projects |
|
PA_COMPETENCE_PROFILES |
PA |
Projects |
|
PA_COST_DISTRIBUTION_LINES_ALL |
PA |
Projects |
|
PA_CUST_EVENT_RDL_ALL |
PA |
Projects |
|
PA_CUST_REV_DIST_LINES_ALL |
PA |
Projects |
|
PA_DRAFT_INVOICES_ALL |
PA |
Projects |
|
PA_DRAFT_INVOICE_ITEMS |
PA |
Projects |
|
PA_DRAFT_REVENUES_ALL |
PA |
Projects |
|
PA_EVENTS |
PA |
Projects |
|
PA_EVENT_TYPES |
PA |
Projects |
|
PA_EXPENDITURES_ALL |
PA |
Projects |
|
PA_EXPENDITURE_ITEMS_ALL |
PA |
Projects |
|
PA_EXPENDITURE_TYPES |
PA |
Projects |
|
PA_FIN_PLAN_TYPES_B |
PA |
Projects |
|
PA_FIN_PLAN_TYPES_TL |
PA |
Projects |
|
PA_FORECAST_ITEMS |
PA |
Projects |
|
PA_IMPLEMENTATIONS_ALL |
PA |
Projects |
|
PA_LOCATIONS |
PA |
Projects |
|
PA_NON_LABOR_RESOURCES |
PA |
Projects |
|
PA_PERCENT_COMPLETES |
PA |
Projects |
|
PA_PROJECTS_ALL |
PA |
Projects |
|
PA_PROJECT_ASSETS_ALL |
PA |
Projects |
|
PA_PROJECT_ASSET_LINES_ALL |
PA |
Projects |
|
PA_PROJECT_ASSET_LINE_DETAILS |
PA |
Projects |
|
PA_PROJECT_ASSIGNMENTS |
PA |
Projects |
|
PA_PROJECT_CUSTOMERS |
PA |
Projects |
|
PA_PROJECT_FUNDINGS |
PA |
Projects |
|
PA_PROJECT_STATUSES |
PA |
Projects |
|
PA_PROJECT_TYPES_ALL |
PA |
Projects |
|
PA_PROJ_FP_OPTIONS |
PA |
Projects |
|
PA_RESOURCES |
PA |
Projects |
|
PA_RESOURCES_DENORM |
PA |
Projects |
|
PA_RESOURCE_ASSIGNMENTS |
PA |
Projects |
|
PA_SCHEDULES |
PA |
Projects |
|
PA_SUMMARY_PROJECT_FUNDINGS |
PA |
Projects |
|
PA_SUMMARY_PROJECT_RETN |
PA |
Projects |
|
PA_TASKS |
PA |
Projects |
|
PA_UTIL_CATEGORIES_TL |
PA |
Projects |
|
PA_WORK_TYPES_B |
PA |
Projects |
|
PER_ALL_ASSIGNMENTS_F |
PER |
Human Resources |
|
PER_ASSIGNMENT_STATUS_TYPES |
PER |
Human Resources |
|
PER_COMPETENCES |
PER |
Human Resources |
|
PER_COMPETENCES_TL |
PER |
Human Resources |
|
PER_COMPETENCE_DEFINITIONS |
PER |
Human Resources |
|
PER_COMPETENCE_ELEMENTS |
PER |
Human Resources |
|
PER_JOBS |
PER |
Human Resources |
|
PER_JOBS_TL |
PER |
Human Resources |
|
PER_JOB_DEFINITIONS |
PER |
Human Resources |
|
PER_PAY_BASES |
PER |
Human Resources |
|
PER_PERIODS_OF_PLACEMENT |
PER |
Human Resources |
|
PER_RATING_LEVELS |
PER |
Human Resources |
|
PER_RATING_LEVELS_TL |
PER |
Human Resources |
|
PER_RATING_SCALES |
PER |
Human Resources |
|
PER_RATING_SCALES_TL |
PER |
Human Resources |
|
PO_LINES_ALL |
PO |
Purchasing |
|
PO_LINE_TYPES_B |
PO |
Purchasing |
EBS PROC (Procurement) table list and associated offerings:
| Datastore Name | App Code | Application Name |
|---|---|---|
|
AP_HOLDS_ALL |
SQLAP |
Payables |
|
AP_INVOICES_ALL |
SQLAP |
Payables |
|
AP_INVOICE_DISTRIBUTIONS_ALL |
SQLAP |
Payables |
|
AP_INVOICE_LINES_ALL |
SQLAP |
Payables |
|
AP_SUPPLIER_SITES_ALL |
SQLAP |
Payables |
|
FINANCIALS_SYSTEM_PARAMS_ALL |
SQLAP |
Payables |
|
GL_LEDGERS |
SQLGL |
General Ledger |
|
GL_SETS_OF_BOOKS |
SQLGL |
General Ledger |
|
HR_ORGANIZATION_INFORMATION |
PER |
Human Resources |
|
HZ_PARTIES |
AR |
Receivables |
|
MTL_MATERIAL_TRANSACTIONS |
INV |
Inventory |
|
MTL_PARAMETERS |
INV |
Inventory |
|
MTL_SYSTEM_ITEMS_B |
INV |
Inventory |
|
MTL_TRANSACTION_ACCOUNTS |
INV |
Inventory |
|
MTL_TRANSACTION_FLOW_HEADERS |
INV |
Inventory |
|
MTL_TRANSACTION_REASONS |
INV |
Inventory |
|
MTL_TRANSACTION_TYPES_VL |
INV |
Inventory |
|
MTL_UNITS_OF_MEASURE_TL |
INV |
Inventory |
|
MTL_UNITS_OF_MEASURE_VL |
INV |
Inventory |
|
ORG_ORGANIZATION_DEFINITIONS |
INV |
Inventory |
|
PON_ACCEPTANCES |
PON |
Sourcing |
|
PON_AUCTION_HEADERS_ALL_V |
PON |
Sourcing |
|
PON_AUCTION_ITEM_PRICES_ALL |
PON |
Sourcing |
|
PON_BIDDING_PARTIES |
PON |
Sourcing |
|
PON_BID_HEADERS |
PON |
Sourcing |
|
PON_BID_ITEM_PRICES |
PON |
Sourcing |
|
POS_SUPPLIER_REGISTRATIONS |
POS |
iSupplier Portal |
|
PO_ACTION_HISTORY |
PO |
Purchasing |
|
PO_DISTRIBUTIONS_ALL |
PO |
Purchasing |
|
PO_DOC_STYLE_HEADERS |
PO |
Purchasing |
|
PO_GA_ORG_ASSIGNMENTS |
PO |
Purchasing |
|
PO_HEADERS_ALL |
PO |
Purchasing |
|
PO_LINES_ALL |
PO |
Purchasing |
|
PO_LINE_LOCATIONS_ALL |
PO |
Purchasing |
|
PO_RELEASES_ALL |
PO |
Purchasing |
|
PO_REQUISITION_HEADERS_ALL |
PO |
Purchasing |
|
PO_REQUISITION_LINES_ALL |
PO |
Purchasing |
|
PO_REQ_DISTRIBUTIONS_ALL |
PO |
Purchasing |
|
PO_VENDORS |
PO |
Purchasing |
|
PO_VENDORS |
SQLAP |
Payables |
|
RCV_SHIPMENT_HEADERS |
PO |
Purchasing |
|
RCV_SHIPMENT_LINES |
PO |
Purchasing |
|
RCV_TRANSACTIONS |
PO |
Purchasing |
|
WIP_TRANSACTIONS |
WIP |
Work in Process |
|
WIP_TRANSACTION_ACCOUNTS |
WIP |
Work in Process |
Unique Offering Name: Work in Process