Search Results inl_adj_charge_lines_v




Overview
Explore in AI Chat

Overview

The INL_ADJ_CHARGE_LINES_V view is a reporting and integration object within Oracle Landed Cost Management (product code INL), an E-Business Suite module used to capture, allocate, and settle landed costs associated with inbound shipments and receipts. The view is owned by the APPS schema and carries a VALID status in both EBS 12.1.1 and 12.2.2. Its documented purpose is to present adjusted information on charge lines, exposing the terminal nodes of the parent-child hierarchy maintained on landed cost charge lines.

Landed cost charge lines may be organized into hierarchical structures, where a parent charge line is subdivided into child lines that represent individual allocations, adjustments, or detail breakdowns. The view applies a hierarchical (connect-by) filter to return only the leaf-level records, providing a flattened, reporting-friendly projection of the charge line data. This makes it suitable for cost analysis, reconciliation, and downstream integration where the grain of interest is the final, most granular charge line rather than intermediate parent nodes.

Underlying Base Objects

The view is defined over a single base object, INL_CHARGE_LINES, referenced through a synonym. The defining query selects the listed columns from INL_CHARGE_LINES (aliased CL1) and restricts the result set using an Oracle hierarchical query:

  • START WITH PARENT_CHARGE_LINE_ID IS NULL establishes the root charge lines (those with no parent) as the starting point of the hierarchy traversal.
  • CONNECT BY PRIOR CHARGE_LINE_ID = PARENT_CHARGE_LINE_ID walks from each parent charge line to its children.
  • WHERE CONNECT_BY_ISLEAF = 1 retains only the leaf rows — charge lines that have no children of their own.

Because the view is a read-only projection over INL_CHARGE_LINES, it does not modify data. All insert, update, and delete operations must target the base table directly; the view is intended solely for query, reporting, and integration consumption.

Key Columns

The view exposes the full documented column set of INL_CHARGE_LINES. The most significant columns include:

Common Use Cases and Queries

Typical uses include reconciling adjusted landed cost charge lines, reporting the final allocated cost per receipt, and feeding downstream integrations that expect a flattened leaf-level charge line set.

To list all leaf charge lines with their amounts and currencies:

  • SELECT charge_line_id, charge_line_num, charge_amt, currency_code FROM inl_adj_charge_lines_v;

To retrieve adjusted lines tied to a specific adjustment number:

  • SELECT charge_line_id, adjustment_num, charge_amt FROM inl_adj_charge_lines_v WHERE adjustment_num = :adjustment_num;

To join to the base table for parent context, note that INL_ADJ_CHARGE_LINES_V is defined directly over INL_CHARGE_LINES; parent rows are filtered out by the CONNECT_BY_ISLEAF = 1 predicate, so use the base table when ancestor information is required.