Search Results inl_tax_lines




Overview
Explore in AI Chat

Overview

The INL_TAX_LINES table is a core transactional data object within the Oracle Landed Cost Management (LCM) module, owned by the INL schema. Its documented purpose is to store information on taxes associated with Shipment components. In the context of Oracle E-Business Suite 12.1.1 and 12.2.2, this table captures the tax line detail that accrues against landed cost shipments, enabling organizations to record, adjust, and reconcile tax amounts incurred during the movement of goods across borders or through the supply chain.

The object is classified as VALID and contains 22 documented columns in the ETRM 12.2.2 physical schema. From a heuristic Data Vault modeling perspective, the metadata suggests this table behaves as a satellite object, holding descriptive and measurable attributes (tax amounts, currency conversion details, adjustment references) that describe a central business concept — the tax line — rather than acting as a pure hub or link. The absence of outgoing foreign keys other than the reference to ZX_LINES reinforces this standalone classification, though the table also relates to shipment headers through its own columns.

Key Information Stored

The table's surrogate primary key is TAX_LINE_ID, which is also the sole documented unique index (INL_TAX_LINES_U1), making it the definitive business-key candidate and the column used for join integrity. Among the most significant columns are:

Common Use Cases and Queries

Typical usage centers on landed cost analysis, tax reconciliation, and shipment cost reporting. A common query retrieves all tax lines for a given shipment:

SELECT TAX_LINE_NUM, TAX_CODE, TAX_AMT, CURRENCY_CODE
FROM INL_TAX_LINES
WHERE SHIP_HEADER_ID = :ship_header_id
ORDER BY TAX_LINE_NUM;

Reporting scenarios include aggregating recoverable versus non-recoverable tax by shipment, validating currency conversion consistency, and tracing adjustment chains via PARENT_TAX_LINE_ID. Integration queries join to ZX_LINES through TAX_LINE_ID to reconcile LCM tax lines with the E-Business Tax engine. Audit queries leverage the WHO columns to identify recent changes.

Related Objects

  • ZX_LINES — referenced via INL_TAX_LINES.TAX_LINE_ID → ZX_LINES.TAX_LINE_ID, providing the authoritative tax calculation detail.
  • INL_SHIP_HEADERS — parent shipment entity joined through SHIP_HEADER_ID.
  • INL_SHIP_LINES — shipment component detail typically correlated to tax lines.
  • INL_MATCHES / INL_MATCH_AMOUNTS — reconciliation records referenced by MATCH_ID and MATCH_AMOUNT_ID.
  • ZX_LINES_SUMMARY and E-Business Tax reporting views — downstream consumers of tax line amounts.