Search Results inl_tax

Overview

APPS.INL_SHIPLN_LANDED_COSTS_V is a reporting view in the Oracle E-Business Suite supply chain execution schema that consolidates landed cost allocations against individual shipment lines. It belongs to the Oracle Inventory Landed Cost (INL) module, the subsystem responsible for capturing, allocating, and applying charges and taxes incurred when goods move between organizations or from suppliers into inventory. The view exposes, for each shipment line and adjustment number, a breakdown of the allocated amount into three components: the item price, non-tax landed cost charges, and taxes. This decomposition makes the view particularly useful for landed cost analysis, customs valuation, and reconciliation of inventory receipts where the delivered cost of an item must be separated from the taxes assessed upon it.

Because the object is a view rather than a table, it carries no independent storage and always reflects the current state of the underlying allocation and shipment data. This makes it safe for ad hoc queries, custom reports, and integration extracts without risk of stale or duplicated rows.

Underlying Base Objects

The documented base objects referenced by the view are INL_ALLOCATIONS, INL_ASSOCIATIONS, INL_SHIP_HEADERS_ALL, and INL_SHIP_LINES_ALL, all accessed through APPS synonyms. The view's text also references INL_ALLOCATION_SUMMARY_V, a supporting summary view that aggregates allocation amounts. Shipment identity and descriptive context (header, line, adjustment number, organization, item, quantity, and unit of measure) are drawn from the shipment header and line tables, while the monetary amounts are derived from allocation data joined through the association records that link allocations to their originating landed cost details.

The three monetary columns are produced by correlated subqueries against INL_ALLOCATION_SUMMARY_V, each filtered by the same shipment, adjustment, line, organization, and item keys but distinguished by the ASSOC_FROM_PARENT_TABLE_NAME attribute. Charges are those whose association originates from an INL_CHARGE% parent table, taxes from an INL_TAX% parent table, and the item price is the remainder, explicitly excluding both charge and tax associations.

Key Columns

• SHIP_HEADER_ID, SHIP_LINE_ID, SHIP_LINE_GROUP_ID, SHIP_LINE_NUM — identify the shipment and the specific line being costed.
• ADJUSTMENT_NUM — the landed cost adjustment identifier, allowing multiple cost adjustments to be reported against the same line.
• ORGANIZATION_ID, INVENTORY_ITEM_ID — the receiving organization and inventory item for which the cost is allocated.
• ITEM_PRICE — the sum of allocation amounts that are landed-cost flagged but not tagged as charges or taxes.
• CHARGES — the sum of allocation amounts associated with INL_CHARGE% parent tables.
• TAXES — the sum of allocation amounts associated with INL_TAX% parent tables; this is the column a user searching for "inl_tax" would typically be seeking.
• PRIMARY_QTY, PRIMARY_UOM_CODE — the shipment line quantity and its unit of measure, supporting per-unit cost calculations.

Common Use Cases and Queries

Typical uses include verifying that tax allocations have been generated for a receipt, comparing tax burden against charge burden per line, and feeding landed cost values into custom valuation or reporting extracts.

SELECT ship_header_id, ship_line_id, adjustment_num,
       organization_id, inventory_item_id,
       item_price, charges, taxes,
       primary_qty, primary_uom_code
FROM   apps.inl_shipln_landed_costs_v
WHERE  ship_header_id = :p_ship_header_id
ORDER BY ship_line_id, adjustment_num;

To isolate tax-only activity, filter on a non-null TAXES value and aggregate by organization or item to produce a tax summary across shipments. Users investigating the "inl_tax" search term should note that the INL_TAX% association prefix in the view text is precisely what populates the TAXES column, making this view the appropriate starting point for tax-related landed cost reporting in both 12.1.1 and 12.2.2.