APPS.BOM_BOM_COMPONENT_UTIL dependencies on MTL_SYSTEM_ITEMS

Line 1453: FROM mtl_system_items

1449:
1450: /*
1451: SELECT decode(eng_item_flag, 'N', 1, 2)
1452: INTO l_assembly_type
1453: FROM mtl_system_items
1454: WHERE inventory_item_id = l_rev_comp_unexp_rec.revised_item_id
1455: AND organization_id = l_rev_comp_unexp_rec.organization_id;
1456: */
1457: IF p_control_rec.caller_type = 'FORM'

Line 1525: FROM MTL_SYSTEM_ITEMS_B

1521:
1522: Begin
1523: SELECT BOM_ITEM_TYPE
1524: INTO l_bom_item_type
1525: FROM MTL_SYSTEM_ITEMS_B
1526: WHERE INVENTORY_ITEM_ID = l_rev_comp_unexp_rec.revised_item_id
1527: AND ORGANIZATION_ID = l_rev_comp_unexp_rec.organization_id;
1528:
1529: If l_bom_item_type = BOM_Globals.G_PRODUCT_FAMILY Then

Line 1755: FROM mtl_system_items

1751: l_structure_type_id number;
1752: -- Added for bug 4550996
1753: CURSOR c_effectivity_control IS
1754: SELECT effectivity_control
1755: FROM mtl_system_items
1756: WHERE inventory_item_id = p_assembly_item_id
1757: AND organization_id = p_organization_id;
1758:
1759: l_effectivity_control NUMBER;