Skip to content
[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 |
APPS.MTL_DEMAND_HISTORY_V