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.AHL_WORKORDER_SEARCH_PUB dependencies on FND_USER

Line 14: select user_id from fnd_user where user_name = p_user_id;

10:
11: FUNCTION init_user_and_role(p_user_id IN VARCHAR2) RETURN VARCHAR2 IS
12:
13: CURSOR get_user_id_csr(p_user_id IN VARCHAR2) IS
14: select user_id from fnd_user where user_name = p_user_id;
15:
16: l_user_id NUMBER;
17: l_resp_id NUMBER;
18:

Line 124: 'Fnd_User fnd '||

120: 'ahl_Operation_Resources Opr, '||
121: 'ahl_Work_Assignments Wass, '||
122: 'per_People_F Pf, '||
123: 'per_Person_Types Pt, '||
124: 'Fnd_User fnd '||
125: 'WHERE '||
126: 'fnd.USER_ID = FND_GLOBAL.USER_ID and '||
127: 'fnd.employee_id = pf.PERSON_ID and '||
128: 'wass.employee_id = pf.PERSON_ID and '||

Line 126: 'fnd.USER_ID = FND_GLOBAL.USER_ID and '||

122: 'per_People_F Pf, '||
123: 'per_Person_Types Pt, '||
124: 'Fnd_User fnd '||
125: 'WHERE '||
126: 'fnd.USER_ID = FND_GLOBAL.USER_ID and '||
127: 'fnd.employee_id = pf.PERSON_ID and '||
128: 'wass.employee_id = pf.PERSON_ID and '||
129: ' pt.Person_Type_Id = Pf.Person_Type_Id And '||
130: 'pt.system_person_type =''EMP'' AND '||

Line 189: 'Fnd_User fnd '||

185: 'per_people_f pf, '||
186: 'bom_resource_employees bre, '||
187: 'PER_PERSON_TYPES PEPT, '||
188: 'ahl_pp_requirement_v aprv, '||
189: 'Fnd_User fnd '||
190: 'WHERE '||
191: 'fnd.USER_ID = FND_GLOBAL.USER_ID and '||
192: 'fnd.employee_id = pf.PERSON_ID and '||
193: ' NVL(pf.CURRENT_EMPLOYEE_FLAG, ''X'') = ''Y'' AND '||

Line 191: 'fnd.USER_ID = FND_GLOBAL.USER_ID and '||

187: 'PER_PERSON_TYPES PEPT, '||
188: 'ahl_pp_requirement_v aprv, '||
189: 'Fnd_User fnd '||
190: 'WHERE '||
191: 'fnd.USER_ID = FND_GLOBAL.USER_ID and '||
192: 'fnd.employee_id = pf.PERSON_ID and '||
193: ' NVL(pf.CURRENT_EMPLOYEE_FLAG, ''X'') = ''Y'' AND '||
194: 'PEPT.PERSON_TYPE_ID = pf.PERSON_TYPE_ID AND '||
195: 'PEPT.SYSTEM_PERSON_TYPE =''EMP'' AND '||

Line 208: 'Fnd_User fnd '||

204: 'wip_discrete_jobs widj1, '||
205: 'ahl_Workorder_Operations Wop, '||
206: 'ahl_Operation_Resources Opr, '||
207: 'ahl_Work_Assignments Wass, '||
208: 'Fnd_User fnd '||
209: 'WHERE '||
210: 'fnd.USER_ID = FND_GLOBAL.USER_ID and '||
211: 'fnd.employee_id = pf.PERSON_ID and '||
212: 'NVL(pf.CURRENT_EMPLOYEE_FLAG, ''X'') = ''Y'' AND '||

Line 210: 'fnd.USER_ID = FND_GLOBAL.USER_ID and '||

206: 'ahl_Operation_Resources Opr, '||
207: 'ahl_Work_Assignments Wass, '||
208: 'Fnd_User fnd '||
209: 'WHERE '||
210: 'fnd.USER_ID = FND_GLOBAL.USER_ID and '||
211: 'fnd.employee_id = pf.PERSON_ID and '||
212: 'NVL(pf.CURRENT_EMPLOYEE_FLAG, ''X'') = ''Y'' AND '||
213: 'PEPT.PERSON_TYPE_ID = pf.PERSON_TYPE_ID AND '||
214: 'PEPT.SYSTEM_PERSON_TYPE =''EMP'' AND '||