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