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_WORKFLOW_UTIL dependencies on EGO_USER_V

Line 9960: , EGO_USER_V UserV

9956: --
9957: SELECT COUNT(*)
9958: INTO l_total_pop
9959: FROM ENG_CHANGE_ROUTE_PEOPLE RoutePeople
9960: , EGO_USER_V UserV
9961: , WF_NOTIFICATIONS wn
9962: WHERE RoutePeople.assignee_id = UserV.party_id
9963: AND RoutePeople.response_condition_code = 'MANDATORY'
9964: AND RoutePeople.step_id = StepId

Line 9972: , EGO_USER_V UserV

9968:
9969: SELECT COUNT(*)
9970: INTO l_total_voted
9971: FROM ENG_CHANGE_ROUTE_PEOPLE RoutePeople
9972: , EGO_USER_V UserV
9973: , WF_NOTIFICATIONS wn
9974: WHERE RoutePeople.assignee_id = UserV.party_id
9975: AND RoutePeople.response_condition_code = 'MANDATORY'
9976: AND RoutePeople.step_id = StepId

Line 9985: , EGO_USER_V UserV

9981:
9982: SELECT COUNT(*)
9983: INTO l_code_count
9984: FROM ENG_CHANGE_ROUTE_PEOPLE RoutePeople
9985: , EGO_USER_V UserV
9986: , WF_NOTIFICATION_ATTRIBUTES wfna
9987: , WF_NOTIFICATIONS wn
9988: WHERE RoutePeople.assignee_id = UserV.party_id
9989: AND RoutePeople.response_condition_code = 'MANDATORY'

Line 10771: FROM EGO_USER_V UserV

10767: CURSOR c_ntf_info (p_ntf_id NUMBER)
10768: IS
10769:
10770: SELECT UserV.user_id user_id
10771: FROM EGO_USER_V UserV
10772: , WF_NOTIFICATIONS wf
10773: WHERE UserV.user_name = wf.recipient_role
10774: AND wf.notification_id = p_ntf_id ;
10775:

Line 10780: FROM EGO_USER_V UserV

10776:
10777: CURSOR c_person_id (p_user_id NUMBER)
10778: IS
10779: SELECT UserV.party_id person_id
10780: FROM EGO_USER_V UserV
10781: WHERE UserV.user_id = p_user_id ;
10782:
10783: BEGIN
10784:

Line 10888: FROM EGO_USER_V UserV

10884: CURSOR c_ntf_info (p_ntf_id NUMBER)
10885: IS
10886:
10887: SELECT UserV.user_id user_id
10888: FROM EGO_USER_V UserV
10889: , WF_NOTIFICATIONS wf
10890: WHERE UserV.user_name = wf.recipient_role
10891: AND wf.notification_id = p_ntf_id ;
10892:

Line 10897: FROM EGO_USER_V UserV

10893:
10894: CURSOR c_person_id (p_user_id NUMBER)
10895: IS
10896: SELECT UserV.party_id person_id
10897: FROM EGO_USER_V UserV
10898: WHERE UserV.user_id = p_user_id ;
10899:
10900: BEGIN
10901: