Results for “xla_owner_type”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
APPS.XLA_LINE_DEFN_JLT_ASSGNS_F_V is a reporting view in the Oracle E-Business Suite Subledger Accounting (XLA) module. It exposes the assignments of accounting line definitions to journal line types, presenting the configured mappings between a journal line type and the accounting lines (and their attributes) that Subledger Accounting will generate for that line type. In EBS 12.1.1 and 12.2.2 this view is part of the Create Accounting configuration data model and is primarily consumed by reporting, diagnostic, and integration queries rather than by the accounting engine itself, which accesses the underlying base tables directly.
The view is of particular interest to users investigating configuration where the source of an accounting line, description, or multi-period accounting attribute is controlled by an owner type. The XLA_OWNER_TYPE lookup governs these owner values, and the view resolves owner codes into user-facing meanings. This makes it a convenient entry point for auditing which accounting line definitions a given journal line type uses and who (or what) owns each definition.
Underlying Base Objects
The view is defined over the following documented base objects:
- XLA_LINE_DEFN_JLT_ASSGNS (synonym) — the primary table holding journal line type to accounting line definition assignments; aliased
xld. - XLA_ACCT_LINE_TYPES_B (synonym) — base accounting line types; aliased
xalt, supplying natural side and multi-period accounting option codes. - XLA_ACCT_LINE_TYPES_TL (synonym) — translation table for accounting line type names; aliased
xal. - XLA_DESCRIPTIONS_TL (synonym) — description definitions joined twice (aliases
xdtandxdt2) to resolve description names and multi-period header description names. - XLA_LOOKUPS (view) — joined three times (aliases
lk,lk2,lk3) against lookup typeXLA_OWNER_TYPEto resolve owner meanings.
The joins to XLA_LOOKUPS and XLA_DESCRIPTIONS_TL are outer joins for the description and multi-period description owner columns, but the accounting line owner join (lk) is an inner join, so only rows with a valid owner type appear. Translation joins restrict to the session language via USERENV('LANG').
Key Columns
- row_id — row identifier of the underlying assignment record.
- amb_context_code, application_id, event_class_code, event_type_code — the application and event context to which the assignment belongs.
- line_definition_owner_code, line_definition_code — the owning product and the accounting line definition identifier.
- accounting_line_name, accounting_line_owner — the translated line type name and the resolved meaning of the
XLA_OWNER_TYPElookup for the accounting line. - accounting_line_code, accounting_line_type_code — machine keys for the accounting line and its type.
- description_name, description_owner, description_code, description_type_code — the description definition and its owner, resolved through
XLA_OWNER_TYPE. - inherit_desc_flag, active_flag, object_version_number — configuration flags and concurrency control.
- natural_side_code, mpa_option_code — natural side and multi-period accounting option inherited from the accounting line type.
- mpa_num_je_code, mpa_gl_dates_code, mpa_proration_code, mpa_header_desc_code, mpa_header_desc_name, mpa_header_desc_owner — multi-period accounting attribute assignments and their resolved description owner.
- creation_date, created_by, last_update_date, last_updated_by, last_update_login — standard audit columns.
Common Use Cases and Queries
Typical scenarios include auditing which accounting line definitions a journal line type uses, verifying owner type assignments, and investigating multi-period accounting configuration. A representative query:
SELECT accounting_line_name, accounting_line_owner, description_name, description_owner FROM xla_line_defn_jlt_assgns_f_v WHERE event_class_code = :p_event_class AND application_id = :p_app_id;— lists assignments and their owners for a given event class.SELECT line_definition_code, accounting_line_type_code, natural_side_code, mpa_option_code FROM xla_line_defn_jlt_assgns_f_v WHERE application_id = 200 AND event_type_code = :p_event_type;— inspects natural side and multi-period options.SELECT DISTINCT accounting_line_owner FROM xla_line_defn_jlt_assgns_f_v ORDER BY 1;— enumerates the owner types in use, matching the search term "xla_owner_type".
Because owner values originate from the XLA_OWNER_TYPE lookup, the view should be joined back to XLA_LOOKUPS whenever additional lookup attributes are required beyond the resolved meaning.
-
Lookup Type: XLA_OWNER_TYPE 12.2.2
Defines owner of components used in SLA
-
Lookup Type: XLA_OWNER_TYPE 12.1.1
Defines owner of components used in SLA
-
APPS.XLA_LINE_DEFN_JLT_ASSGNS_F_V·↳ XLA_ACCT_LINE_TYPES_B·↳ XLA_ACCT_LINE_TYPES_TL·↳ XLA_DESCRIPTIONS_TL·Explore XLA module →
-
APPS.XLA_LINE_DEFN_JLT_ASSGNS_F_V·↳ XLA_ACCT_LINE_TYPES_B·↳ XLA_ACCT_LINE_TYPES_TL·↳ XLA_DESCRIPTIONS_TL·Explore XLA module →
-
APPS.XLA_PAD_INQ_LINES_AC_FVL·↳ FND_GLOBAL·↳ XLA_ACCT_LINE_TYPES_B·↳ XLA_ACCT_LINE_TYPES_TL·Explore XLA module →
-
APPS.XLA_PAD_INQ_LINES_AC_FVL·↳ FND_GLOBAL·↳ XLA_ACCT_LINE_TYPES_B·↳ XLA_ACCT_LINE_TYPES_TL·Explore XLA module →
-
VIEW: APPS.XLA_SEG_RULES_FVL 12.1.1
-
View: XLA_PAD_INQ_LINES_FVL 12.1.1
APPS.XLA_PAD_INQ_LINES_FVL·↳ FND_GLOBAL·↳ XLA_ACCT_LINE_TYPES_B·↳ XLA_ACCT_LINE_TYPES_TL·Explore XLA module →
-
View: XLA_PAD_INQ_LINES_FVL 12.2.2
APPS.XLA_PAD_INQ_LINES_FVL·↳ FND_GLOBAL·↳ XLA_ACCT_LINE_TYPES_B·↳ XLA_ACCT_LINE_TYPES_TL·Explore XLA module →
-
APPS.XLA_PROD_ACCT_LINES_FVL·↳ XLA_ACCT_LINE_TYPES_TL·↳ XLA_DESCRIPTIONS_TL·↳ XLA_LOOKUPS·Explore XLA module →
-
APPS.XLA_PROD_ACCT_LINES_FVL·↳ XLA_ACCT_LINE_TYPES_TL·↳ XLA_DESCRIPTIONS_TL·↳ XLA_LOOKUPS·Explore XLA module →
-
View: XLA_MPA_JLT_ASSGNS_F_V 12.1.1
Internal form view for the xla_mpa_jlt_ac_assgns table
APPS.XLA_MPA_JLT_ASSGNS_F_V·↳ XLA_ACCT_LINE_TYPES_B·↳ XLA_ACCT_LINE_TYPES_TL·↳ XLA_DESCRIPTIONS_TL·Explore XLA module →
-
VIEW: APPS.XLA_SEG_RULES_FVL 12.2.2