Table: XLA_UPGRADE_DATES | Oracle EBS ETRM Search

This view is based on tables gl_sets_of_books and hr_organization_information. It will contain information about the Currency corresponding to a Ledger.

APPS.FII_OU_LEDGER_V·↳ GL_SETS_OF_BOOKS·↳ HR_ORGANIZATION_INFORMATION·Explore FII module →

View: XLA_DIAG_NUMBERS_V 12.2.2

XLA - Subledger Accounting·6 columns

This view retrieves the different transaction numbers for an event stored in XLA_DIAG_EVENTS table. This view is defined for the XLA_DIAG_TRANS_NUMBERS value set defined for the Transaction Object Diagnostics concurrent request.

APPS.XLA_DIAG_NUMBERS_V·↳ XLA_DIAG_EVENTS·Explore XLA module →

View: AR_CM_BATCHES_H_V 12.1.1

AR - Receivables·6 columns

AR XLA Extract

APPS.AR_CM_BATCHES_H_V·↳ AR_XLA_LINES_EXTRACT·↳ RA_BATCHES_ALL·Explore AR module →

View: AR_AGREEMENTS_S_V 12.2.2

AR - Receivables·6 columns

agreement shared extract

APPS.AR_AGREEMENTS_S_V·↳ AR_XLA_LINES_EXTRACT·↳ OE_AGREEMENTS_B·Explore AR module →

View: AR_PAYMENT_TERM_S_VL 12.2.2

AR - Receivables·6 columns

payment term shared mls extract

APPS.AR_PAYMENT_TERM_S_VL·↳ AR_XLA_LINES_EXTRACT·↳ RA_TERMS_TL·Explore AR module →

View: ARFV_ADJ_DISTS_ALC_V 12.2.2

AR - Receivables·6 columns

This shows Alternate Currencies information about adjustment amounts transferred to the Subledger Accounting.

APPS.ARFV_ADJ_DISTS_ALC_V·↳ AR_DISTRIBUTIONS_ALL·↳ FND_CURRENCIES·↳ GL_LEDGERS_PUBLIC_V·Explore AR module →

View: GL_ALL_PERIOD_NAME_VIEW 12.2.2

GL - General Ledger·6 columns

APPS.GL_ALL_PERIOD_NAME_VIEW·↳ GL_LOOKUPS·↳ GL_PERIOD_STATUSES·Explore GL module →

View: GL_ALL_PERIOD_NAME_VIEW 12.1.1

GL - General Ledger·6 columns

APPS.GL_ALL_PERIOD_NAME_VIEW·↳ GL_LOOKUPS·↳ GL_PERIOD_STATUSES·Explore GL module →

Table: AP_TB_BALANCES_TMP 12.1.1

owner AP·AP - Payables·4 columns

AP_TB_BALANCES_TMP stores balance amounts for each liability account within a ledger as of the balance date. This table is used during trial balance upgrade to populate the account balances based on XLA_UPGRADE_DATES.start_date

AP.AP_TB_BALANCES_TMP·Explore AP module →

View: GL_SRS_LEDGER_BUD_ENCUM_NAME 12.2.2

GL - General Ledger·4 columns

Review budget names and encumbrance types

APPS.GL_SRS_LEDGER_BUD_ENCUM_NAME·↳ GL_BUDGETS·↳ GL_BUDGET_PERIOD_RANGES·↳ GL_BUDGET_VERSIONS·Explore GL module →

View: GL_INTERFACE_GROUPS_V 12.1.1

GL - General Ledger·4 columns

10SC ONLY

APPS.GL_INTERFACE_GROUPS_V·↳ GL_INTERFACE·Explore GL module →

View: GL_SRS_DEL_JI_GROUPS_V 12.1.1

GL - General Ledger·4 columns

APPS.GL_SRS_DEL_JI_GROUPS_V·↳ GL_INTERFACE·↳ GL_INTERFACE_CONTROL·↳ GL_JE_SOURCES·Explore GL module →

View: JG_ZZ_SRS_LEDGER_BUD_ENCUM_V 12.2.2

