DBA Data[Home] [Help]

APPS.ENGECOBO dependencies on ENG_CHANGE_OBJ_RELATIONSHIPS

Line 182: , eng_change_obj_relationships ecor

178:
179: CURSOR c_local_change_order IS
180: SELECT eec.change_id
181: FROM eng_engineering_changes eec
182: , eng_change_obj_relationships ecor
183: WHERE eec.change_id = ecor.object_to_id1
184: AND ecor.relationship_code IN ( 'PROPAGATED_TO', 'TRANSFERRED_TO' )
185: AND ecor.object_to_name ='ENG_CHANGE'
186: AND ecor.object_to_id3 = p_local_organization_id

Line 5841: FROM eng_change_obj_relationships

5837:
5838: -- Bug# 9498305
5839: SELECT object_to_id1
5840: INTO l_propagated_to_chg_id
5841: FROM eng_change_obj_relationships
5842: WHERE relationship_code = 'PROPAGATED_TO'
5843: AND object_to_name ='ENG_CHANGE'
5844: AND change_id = l_global_change_id
5845: AND object_to_id2 = p_organization_id