VIEW: APPS.CSP_USAGE_REG_ORG_SUBINV_V

Source

View Text - Preformatted

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_regs 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

View Text - HTML Formatted

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_REGS 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