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.FTE_COMP_CONSTRAINT_UTIL dependencies on HR_ORGANIZATION_UNITS

Line 35: FROM HR_ORGANIZATION_UNITS HOU, HR_ORGANIZATION_INFORMATION HOI1, MTL_PARAMETERS MP

31: IS
32:
33: CURSOR c_get_org_name(c_object_value_num IN NUMBER) IS
34: SELECT HOU.NAME ORGANIZATION_NAME
35: FROM HR_ORGANIZATION_UNITS HOU, HR_ORGANIZATION_INFORMATION HOI1, MTL_PARAMETERS MP
36: WHERE HOU.ORGANIZATION_ID = HOI1.ORGANIZATION_ID
37: AND HOU.ORGANIZATION_ID = MP.ORGANIZATION_ID
38: AND HOI1.ORG_INFORMATION1 = 'INV'
39: AND HOI1.ORG_INFORMATION2 = 'Y'

Line 80: FROM HR_ORGANIZATION_UNITS HAOU, HR_ORGANIZATION_INFORMATION HOI1, MTL_PARAMETERS MP,

76: haou.name company_name,
77: 'ORGANIZATION' company_type,
78: nvl(nvl(flp.facility_code,wl.location_code),to_char(wl.wsh_location_id)) facility_code,
79: nvl(flp.description,wl.ui_location_code) description
80: FROM HR_ORGANIZATION_UNITS HAOU, HR_ORGANIZATION_INFORMATION HOI1, MTL_PARAMETERS MP,
81: wsh_locations wl, fte_location_parameters flp
82: WHERE haou.location_id = wl.source_location_id
83: AND wl.location_source_code = 'HR'
84: AND HAOU.ORGANIZATION_ID = HOI1.ORGANIZATION_ID

Line 421: FROM HR_ORGANIZATION_UNITS HOU, HR_ORGANIZATION_INFORMATION HOI1, MTL_PARAMETERS MP,

417:
418: cursor c_hr_details (p_locid VARCHAR2) is
419: select hou.organization_id company_id, hou.name company_name,
420: hou.name site, 'ORGANIZATION' company_type
421: FROM HR_ORGANIZATION_UNITS HOU, HR_ORGANIZATION_INFORMATION HOI1, MTL_PARAMETERS MP,
422: wsh_locations wl
423: WHERE hou.location_id = wl.source_location_id
424: AND wl.location_source_code = 'HR'
425: AND HOU.ORGANIZATION_ID = HOI1.ORGANIZATION_ID