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 5225: pn_location_parks d,

5221: INTO l_location_name_rec
5222: FROM pn_locations_all a,
5223: pn_locations_all b,
5224: pn_locations_all c,
5225: pn_location_parks d,
5226: pn_location_parks e,
5227: pn_properties_all prop
5228: WHERE a.location_id = p_Location_Id
5229: AND l_as_of_date BETWEEN a.active_start_date AND a.active_end_date

Line 5226: pn_location_parks e,

5222: FROM pn_locations_all a,
5223: pn_locations_all b,
5224: pn_locations_all c,
5225: pn_location_parks d,
5226: pn_location_parks e,
5227: pn_properties_all prop
5228: WHERE a.location_id = p_Location_Id
5229: AND l_as_of_date BETWEEN a.active_start_date AND a.active_end_date
5230: AND b.location_id = l_parent_location_id

Line 5251: pn_location_parks d,

5247: d.name office_park_name, e.name region_name
5248: INTO l_location_name_rec
5249: FROM pn_locations_all b,
5250: pn_locations_all c,
5251: pn_location_parks d,
5252: pn_location_parks e,
5253: pn_properties_all prop
5254: WHERE b.location_id = p_Location_Id
5255: AND l_as_of_date BETWEEN b.active_start_date AND b.active_end_date

Line 5252: pn_location_parks e,

5248: INTO l_location_name_rec
5249: FROM pn_locations_all b,
5250: pn_locations_all c,
5251: pn_location_parks d,
5252: pn_location_parks e,
5253: pn_properties_all prop
5254: WHERE b.location_id = p_Location_Id
5255: AND l_as_of_date BETWEEN b.active_start_date AND b.active_end_date
5256: AND c.location_id = l_parent_location_id

Line 5274: pn_location_parks d,

5270: prop.property_code,prop.property_name,
5271: d.name office_park_name, e.name region_name
5272: INTO l_location_name_rec
5273: FROM pn_locations_all c,
5274: pn_location_parks d,
5275: pn_location_parks e,
5276: pn_properties_all prop
5277: WHERE c.location_id = p_Location_Id
5278: AND l_as_of_date BETWEEN c.active_start_date AND c.active_end_date

Line 5275: pn_location_parks e,

5271: d.name office_park_name, e.name region_name
5272: INTO l_location_name_rec
5273: FROM pn_locations_all c,
5274: pn_location_parks d,
5275: pn_location_parks e,
5276: pn_properties_all prop
5277: WHERE c.location_id = p_Location_Id
5278: AND l_as_of_date BETWEEN c.active_start_date AND c.active_end_date
5279: AND prop.property_id(+) = c.property_id