Search Results parent_charge_line_id




Overview
Explore in AI Chat

Overview

APPS.INL_ADJ_CHARGE_LINES_V is a reporting view in Oracle E-Business Suite Release 12.1.1 and 12.2.2 that exposes the leaf-level adjustment charge lines recorded in the Oracle Landed Cost Management (LCM) module. The view is defined over the INL_CHARGE_LINES synonym and applies a hierarchical filter using Oracle's CONNECT BY clause. Specifically, it starts with rows where PARENT_CHARGE_LINE_ID IS NULL (the root charge lines) and traverses downward through the relationship PRIOR charge_line_id = parent_charge_line_id, returning only rows where CONNECT_BY_ISLEAF = 1. The result is a flattened set of terminal (leaf) charge lines, which represent the most granular adjustment records associated with a landed cost charge structure.

Because adjustment charge lines are frequently inserted as child records beneath a parent charge line, this view serves as the canonical source for retrieving only those lines that have no further descendants. It is used extensively in LCM reporting, landed cost reconciliation, and integration extracts where downstream systems require a single row per final adjustment rather than an intermediate node.

Underlying Base Objects

The view is defined exclusively over INL_CHARGE_LINES, referenced through a synonym in the APPS schema. INL_CHARGE_LINES is the core transactional table that stores all charge lines generated during landed cost processing, including both parent (header-level) and child (adjustment) entries. The self-referential PARENT_CHARGE_LINE_ID column establishes the hierarchical link back to CHARGE_LINE_ID, enabling the CONNECT BY traversal. No joins to other tables appear in the view definition; all attributes are projected directly from the base synonym.

Key Columns

Common Use Cases and Queries

Typical usage includes reconciling final adjustment charges, extracting tax-relevant charge lines, and feeding landed cost data into financial or analytical systems. Because the view pre-filters to leaves, queries need not repeat the CONNECT BY predicate.

Retrieve all leaf adjustment lines for a given currency:

  • SELECT charge_line_id, charge_line_num, parent_charge_line_id, charge_amt, currency_code FROM apps.inl_adj_charge_lines_v WHERE currency_code = 'USD';

Identify orphaned leaves or verify hierarchy depth via the parent column:

  • SELECT charge_line_id, parent_charge_line_id FROM apps.inl_adj_charge_lines_v WHERE parent_charge_line_id IS NOT NULL;

Aggregate assessable values by tax classification:

  • SELECT tax_classification_code, SUM(assessable_value) FROM apps.inl_adj_charge_lines_v GROUP BY tax_classification_code;