[Home] [Help]
View: MSD_ITEM_MASTER_V
Product: | MSD - Demand Planning |
Description: | This view exposes item specific properties - forecast type, base uom, average discount, list price - to the demand planning engine. |
Implementation/DBA Data: |
APPS.MSD_ITEM_MASTER_V
|
View Text
SELECT DISTINCT MSD_COMMON_UTILITIES.GET_ITEM_KEY(MLP.INSTANCE
, MLP.SR_ITEM_PK
, MLP.ITEM
, 1)
, MLP.ITEM
, FCL1.LOOKUP_CODE
, FCL1.MEANING
, FCL2.LOOKUP_CODE
, FCL2.MEANING
, MLP.BASE_UOM
, MLP.AVG_DISCOUNT
, MLP.LIST_PRICE
, MLP.LAST_REFRESH_NUM
, MLP.CREATED_BY_REFRESH_NUM
, MLP.ACTION_CODE
FROM MSD_ITEM_LIST_PRICE MLP
, FND_COMMON_LOOKUPS FCL1
, FND_COMMON_LOOKUPS FCL2
WHERE FCL1.LOOKUP_TYPE = 'MSD_ITEM_TYPE'
AND FCL1.LOOKUP_CODE = MLP.ITEM_TYPE_ID
AND FCL2.LOOKUP_TYPE = 'MSD_FORECAST_CONTROL'
AND FCL2.LOOKUP_CODE = MLP.FORECAST_TYPE_ID
Columns
Name |
ITEM_PK |
ITEM |
ITEM_TYPE_ID |
ITEM_TYPE |
FORECAST_TYPE_ID |
FORECAST_TYPE |
BASE_UOM |
AVG_DISCOUNT |
LIST_PRICE |
LAST_REFRESH_NUM |
CREATED_BY_REFRESH_NUM |
ACTION_CODE |