View: CSD_MOST_COMM_RES_USED_V

Product:	CSD - Depot Repair
Description:	View used in the Most Common Resource Transacted bin.
Implementation/DBA Data:	APPS.CSD_MOST_COMM_RES_USED_V

View Text

SELECT RES_MV.RO_INVENTORY_ITEM_ID RO_INVENTORY_ITEM_ID
, RES_MV.RES_ONLY_RO_COUNT RES_ONLY_RO_COUNT
, RO_MV.TOTAL_RO_COUNT TOTAL_RO_COUNT
, (RES_MV.RES_ONLY_RO_COUNT/RO_MV.TOTAL_RO_COUNT) FREQUENCY
, RES_MV.RESOURCE_ID RESOURCE_ID
, RES_MV.RES_PRIMARY_UOM_CODE RES_PRIMARY_UOM_CODE
, RES_MV.TOTAL_RES_QUANTITY TOTAL_RES_QUANTITY
, RES_MV.RES_ONLY_RO_QUANTITY RES_ONLY_RO_QUANTITY
, (RES_MV.TOTAL_RES_QUANTITY/RES_MV.RES_ONLY_RO_QUANTITY) AVG_CONSUMPTION
FROM CSD_RO_PER_ITEM_MV RO_MV
, CSD_WIP_RES_USED_MV RES_MV
WHERE RES_MV.RO_INVENTORY_ITEM_ID = RO_MV.RO_INVENTORY_ITEM_ID

Columns