eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.CSD_MOST_COMM_MTL_USED_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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