eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: MSD_SR_ITEM_LIST_PRICE_V

Product:	MSD - Demand Planning
Description:	This is the Source View for Item List Price. This view would be applied to an Oracle Applications 11i instance from which the Item List Price information is to be retrieved. This view specifies the Base UOM, List Price and Average Discount
Implementation/DBA Data:	APPS.MSD_SR_ITEM_LIST_PRICE_V

View Text

SELECT CONCATENATED_SEGMENTS
, INVENTORY_ITEM_ID
, LIST_PRICE_PER_UNIT
, NULL
, PRIMARY_UOM_CODE
, BOM_ITEM_TYPE
, ATO_FORECAST_CONTROL
FROM MTL_SYSTEM_ITEMS_KFV
WHERE ORGANIZATION_ID = MSD_SR_UTIL.MASTER_ORGANIZATION()

Columns

Name
ITEM
SR_ITEM_PK
LIST_PRICE
AVG_DISCOUNT
BASE_UOM
ITEM_TYPE_ID
FORECAST_TYPE_ID