APPS.FLM_ROUTING dependencies on BOM_BILL_OF_MATERIALS

Line 32: from bom_bill_of_materials bbom,

28: i_to_item is null))
29: and (i_product_family_id is null or
30: msik.inventory_item_id in (
31: select bic.component_item_id
32: from bom_bill_of_materials bbom,
33: bom_inventory_components bic
34: where bbom.assembly_item_id = i_product_family_id
35: and bbom.organization_id = i_org_id
36: and bbom.alternate_bom_designator is null

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 102: from bom_bill_of_materials bbom, bom_inventory_components bic

98: (msik.concatenated_segments <= i_to_item or i_to_item is null))
99: and (i_product_family_id is null or
100: msik.inventory_item_id in
101: (select bic.component_item_id
102: from bom_bill_of_materials bbom, bom_inventory_components bic
103: where bbom.assembly_item_id = i_product_family_id
104: and bbom.organization_id = i_org_id
105: and bbom.alternate_bom_designator is null
106: and bbom.bill_sequence_id = bic.bill_sequence_id))

Line 148: from bom_bill_of_materials bbom,

144: i_to_item is null))
145: and (i_product_family_id is null or
146: msik.inventory_item_id in (
147: select bic.component_item_id
148: from bom_bill_of_materials bbom,
149: bom_inventory_components bic
150: where bbom.assembly_item_id = i_product_family_id
151: and bbom.organization_id = i_org_id
152: and bbom.alternate_bom_designator is null

Line 173: bom_bill_of_materials bbom2,

169: and nvl(bor.alternate_routing_designator, '~$~') = nvl(i_alternate_routing_designator, '~$~') )
170: and msik.inventory_item_id in (
171: select bic2.component_item_id
172: from mtl_system_items_b msi2,
173: bom_bill_of_materials bbom2,
174: bom_inventory_components bic2
175: where bbom2.organization_id = i_org_id and
176: bbom2.assembly_item_id = i_assembly_item_id and
177: nvl(bbom2.alternate_bom_designator,'$$$') = nvl(i_alt_designator,'$$$') and

Line 195: from bom_bill_of_materials

191: BEGIN
192:
193: select count(*)
194: into l_bill_count
195: from bom_bill_of_materials
196: where assembly_item_id = i_assembly_item_id and
197: organization_id = i_org_id and
198: nvl(alternate_bom_designator,'$$$') =
199: nvl(i_alt_designator,'$$$');

Line 317: from bom_bill_of_materials bbom,

313: i_to_item is null))
314: and (i_product_family_id is null or
315: msik.inventory_item_id in (
316: select bic.component_item_id
317: from bom_bill_of_materials bbom,
318: bom_inventory_components bic
319: where bbom.assembly_item_id = i_product_family_id
320: and bbom.organization_id = i_org_id
321: and bbom.alternate_bom_designator is null