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_DC_FREQUENCY_V

Source

View Text - Preformatted


SELECT DC_MV.RO_INVENTORY_ITEM_ID RO_INVENTORY_ITEM_ID, DC_MV.TOTAL_RO_COUNT TOTAL_RO_COUNT, DC_MV.diagnostic_code_id diagnostic_code_id, DC_MV.diagnostic_item_id diagnostic_item_id, DC_MV.DC_ONLY_RO_COUNT DC_ONLY_RO_COUNT, (DC_ONLY_RO_COUNT/DC_MV.TOTAL_RO_COUNT) FREQUENCY FROM CSD_DC_FREQ_SUM_MV DC_MV

View Text - HTML Formatted

SELECT DC_MV.RO_INVENTORY_ITEM_ID RO_INVENTORY_ITEM_ID
, DC_MV.TOTAL_RO_COUNT TOTAL_RO_COUNT
, DC_MV.DIAGNOSTIC_CODE_ID DIAGNOSTIC_CODE_ID
, DC_MV.DIAGNOSTIC_ITEM_ID DIAGNOSTIC_ITEM_ID
, DC_MV.DC_ONLY_RO_COUNT DC_ONLY_RO_COUNT
, (DC_ONLY_RO_COUNT/DC_MV.TOTAL_RO_COUNT) FREQUENCY
FROM CSD_DC_FREQ_SUM_MV DC_MV