APPS.BOM_VALIDATE dependencies on BOM_BILL_OF_MATERIALS

Line 236: select NULL from bom_bill_of_materials a, bom_alternate_designators b

232: RETURN 'N' ;
233: END IF;
234:
235: SELECT 'x' INTO l_dummy FROM dual WHERE EXISTS (
236: select NULL from bom_bill_of_materials a, bom_alternate_designators b
237: where a.assembly_item_id = p_assembly_item_id
238: and a.organization_id = p_organization_id
239: and a.is_preferred = 'Y'
240: and a.structure_type_id = b.structure_type_id