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.PN_LOC_STATUS_CHANGE_PKG dependencies on STANDARD

Line 74: loc.standard_type_lookup_code

70: loc.assignable_area,
71: loc.common_area,
72: loc.common_area_flag,
73: loc.function_type_lookup_code,
74: loc.standard_type_lookup_code
75: FROM pn_locations loc /*sdm?? Location Code lies in a range*/
76: WHERE loc.location_type_lookup_code = p_loc_type
77: AND loc.location_code BETWEEN p_loc_code_low and p_loc_code_high;
78:

Line 144: cld.standard_type_lookup_code

140: cld.assignable_area,
141: cld.common_area,
142: cld.common_area_flag,
143: cld.function_type_lookup_code,
144: cld.standard_type_lookup_code
145: FROM pn_locations_all cld /*sdm14jul*/
146: WHERE cld.location_id <> p_location_id
147: AND cld.location_id IN (SELECT location_id
148: FROM pn_locations_all /*sdm14jul*/