View: CSD_DC_FREQUENCY_V

Product:	CSD - Depot Repair
Description:	View used for the FREQUENCY column for Diagnostic Code in the Evaluation page.
Implementation/DBA Data:	APPS.CSD_DC_FREQUENCY_V

View Text

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

Columns