[Home] [Help]
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
Name |
RO_INVENTORY_ITEM_ID |
TOTAL_RO_COUNT |
SERVICE_CODE_ID |
SERVICE_ITEM_ID |
SC_ONLY_RO_COUNT |
FREQUENCY |