VIEW: APPS.MTL_DEMAND_HISTORY_V

Source

View Text - Preformatted

SELECT I.INVENTORY_ITEM_ID , I.ITEM_NUMBER , I.DESCRIPTION , I.ORGANIZATION_ID , I.PRIMARY_UOM_CODE , H.PERIOD_START_DATE , H.PERIOD_TYPE , H.SALES_ORDER_DEMAND , H.INTERORG_ISSUE , H.MISCELLANEOUS_ISSUE , H.STD_WIP_USAGE , H.SALES_ORDER_DEMAND + H.INTERORG_ISSUE + H.MISCELLANEOUS_ISSUE + H.STD_WIP_USAGE 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

View Text - HTML Formatted

SELECT I.INVENTORY_ITEM_ID
, I.ITEM_NUMBER
, I.DESCRIPTION
, I.ORGANIZATION_ID
, I.PRIMARY_UOM_CODE
, H.PERIOD_START_DATE
, H.PERIOD_TYPE
, H.SALES_ORDER_DEMAND
, H.INTERORG_ISSUE
, H.MISCELLANEOUS_ISSUE
, H.STD_WIP_USAGE
, H.SALES_ORDER_DEMAND + H.INTERORG_ISSUE + H.MISCELLANEOUS_ISSUE + H.STD_WIP_USAGE
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