Search Results fc_primary_unit_price

Overview

The view APPS.INL_ADJ_SHIP_LINES_V is an Oracle E-Business Suite database object belonging to the Logistics and Transportation Management (INL) module, sometimes referenced under the broader ETRM (Enterprise Transportation and Trade Management) family of products. It exposes adjustment-related shipment line records in a de-duplicated form, presenting the most recent version of each shipment line as defined by its shipment header, line group, and line number combination. The view is primarily used for reporting, integration, and inquiry purposes where downstream processes require a stable, unique representation of shipment line adjustment data without traversing the underlying transactional table directly.

Because the view filters out superseded rows, it is well suited for interfaces and extracts that must not double-count shipment lines when multiple historical versions exist in the base table. This makes it valuable in distributed order and shipment reconciliation, landed cost calculations, and customs or fiscal reporting that depends on a consistent snapshot of adjustment lines.

Underlying Base Objects

The view is defined over a single documented base object: INL_SHIP_LINES_ALL, accessed via a synonym in the APPS schema. The SQL logic selects from INL_SHIP_LINES_ALL (aliased OPL1) and restricts each row to those whose SHIP_LINE_ID equals the maximum SHIP_LINE_ID found in a correlated subquery against the same table (aliased OPL2), correlated on SHIP_HEADER_ID, SHIP_LINE_GROUP_ID, and SHIP_LINE_NUM. In effect, the view returns the latest shipment line version for each logical line position within a line group on a shipment header. No joins to other tables are documented; all projected columns originate from INL_SHIP_LINES_ALL.

Key Columns

• SHIP_HEADER_ID, SHIP_LINE_GROUP_ID, SHIP_LINE_ID — shipment hierarchy identifiers; the combination of header, line group, and line number determines uniqueness.
• SHIP_LINE_NUM — the line number the user searched for, identifying the line position within its group.
• SHIP_LINE_TYPE_ID, SHIP_LINE_SRC_TYPE_CODE, SHIP_LINE_SOURCE_ID, PARENT_SHIP_LINE_ID, ADJUSTMENT_NUM, MATCH_ID — classify the line and link it to its source and adjustment context.
• CURRENCY_CODE, CURRENCY_CONVERSION_TYPE, CURRENCY_CONVERSION_DATE, CURRENCY_CONVERSION_RATE — currency and conversion metadata; the derived column FC_PRIMARY_UNIT_PRICE computes PRIMARY_UNIT_PRICE * NVL(CURRENCY_CONVERSION_RATE,1).
• INVENTORY_ITEM_ID, TXN_QTY, TXN_UOM_CODE, TXN_UNIT_PRICE, PRIMARY_QTY, PRIMARY_UOM_CODE, PRIMARY_UNIT_PRICE, SECONDARY_QTY, SECONDARY_UOM_CODE, SECONDARY_UNIT_PRICE — quantities, units of measure, and prices in transaction, primary, and secondary UOMs.
• LANDED_COST_FLAG, ALLOCATION_ENABLED_FLAG, ASSESSABLE_VALUE, TAX_CLASSIFICATION_CODE, TAX_ALREADY_CALCULATED_FLAG — flags and values supporting landed cost and tax determination.
• SHIP_FROM_PARTY_ID, SHIP_TO_ORGANIZATION_ID, BILL_FROM_PARTY_ID, BILL_TO_ORGANIZATION_ID, POA_PARTY_ID, POO_ORGANIZATION_ID (with associated site and location columns) — trading partner and party addressing data.
• ORG_ID — multi-org operating unit identifier.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — descriptive flexfield columns.

Common Use Cases and Queries

Typical uses include extracting the latest adjustment lines for a shipment, reconciling line quantities and prices, and feeding landed cost or tax engines. A representative query filtering by the searched column is:

• SELECT ship_header_id, ship_line_group_id, ship_line_num, adjustment_num, inventory_item_id, primary_qty, fc_primary_unit_price FROM apps.inl_adj_ship_lines_v WHERE ship_line_num = :p_line_num;
• SELECT * FROM apps.inl_adj_ship_lines_v WHERE ship_header_id = :p_header_id AND org_id = :p_org_id ORDER BY ship_line_group_id, ship_line_num;

Because ORG_ID is exposed, queries should generally be constrained by operating unit in a multi-org environment. The de-duplication logic ensures each header, line group, and line number appears once, returning the highest SHIP_LINE_ID.