APPS.OE_CONFIG_TSO_PVT dependencies on MTL_SYSTEM_ITEMS

Line 232: FROM mtl_system_items mtl_msi

228: ,mtl_msi.config_model_type
229: INTO l_bom_item_type
230: ,l_replenish_to_order_flag
231: ,l_config_model_type
232: FROM mtl_system_items mtl_msi
233: WHERE mtl_msi.inventory_item_id = l_inventory_item_id
234: AND mtl_msi.organization_id=OE_SYS_PARAMETERS.Value('MASTER_ORGANIZATION_ID',p_org_id); --Bug 5524710
235:
236: IF l_debug_level > 0 THEN

Line 293: FROM mtl_system_items mtl_msi, oe_order_lines oe_l

289: l_ato_line_id IS NULL THEN
290:
291: SELECT mtl_msi.config_model_type
292: INTO l_config_model_type
293: FROM mtl_system_items mtl_msi, oe_order_lines oe_l
294: WHERE oe_l.line_id = l_top_model_line_id
295: AND oe_l.inventory_item_id = mtl_msi.inventory_item_id
296: AND mtl_msi.organization_id = OE_SYS_PARAMETERS.Value('MASTER_ORGANIZATION_ID',p_org_id); --Bug 5524710
297:

Line 581: FROM mtl_system_items

577: IF l_top_container_model = 'Y' AND p_line_rec.ordered_quantity <> 1 THEN -- 7217602
578:
579: SELECT nvl(comms_nl_trackable_flag, 'N')
580: INTO l_ib_trackable_flag
581: FROM mtl_system_items
582: WHERE inventory_item_id = p_line_rec.inventory_item_id
583: AND organization_id = OE_SYS_PARAMETERS.Value('MASTER_ORGANIZATION_ID');
584:
585: IF l_ib_trackable_flag = 'Y' THEN

Line 662: FROM cz_config_details_v cz_czv, mtl_system_items mtl_msi

658: OE_DEBUG_PUB.Add('ERRM: No Data Found when selecting config delta',3);
659:
660: SELECT description
661: INTO l_description
662: FROM cz_config_details_v cz_czv, mtl_system_items mtl_msi
663: WHERE cz_czv.inventory_item_id = mtl_msi.inventory_item_id
664: AND cz_czv.config_delta <> 0 --implies change
665: AND cz_czv.config_hdr_id = p_line_rec.config_header_id
666: AND cz_czv.config_rev_nbr = p_line_rec.config_rev_nbr

Line 1129: FROM oe_order_lines oe_oel, mtl_system_items mtl_msi

1125: x_msg_count := 1;
1126:
1127: SELECT description
1128: INTO l_description
1129: FROM oe_order_lines oe_oel, mtl_system_items mtl_msi
1130: WHERE oe_oel.line_id = p_line_id
1131: AND oe_oel.inventory_item_id = mtl_msi.inventory_item_id
1132: AND oe_oel.org_id = mtl_msi.organization_id;
1133: