View: MTL_DEMAND_HISTORY_ITEMS_V

Product:	INV - Inventory
Description:	10SC ONLY
Implementation/DBA Data:	APPS.MTL_DEMAND_HISTORY_ITEMS_V

View Text

SELECT I.INVENTORY_ITEM_ID
, I.ORGANIZATION_ID
, I.ITEM_NUMBER
, I.DESCRIPTION
, I.PRIMARY_UOM_CODE
, DECODE(COUNT(DECODE(H.PERIOD_TYPE
, 1
, 1
, NULL))
, 0
, 0
, 1)
, DECODE(COUNT(DECODE(H.PERIOD_TYPE
, 2
, 1
, NULL))
, 0
, 0
, 1)
, DECODE(COUNT(DECODE(H.PERIOD_TYPE
, 3
, 1
, NULL))
, 0
, 0
, 1)
FROM MTL_ITEM_FLEXFIELDS I
, MTL_DEMAND_HISTORIES H
WHERE I.INVENTORY_ITEM_ID = H.INVENTORY_ITEM_ID (+)
AND I.ORGANIZATION_ID = H.ORGANIZATION_ID (+) GROUP BY I.INVENTORY_ITEM_ID
, I.ORGANIZATION_ID
, I.ITEM_NUMBER
, I.DESCRIPTION
, I.PRIMARY_UOM_CODE

Columns