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