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 1929: , HR_ORGANIZATION_INFORMATION HOI1

1925: /* Need the Organization Id to fetch the records */
1926: SELECT MP.organization_id
1927: INTO l_org_hierarchy_level_id
1928: FROM HR_ORGANIZATION_UNITS HOU
1929: , HR_ORGANIZATION_INFORMATION HOI1
1930: , MTL_PARAMETERS MP
1931: WHERE HOU.ORGANIZATION_ID = HOI1.ORGANIZATION_ID
1932: AND HOU.ORGANIZATION_ID = MP.ORGANIZATION_ID
1933: AND HOI1.ORG_INFORMATION1 = 'INV'

Line 5741: , hr_organization_information hoi

5737: SELECT eclo.local_organization_id
5738: FROM eng_engineering_changes eec
5739: , eng_change_local_orgs eclo
5740: , hr_all_organization_units org
5741: , hr_organization_information hoi
5742: , mtl_parameters mp
5743: WHERE eec.change_notice = p_change_notice
5744: AND eec.organization_id = p_organization_id
5745: AND eclo.change_id = eec.change_id

Line 5841: , HR_ORGANIZATION_INFORMATION HOI1

5837:
5838: CURSOR c_organization_details IS
5839: SELECT MP.organization_id
5840: FROM HR_ORGANIZATION_UNITS HOU
5841: , HR_ORGANIZATION_INFORMATION HOI1
5842: , MTL_PARAMETERS MP
5843: WHERE HOU.ORGANIZATION_ID = HOI1.ORGANIZATION_ID
5844: AND HOU.ORGANIZATION_ID = MP.ORGANIZATION_ID
5845: AND HOI1.ORG_INFORMATION1 = 'INV'