Search Results billing_rule_header_id




Overview
Explore in AI Chat

Overview

The MTL_BILLING_RULE_HEADERS_TL table is a translation (TL) table within the Oracle E-Business Suite Inventory (INV) module. Its primary function is to store multilingual translations for the descriptive, user-facing text associated with Third-Party Logistics (3PL) billing rule headers. This table enables the global deployment of Oracle EBS by allowing billing rule names and descriptions to be maintained in multiple languages, supporting the NLS (National Language Support) architecture. It serves as a critical supporting object for the base table, MTL_BILLING_RULE_HEADERS_B, by decoupling language-specific data from the core transactional structure.

Key Information Stored

The table stores translated text for billing rule headers, keyed by language and the rule identifier. Based on standard Oracle translation table conventions and the provided metadata, its essential columns include:

  • BILLING_RULE_HEADER_ID: The foreign key linking the translation row to its corresponding header in the base table MTL_BILLING_RULE_HEADERS_B. This is part of the table's primary key.
  • LANGUAGE: The ISO code for the language of the translated text (e.g., 'US' for American English). This is the second component of the primary key.
  • SOURCE_LANG: A column (implied by convention) indicating the original language in which the data was entered.
  • NAME: The translated name of the billing rule as displayed in the application interface.
  • DESCRIPTION: The translated descriptive text for the billing rule.
  • Standard WHO columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY) for auditing.

Common Use Cases and Queries

This table is primarily accessed by the Oracle application's NLS engine to display rule information in a user's session language. Common technical use cases include generating multilingual reports and extracting localized data for interfaces. A typical query to retrieve a billing rule's name in a specific language would join this table with its base table.

Sample Query:
SELECT b.RULE_NUMBER, tl.NAME, tl.DESCRIPTION, tl.LANGUAGE
FROM INV.MTL_BILLING_RULE_HEADERS_B b,
INV.MTL_BILLING_RULE_HEADERS_TL tl
WHERE b.BILLING_RULE_HEADER_ID = tl.BILLING_RULE_HEADER_ID
AND tl.LANGUAGE = USERENV('LANG')
AND b.ORG_ID = :p_org_id;

For data migration or setup scripts, it is crucial to insert records into this table for each supported language when creating a new billing rule header. Updates to descriptive text must be performed across all relevant language rows to maintain consistency.

Related Objects

The table has direct relationships with several core Inventory objects, as indicated by its foreign key structure.

  • MTL_BILLING_RULE_HEADERS_B: This is the base transactional table. The TL table's BILLING_RULE_HEADER_ID column is a foreign key to this table's primary key.
  • MTL_BILLING_RULE_LINES_TL: The translation table for billing rule lines, which likely shares a similar relationship to its base table and may be used in conjunction with this header translation table for complete rule localization.
  • FND_LANGUAGES: The application table that defines available languages, which provides valid values for the LANGUAGE column.
  • User Interface forms and APIs for managing 3PL billing rules will internally handle operations on this table to present and maintain translated text.