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 10301: FROM pn_tenancies_all

10297: SELECT DISTINCT var.var_rent_id
10298: from pn_var_rents_all var
10299: where var.lease_id IN( SELECT distinct lease_id
10300: FROM ( SELECT lease_id
10301: FROM pn_tenancies_all
10302: WHERE location_id in (SELECT location_id
10303: FROM pn_locations_all
10304: WHERE property_id = p_prop_id)
10305: UNION

Line 10320: FROM pn_tenancies_all

10316: SELECT DISTINCT var.var_rent_id
10317: FROM pn_var_rents_all var
10318: WHERE var.lease_id IN (SELECT lease_id
10319: FROM (SELECT lease_id
10320: FROM pn_tenancies_all
10321: WHERE location_id = p_loc_id
10322: UNION
10323: SELECT lease_id
10324: FROM pn_leases_all