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.IRC_SEEKER_VAC_MATCHING_PKG dependencies on SDO_GEOMETRY

Line 1017: , mdsys.sdo_geometry(2001,8307,mdsys.sdo_point_type(:longitude,:latitude,null),null,null)

1013: )
1014: AND :longitude IS NOT NULL
1015: AND ( locator_within_distance
1016: ( loc.geometry
1017: , mdsys.sdo_geometry(2001,8307,mdsys.sdo_point_type(:longitude,:latitude,null),null,null)
1018: , ''distance=''
1019: || :distance_to_location
1020: ||'' units=MILE''
1021: ) = ''TRUE''

Line 1029: , mdsys.sdo_geometry(2001,8307,mdsys.sdo_point_type(:longitude,:latitude,null),null,null)

1025: where ilp.object_type (+) = ''VACANCY''
1026: and vac.vacancy_id = ilp.object_id(+)
1027: and ilp.location_id = loc_pref.location_id
1028: and locator_within_distance (loc_pref.geometry
1029: , mdsys.sdo_geometry(2001,8307,mdsys.sdo_point_type(:longitude,:latitude,null),null,null)
1030: , ''distance=''
1031: || :distance_to_location
1032: ||'' units=MILE''
1033: ) = ''TRUE''