APPS.BOM_VALIDATE dependencies on BOM_ALTERNATE_DESIGNATORS

Line 48: FROM bom_alternate_designators

44: l_dummy NUMBER;
45: BEGIN
46: SELECT 1
47: INTO l_dummy
48: FROM bom_alternate_designators
49: WHERE alternate_designator_code = p_alternate_bom_code
50: AND organization_id = p_organization_id;
51:
52: RETURN TRUE;

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