View: CSD_MOST_COMM_MTL_USED_V

Product:	CSD - Depot Repair
Description:	View used in the Most Common Material Used bin.
Implementation/DBA Data:	APPS.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