APPS.BOM_VALIDATE_SUB_COMPONENT dependencies on BOM_BILL_OF_MATERIALS

Line 128: -- from bom_inventory_component and bom_bill_of_materials tables |

124: BEGIN
125: ------------------------------------------------------------------
126: -- Select Bill_Sequence_Id, Assembly_Type, Assembly_Item_Id, |
127: -- ACD_TYPE, Component_Item_Id and Implementation_Date |
128: -- from bom_inventory_component and bom_bill_of_materials tables |
129: ------------------------------------------------------------------
130:
131: --modifying the query below for BOM ER #9946990
132:

Line 158: bom_bill_of_materials bbom

154: l_rec_optional
155: FROM mtl_system_items msi,
156: mtl_system_items msi2,
157: bom_inventory_components bic,
158: bom_bill_of_materials bbom
159: WHERE msi.inventory_item_id = bbom.assembly_item_id
160: AND msi.organization_id = bbom.organization_id
161: AND msi2.inventory_item_id = bic.component_item_id
162: AND msi2.organization_id = bic.pk2_value

Line 225: FROM bom_bill_of_materials

221: BEGIN
222: IF Bom_Globals.Get_Caller_Type <> 'MIGRATION' THEN
223: SELECT 1
224: INTO l_dummy
225: FROM bom_bill_of_materials
226: WHERE bill_sequence_id = source_bill_sequence_id
227: AND bill_sequence_id = l_rec_BSI; --p_sub_comp_unexp_rec.bill_Sequence_id; --Bug 5726557
228: END IF;
229: EXCEPTION

Line 243: bom_bill_of_materials bbom

239:
240: SELECT msi.bom_enabled_flag
241: INTO l_assy_bom_enabled
242: FROM mtl_system_items_b msi,
243: bom_bill_of_materials bbom
244: WHERE bbom.bill_sequence_id = l_rec_BSI
245: AND bbom.assembly_item_id = msi.inventory_item_id
246: AND bbom.organization_id = msi.organization_id;
247:

Line 453: FROM bom_bill_of_materials bbom

449: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Verfying component for other common orgs . . . '); END IF;
450:
451: SELECT 1
452: INTO l_dummy
453: FROM bom_bill_of_materials bbom
454: WHERE rownum =1
455: AND bbom.common_bill_sequence_id = l_rec_BSI
456: AND bbom.organization_id <> bbom.common_organization_id
457: AND not exists