DBA Data[Home] [Help]

APPS.ENG_VALIDATE_REVISED_ITEM dependencies on BOM_ALTERNATE_DESIGNATORS

Line 1883: FROM bom_alternate_designators bad

1879: OR (p_alternate_bom_code IS NOT NULL AND alternate_bom_designator = p_alternate_bom_code));
1880:
1881: CURSOR get_alt_structure_type IS
1882: SELECT bad.structure_type_id
1883: FROM bom_alternate_designators bad
1884: WHERE ((p_alternate_bom_code IS NULL AND bad.alternate_designator_code IS NULL AND bad.organization_id = -1)
1885: OR (p_alternate_bom_code IS NOT NULL AND bad.alternate_designator_code = p_alternate_bom_code
1886: AND bad.organization_id = p_organization_id));
1887:

Line 5439: FROM bom_alternate_designators

5435: p_organization_id NUMBER ) IS
5436: SELECT 'Invalid Alaternatae'
5437: FROM SYS.DUAL
5438: WHERE NOT EXISTS ( SELECT NULL
5439: FROM bom_alternate_designators
5440: WHERE alternate_designator_code = p_alt_designator
5441: AND organization_id = p_organization_id
5442: ) ;
5443: