VIEW: APPS.CST_STD_INV_ADJ_VIEW

Source

View Text - Preformatted

SELECT CV.COST_UPDATE_ID, CV.ORGANIZATION_ID, CV.INVENTORY_ITEM_ID, CV.SUBINVENTORY, CV.ADJUSTMENT_QUANTITY, SUM(OLD_UNIT_COST), SUM(NEW_UNIT_COST) FROM CST_STD_COST_ADJ_VALUES CV WHERE CV.TRANSACTION_TYPE = 1 AND CV.NEW_UNIT_COST != CV.OLD_UNIT_COST GROUP BY CV.COST_UPDATE_ID, CV.ORGANIZATION_ID, CV.SUBINVENTORY, CV.INVENTORY_ITEM_ID, CV.ADJUSTMENT_QUANTITY

View Text - HTML Formatted

SELECT CV.COST_UPDATE_ID
, CV.ORGANIZATION_ID
, CV.INVENTORY_ITEM_ID
, CV.SUBINVENTORY
, CV.ADJUSTMENT_QUANTITY
, SUM(OLD_UNIT_COST)
, SUM(NEW_UNIT_COST)
FROM CST_STD_COST_ADJ_VALUES CV
WHERE CV.TRANSACTION_TYPE = 1
AND CV.NEW_UNIT_COST != CV.OLD_UNIT_COST GROUP BY CV.COST_UPDATE_ID
, CV.ORGANIZATION_ID
, CV.SUBINVENTORY
, CV.INVENTORY_ITEM_ID
, CV.ADJUSTMENT_QUANTITY