Results for “glfv_global_interco_subs”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

GLFV_GLOBAL_INTERCO_SUBS is a read-only Oracle E-Business Suite General Ledger view that presents global intercompany subsidiary configuration in a flattened, reporting-friendly form. It is part of the Global Intercompany System (GIS/GL_IEA) subsystem and consolidates the operational setup of intercompany subsidiaries with the descriptive names of their associated chart of accounts, set of books, and daily conversion types. Rather than requiring reporting tools to join multiple base tables and decode lookup codes manually, the view surfaces both the coded values and their human-readable meanings using Oracle Forms-style _LA (list-of-values) pseudo-columns and a _DF descriptive flexfield column.

The object is documented under the GL — General Ledger product for EBS 12.1.1 and 12.2.2. The ETRM metadata records it as not implemented in the source database instance, meaning the definition is a seeded Oracle application view rather than a customer-specific object. The user search term chart_of_accounts_tl is directly relevant: the view depends on FND_ID_FLEX_STRUCTURES_TL, the translated chart-of-accounts structure table, exposing ID_FLEX_STRUCTURE_NAME so that reporting output displays the accounting flexfield structure name resolved in the session language.

Underlying Base Objects

The view is defined over five base objects:

• GL_IEA_SUBSIDIARIES (aliased GLOBAL_INTERCO_SUB) — the primary source table holding intercompany subsidiary definitions.
• GL_SETS_OF_BOOKS (aliased GL_SET_OF_BOOKS1) — joined on SET_OF_BOOKS_ID to resolve the subsidiary's owning set of books name.
• GL_SETS_OF_BOOKS (aliased GL_SET_OF_BOOKS2) — an outer join on TRANSFER_SET_OF_BOOKS_ID to resolve the optional transfer set of books name, with a DECODE substituting NULL when the value is -1.
• GL_DAILY_CONVERSION_TYPES (aliased GL_CONVERSION_TYPE) — outer-joined to resolve the user-defined conversion rate type description.
• FND_ID_FLEX_STRUCTURES_TL (aliased CHART_OF_ACCOUNTS_TL) — provides the translated accounting flexfield structure name.

The join to FND_ID_FLEX_STRUCTURES_TL is constrained to APPLICATION_ID = 101, ID_FLEX_CODE = 'GL#', and LANGUAGE = USERENV('LANG'), guaranteeing that only the General Ledger chart-of-accounts structure and the caller's session language rows are returned.

Key Columns

• SUBSIDIARY_ID / NAME — identifier and display name of the intercompany subsidiary.
• CHART_OF_ACCOUNTS_ID and ID_FLEX_STRUCTURE_NAME — the accounting flexfield identifier and its translated structure name.
• SET_OF_BOOKS_ID / GL_SET_OF_BOOKS1.NAME — the subsidiary's owning ledger.
• CURRENCY_CODE / COMPANY_VALUE / DESCRIPTION — currency, balancing company segment value, and free-text description.
• Lookup-decoded flags — SUBSIDIARY_TYPE_CODE, ENABLED_FLAG, AUTO_APPROVE_FLAG, CONVERSION_TYPE_CODE, REMOTE_INSTANCE_FLAG, and VIEW_PARTNER_LINES_FLAG, each exposed as a _LA meaning column sourced from GL_LOOKUPS.
• CONVERSION_TYPE / USER_CONVERSION_TYPE — rate type code and its resolved description.
• NOTIFICATION_THRESHOLD / TRANSFER_CURRENCY_CODE / TRANSFER_SET_OF_BOOKS_ID — transfer behaviour and threshold settings.
• _DF:SQLGL:GL_IEA_SUBSIDIARIES — the descriptive flexfield context column.

Common Use Cases and Queries

Typical uses include auditing subsidiary configuration, validating which chart of accounts each subsidiary references, and building intercompany reconciliation or transfer reports.

• List enabled subsidiaries for a ledger: SELECT subsidiary_id, name, currency_code FROM glfv_global_interco_subs WHERE set_of_books_id = :p_sob AND enabled_flag = 'Yes';
• Find subsidiaries by chart of accounts structure: SELECT name, id_flex_structure_name FROM glfv_global_interco_subs WHERE chart_of_accounts_id = :p_coa_id;
• Report transfer settings: SELECT name, transfer_currency_code, notification_threshold, conversion_type FROM glfv_global_interco_subs;

Because the view is read-only (WITH READ ONLY), it cannot be used for DML; inserts and updates must target GL_IEA_SUBSIDIARIES directly.