View: CSP_ORG_USAGE_DETAILS_V

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

View Text

SELECT NVL(CSI.INVENTORY_ITEM_ID
, CUOM.INVENTORY_ITEM_ID) INVENTORY_ITEM_ID
, CUOM.ORGANIZATION_ID
, TRUNC(SYSDATE - ROUND((TO_NUMBER(SYSDATE - CUOM.PERIOD_START_DATE)/ CFRB.PERIOD_SIZE+0.5)) * CFRB.PERIOD_SIZE) PERIOD_START_DATE
, SUM(CUOM.QUANTITY) QUANTITY
FROM CSP_PLANNING_PARAMETERS CPP
, CSP_USAGE_ORG_MV CUOM
, CSP_SUPERSEDE_ITEMS CSI
, CSP_FORECAST_RULES_B CFRB
WHERE CUOM.ORGANIZATION_ID = CPP.ORGANIZATION_ID
AND CPP.SECONDARY_INVENTORY IS NULL
AND CPP.NODE_TYPE = 'ORGANIZATION_WH'
AND CUOM.PERIOD_START_DATE BETWEEN TRUNC(SYSDATE) - CFRB.PERIOD_SIZE * CFRB.HISTORY_PERIODS
AND TRUNC(SYSDATE)
AND CSI.INVENTORY_ITEM_ID(+) = CUOM.INVENTORY_ITEM_ID
AND CSI.ORGANIZATION_ID (+) = CUOM.ORGANIZATION_ID
AND CSI.SUB_INVENTORY_CODE(+) = '-'
AND CFRB.FORECAST_RULE_ID = CPP.FORECAST_RULE_ID GROUP BY NVL(CSI.INVENTORY_ITEM_ID
, CUOM.INVENTORY_ITEM_ID)
, CUOM.ORGANIZATION_ID
, SYSDATE - ROUND((TO_NUMBER(SYSDATE - CUOM.PERIOD_START_DATE)/ CFRB.PERIOD_SIZE+0.5)) * CFRB.PERIOD_SIZE

Columns