Search Results mtl_billing_rule_lines




Overview
Explore in AI Chat

Overview

The MTL_BILLING_RULE_LINES table is a core transactional data object within Oracle E-Business Suite Inventory (INV) module. It functions as the detailed line-level repository for billing rules, specifically architected for the Third-Party Logistics (3PL) Billing Project. While the header table (MTL_BILLING_RULE_HEADERS_B) defines the overarching billing rule, this table stores the individual, configurable components or conditions that constitute the rule. Each line dictates a specific chargeable activity, rate, or calculation parameter, enabling the granular definition of complex billing agreements for 3PL warehouse and fulfillment services.

Key Information Stored

The table's primary purpose is to define the actionable elements of a billing rule. The key columns, as indicated by its constraints, include the surrogate primary key BILLING_RULE_LINE_ID and the foreign key BILLING_RULE_HEADER_ID, which links each line to its parent rule. The CLIENT_CODE column, also a foreign key, associates the line with a specific 3PL client defined in MTL_CLIENT_PARAMETERS. While the provided metadata does not list all columns, typical data stored in such a structure includes sequence numbers for line ordering, a billing element or activity code (e.g., storage, picking, packing), applicable rates or pricing formulas, calculation units (per pallet, per hour, per transaction), minimum charges, and effective date ranges. Each record represents a single, billable component within a client's contractual agreement.

Common Use Cases and Queries

This table is central to the automated generation of 3PL client invoices. Common operational and reporting use cases include auditing the components of a specific billing rule, modifying line details for contract renewals, and generating detail reports for client billing transparency. A frequent query pattern involves joining to the header and client tables to retrieve a complete, active rule definition for a client.

Sample Query:
SELECT brh.rule_name,
      mcp.client_name,
      brl.*
FROM inv.mtl_billing_rule_lines brl,
     inv.mtl_billing_rule_headers_b brh,
     inv.mtl_client_parameters mcp
WHERE brl.billing_rule_header_id = brh.billing_rule_header_id
AND brl.client_code = mcp.client_code
AND brh.rule_name = '<RULE_NAME>'
ORDER BY brl.line_number;

Related Objects

MTL_BILLING_RULE_LINES is a child table within a tightly integrated schema for 3PL billing. Its documented relationships are:

  • Parent Table (MTL_BILLING_RULE_HEADERS_B): Joined via BILLING_RULE_HEADER_ID. This is the primary relationship; every billing rule line must belong to one billing rule header.
  • Reference Table (MTL_CLIENT_PARAMETERS): Joined via CLIENT_CODE. This links the billing rule line to the specific 3PL client entity, ensuring client-specific billing parameters are applied.

The table is also a likely source for views or interfaces that feed the invoice generation process, and it may be populated or maintained via dedicated private APIs within the INV module.