APPS.BOMPLDCB dependencies on MTL_SYSTEM_ITEMS_INTERFACE

Line 113: from mtl_system_items_interface

109: where id_flex_code = 'MICG'
110: and application_id = 401;
111:
112: select item_catalog_group_id into group_id
113: from mtl_system_items_interface
114: where inventory_item_id = item_id
115: and organization_id = org_id;
116:
117: idx := 0;

Line 140: update mtl_system_items_interface

136: end loop;
137: close cc;
138:
139: if idx <> 0 then
140: update mtl_system_items_interface
141: set description = cat_value
142: where inventory_item_id = item_id
143: and organization_id = org_id;
144: end if;

Line 222: from mtl_system_items_interface

218: ** declare cursor to retrieve config items
219: */
220: CURSOR ee IS
221: select inventory_item_id, organization_id
222: from mtl_system_items_interface
223: where set_id = TO_CHAR(to_number(USERENV('SESSIONID')));
224:
225: routing_id NUMBER;
226: bill_id NUMBER;

Line 337: MTL_SYSTEM_ITEMS_INTERFACE m

333: m.demand_source_header_id,
334: m.set_id
335: from
336: BOM_BILL_OF_MATERIALS b,
337: MTL_SYSTEM_ITEMS_INTERFACE m
338: where m.set_id = TO_CHAR(to_number(USERENV('SESSIONID')))
339: and m.copy_item_id = b.assembly_item_id
340: and m.organization_id = b.organization_id
341: and b.alternate_bom_designator is NULL;

Line 1202: MTL_SYSTEM_ITEMS_INTERFACE m

1198: from
1199: BOM_OPERATIONAL_ROUTINGS b,
1200: MTL_DEMAND d,
1201: MTL_PARAMETERS mp,
1202: MTL_SYSTEM_ITEMS_INTERFACE m
1203: where m.set_id = TO_CHAR(to_number(USERENV('SESSIONID')))
1204: and d.demand_source_line = m.demand_source_line
1205: and d.demand_source_type = m.demand_source_type
1206: and d.demand_source_header_id = m.demand_source_header_id

Line 1239: mtl_system_items_interface m

1235: Update BOM_OP_ROUTINGS_INTERFACE b
1236: set mixed_model_map_flag =
1237: ( select 1
1238: from bom_operational_routings b1,
1239: mtl_system_items_interface m
1240: where b.assembly_item_id = m.inventory_item_id
1241: and b.organization_id = m.organization_id
1242: and m.set_id = to_char(to_number(USERENV('SESSIONID')))
1243: and b1.assembly_item_id = m.copy_item_id

Line 2360: from mtl_system_items_interface m

2356: and v.inventory_item_id = bci.component_item_id
2357: and v.element_name = i.element_name)
2358: where i.inventory_item_id =
2359: (select inventory_item_id
2360: from mtl_system_items_interface m
2361: where inventory_item_id = i.inventory_item_id
2362: and set_id = TO_CHAR(to_number(USERENV('SESSIONID'))));
2363:
2364: /*

Line 2366: ** the MTL_SYSTEM_ITEMS_INTERFACE

2362: and set_id = TO_CHAR(to_number(USERENV('SESSIONID'))));
2363:
2364: /*
2365: ** Update descriptions of the config items in
2366: ** the MTL_SYSTEM_ITEMS_INTERFACE
2367: */
2368: stmt_num := 220;
2369: open ee;
2370: