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_RES_USED_V

Source

View Text - Preformatted


SELECT RES_MV.RO_INVENTORY_ITEM_ID RO_INVENTORY_ITEM_ID, RES_MV.RES_ONLY_RO_COUNT RES_ONLY_RO_COUNT, RO_MV.TOTAL_RO_COUNT TOTAL_RO_COUNT, (RES_MV.RES_ONLY_RO_COUNT/RO_MV.TOTAL_RO_COUNT) FREQUENCY, RES_MV.resource_id RESOURCE_ID, RES_MV.res_primary_uom_code RES_PRIMARY_UOM_CODE, RES_MV.TOTAL_RES_QUANTITY TOTAL_RES_QUANTITY, RES_MV.RES_ONLY_RO_QUANTITY RES_ONLY_RO_QUANTITY, (RES_MV.TOTAL_RES_QUANTITY/RES_MV.RES_ONLY_RO_QUANTITY) AVG_CONSUMPTION FROM CSD_RO_PER_ITEM_MV RO_MV, CSD_WIP_RES_USED_MV RES_MV WHERE RES_MV.RO_INVENTORY_ITEM_ID = RO_MV.RO_INVENTORY_ITEM_ID

View Text - HTML Formatted

SELECT RES_MV.RO_INVENTORY_ITEM_ID RO_INVENTORY_ITEM_ID
, RES_MV.RES_ONLY_RO_COUNT RES_ONLY_RO_COUNT
, RO_MV.TOTAL_RO_COUNT TOTAL_RO_COUNT
, (RES_MV.RES_ONLY_RO_COUNT/RO_MV.TOTAL_RO_COUNT) FREQUENCY
, RES_MV.RESOURCE_ID RESOURCE_ID
, RES_MV.RES_PRIMARY_UOM_CODE RES_PRIMARY_UOM_CODE
, RES_MV.TOTAL_RES_QUANTITY TOTAL_RES_QUANTITY
, RES_MV.RES_ONLY_RO_QUANTITY RES_ONLY_RO_QUANTITY
, (RES_MV.TOTAL_RES_QUANTITY/RES_MV.RES_ONLY_RO_QUANTITY) AVG_CONSUMPTION
FROM CSD_RO_PER_ITEM_MV RO_MV
, CSD_WIP_RES_USED_MV RES_MV
WHERE RES_MV.RO_INVENTORY_ITEM_ID = RO_MV.RO_INVENTORY_ITEM_ID