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_LEASE_UTILS dependencies on PN_LOCATIONS_ALL

Line 345: FROM pn_locations_all loc

341: ) location_name
342: , lkp.meaning
343: , loc.location_type_lookup_code
344: , loc.location_id
345: FROM pn_locations_all loc
346: , fnd_lookups lkp
347: WHERE loc.status = 'A'
348: --AND loc.org_id = g_org_id
349: AND loc.org_id = fnd_global.org_id

Line 364: FROM pn_locations_all loc2

360: AND ( (p_lease_class_code IN ('THIRD_PARTY', 'DIRECT'))
361: OR ( p_lease_class_code = 'SUB_LEASE'
362: AND loc.location_id IN (
363: SELECT loc2.location_id
364: FROM pn_locations_all loc2
365: START WITH loc2.location_id IN (
366: SELECT location_id
367: FROM pn_tenancies_all
368: WHERE lease_id =

Line 402: FROM pn_locations_all loc

398: ) location_name
399: , lkp.meaning
400: , loc.location_type_lookup_code
401: , loc.location_id
402: FROM pn_locations_all loc
403: , fnd_lookups lkp
404: WHERE loc.status = 'A'
405: AND loc.org_id = p_org_id
406: AND loc.location_type_lookup_code = lkp.lookup_code

Line 420: FROM pn_locations_all loc2

416: AND ( (p_lease_class_code IN ('THIRD_PARTY', 'DIRECT'))
417: OR ( p_lease_class_code = 'SUB_LEASE'
418: AND loc.location_id IN (
419: SELECT loc2.location_id
420: FROM pn_locations_all loc2
421: START WITH loc2.location_id IN (
422: SELECT location_id
423: FROM pn_tenancies_all
424: WHERE lease_id =