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_VAR_RENT_PKG dependencies on PN_TENANCIES_ALL

Line 10318: FROM pn_tenancies_all

10314: SELECT DISTINCT var.var_rent_id
10315: from pn_var_rents_all var
10316: where var.lease_id IN( SELECT distinct lease_id
10317: FROM ( SELECT lease_id
10318: FROM pn_tenancies_all
10319: WHERE location_id in (SELECT location_id
10320: FROM pn_locations_all
10321: WHERE property_id = p_prop_id)
10322: UNION

Line 10337: FROM pn_tenancies_all

10333: SELECT DISTINCT var.var_rent_id
10334: FROM pn_var_rents_all var
10335: WHERE var.lease_id IN (SELECT lease_id
10336: FROM (SELECT lease_id
10337: FROM pn_tenancies_all
10338: WHERE location_id = p_loc_id
10339: UNION
10340: SELECT lease_id
10341: FROM pn_leases_all