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.PNRX_RENT_INCREASE_DETAIL dependencies on PN_LOCATIONS_ALL

Line 11: FROM pn_locations_all

7:
8: BEGIN
9: SELECT SUBSTR (location_code, 1, 30)
10: INTO l_location_code
11: FROM pn_locations_all
12: WHERE location_id = p_location_id
13: AND ROWNUM < 2;
14:
15: RETURN (l_location_code);

Line 203: ', PN_TENANCIES_ALL ten , PN_LOCATIONS_ALL loc';

199:
200: IF p_location_id IS NOT NULL
201: THEN
202: location_code_from :=
203: ', PN_TENANCIES_ALL ten , PN_LOCATIONS_ALL loc';
204: location_code_where :=
205: ' AND l.lease_id = ten.lease_id
206: AND ten.location_id = loc.location_id
207: AND loc.rowid = (select max(loc1.rowid) from pn_locations_all loc1

Line 207: AND loc.rowid = (select max(loc1.rowid) from pn_locations_all loc1

203: ', PN_TENANCIES_ALL ten , PN_LOCATIONS_ALL loc';
204: location_code_where :=
205: ' AND l.lease_id = ten.lease_id
206: AND ten.location_id = loc.location_id
207: AND loc.rowid = (select max(loc1.rowid) from pn_locations_all loc1
208: where loc.location_id = loc1.location_id)
209: AND ten.location_id = '
210: || ''''
211: || p_location_id

Line 220: pn_locations_all bld

216: THEN
217: property_name_from :=
218: ', PN_TENANCIES_ALL ten, (select bld.location_id, bld.location_type_lookup_code , bld.location_id building_id, prop.property_id FROM
219: pn_properties_all prop,
220: pn_locations_all bld
221: WHERE
222: bld.location_type_lookup_code IN ('
223: || ''''
224: || 'BUILDING'

Line 235: pn_locations_all bld,

231: bld.property_id = prop.property_id (+)
232: UNION
233: select flr.location_id, flr.location_type_lookup_code ,bld.location_id building_id, prop.property_id FROM
234: pn_properties_all prop,
235: pn_locations_all bld,
236: pn_locations_all flr
237: WHERE flr.location_type_lookup_code IN ('
238: || ''''
239: || 'FLOOR'

Line 236: pn_locations_all flr

232: UNION
233: select flr.location_id, flr.location_type_lookup_code ,bld.location_id building_id, prop.property_id FROM
234: pn_properties_all prop,
235: pn_locations_all bld,
236: pn_locations_all flr
237: WHERE flr.location_type_lookup_code IN ('
238: || ''''
239: || 'FLOOR'
240: || ''''

Line 254: pn_locations_all bld,

250: bld.active_end_date))
251: UNION
252: select off.location_id, off.location_type_lookup_code ,bld.location_id building_id, prop.property_id FROM
253: pn_properties_all prop,
254: pn_locations_all bld,
255: pn_locations_all flr,
256: pn_locations_all off
257: WHERE off.location_type_lookup_code IN ('
258: || ''''

Line 255: pn_locations_all flr,

251: UNION
252: select off.location_id, off.location_type_lookup_code ,bld.location_id building_id, prop.property_id FROM
253: pn_properties_all prop,
254: pn_locations_all bld,
255: pn_locations_all flr,
256: pn_locations_all off
257: WHERE off.location_type_lookup_code IN ('
258: || ''''
259: || 'OFFICE'

Line 256: pn_locations_all off

252: select off.location_id, off.location_type_lookup_code ,bld.location_id building_id, prop.property_id FROM
253: pn_properties_all prop,
254: pn_locations_all bld,
255: pn_locations_all flr,
256: pn_locations_all off
257: WHERE off.location_type_lookup_code IN ('
258: || ''''
259: || 'OFFICE'
260: || ''''

Line 286: pn_locations_all bld

282: THEN
283: building_name_from :=
284: ', PN_TENANCIES_ALL ten, (select bld.location_id, bld.location_type_lookup_code, bld.location_id building_id, prop.property_id FROM
285: pn_properties_all prop,
286: pn_locations_all bld
287: WHERE
288: bld.location_type_lookup_code IN ('
289: || ''''
290: || 'BUILDING'

Line 301: pn_locations_all bld,

297: bld.property_id = prop.property_id (+)
298: UNION
299: select flr.location_id, flr.location_type_lookup_code , bld.location_id building_id, prop.property_id FROM
300: pn_properties_all prop,
301: pn_locations_all bld,
302: pn_locations_all flr
303: WHERE flr.location_type_lookup_code IN ('
304: || ''''
305: || 'FLOOR'

Line 302: pn_locations_all flr

298: UNION
299: select flr.location_id, flr.location_type_lookup_code , bld.location_id building_id, prop.property_id FROM
300: pn_properties_all prop,
301: pn_locations_all bld,
302: pn_locations_all flr
303: WHERE flr.location_type_lookup_code IN ('
304: || ''''
305: || 'FLOOR'
306: || ''''

Line 320: pn_locations_all bld,

316: bld.active_end_date))
317: UNION
318: select off.location_id, off.location_type_lookup_code , bld.location_id building_id, prop.property_id FROM
319: pn_properties_all prop,
320: pn_locations_all bld,
321: pn_locations_all flr,
322: pn_locations_all off
323: WHERE off.location_type_lookup_code IN ('
324: || ''''

Line 321: pn_locations_all flr,

317: UNION
318: select off.location_id, off.location_type_lookup_code , bld.location_id building_id, prop.property_id FROM
319: pn_properties_all prop,
320: pn_locations_all bld,
321: pn_locations_all flr,
322: pn_locations_all off
323: WHERE off.location_type_lookup_code IN ('
324: || ''''
325: || 'OFFICE'

Line 322: pn_locations_all off

318: select off.location_id, off.location_type_lookup_code , bld.location_id building_id, prop.property_id FROM
319: pn_properties_all prop,
320: pn_locations_all bld,
321: pn_locations_all flr,
322: pn_locations_all off
323: WHERE off.location_type_lookup_code IN ('
324: || ''''
325: || 'OFFICE'
326: || ''''

Line 355: ', PN_TENANCIES_ALL ten , PN_LOCATIONS_ALL loc';

351: location_code_field :=
352: ',ten.location_id, loc.location_type_lookup_code ';
353: ELSE
354: location_code_from :=
355: ', PN_TENANCIES_ALL ten , PN_LOCATIONS_ALL loc';
356: location_code_where :=
357: ' AND l.lease_id = ten.lease_id
358: AND ten.location_id = loc.location_id
359: AND loc.rowid = (select max(loc1.rowid) from pn_locations_all loc1

Line 359: AND loc.rowid = (select max(loc1.rowid) from pn_locations_all loc1

355: ', PN_TENANCIES_ALL ten , PN_LOCATIONS_ALL loc';
356: location_code_where :=
357: ' AND l.lease_id = ten.lease_id
358: AND ten.location_id = loc.location_id
359: AND loc.rowid = (select max(loc1.rowid) from pn_locations_all loc1
360: where loc.location_id = loc1.location_id) ';
361: location_code_field :=
362: ',ten.location_id, loc.location_type_lookup_code ';
363: END IF;