View: CSD_SC_FREQUENCY_V

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

View Text

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

Columns