[Home] [Help]
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
Name |
PERIOD_START_DATE |
PERIOD_TYPE |
INVENTORY_ITEM_ID |
ORGANIZATION_ID |
PARTS_LOOP_ID |
SUBINVENTORY_CODE |
HIERARCHY_NODE_ID |
USAGE_QUANTITY |
SO_QUANTITY |
FORECAST_QUANTITY |
TOTAL |