JG - Regional Localizations·4 columns

APPS.JG_ZZ_SRS_LEDGER_BUD_ENCUM_V·↳ GL_BUDGETS·↳ GL_BUDGET_PERIOD_RANGES·↳ GL_BUDGET_VERSIONS·Explore JG module →

View: GL_PERIOD_STATUSES_FIRST_60_V 12.1.1

GL - General Ledger·4 columns

10SC ONLY

APPS.GL_PERIOD_STATUSES_FIRST_60_V·↳ GL_PERIOD_STATUSES·Explore GL module →

View: PSBBV_GL_ACCOUNT_HIERARCHIES 12.1.1

PSB - Public Sector Budgeting·4 columns

APPS.PSBBV_GL_ACCOUNT_HIERARCHIES·↳ GL_ACCOUNT_HIERARCHIES·Explore PSB module →

View: JG_ZZ_SRS_LEDGER_PER_START_V 12.1.1

JG - Regional Localizations·7 columns

APPS.JG_ZZ_SRS_LEDGER_PER_START_V·↳ GL_BUDGET_PERIOD_RANGES·↳ GL_LEDGERS·↳ GL_LEDGER_SET_ASSIGNMENTS·Explore JG module →

View: GLBV_GL_BUDGET_ORGANIZATIONS 12.1.1

GL - General Ledger·7 columns

APPS.GLBV_GL_BUDGET_ORGANIZATIONS·↳ GL_BUDGET_ENTITIES·Explore GL module →

View: GL_PERIOD_NAMES_ALL_V 12.1.1

GL - General Ledger·7 columns

10SC ONLY

APPS.GL_PERIOD_NAMES_ALL_V·↳ FINANCIALS_SYSTEM_PARAMETERS·↳ GL_PERIOD_STATUSES·Explore GL module →

View: GLBV_GL_PERIOD_EXCHANGE_RATES 12.1.1

GL - General Ledger·7 columns

APPS.GLBV_GL_PERIOD_EXCHANGE_RATES·↳ GL_DAILY_RATES·↳ GL_LEDGERS·↳ GL_LOOKUPS·Explore GL module →

View: GL_PERIOD_NAMES_ALL_V 12.2.2

GL - General Ledger·7 columns

10SC ONLY

APPS.GL_PERIOD_NAMES_ALL_V·↳ FINANCIALS_SYSTEM_PARAMETERS·↳ GL_PERIOD_STATUSES·Explore GL module →

View: GL_BUDGETS_NO_JOURNALS_V 12.2.2

GL - General Ledger·7 columns

10SC ONLY

APPS.GL_BUDGETS_NO_JOURNALS_V·↳ GL_BUDGETS·↳ GL_BUDGET_VERSIONS·Explore GL module →

View: AR_AGREEMENTS_S_VL 12.2.2

AR - Receivables·5 columns

agreement shared mls extract

APPS.AR_AGREEMENTS_S_VL·↳ AR_XLA_LINES_EXTRACT·↳ OE_AGREEMENTS_TL·Explore AR module →

View: AR_TRX_TAX_L_VL 12.2.2

AR - Receivables·5 columns

transaction tax line mls extract

APPS.AR_TRX_TAX_L_VL·↳ AR_VAT_TAX_ALL_TL·↳ AR_XLA_LINES_EXTRACT·Explore AR module →

View: AR_CM_ITEM_CAT_L_VL 12.2.2

AR - Receivables·5 columns

credit memo item category line extract

APPS.AR_CM_ITEM_CAT_L_VL·↳ AR_XLA_LINES_EXTRACT·↳ MTL_CATEGORIES_TL·↳ MTL_ITEM_CATEGORIES·Explore AR module →

View: GL_SUMMARY_TEMPLATES_NAMES_V 12.1.1

GL - General Ledger·8 columns

10SC ONLY

APPS.GL_SUMMARY_TEMPLATES_NAMES_V·↳ GL_SUMMARY_TEMPLATES·Explore GL module →

View: GL_PERIOD_STATUSES_BUD_V 12.1.1

