View: CSP_USAGE_HISTORIES_V1

Product:	CSP - Spares Management
Description:	Used by spreadtable to display usage history
Implementation/DBA Data:	APPS.CSP_USAGE_HISTORIES_V1

View Text

SELECT CUH.PERIOD_START_DATE
, CUH.PERIOD_TYPE
, CUH.INVENTORY_ITEM_ID
, CUH.ORGANIZATION_ID
, CUH.PARTS_LOOP_ID
, CUH.SUBINVENTORY_CODE
, CUH.HIERARCHY_NODE_ID
, NVL(SUM(DECODE(TRANSACTION_TYPE_ID
, 93
, CUH.QUANTITY))
, 0)
, NVL(SUM(DECODE(TRANSACTION_TYPE_ID
, 33
, CUH.QUANTITY))
, 0)
, NVL(SUM(DECODE(TRANSACTION_TYPE_ID
, -1
, CUH.QUANTITY))
, 0)
, NVL(SUM(DECODE(TRANSACTION_TYPE_ID
, 93
, CUH.QUANTITY))
, 0)+NVL(SUM(DECODE(TRANSACTION_TYPE_ID
, 33
, CUH.QUANTITY))
, 0)
FROM CSP_USAGE_HISTORIES CUH
WHERE HISTORY_DATA_TYPE = 0 GROUP BY PERIOD_START_DATE
, PERIOD_TYPE
, INVENTORY_ITEM_ID
, ORGANIZATION_ID
, PARTS_LOOP_ID
, SUBINVENTORY_CODE
, HIERARCHY_NODE_ID

Columns