[Home] [Help]
View: CST_STD_INV_ADJ_VIEW
Product: | BOM - Bills of Material |
Description: | Standard cost update adjustment : SINGLE-ORG view |
Implementation/DBA Data: |
APPS.CST_STD_INV_ADJ_VIEW
|
View Text
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
Columns
Name |
COST_UPDATE_ID |
ORGANIZATION_ID |
INVENTORY_ITEM_ID |
SUBINVENTORY |
ADJUSTMENT_QUANTITY |
OLD_UNIT_COST |
NEW_UNIT_COST |