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_SC_FREQUENCY_V

Source

View Text - Preformatted


SELECT SC_MV.RO_INVENTORY_ITEM_ID RO_INVENTORY_ITEM_ID, SC_MV.TOTAL_RO_COUNT TOTAL_RO_COUNT, SC_MV.service_code_id service_code_id, SC_MV.service_item_id service_item_id, SC_MV.SC_ONLY_RO_COUNT SC_ONLY_RO_COUNT, (SC_ONLY_RO_COUNT/SC_MV.TOTAL_RO_COUNT) FREQUENCY FROM CSD_SC_FREQ_SUM_MV SC_MV

View Text - HTML Formatted

SELECT SC_MV.RO_INVENTORY_ITEM_ID RO_INVENTORY_ITEM_ID
, SC_MV.TOTAL_RO_COUNT TOTAL_RO_COUNT
, SC_MV.SERVICE_CODE_ID SERVICE_CODE_ID
, SC_MV.SERVICE_ITEM_ID SERVICE_ITEM_ID
, SC_MV.SC_ONLY_RO_COUNT SC_ONLY_RO_COUNT
, (SC_ONLY_RO_COUNT/SC_MV.TOTAL_RO_COUNT) FREQUENCY
FROM CSD_SC_FREQ_SUM_MV SC_MV