Search Results charge_line_type_name

Overview

APPS.INL_CHARGE_LINE_TYPES_VL is a reporting and integration view in the Oracle E-Business Suite ETRM (Enterprise Trade Management) module. It exposes charge line type definitions used within landed cost and trade management processing, presenting each row as a charge line type with its identifier, code, name, default landed cost indicator, payables line type mapping, allocation basis, and effective date range. The view functions as a presentation layer over the cost factor definitions maintained in the PON schema, giving trading and logistics users a stable, descriptive interface for charge line types.

The "_VL" suffix follows the Oracle EBS convention for views that combine a base table with its translation table, so the view is expected to return the charge line type name in the session or installation language. The view also supplies the allocation_basis column, defaulting to 'VALUE' via NVL(ALLOCATION_BASIS,'VALUE'), which is the attribute users search for when configuring how charges are apportioned across a transaction or shipment.

Underlying Base Objects

The documented base object for INL_CHARGE_LINE_TYPES_VL is PON_COST_FACTORS_VL, itself a view. The definition selects from PON_COST_FACTORS_VL and performs column renaming and derivation to map cost factor terminology to charge line type terminology.

• PRICE_ELEMENT_TYPE_ID is exposed as CHARGE_LINE_TYPE_ID.
• PRICE_ELEMENT_CODE is exposed as CHARGE_LINE_TYPE_CODE.
• NAME is exposed as CHARGE_LINE_TYPE_NAME.

Because the view reads from another view rather than directly from a table, any change to PON_COST_FACTORS_VL propagates immediately. No local storage exists; all columns are derived at query time.

Key Columns

• CHARGE_LINE_TYPE_ID — Primary identifier of the charge line type, sourced from PRICE_ELEMENT_TYPE_ID.
• CHARGE_LINE_TYPE_CODE — The code value for the charge line type.
• CHARGE_LINE_TYPE_NAME — Descriptive name of the charge line type.
• DFLT_LANDED_COST_FLAG — Hard-coded to 'Y', marking the charge line type as a default landed cost element in this view.
• AP_LINE_TYPE_CODE — Hard-coded to 'MISCELLANEOUS', indicating the payables line type mapped for these charges.
• ALLOCATION_BASIS — The basis on which the charge is allocated; returns the underlying value or 'VALUE' when null. This is the column associated with the search term "allocation_basis."
• ACTIVE_FROM_DATE — Set to '01-JAN-1900', indicating an open start of validity in this view's representation.
• ACTIVE_TO_DATE — Derived via DECODE(ENABLED_FLAG,'Y',NULL,'01-JAN-1900'); null when the record is enabled, otherwise a sentinel date indicating inactive status.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — Standard audit columns carried through from the base object.

Common Use Cases and Queries

This view is typically used to validate or report on charge line type configuration, especially allocation basis settings. A common query lists enabled charge line types and their allocation basis:

SELECT charge_line_type_code, charge_line_type_name, allocation_basis, active_to_date FROM apps.inl_charge_line_types_vl ORDER BY charge_line_type_code;

To isolate only active charge line types, filter on the sentinel date:

SELECT charge_line_type_id, charge_line_type_name, allocation_basis FROM apps.inl_charge_line_types_vl WHERE active_to_date IS NULL;

Integration scenarios join this view to transaction or receipt charge records to resolve the allocation basis applied to a given charge. Data extraction processes populate lookup or staging tables from the view when synchronising charge configuration with external landed cost or trade systems.