APPS.BOM_VALIDATE_SUB_COMPONENT dependencies on BOM_BILL_OF_MATERIALS

Line 125: -- from bom_inventory_component and bom_bill_of_materials tables |

121: BEGIN
122: ------------------------------------------------------------------
123: -- Select Bill_Sequence_Id, Assembly_Type, Assembly_Item_Id, |
124: -- ACD_TYPE, Component_Item_Id and Implementation_Date |
125: -- from bom_inventory_component and bom_bill_of_materials tables |
126: ------------------------------------------------------------------
127:
128: SELECT bbom.bill_sequence_id ,
129: bbom.assembly_type,

Line 146: bom_bill_of_materials bbom

142: l_rec_ID,
143: l_parent_BIT
144: FROM mtl_system_items msi,
145: bom_inventory_components bic,
146: bom_bill_of_materials bbom
147: WHERE msi.inventory_item_id = bbom.assembly_item_id
148: AND msi.organization_id = bbom.organization_id
149: AND bic.component_sequence_id =
150: p_Sub_Comp_Unexp_Rec.component_sequence_id

Line 165: FROM bom_bill_of_materials

161:
162: BEGIN
163: SELECT 1
164: INTO l_dummy
165: FROM bom_bill_of_materials
166: WHERE bill_sequence_id = source_bill_sequence_id
167: AND bill_sequence_id = l_rec_BSI; --p_sub_comp_unexp_rec.bill_Sequence_id; --Bug 5726557
168: EXCEPTION
169: WHEN NO_DATA_FOUND THEN

Line 182: bom_bill_of_materials bbom

178:
179: SELECT msi.bom_enabled_flag
180: INTO l_assy_bom_enabled
181: FROM mtl_system_items_b msi,
182: bom_bill_of_materials bbom
183: WHERE bbom.bill_sequence_id = l_rec_BSI
184: AND bbom.assembly_item_id = msi.inventory_item_id
185: AND bbom.organization_id = msi.organization_id;
186:

Line 392: FROM bom_bill_of_materials bbom

388: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Verfying component for other common orgs . . . '); END IF;
389:
390: SELECT 1
391: INTO l_dummy
392: FROM bom_bill_of_materials bbom
393: WHERE rownum =1
394: AND bbom.common_bill_sequence_id = l_rec_BSI
395: AND bbom.organization_id <> bbom.common_organization_id
396: AND not exists