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_WIP_RES_USED_MV#

Source

View Text - Preformatted


SELECT count(*) "count(*)",
       RO.inventory_item_id RO_INVENTORY_ITEM_ID,
       count(RO.repair_line_id) RES_ONLY_RO_COUNT,
       sum(RO.primary_quantity) RES_ONLY_RO_QUANTITY,
       count(RO.primary_quantity) RES_ONLY_RO_QUANTITY_CNT,
       RES.resource_id RESOURCE_ID,
       sum(ABS(RES.primary_quantity)) TOTAL_RES_QUANTITY,
       count(ABS(RES.primary_quantity)) TOTAL_RES_QUANTITY_CNT,
       RES.primary_uom_code RES_PRIMARY_UOM_CODE
  FROM CSD_REPAIR_ORDERS_F RO,
       CSD_RES_CONSUMED_F RES
 WHERE RO.status = 'C'
   AND RES.repair_line_id = Ro.repair_line_id
 GROUP BY RO.inventory_item_id,
          RES.resource_id,
          RES.primary_uom_code

View Text - HTML Formatted

SELECT COUNT(*) "COUNT(*)"
, RO.INVENTORY_ITEM_ID RO_INVENTORY_ITEM_ID
, COUNT(RO.REPAIR_LINE_ID) RES_ONLY_RO_COUNT
, SUM(RO.PRIMARY_QUANTITY) RES_ONLY_RO_QUANTITY
, COUNT(RO.PRIMARY_QUANTITY) RES_ONLY_RO_QUANTITY_CNT
, RES.RESOURCE_ID RESOURCE_ID
, SUM(ABS(RES.PRIMARY_QUANTITY)) TOTAL_RES_QUANTITY
, COUNT(ABS(RES.PRIMARY_QUANTITY)) TOTAL_RES_QUANTITY_CNT
, RES.PRIMARY_UOM_CODE RES_PRIMARY_UOM_CODE
FROM CSD_REPAIR_ORDERS_F RO
, CSD_RES_CONSUMED_F RES
WHERE RO.STATUS = 'C'
AND RES.REPAIR_LINE_ID = RO.REPAIR_LINE_ID GROUP BY RO.INVENTORY_ITEM_ID
, RES.RESOURCE_ID
, RES.PRIMARY_UOM_CODE