APPS.MSD_DEM_SR_UTIL dependencies on MTL_SYSTEM_ITEMS

Line 265: from mtl_system_items

261: where parameter_name = 'MSD_DEM_MASTER_ORG';
262:
263: select NVL(primary_uom_code,'Ea')
264: into l_master_uom
265: from mtl_system_items
266: where inventory_item_id = item_id
267: and organization_id = l_master_org;
268:
269: conv_rate := inv_convert.inv_um_convert(item_id,NULL,NULL,uom_code,l_master_uom,NULL,NULL);

Line 294: mtl_system_items msi, -- Parent

290: select 1
291: from
292: msd_dem_app_instance_orgs morg,
293: bom_bill_of_materials bbm,
294: mtl_system_items msi, -- Parent
295: bom_inventory_components bic
296: where
297: bic.bill_sequence_id = bbm.bill_sequence_id
298: and bbm.organization_id = morg.organization_id

Line 337: mtl_system_items parent,

333: CURSOR c_count IS
334: SELECT
335: count(1)
336: FROM
337: mtl_system_items parent,
338: bom_inventory_components bic,
339: bom_bill_of_materials bom
340: WHERE
341: parent.bom_item_type = 5 and

Line 389: from mtl_system_items itm

385: CURSOR c_config_model (p_header_id IN NUMBER,
386: p_org_id IN NUMBER,
387: p_ato_line_id IN NUMBER) IS
388: select count(1)
389: from mtl_system_items itm
390: where inventory_item_id = (select inventory_item_id
391: from oe_order_lines_all l
392: where l.item_type_code = 'CONFIG'
393: and l.header_id = p_header_id

Line 752: mtl_system_items msi,

748: IS
749: SELECT 1
750: FROM msd_dem_app_instance_orgs mdaio,
751: bom_bill_of_materials bbm,
752: mtl_system_items msi,
753: bom_inventory_components bic
754: WHERE
755: bic.component_sequence_id = x_component_sequence_id
756: AND bic.bill_sequence_id = bbm.bill_sequence_id

Line 776: mtl_system_items msi,

772: SELECT
773: 1
774: FROM msd_dem_app_instance_orgs mdaio,
775: bom_bill_of_materials bbm,
776: mtl_system_items msi,
777: bom_inventory_components bic
778: WHERE
779: bic.component_sequence_id = x_component_sequence_id
780: AND bic.bill_sequence_id = bbm.bill_sequence_id