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 BOM_RESOURCE_EMPLOYEES

Line 7908: SELECT FU.user_id, PF.person_id FROM fnd_user FU,PER_PEOPLE_F PF, HR_ORGANIZATION_UNITS HOU, PER_PERSON_TYPES PEPT, BOM_RESOURCE_EMPLOYEES BRE

7904:
7905: CURSOR get_user_id_csr(p_emp_name VARCHAR2, p_org_id NUMBER) IS
7906:
7907: /* fix for perf. bug# 4919298.
7908: SELECT FU.user_id, PF.person_id FROM fnd_user FU,PER_PEOPLE_F PF, HR_ORGANIZATION_UNITS HOU, PER_PERSON_TYPES PEPT, BOM_RESOURCE_EMPLOYEES BRE
7909: WHERE NVL(PF.CURRENT_EMPLOYEE_FLAG, 'X') = 'Y'
7910: AND PEPT.PERSON_TYPE_ID = PF.PERSON_TYPE_ID
7911: AND PEPT.SYSTEM_PERSON_TYPE = 'EMP'
7912: AND PF.PERSON_ID = BRE.PERSON_ID

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

7918: AND UPPER(PF.FULL_NAME) like UPPER(p_emp_name);
7919: */
7920:
7921: SELECT DISTINCT bre.person_id, fu.user_id
7922: FROM mtl_employees_current_view pf, bom_resource_employees bre, fnd_user fu
7923: WHERE pf.employee_id=bre.person_id
7924: and pf.organization_id = bre.organization_id
7925: and sysdate between BRE.EFFECTIVE_START_DATE and BRE.EFFECTIVE_END_DATE
7926: and FU.employee_id = pf.employee_id