DBA Data[Home] [Help]

APPS.BOM_VALIDATE_BOM_HEADER dependencies on BOM_ALTERNATE_DESIGNATORS

Line 609: SELECT Count(1) INTO l_count FROM bom_alternate_designators

605: ---
606: -- Packaging BOM creation is allowed only with the prefered structure name for the
607: -- structure type 'Packaging Hierarchy'
608: ---
609: SELECT Count(1) INTO l_count FROM bom_alternate_designators
610: WHERE structure_type_id = struct_type_id and alternate_designator_code = p_bom_header_rec.alternate_bom_code
611: AND organization_id = p_bom_head_unexp_rec.organization_id AND is_preferred = 'Y';
612:
613: IF l_count < 1 THEN

Line 699: FROM BOM_ALTERNATE_DESIGNATORS BAD

695: AND p_bom_head_unexp_rec.structure_type_id <> FND_API.G_MISS_NUM )
696: THEN
697: SELECT COUNT(1)
698: INTO l_count
699: FROM BOM_ALTERNATE_DESIGNATORS BAD
700: WHERE
701: BAD.ORGANIZATION_ID = p_bom_head_unexp_rec.organization_id
702: AND BAD.ALTERNATE_DESIGNATOR_CODE = p_bom_header_rec.alternate_bom_code
703: AND BAD.STRUCTURE_TYPE_ID IN