VIEW: APPS.CSP_USAGE_HISTORIES_V1

Source

View Text - Preformatted

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

View Text - HTML Formatted

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