Search Results inl_allocation_summary_v




Overview
Explore in AI Chat

Overview

INL_ALLOCATION_SUMMARY_V is a VALID database view owned by the APPS schema within Oracle Landed Cost Management (INL), available in Oracle E-Business Suite 12.1.1 and 12.2.2. Per the ETRM documentation, the view shows the summary of the allocation of shipment amounts. In practical terms, it joins shipment header and line records with their association and allocation records, exposing the monetary amounts allocated to landed cost charges and taxes at the shipment line level.

The view serves as a reporting and integration layer over the base landed cost allocation tables. Rather than requiring report authors or interface developers to reconstruct the multi-table join logic that links shipments, associations, and allocations, the view presents a denormalized, query-ready result set. This makes it suitable for landed cost analysis, charge and tax reconciliation, and downstream data extraction into custom reports, concurrent programs, or external systems.

Underlying Base Objects

The documented ETRM metadata identifies four referenced base objects, all resolved through synonyms:

The join relationships are fixed: shipment header equals shipment line header, header equals allocation header, and the shipment line and association relationships are outer-joined (via (+)) to the allocation, ensuring allocation rows are preserved even when line or association detail is absent.

Key Columns

Common Use Cases and Queries

Typical scenarios include summarizing landed cost allocations by shipment or item, reconciling charge lines versus tax lines, and feeding allocation data into cost analysis reports. The CHARGE_LINE_ID and TAX_LINE_ID columns allow filtering by cost category directly.

Allocated amounts for a shipment:

SELECT ship_header_id, ship_line_id, inventory_item_id,
       allocation_id, allocation_amt, landed_cost_flag
FROM   apps.inl_allocation_summary_v
WHERE  ship_header_id = :p_ship_header_id;

Total allocations by item for an organization:

SELECT organization_id, inventory_item_id,
       SUM(allocation_amt) total_allocated
FROM   apps.inl_allocation_summary_v
WHERE  organization_id = :p_org_id
GROUP  BY organization_id, inventory_item_id;

Reconciling charge versus tax allocations:

SELECT ship_header_id, ship_line_id,
       SUM(NVL(allocation_amt,0)) allocation_amt,
       COUNT(charge_line_id) charge_lines,
       COUNT(tax_line_id) tax_lines
FROM   apps.inl_allocation_summary_v
GROUP  BY ship_header_id, ship_line_id;

As with all APPS synonyms, query the view through the APPS schema and apply organization or shipment filters to limit result sets on high-volume installations.