[Home] [Help]
View: MTL_DEMAND_HISTORY_V
View Text
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
Columns
Name |
INVENTORY_ITEM_ID |
ITEM_NUMBER |
DESCRIPTION |
ORGANIZATION_ID |
PRIMARY_UOM_CODE |
PERIOD_START_DATE |
PERIOD_TYPE |
SALES_ORDER_DEMAND |
INTERORG_ISSUE |
MISCELLANEOUS_ISSUE |
STD_WIP_USAGE |
TOTAL |