[Home] [Help]
VIEW: APPS.MSD_SR_ITEM_LIST_PRICE_V
Source
View Text - Preformatted
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()
View Text - HTML Formatted
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()