Search Results from_org_code




Overview
Explore in AI Chat

Overview

APPS.CSTBV_ITEM_STD_CST_UPDATE_ADJ is a Business Intelligence System (BIS) view in Oracle E-Business Suite, owned by the APPS schema and registered under FND Design Data as BOM.CSTBV_ITEM_STD_CST_UPDATE_ADJ. Its status is VALID in both 12.1.1 and 12.2.2. The view exposes the detailed cost adjustments generated when a standard cost update is executed, capturing the impact on inventory, intransit, and Work in Process (WIP) transactions for each item, organization, and cost element affected by the update. Because it is a BIS view, it is intended primarily for reporting, ad-hoc enquiry, and downstream integration where a denormalized, human-readable presentation of the underlying standard cost adjustment values is required. It joins the transactional adjustment rows in CST_STD_COST_ADJ_VALUES to descriptive attributes such as organization code, organization name, cost element name, item number, and WIP entity name, removing the need for callers to resolve those lookups themselves. The view also presents both the numeric identifiers (FROM_ORGANIZATION_ID, TO_ORGANIZATION_ID) and their decoded counterparts (FROM_ORG_CODE, FROM_ORG_NAME, TO_ORG_CODE, TO_ORG_NAME), which is directly relevant to searches such as from_org_code, since users frequently filter transfer-related adjustments by the shipping organization's code rather than its surrogate key.

Underlying Base Objects

The ETRM metadata documents the following referenced base objects (all accessed through APPS synonyms): CST_COST_ELEMENTS, CST_COST_UPDATES, CST_STD_COST_ADJ_VALUES, HR_ALL_ORGANIZATION_UNITS, MTL_PARAMETERS, MTL_SYSTEM_ITEMS, and WIP_ENTITIES. CST_STD_COST_ADJ_VALUES is the driving table and supplies the quantitative adjustment facts, including adjustment quantities, old and new unit costs, and the various in/out and level-type flags. CST_COST_UPDATES provides the cost update header, contributing COST_UPDATE_DESCRIPTION and the COST_UPDATE_ID key. CST_COST_ELEMENTS resolves the cost element name for each adjustment line. MTL_SYSTEM_ITEMS supplies the concatenated item-number key flexfield value, while MTL_PARAMETERS and HR_ALL_ORGANIZATION_UNITS resolve organization code and organization name for both the primary organization and the from/to organizations involved in transfer transactions. WIP_ENTITIES provides the WIP entity name for adjustments tied to discrete jobs, repetitive schedules, or flow schedules.

Key Columns

Common Use Cases and Queries

This view is used to analyse the financial impact of a standard cost update, to reconcile intransit and WIP revaluations, and to feed external reporting or reconciliation extracts. A frequent pattern is filtering by the shipping organization code, which corresponds to the user's search term from_org_code.

SELECT COST_UPDATE_ID
     , COST_UPDATE_DESCRIPTION
     , ORGANIZATION_CODE
     , FROM_ORG_CODE
     , TO_ORG_CODE
     , _KF:ITEM_NUMBER:_CO   AS ITEM_NUMBER
     , COST_ELEMENT_NAME
     , ADJUSTMENT_QUANTITY
     , OLD_UNIT_COST
     , NEW_UNIT_COST
     , _LA:TRANSACTION_TYPE  AS TRANSACTION_TYPE
FROM   APPS.CSTBV_ITEM_STD_CST_UPDATE_ADJ
WHERE  COST_UPDATE_ID = :p_cost_update_id
AND    FROM_ORG_CODE  = :p_from_org_code
ORDER BY ORGANIZATION_CODE, ITEM_NUMBER, COST_ELEMENT_NAME;

A second scenario totals the revaluation by organization and cost element for a given update, which supports variance analysis and accounting review:

SELECT ORGANIZATION_CODE
     , COST_ELEMENT_NAME
     , SUM(ADJUSTMENT_QUANTITY) AS TOTAL_QTY
     , SUM((NEW_UNIT_COST - OLD_UNIT_COST) * ADJUSTMENT_QUANTITY) AS NET_REVALUE
FROM   APPS.CSTBV_ITEM_STD_CST_UPDATE_ADJ
WHERE  COST_UPDATE_ID = :p_cost_update_id
GROUP  BY ORGANIZATION_CODE, COST_ELEMENT_NAME;

A third pattern retrieves WIP-related adjustments for discrete jobs, using WIP_ENTITY_NAME and ADJUSTMENT_QUANTITY to trace which jobs absorbed standard cost changes. Because the object is a view rather than a table, all access is read-only and should be bound to the appropriate cost update, organization, or from/to organization filters to avoid full scans of the underlying adjustment values.