VIEW: APPS.CSP_ORG_USAGE_DETAILS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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