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.CTO_AUTO_PROCURE_PK dependencies on HR_ALL_ORGANIZATION_UNITS

Line 1350: from hr_all_organization_units org,

1346: -- There is a user setup needed for IR. Refer to PO manuals.
1347:
1348: /* Commented as part of bugfix 7162037
1349: select org.location_id into x_location_id
1350: from hr_all_organization_units org,
1351: hr_locations_all loc
1352: where org.organization_id = p_org_id
1353: and org.location_id = loc.location_id
1354: and exists(select 1 from po_location_associations_all pla

Line 1374: from hr_all_organization_units org,

1370: elsif p_source_type = 3 then
1371:
1372: -- For ER's validating against hr_locations is enough
1373: select org.location_id into x_location_id
1374: from hr_all_organization_units org,
1375: hr_locations_all loc
1376: where org.organization_id = p_org_id
1377: and org.location_id = loc.location_id;
1378: