eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BOM_VALIDATE_BOM_HEADER dependencies on BOM_ALTERNATE_DESIGNATORS

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

568: ---
569: -- Packaging BOM creation is allowed only with the prefered structure name for the
570: -- structure type 'Packaging Hierarchy'
571: ---
572: SELECT Count(1) INTO l_count FROM bom_alternate_designators
573: WHERE structure_type_id = struct_type_id and alternate_designator_code = p_bom_header_rec.alternate_bom_code
574: AND organization_id = p_bom_head_unexp_rec.organization_id AND is_preferred = 'Y';
575:
576: IF l_count < 1 THEN

Line 662: FROM BOM_ALTERNATE_DESIGNATORS BAD

658: AND p_bom_head_unexp_rec.structure_type_id <> FND_API.G_MISS_NUM )
659: THEN
660: SELECT COUNT(1)
661: INTO l_count
662: FROM BOM_ALTERNATE_DESIGNATORS BAD
663: WHERE
664: BAD.ORGANIZATION_ID = p_bom_head_unexp_rec.organization_id
665: AND BAD.ALTERNATE_DESIGNATOR_CODE = p_bom_header_rec.alternate_bom_code
666: AND BAD.STRUCTURE_TYPE_ID IN