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_PRD_WORKORDER_PVT dependencies on MTL_EMPLOYEES_CURRENT_VIEW

Line 10529: FROM mtl_employees_current_view pf, bom_resource_employees bre, fnd_user fu

10525: AND UPPER(PF.FULL_NAME) like UPPER(p_emp_name);
10526: */
10527:
10528: SELECT DISTINCT bre.person_id, fu.user_id
10529: FROM mtl_employees_current_view pf, bom_resource_employees bre, fnd_user fu
10530: WHERE pf.employee_id=bre.person_id
10531: and pf.organization_id = bre.organization_id
10532: and sysdate between BRE.EFFECTIVE_START_DATE and BRE.EFFECTIVE_END_DATE
10533: and FU.employee_id = pf.employee_id

Line 12139: FROM mtl_employees_current_view pf, bom_resource_employees bre, fnd_user fu

12135: ) IS
12136: --Cursor to Get Current login user's employee name and employee id
12137: CURSOR Get_Emp_Name_And_Id(c_organization_id NUMBER) IS
12138: SELECT distinct pf.full_name emp_name, pf.employee_id
12139: FROM mtl_employees_current_view pf, bom_resource_employees bre, fnd_user fu
12140: WHERE pf.employee_id=bre.person_id
12141: and pf.organization_id = bre.organization_id
12142: and sysdate between BRE.EFFECTIVE_START_DATE and BRE.EFFECTIVE_END_DATE
12143: and FU.employee_id = pf.employee_id