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.ENGECOBO dependencies on HR_ORGANIZATION_INFORMATION

Line 1948: , HR_ORGANIZATION_INFORMATION HOI1

1944: /* Need the Organization Id to fetch the records */
1945: SELECT MP.organization_id
1946: INTO l_org_hierarchy_level_id
1947: FROM HR_ORGANIZATION_UNITS HOU
1948: , HR_ORGANIZATION_INFORMATION HOI1
1949: , MTL_PARAMETERS MP
1950: WHERE HOU.ORGANIZATION_ID = HOI1.ORGANIZATION_ID
1951: AND HOU.ORGANIZATION_ID = MP.ORGANIZATION_ID
1952: AND HOI1.ORG_INFORMATION1 = 'INV'

Line 6214: , hr_organization_information hoi

6210: SELECT eclo.local_organization_id
6211: FROM eng_engineering_changes eec
6212: , eng_change_local_orgs eclo
6213: , hr_all_organization_units org
6214: , hr_organization_information hoi
6215: , mtl_parameters mp
6216: WHERE eec.change_notice = p_change_notice
6217: AND eec.organization_id = p_organization_id
6218: AND eclo.change_id = eec.change_id

Line 6314: , HR_ORGANIZATION_INFORMATION HOI1

6310:
6311: CURSOR c_organization_details IS
6312: SELECT MP.organization_id
6313: FROM HR_ORGANIZATION_UNITS HOU
6314: , HR_ORGANIZATION_INFORMATION HOI1
6315: , MTL_PARAMETERS MP
6316: WHERE HOU.ORGANIZATION_ID = HOI1.ORGANIZATION_ID
6317: AND HOU.ORGANIZATION_ID = MP.ORGANIZATION_ID
6318: AND HOI1.ORG_INFORMATION1 = 'INV'