Results for “mtl_phy_adj_cost_v”
26 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
MTL_PHY_ADJ_COST_V is an Oracle E-Business Suite 12.1.1 / 12.2.2 inventory view owned by the APPS schema and classified under the INV (Inventory) product family. It exposes the physical inventory adjustment lines stored in MTL_PHYSICAL_ADJUSTMENTS together with the item cost that Oracle Cost Management would apply when the adjustment is approved and posted. In 12.2.2 the object is described in the ETRM repository simply as "Retrofitted," indicating that it was carried forward from earlier releases to preserve downward compatibility for reports, Discoverer workbooks, and custom extensions that referenced the earlier definition.
The view's principal role is to provide a single read-only result set for physical inventory count reconciliation, adjustment review, and cost impact analysis. It joins adjustment lines to the cost group item cost view so that a pending or approved adjustment can be valued without invoking the Cost Management APIs directly. Because it is a UNION ALL construct, rows are returned from both locator-based and non-locator-based adjustment paths in a consistent column layout.
Underlying Base Objects
The documented base objects are MTL_PHYSICAL_ADJUSTMENTS (the primary driver), CST_CG_ITEM_COSTS_VIEW (the costing source), MTL_PARAMETERS (organization-level cost method), and MTL_ITEM_LOCATIONS (locator validation). MRP_PROJECT_PARAMETERS appears in the dependency list as a synonym reference. The view text restricts the first branch to rows where MPA.LOCATOR_ID IS NULL and joins CST_CG_ITEM_COSTS_VIEW on ORGANIZATION_ID, INVENTORY_ITEM_ID, and COST_GROUP_ID, where the cost group is resolved as DECODE(MP.PRIMARY_COST_METHOD, 1, 1, NVL(MPA.COST_GROUP_ID, 1)). A UNION ALL branch returns adjustment lines that have no matching cost row, substituting 0 for ITEM_COST, which ensures that uncosted or newly created items still appear in adjustment reports rather than being silently dropped.
Key Columns
- ADJUSTMENT_ID, PHYSICAL_INVENTORY_ID, ORGANIZATION_ID — primary identifiers linking the line to the physical inventory and the inventory organization.
- INVENTORY_ITEM_ID, REVISION, LOT_NUMBER, SERIAL_NUMBER, LOT_EXPIRATION_DATE, LOT_SERIAL_CONTROLS — item and lot/serial context. LOT_SERIAL_CONTROLS is the column most often targeted by searches, since it carries the item's lot and serial control code and determines which of the preceding columns are populated.
- SUBINVENTORY_NAME, LOCATOR_ID, PARENT_LPN_ID, OUTERMOST_LPN_ID — material location and LPN (license plate number) hierarchy for warehouse-managed (WMS) organizations.
- SYSTEM_QUANTITY, COUNT_QUANTITY, ADJUSTMENT_QUANTITY — snapshot of on-hand, counted, and resulting difference quantities.
- ACTUAL_COST, ITEM_COST, COST_GROUP_ID — unit cost attributes. ITEM_COST is supplied by CST_CG_ITEM_COSTS_VIEW and is zeroed in the fallback branch.
- APPROVAL_STATUS, APPROVED_BY_EMPLOYEE_ID, AUTOMATIC_APPROVAL_CODE, TEMP_APPROVER — approval workflow state, used to isolate pending adjustments.
- GL_ADJUST_ACCOUNT — the general ledger account that will receive the adjustment.
- REQUEST_ID, PROGRAM_ID, PROGRAM_APPLICATION_ID, CREATION_DATE, LAST_UPDATE_DATE — concurrent program and audit trail columns.
Common Use Cases and Queries
Typical applications include pending-adjustment approval reports, cost impact analysis of a physical inventory, and lot/serial audit extracts. Because LOT_SERIAL_CONTROLS is exposed directly, a frequent query filters adjustments for items under lot or serial control:
SELECT adjustment_id, organization_id, inventory_item_id, lot_number, serial_number, adjustment_quantity, item_cost, approval_status FROM apps.mtl_phy_adj_cost_v WHERE lot_serial_controls IN (2, 5) AND approval_status <> 7 AND organization_id = :org_id;
A second common pattern values the total adjustment amount for an organization by multiplying the adjustment quantity by the viewed item cost, while excluding zero-cost fallback rows with a NVL or ITEM_COST check. Developers should note that the view is read-only and that the embedded DECODE on PRIMARY_COST_METHOD means the cost group resolution behaves differently in standard versus average costing organizations; report logic should therefore avoid reproducing the join independently.
-
View: MTL_PHY_ADJ_COST_V 12.1.1
- Retrofitted
APPS.MTL_PHY_ADJ_COST_V·↳ CST_CG_ITEM_COSTS_VIEW·↳ MRP_PROJECT_PARAMETERS·↳ MTL_ITEM_LOCATIONS·Explore INV module →
-
View: MTL_PHY_ADJ_COST_V 12.2.2
- Retrofitted
APPS.MTL_PHY_ADJ_COST_V·↳ CST_CG_ITEM_COSTS_VIEW·↳ MRP_PROJECT_PARAMETERS·↳ MTL_ITEM_LOCATIONS·Explore INV module →
-
12.1.1 FND Design Data 12.1.1
-
12.2.2 FND Design Data 12.2.2
-
SYNONYM: APPS.MTL_PARAMETERS 12.1.1
-
SYNONYM: APPS.MTL_PARAMETERS 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
eTRM - BOM Tables and Views 12.2.2
Table to map wip transactions to their corresponding event types.
-
eTRM - INV Tables and Views 12.2.2
-
eTRM - BOM Tables and Views 12.1.1
Table to map wip transactions to their corresponding event types.
-
eTRM - INV Tables and Views 12.1.1
-
eTRM - BOM Tables and Views 12.2.2
Table to map wip transactions to their corresponding event types.
-
eTRM - BOM Tables and Views 12.1.1
Table to map wip transactions to their corresponding event types.
-
eTRM - INV Tables and Views 12.1.1
-
eTRM - INV Tables and Views 12.2.2