GL - General Ledger·8 columns

APPS.GL_PERIOD_STATUSES_BUD_V·↳ GL_BUDGETS·↳ GL_BUDGET_PERIOD_RANGES·↳ GL_BUDGET_VERSIONS·Explore GL module →

View: GL_RECURRING_VALID_PERIODS_V 12.2.2

GL - General Ledger·8 columns

10SC ONLY

APPS.GL_RECURRING_VALID_PERIODS_V·↳ GL_PERIOD_STATUSES·↳ GL_RECURRING_BATCHES·↳ GL_RECURRING_HEADERS·Explore GL module →

View: ARFV_FREIGHT_DISTS_ALC_V 12.1.1

AR - Receivables·8 columns

This shows Alternate Currencies information about freight amounts transferred to the Subledger Accounting.

APPS.ARFV_FREIGHT_DISTS_ALC_V·↳ FND_CURRENCIES·↳ GL_LEDGERS_PUBLIC_V·↳ RA_CUSTOMER_TRX_ALL·Explore AR module →

Table: GL_LEDGER_BSV_GT 12.1.1

owner GL·GL - General Ledger·3 columns

GL.GL_LEDGER_BSV_GT·Explore GL module →

View: GL_BUDGETS_REQUIRE_JOURNALS_V 12.1.1

GL - General Ledger·3 columns

10SC ONLY

APPS.GL_BUDGETS_REQUIRE_JOURNALS_V·↳ GL_BUDGETS·↳ GL_BUDGET_VERSIONS·Explore GL module →

View: RG_PERIOD_YEARS_V 12.1.1

RG - Application Report Generator·3 columns

10SC ONLY

APPS.RG_PERIOD_YEARS_V·↳ GL_PERIOD_STATUSES·Explore RG module →

Table: GL_BC_PACKET_ARRIVAL_ORDER 12.1.1 satellite-leaning

owner GL·GL - General Ledger·6 columns

Budgetary control packet processing sequence

GL.GL_BC_PACKET_ARRIVAL_ORDER·Explore GL module →

View: GL_SUSPENSE_ACCOUNTS_LOV_V 12.1.1

GL - General Ledger·6 columns

10SC ONLY

APPS.GL_SUSPENSE_ACCOUNTS_LOV_V·↳ GL_JE_CATEGORIES·↳ GL_JE_SOURCES·↳ GL_SUSPENSE_ACCOUNTS·Explore GL module →

View: GL_CONS_BUDGET_NAMES_V 12.2.2

GL - General Ledger·6 columns

10SC ONLY

APPS.GL_CONS_BUDGET_NAMES_V·↳ GL_BUDGETS·↳ GL_BUDGET_VERSIONS·Explore GL module →

Table: XLA_BAL_CONCURRENCY_CONTROL 12.2.2

owner XLA·XLA - Subledger Accounting·6 columns

Table used for locking purpose in balances

XLA.XLA_BAL_CONCURRENCY_CONTROL·Explore XLA module →

View: AR_SYSTEM_PARAM_H_V 12.2.2

AR - Receivables·6 columns

APPS.AR_SYSTEM_PARAM_H_V·↳ AR_SYSTEM_PARAMETERS_ALL·↳ AR_XLA_LINES_EXTRACT·↳ FND_PROFILE·Explore AR module →

Table: FUN_SUBSIDIARY_PARTY_MAPPINGS 12.1.1 standalone

owner FUN·FUN - Financials Common Modules·9 columns

FUN_SUBSIDIARY_PARTY_MAPPINGS is used to upgrade GL Subsidiaries as Intercompany Organizations. This table is not used once the organizations and transactions have been upgraded.

FUN.FUN_SUBSIDIARY_PARTY_MAPPINGS·Explore FUN module →

View: CST_XLA_AWO_LINES_V 12.2.2

BOM - Bills of Material·9 columns

APPS.CST_XLA_AWO_LINES_V·↳ CST_XLA_AWO_HEADERS_V·Explore BOM module →

Results for “ledger_id”