APPS.MSD_DEM_SR_UTIL dependencies on MTL_SYSTEM_ITEMS

Line 241: from mtl_system_items

237: where parameter_name = 'MSD_DEM_MASTER_ORG';
238:
239: select NVL(primary_uom_code,'Ea')
240: into l_master_uom
241: from mtl_system_items
242: where inventory_item_id = item_id
243: and organization_id = l_master_org;
244:
245: conv_rate := inv_convert.inv_um_convert(item_id,NULL,NULL,uom_code,l_master_uom,NULL,NULL);

Line 270: mtl_system_items msi, -- Parent

266: select 1
267: from
268: msd_dem_app_instance_orgs morg,
269: bom_bill_of_materials bbm,
270: mtl_system_items msi, -- Parent
271: bom_inventory_components bic
272: where
273: bic.bill_sequence_id = bbm.bill_sequence_id
274: and bbm.organization_id = morg.organization_id

Line 313: mtl_system_items parent,

309: CURSOR c_count IS
310: SELECT
311: count(1)
312: FROM
313: mtl_system_items parent,
314: bom_inventory_components bic,
315: bom_bill_of_materials bom
316: WHERE
317: parent.bom_item_type = 5 and

Line 365: from mtl_system_items itm

361: CURSOR c_config_model (p_header_id IN NUMBER,
362: p_org_id IN NUMBER,
363: p_ato_line_id IN NUMBER) IS
364: select count(1)
365: from mtl_system_items itm
366: where inventory_item_id = (select inventory_item_id
367: from oe_order_lines_all l
368: where l.item_type_code = 'CONFIG'
369: and l.header_id = p_header_id