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.PNP_UTIL_FUNC dependencies on PN_LOCATION_PARKS

Line 5067: pn_location_parks d,

5063: INTO l_location_name_rec
5064: FROM pn_locations_all a,
5065: pn_locations_all b,
5066: pn_locations_all c,
5067: pn_location_parks d,
5068: pn_location_parks e,
5069: pn_properties_all prop
5070: WHERE a.location_id = p_Location_Id
5071: AND l_as_of_date BETWEEN a.active_start_date AND a.active_end_date

Line 5068: pn_location_parks e,

5064: FROM pn_locations_all a,
5065: pn_locations_all b,
5066: pn_locations_all c,
5067: pn_location_parks d,
5068: pn_location_parks e,
5069: pn_properties_all prop
5070: WHERE a.location_id = p_Location_Id
5071: AND l_as_of_date BETWEEN a.active_start_date AND a.active_end_date
5072: AND b.location_id = l_parent_location_id

Line 5093: pn_location_parks d,

5089: d.name office_park_name, e.name region_name
5090: INTO l_location_name_rec
5091: FROM pn_locations_all b,
5092: pn_locations_all c,
5093: pn_location_parks d,
5094: pn_location_parks e,
5095: pn_properties_all prop
5096: WHERE b.location_id = p_Location_Id
5097: AND l_as_of_date BETWEEN b.active_start_date AND b.active_end_date

Line 5094: pn_location_parks e,

5090: INTO l_location_name_rec
5091: FROM pn_locations_all b,
5092: pn_locations_all c,
5093: pn_location_parks d,
5094: pn_location_parks e,
5095: pn_properties_all prop
5096: WHERE b.location_id = p_Location_Id
5097: AND l_as_of_date BETWEEN b.active_start_date AND b.active_end_date
5098: AND c.location_id = l_parent_location_id

Line 5116: pn_location_parks d,

5112: prop.property_code,prop.property_name,
5113: d.name office_park_name, e.name region_name
5114: INTO l_location_name_rec
5115: FROM pn_locations_all c,
5116: pn_location_parks d,
5117: pn_location_parks e,
5118: pn_properties_all prop
5119: WHERE c.location_id = p_Location_Id
5120: AND l_as_of_date BETWEEN c.active_start_date AND c.active_end_date

Line 5117: pn_location_parks e,

5113: d.name office_park_name, e.name region_name
5114: INTO l_location_name_rec
5115: FROM pn_locations_all c,
5116: pn_location_parks d,
5117: pn_location_parks e,
5118: pn_properties_all prop
5119: WHERE c.location_id = p_Location_Id
5120: AND l_as_of_date BETWEEN c.active_start_date AND c.active_end_date
5121: AND prop.property_id(+) = c.property_id