Search Results interface_charge_id

Overview

APPS.INL_PO_CHARGES_V is a reporting view in Oracle Landed Cost Management (INL) that consolidates landed cost charge lines with their allocations, shipment associations, and purchasing context. It is the view that surfaces INL charges within the View Acquisition Costs page, allowing users to inspect the estimated and actual amounts of each charge line applied to a shipment. The view carries a VALID status in both Oracle EBS 12.1.1 and 12.2.2 environments, and is owned by the APPS schema.

The object is frequently surfaced when searching for "po_rcv_charges" because it exposes a PO_RCV_CHARGES synonym among its documented base objects and produces output structurally similar to receipt charge data. Its principal role is to join the Landed Cost Management charge definition model to receiving shipment data so that estimated amounts, matched actual amounts, and acquisition cost inclusion flags are available in a single row per charge line.

Underlying Base Objects

The documented base objects referenced by this view are: INL_ALLOCATIONS, INL_ASSOCIATIONS, INL_CHARGE_LINES, INL_SHIPMENT_PVT (package), PON_COST_FACTORS_VL (view), PO_HEADERS_ALL, PO_RCV_CHARGES, and RCV_SHIPMENT_LINES, all resolved through APPS synonyms except the package and the PON view.

• INL_CHARGE_LINES (ICL) — driving table; supplies the charge line identity, currency, conversion details, and the landed cost inclusion flag.
• INL_ASSOCIATIONS (IAS) — links charge lines to shipment headers or line groups; supplies the allocation basis and allocation UOM used as the allocation method.
• INL_ALLOCATIONS (IAL) — provides the allocated amounts summed into the estimated amount; restricted to rows where LANDED_COST_FLAG = 'Y' and ADJUSTMENT_NUM = 0.
• RCV_SHIPMENT_LINES (RSL) — supplies the shipment header and line identifiers and the PO header linkage.
• PO_HEADERS_ALL (PH) — provides vendor and vendor site context.
• PON_COST_FACTORS_VL (PCF) — joins the charge line type to its cost component class and cost analysis code.
• INL_SHIPMENT_PVT (package) — invoked through GET_MATCHEDAMT to derive the actual matched amount per shipment line and charge type.

PO_RCV_CHARGES is documented as a referenced synonym; this is why the view is often retrieved by searches for "po_rcv_charges", though the view text itself sources its charge data from the INL tables.

Key Columns

• CHARGE_ID — aliases INL_CHARGE_LINES.CHARGE_LINE_ID; the unique charge line identifier.
• SHIPMENT_HEADER_ID / SHIPMENT_LINE_ID — shipment context; the line identifier is nulled when the association is at shipment header or ship line group level via DECODE logic.
• COST_FACTOR_ID — aliases CHARGE_LINE_TYPE_ID; identifies the charge/price element type.
• CURRENCY_CODE, CURRENCY_CONVERSION_TYPE, CURRENCY_CONVERSION_RATE, CURRENCY_CONVERSION_DATE — currency and conversion attributes for the charge.
• ALLOCATION_METHOD / UNIT_OF_MEASURE — from INL_ASSOCIATIONS, describing how the charge is apportioned.
• ESTIMATED_AMT — SUM of allocated amounts; the projected charge value.
• ACTUAL_AMOUNT — value returned by INL_SHIPMENT_PVT.GET_MATCHEDAMT for the shipment line and charge type with source 'INL_CHARGE_LINES'.
• INCLUDE_IN_ACQUISITION_COST — the landed cost flag controlling whether the charge is capitalized into acquisition cost.
• VENDOR_ID / VENDOR_SITE_ID — supplier context from PO_HEADERS_ALL.
• ESTIMATED_TAX / ACTUAL_TAX — hard-coded to 0 in this view.
• COST_COMPONENT_CLASS_ID / COST_ANALYSIS_CODE — classification from PON_COST_FACTORS_VL.

Common Use Cases and Queries

Typical uses include reconciliation of estimated versus actual landed cost per shipment, verification of which charges are included in acquisition cost, and reporting charge exposure by vendor. A simple extraction would be:

SELECT charge_id, shipment_header_id, shipment_line_id,
       cost_factor_id, allocation_method,
       estimated_amt, actual_amount,
       include_in_acquisition_cost,
       vendor_id, cost_component_class_id
FROM   apps.inl_po_charges_v
WHERE  shipment_header_id = :p_shipment_header_id;

To compare estimated against matched actual amounts at charge level:

SELECT charge_id, cost_factor_id,
       estimated_amt, actual_amount,
       (actual_amount - estimated_amt) variance
FROM   apps.inl_po_charges_v
WHERE  include_in_acquisition_cost = 'Y'
ORDER  BY variance DESC;

Users searching for "po_rcv_charges" should note that although PO_RCV_CHARGES is a documented referenced object, the primary charge line source is INL_CHARGE_LINES; queries should therefore filter on INL-specific identifiers such as CHARGE_ID and SHIPMENT_HEADER_ID rather than assuming columns native to PO_RCV_CHARGES exist in the view.