Search Results interface_source_table

Overview

INL_ADJ_SHIP_LINES_V is a PL/SQL view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It is a component of Oracle Landed Cost Management (INL), the module responsible for estimating, accruing, and reconciling landed costs such as freight, duty, insurance, and brokerage against received goods. Within that module, the view exposes adjustment shipment line records — the transaction lines that represent landed cost adjustments applied to an original shipment line — and presents them in a flattened, query-ready form.

The view's practical role is reporting and integration rather than transactional data entry. Because the base table INL_SHIP_LINES_ALL stores every version of a shipment line, including superseded rows generated when adjustments are applied, consumers that simply query the base table risk retrieving multiple historical rows for the same logical line. INL_ADJ_SHIP_LINES_V resolves this ambiguity by returning only the most recent row per shipment header, line group, and line number, making it suitable for extracts, reconciliation reports, and downstream integrations.

Underlying Base Objects

The view is defined over a single documented base object, the synonym INL_SHIP_LINES_ALL, which resolves to the INL shipment lines table in the APPS schema. The view does not join to INL_SHIP_HEADERS_ALL or to any receipt, purchase order, or inventory table; header-level and receipt-level context must be obtained separately by joining on SHIP_HEADER_ID or MATCH_ID.

The defining predicate is a correlated subquery. For each candidate row OPL1, the view retains it only when its SHIP_LINE_ID equals the maximum SHIP_LINE_ID among all rows sharing the same SHIP_HEADER_ID, SHIP_LINE_GROUP_ID, and SHIP_LINE_NUM. Because SHIP_LINE_ID is system-generated in ascending order, the maximum value identifies the newest version of that line. The effect is a de-duplicating filter: one row per logical shipment line, representing its current adjustment state.

Key Columns

• SHIP_HEADER_ID, SHIP_LINE_GROUP_ID, SHIP_LINE_ID, SHIP_LINE_NUM — the primary identification and grouping keys for the shipment and its lines.
• SHIP_LINE_TYPE_ID, SHIP_LINE_SRC_TYPE_CODE, SHIP_LINE_SOURCE_ID, PARENT_SHIP_LINE_ID — classify the line and identify the source document; PARENT_SHIP_LINE_ID links an adjustment line back to the line it adjusts.
• ADJUSTMENT_NUM, MATCH_ID — the adjustment sequence number and the match identifier associating the line with a receipt or invoice match.
• CURRENCY_CODE, CURRENCY_CONVERSION_TYPE, CURRENCY_CONVERSION_DATE, CURRENCY_CONVERSION_RATE — currency context for the transaction.
• INVENTORY_ITEM_ID, TXN_QTY, TXN_UOM_CODE, TXN_UNIT_PRICE — the transactional quantity, unit of measure, and price.
• PRIMARY_QTY, PRIMARY_UOM_CODE, PRIMARY_UNIT_PRICE, FC_PRIMARY_UNIT_PRICE — quantities in the primary UOM; FC_PRIMARY_UNIT_PRICE is computed as PRIMARY_UNIT_PRICE multiplied by NVL(CURRENCY_CONVERSION_RATE, 1), yielding the functional-currency unit price.
• SECONDARY_QTY, SECONDARY_UOM_CODE, SECONDARY_UNIT_PRICE — the secondary UOM representation.
• LANDED_COST_FLAG, ALLOCATION_ENABLED_FLAG — indicate whether the line participates in landed cost processing and allocation.
• TRX_BUSINESS_CATEGORY, INTENDED_USE, PRODUCT_FISCAL_CLASS, PRODUCT_CATEGORY, PRODUCT_TYPE, USER_DEF_FISCAL_CLASS, TAX_CLASSIFICATION_CODE — tax and fiscal classification attributes.
• ASSESSABLE_VALUE, TAX_ALREADY_CALCULATED_FLAG — the value subject to taxation and whether tax was pre-calculated.
• SHIP_FROM_PARTY_ID, SHIP_FROM_PARTY_SITE_ID, SHIP_TO_ORGANIZATION_ID, SHIP_TO_LOCATION_ID, BILL_FROM_PARTY_ID, BILL_FROM_PARTY_SITE_ID, BILL_TO_ORGANIZATION_ID, BILL_TO_LOCATION_ID, POA_PARTY_ID, POA_PARTY_SITE_ID, POO_ORGANIZATION_ID, POO_LOCATION_ID — the full party, organization, and location context for ship-from, ship-to, bill-from, bill-to, and point-of-acceptance/order.
• ORG_ID — the operating unit, supporting multi-org security and filtering.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — the standard EBS descriptive flexfield columns.

Common Use Cases and Queries

The view is typically used to report current adjustment line detail, to reconcile landed cost adjustments against receipts matched through MATCH_ID, and to drive extracts into tax determination or cost accounting processes. A basic query lists the current lines for a shipment:

• SELECT ship_header_id, ship_line_num, adjustment_num, inventory_item_id, txn_qty, primary_unit_price, fc_primary_unit_price FROM inl_adj_ship_lines_v WHERE ship_header_id = :p_header_id ORDER BY ship_line_num;
• SELECT ship_line_id, match_id, currency_code, assessable_value FROM inl_adj_ship_lines_v WHERE org_id = :p_org_id AND landed_cost_flag = 'Y' AND adjustment_num IS NOT NULL;
• SELECT v.ship_line_num, v.txn_qty, v.primary_unit_price, v.fc_primary_unit_price FROM inl_adj_ship_lines_v v WHERE v.ship_header_id = :p_header_id AND v.parent_ship_line_id IS NOT NULL;

Because the view carries ORG_ID, queries should always filter by operating unit to respect multi-org access. When header attributes such as shipment number or vendor are required, join to the shipment header table on SHIP_HEADER_ID. Since INL_SHIP_LINES_ALL can be large, filtering on SHIP_HEADER_ID or MATCH_ID is strongly recommended to avoid full scans driven by the correlated subquery predicate.