[Home] [Help]
View: CSD_MOST_COMM_MTL_USED_V
View Text
SELECT MTL_MV.RO_INVENTORY_ITEM_ID RO_INVENTORY_ITEM_ID
, MTL_MV.PART_ONLY_RO_COUNT PART_ONLY_RO_COUNT
, RO_MV.TOTAL_RO_COUNT TOTAL_RO_COUNT
, (MTL_MV.PART_ONLY_RO_COUNT/RO_MV.TOTAL_RO_COUNT) FREQUENCY
, MTL_MV.PART_INVENTORY_ITEM_ID PART_INVENTORY_ITEM_ID
, MTL_MV.PART_PRIMARY_UOM_CODE PART_PRIMARY_UOM_CODE
, MTL_MV.TOTAL_PART_QUANTITY TOTAL_PART_QUANTITY
, MTL_MV.PART_ONLY_RO_QUANTITY PART_ONLY_RO_QUANTITY
, (MTL_MV.TOTAL_PART_QUANTITY/MTL_MV.PART_ONLY_RO_QUANTITY) AVG_CONSUMPTION
FROM CSD_RO_PER_ITEM_MV RO_MV
, CSD_WIP_MTL_USED_MV MTL_MV
WHERE MTL_MV.RO_INVENTORY_ITEM_ID = RO_MV.RO_INVENTORY_ITEM_ID
Columns
Name |
RO_INVENTORY_ITEM_ID |
PART_ONLY_RO_COUNT |
TOTAL_RO_COUNT |
FREQUENCY |
PART_INVENTORY_ITEM_ID |
PART_PRIMARY_UOM_CODE |
TOTAL_PART_QUANTITY |
PART_ONLY_RO_QUANTITY |
AVG_CONSUMPTION |