DBA Data[Home] [Help]

APPS.ENG_VALIDATE_REVISED_ITEM dependencies on BOM_ALTERNATE_DESIGNATORS

Line 1811: FROM bom_alternate_designators bad

1807: OR (p_alternate_bom_code IS NOT NULL AND alternate_bom_designator = p_alternate_bom_code));
1808:
1809: CURSOR get_alt_structure_type IS
1810: SELECT bad.structure_type_id
1811: FROM bom_alternate_designators bad
1812: WHERE ((p_alternate_bom_code IS NULL AND bad.alternate_designator_code IS NULL AND bad.organization_id = -1)
1813: OR (p_alternate_bom_code IS NOT NULL AND bad.alternate_designator_code = p_alternate_bom_code
1814: AND bad.organization_id = p_organization_id));
1815:

Line 5358: FROM bom_alternate_designators

5354: p_organization_id NUMBER ) IS
5355: SELECT 'Invalid Alaternatae'
5356: FROM SYS.DUAL
5357: WHERE NOT EXISTS ( SELECT NULL
5358: FROM bom_alternate_designators
5359: WHERE alternate_designator_code = p_alt_designator
5360: AND organization_id = p_organization_id
5361: ) ;
5362: