DBA Data[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()