536: IF l_tmp_str_name IS NOT NULL THEN
537:
538: select alternate_bom_designator
539: into l_tmp_str_name
540: from bom_structures_b
541: where assembly_item_id = p_item_id
542: and organization_id = p_org_id
543: and alternate_bom_designator = l_tmp_str_name;
544:
545: ELSE
546:
547: select alternate_bom_designator
548: into l_tmp_str_name
549: from bom_structures_b
550: where assembly_item_id = p_item_id
551: and organization_id = p_org_id
552: and alternate_bom_designator IS NULL;
553: