APPS.FLM_ROUTING dependencies on MTL_SYSTEM_ITEMS_KFV

Line 18: from mtl_system_items_kfv msik

14: o_return_code OUT NOCOPY NUMBER) IS
15:
16: CURSOR all_items IS
17: select msik.inventory_item_id id
18: from mtl_system_items_kfv msik
19: where msik.organization_id = i_org_id
20: and msik.bom_enabled_flag = 'Y'
21: and msik.inventory_item_flag ='Y'
22: and msik.bom_item_type <> 3

Line 89: from mtl_system_items_kfv msik, bom_bill_of_materials bbom2,

85: /* perf bug 5204346 - change in (...) to be a regular query */
86: CURSOR all_option_items IS
87: select id from (
88: select distinct msik.inventory_item_id id, msik.concatenated_segments c_name
89: from mtl_system_items_kfv msik, bom_bill_of_materials bbom2,
90: bom_inventory_components bic2
91: where msik.organization_id = i_org_id
92: and msik.bom_enabled_flag = 'Y'
93: and msik.inventory_item_flag = 'Y'

Line 134: from mtl_system_items_kfv msik

130: and msik.inventory_item_id = bic2.component_item_id
131: ) order by c_name;
132:
133: /* select msik.inventory_item_id id
134: from mtl_system_items_kfv msik
135: where msik.organization_id = i_org_id
136: and msik.bom_enabled_flag = 'Y'
137: and msik.inventory_item_flag = 'Y'
138: and msik.bom_item_type =2

Line 300: from mtl_system_items_kfv msik, bom_operational_routings bor1

296: o_return_code OUT NOCOPY NUMBER) IS
297:
298: CURSOR all_items IS
299: select msik.inventory_item_id id, bor1.alternate_routing_designator alt
300: from mtl_system_items_kfv msik, bom_operational_routings bor1
301: where msik.organization_id = i_org_id
302: and msik.organization_id = bor1.organization_id
303: and msik.inventory_item_id = bor1.assembly_item_id
304: and msik.bom_enabled_flag = 'Y'