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.ENG_ECO_UTIL dependencies on ENG_CHANGE_ROUTE_PEOPLE

Line 4315: from ENG_CHANGE_ROUTE_PEOPLE ecrp , ENG_CHANGE_ROUTE_STEPS ecrs , ENG_LIFECYCLE_STATUSES els

4311: -- Real code starts here -----------------------------------------------
4312: DELETE FROM ENG_CHANGE_ROUTE_ASSOCS
4313: WHERE ROUTE_PEOPLE_ID in
4314: ( select ecrp.ROUTE_PEOPLE_ID
4315: from ENG_CHANGE_ROUTE_PEOPLE ecrp , ENG_CHANGE_ROUTE_STEPS ecrs , ENG_LIFECYCLE_STATUSES els
4316: where ecrp.STEP_ID = ecrs.step_id
4317: AND ecrs.ROUTE_ID = els.CHANGE_WF_ROUTE_ID
4318: and els.ENTITY_ID1 = p_change_id
4319: and els.ENTITY_NAME = 'ENG_CHANGE'

Line 4323: from ENG_CHANGE_ROUTE_PEOPLE

4319: and els.ENTITY_NAME = 'ENG_CHANGE'
4320: );
4321: --Fixed for bug 4958931
4322: /*( select ROUTE_PEOPLE_ID
4323: from ENG_CHANGE_ROUTE_PEOPLE
4324: where STEP_ID in
4325: ( select STEP_ID
4326: from ENG_CHANGE_ROUTE_STEPS
4327: where ROUTE_ID in

Line 4336: delete from ENG_CHANGE_ROUTE_PEOPLE_tl

4332: )
4333: )
4334: );*/
4335:
4336: delete from ENG_CHANGE_ROUTE_PEOPLE_tl
4337: where ROUTE_PEOPLE_ID in
4338: ( select ecrp.ROUTE_PEOPLE_ID
4339: from ENG_CHANGE_ROUTE_PEOPLE ecrp , ENG_CHANGE_ROUTE_STEPS ecrs , ENG_LIFECYCLE_STATUSES els
4340: where ecrp.STEP_ID = ecrs.step_id

Line 4339: from ENG_CHANGE_ROUTE_PEOPLE ecrp , ENG_CHANGE_ROUTE_STEPS ecrs , ENG_LIFECYCLE_STATUSES els

4335:
4336: delete from ENG_CHANGE_ROUTE_PEOPLE_tl
4337: where ROUTE_PEOPLE_ID in
4338: ( select ecrp.ROUTE_PEOPLE_ID
4339: from ENG_CHANGE_ROUTE_PEOPLE ecrp , ENG_CHANGE_ROUTE_STEPS ecrs , ENG_LIFECYCLE_STATUSES els
4340: where ecrp.STEP_ID = ecrs.step_id
4341: AND ecrs.ROUTE_ID = els.CHANGE_WF_ROUTE_ID
4342: and els.ENTITY_ID1 = p_change_id
4343: and els.ENTITY_NAME = 'ENG_CHANGE'

Line 4347: from ENG_CHANGE_ROUTE_PEOPLE

4343: and els.ENTITY_NAME = 'ENG_CHANGE'
4344: );
4345: --Fixed for bug 4958931
4346: /*( select ROUTE_PEOPLE_ID
4347: from ENG_CHANGE_ROUTE_PEOPLE
4348: where STEP_ID in
4349: ( select STEP_ID
4350: from ENG_CHANGE_ROUTE_STEPS
4351: where ROUTE_ID in

Line 4362: delete from ENG_CHANGE_ROUTE_PEOPLE

4358: );*/
4359:
4360:
4361:
4362: delete from ENG_CHANGE_ROUTE_PEOPLE
4363: where STEP_ID in
4364: ( select STEP_ID
4365: from ENG_CHANGE_ROUTE_STEPS
4366: where ROUTE_ID in