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.OKC_WF_K_APPROVE dependencies on DUAL

Line 104: from dual

100: (
101: select 1 num,
102: FND_PROFILE.VALUE('OKC_K_APPROVER') role,
103: FND_PROFILE.VALUE('OKC_K_APPROVER') name
104: from dual
105: where not exists
106: ( select '!'
107: from FND_USER USR, PER_PEOPLE_F PER
108: where USR.USER_NAME=FND_PROFILE.VALUE('OKC_K_APPROVER')

Line 158: (select 1 num, l_approver role, '' name from dual

154:
155: cursor Next_Informed_csr is
156: select role, name from -- here should be your view
157: ------------------------------------------------------
158: (select 1 num, l_approver role, '' name from dual
159: where l_approver is not NULL
160: union all
161: select 2 num, l_initiator role, '' name from dual
162: where not exists

Line 161: select 2 num, l_initiator role, '' name from dual

157: ------------------------------------------------------
158: (select 1 num, l_approver role, '' name from dual
159: where l_approver is not NULL
160: union all
161: select 2 num, l_initiator role, '' name from dual
162: where not exists
163: (select 1 from wf_user_roles
164: where user_name=l_initiator
165: and USER_ORIG_SYSTEM IN ('PER','FND_USR')

Line 173: (select 1 num, l_approver role, '' name from dual

169: ------------------------------------------------------
170: where (p_current is NULL
171: or num > (select num from -- same view
172: ------------------------------------------------------
173: (select 1 num, l_approver role, '' name from dual
174: where l_approver is not NULL
175: union all
176: select 2 num, l_initiator role, '' name from dual
177: where not exists

Line 176: select 2 num, l_initiator role, '' name from dual

172: ------------------------------------------------------
173: (select 1 num, l_approver role, '' name from dual
174: where l_approver is not NULL
175: union all
176: select 2 num, l_initiator role, '' name from dual
177: where not exists
178: (select 1 from wf_user_roles
179: where user_name=l_initiator
180: and USER_ORIG_SYSTEM IN ('PER','FND_USR')

Line 1831: FROM dual;

1827: l_api_version NUMBER :=1.0 ;
1828: l_session_id number;
1829: CURSOR csr_session_id IS
1830: SELECT userenv('sessionid')
1831: FROM dual;
1832: --
1833: begin
1834: mo_global.init('OKC');
1835: --