APPS.BOM_VALIDATE_REF_DESIGNATOR dependencies on BOM_BILL_OF_MATERIALS

Line 278: bom_bill_of_materials bbom

274: l_rec_optional
275: FROM mtl_system_items msi,
276: mtl_system_items msi2,
277: bom_inventory_components bic,
278: bom_bill_of_materials bbom
279: WHERE msi.inventory_item_id = bbom.assembly_item_id
280: AND msi.organization_id = bbom.organization_id
281: AND msi2.inventory_item_id = bic.component_item_id
282: AND msi2.organization_id = bic.pk2_value

Line 334: FROM bom_bill_of_materials

330: BEGIN
331: IF Bom_Globals.Get_Caller_Type <> 'MIGRATION' THEN
332: SELECT 1
333: INTO l_dummy
334: FROM bom_bill_of_materials
335: WHERE bill_sequence_id = source_bill_sequence_id
336: AND bill_sequence_id = p_ref_desg_unexp_rec.bill_sequence_id;
337: END IF;
338: EXCEPTION

Line 367: bom_bill_of_materials bbom

363: /*Check BOM enabled flag of the assembly*/
364: SELECT msi.bom_enabled_flag
365: INTO l_assy_bom_enabled
366: FROM mtl_system_items_b msi,
367: bom_bill_of_materials bbom
368: WHERE bbom.bill_sequence_id = p_Ref_Desg_Unexp_Rec.bill_sequence_id
369: AND bbom.assembly_item_id = msi.inventory_item_id
370: AND bbom.organization_id = msi.organization_id;
371:

Line 566: FROM bom_bill_of_materials bom,

562: SELECT 'Planning Bill'
563: INTO l_dummy
564: FROM sys.dual
565: WHERE EXISTS (SELECT 'Planning Item'
566: FROM bom_bill_of_materials bom,
567: mtl_system_items msi,
568: bom_inventory_components bic
569: WHERE msi.bom_item_type = 3 /* PLANNING */
570: AND msi.inventory_item_id = bom.assembly_item_id

Line 885: bom_bill_of_materials bbom

881: l_rec_optional
882: FROM mtl_system_items msi,
883: mtl_system_items msi2,
884: bom_inventory_components bic,
885: bom_bill_of_materials bbom
886: WHERE msi.inventory_item_id = bbom.assembly_item_id
887: AND msi.organization_id = bbom.organization_id
888: AND msi2.inventory_item_id = bic.component_item_id
889: AND msi2.organization_id = bic.pk2_value