Search Results notification_threshold

Overview

GLBV_GLOBAL_INTERCO_SUBS is a read-only Oracle EBS view in the General Ledger (GL) module that exposes the configuration of intercompany subsidiaries defined for global intercompany processing. It presents subsidiary-level setup attributes — including the chart of accounts, set of books, currency, company value, notification thresholds, and transfer parameters — in a denormalized, translatable form suitable for reporting, integration, and user-facing inquiry. The view is defined with the WITH READ ONLY clause, so it can be queried but never used as a DML target. In Oracle EBS 12.1.1 and 12.2.2, it plays a supporting role in the Intercompany and Advanced Global Intercompany System (AGIS) functionality, where subsidiaries represent the counterparties between which intercompany transactions are entered, approved, and transferred. Because the view resolves lookup codes into their meanings (via the _LA: token convention), it is well suited to concurrent-program extracts, Oracle Reports, OAF/Forms list-of-values, and BI Publisher data models that require human-readable descriptions rather than raw lookup codes.

Underlying Base Objects

The view is defined over a single base table, GL_IEA_SUBSIDIARIES, aliased as GLOBAL_INTERCO_SUB. The ETRM metadata lists no additional referenced base objects, and the view text confirms a straightforward projection of that table with no joins. General Ledger intercompany subsidiaries are maintained through the AGIS setup, and each row in GL_IEA_SUBSIDIARIES corresponds to one subsidiary belonging to a given set of books and chart of accounts. The view therefore inherits the key structure of that table directly — SUBSIDIARY_ID is the primary identifier, and SET_OF_BOOKS_ID and CHART_OF_ACCOUNTS_ID establish the accounting context in which the subsidiary operates. The read-only nature of the view and its use of translated lookup tokens make it a presentation-layer object rather than a transactional one; underlying maintenance is performed against the base table through the standard AGIS forms.

Key Columns

• SUBSIDIARY_ID — Primary key identifying the subsidiary record.
• SUBSIDIARY_NAME (NAME) — Descriptive name of the subsidiary.
• "_LA:SUBSIDIARY_TYPE" — Translated meaning of SUBSIDIARY_TYPE_CODE from the GL_LOOKUPS lookup type SUBSIDIARY_TYPE.
• CHART_OF_ACCOUNTS_ID — Chart of accounts to which the subsidiary is assigned.
• SET_OF_BOOKS_ID — Set of books (ledger context) owning the subsidiary.
• DEFAULT_CURRENCY (CURRENCY_CODE) — Default currency for the subsidiary.
• COMPANY (COMPANY_VALUE) — Balancing segment/company value associated with the subsidiary.
• DESCRIPTION — Free-form description of the subsidiary.
• "_LA:ENABLED_FLAG" / "_LA:ALLOW_AUTO_APPRVL_FLAG" — Translated Yes/No indicators for whether the subsidiary is enabled and whether automatic approval applies.
• "_LA:CONVERSION_RATES_TYPE" and CURRENCY_CONVERSION_TYPE_CODE — Translated and raw conversion-rate type used for currency translation.
• NOTIFICATION_THRESHOLD — Monetary threshold above which notifications are raised.
• TRANSFER_CURRENCY_CODE — Currency used when transferring intercompany balances.
• "_LA:REMOTE_INSTANCE_FLAG" / "_LA:VIEW_PARTNER_LINES_FLAG" — Indicators for remote-instance participation and partner-line visibility.
• TRANSFER_SET_OF_BOOKS_ID — The set of books to which intercompany balances are transferred; this is the column most frequently sought by users searching for transfer_set_of_books_id, particularly when auditing or reconciling intercompany transfer setups.

Common Use Cases and Queries

The view is typically queried to report subsidiary setup, to identify the transfer target set of books, or to drive integration extracts. A representative query retrieving all enabled subsidiaries and their transfer targets is:

SELECT subsidiary_id, subsidiary_name, set_of_books_id, transfer_set_of_books_id, transfer_currency_code FROM glbv_global_interco_subs WHERE "_LA:ENABLED_FLAG" = 'Yes';

To locate subsidiaries that transfer into a specific set of books:

SELECT subsidiary_name, company, transfer_currency_code FROM glbv_global_interco_subs WHERE transfer_set_of_books_id = :p_set_of_books_id;

To audit notification thresholds and conversion settings across a ledger:

SELECT subsidiary_name, notification_threshold, "_LA:CONVERSION_RATES_TYPE" FROM glbv_global_interco_subs WHERE set_of_books_id = :p_sob ORDER BY subsidiary_name;

Because the view is read-only, all such queries are safe for concurrent reporting and never risk modifying AGIS configuration. Where the ETRM metadata is silent (for example, on indexes or dependencies), behavior follows the underlying GL_IEA_SUBSIDIARIES table.