APPS.BOM_BOM_COMPONENT_UTIL dependencies on MTL_SYSTEM_ITEMS

Line 1346: FROM mtl_system_items

1342:
1343: /*
1344: SELECT decode(eng_item_flag, 'N', 1, 2)
1345: INTO l_assembly_type
1346: FROM mtl_system_items
1347: WHERE inventory_item_id = l_rev_comp_unexp_rec.revised_item_id
1348: AND organization_id = l_rev_comp_unexp_rec.organization_id;
1349: */
1350: IF p_control_rec.caller_type = 'FORM'

Line 1418: FROM MTL_SYSTEM_ITEMS_B

1414:
1415: Begin
1416: SELECT BOM_ITEM_TYPE
1417: INTO l_bom_item_type
1418: FROM MTL_SYSTEM_ITEMS_B
1419: WHERE INVENTORY_ITEM_ID = l_rev_comp_unexp_rec.revised_item_id
1420: AND ORGANIZATION_ID = l_rev_comp_unexp_rec.organization_id;
1421:
1422: If l_bom_item_type = BOM_Globals.G_PRODUCT_FAMILY Then

Line 1647: FROM mtl_system_items

1643: l_structure_type_id number;
1644: -- Added for bug 4550996
1645: CURSOR c_effectivity_control IS
1646: SELECT effectivity_control
1647: FROM mtl_system_items
1648: WHERE inventory_item_id = p_assembly_item_id
1649: AND organization_id = p_organization_id;
1650:
1651: l_effectivity_control NUMBER;