View: CSP_SUBINV_USAGE_DETAILS_V

Product:	CSP - Spares Management
Description:
Implementation/DBA Data:	APPS.CSP_SUBINV_USAGE_DETAILS_V

View Text

SELECT NVL(CSI.INVENTORY_ITEM_ID
, CUH.INVENTORY_ITEM_ID) INVENTORY_ITEM_ID
, CUH.ORGANIZATION_ID
, CUH.SUBINVENTORY_CODE
, SYSDATE - ROUND((TO_NUMBER(SYSDATE - CUH.PERIOD_START_DATE)/CFRB.PERIOD_SIZE+0.5)) * CFRB.PERIOD_SIZE PERIOD_START_DATE
, SUM(CUH.QUANTITY) QUANTITY
FROM CSP_PLANNING_PARAMETERS CPP
, CSP_USAGE_HISTORIES CUH
, CSP_SUPERSEDE_ITEMS CSI
, CSP_FORECAST_RULES_B CFRB
WHERE CUH.ORGANIZATION_ID = CPP.ORGANIZATION_ID
AND CUH.SUBINVENTORY_CODE = CPP.SECONDARY_INVENTORY
AND CPP.NODE_TYPE = 'SUBINVENTORY'
AND CUH.HISTORY_DATA_TYPE = 1
AND CUH.PERIOD_START_DATE BETWEEN TRUNC(SYSDATE) - CFRB.PERIOD_SIZE * CFRB.HISTORY_PERIODS
AND TRUNC(SYSDATE)
AND CSI.INVENTORY_ITEM_ID(+) = CUH.INVENTORY_ITEM_ID
AND CSI.ORGANIZATION_ID (+) = CUH.ORGANIZATION_ID
AND CSI.SUB_INVENTORY_CODE(+) = CUH.SUBINVENTORY_CODE
AND CFRB.FORECAST_RULE_ID = CPP.FORECAST_RULE_ID GROUP BY NVL(CSI.INVENTORY_ITEM_ID
, CUH.INVENTORY_ITEM_ID)
, CUH.ORGANIZATION_ID
, CUH.SUBINVENTORY_CODE
, SYSDATE - ROUND((TO_NUMBER(SYSDATE - CUH.PERIOD_START_DATE) /CFRB.PERIOD_SIZE+0.5)) * CFRB.PERIOD_SIZE

Columns