VIEW: APPS.MSD_ITEM_MASTER_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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