[Home] [Help]
View: CSP_USAGE_REG_ORG_SUBINV_V
View Text
SELECT CURM.INVENTORY_ITEM_ID
, CPP.ORGANIZATION_ID
, NVL(CPP.SECONDARY_INVENTORY
, '-')
, ROUND(SUM(DECODE(NVL(CEDM.ENGINEER_DAYS
, 0)
, 0
, 0
, CURM.QUANTITY/CEDM.ENGINEER_DAYS)) * 7
, 4)
, CPP.LEVEL_ID
FROM CSP_PLANNING_PARAMETERS CPP
, CSP_USAGE_REG_MV CURM
, CSP_ENGINEER_DAYS_V CEDM
WHERE CPP.NODE_TYPE = 'SUBINVENTORY'
AND CPP.RECOMMEND_METHOD IN ('TNORM'
, 'USAGE_TNORM')
AND CEDM.PLANNING_PARAMETERS_ID = CPP.PARENT_NODE_ID
AND CURM.PLANNING_PARAMETERS_ID = CPP.PARENT_NODE_ID
AND CURM.PERIOD_START_DATE BETWEEN TRUNC(SYSDATE) - CEDM.HISTORY_DAYS
AND TRUNC(SYSDATE) GROUP BY CURM.INVENTORY_ITEM_ID
, CPP.ORGANIZATION_ID
, CPP.SECONDARY_INVENTORY
, CPP.LEVEL_ID
Columns
Name |
INVENTORY_ITEM_ID |
ORGANIZATION_ID |
SECONDARY_INVENTORY |
AWU |
LEVEL_ID |