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

Line 49: , pn_tenancies_all pt

45: , pt.location_id
46: , pld.lease_commencement_date
47: , pld.lease_termination_date
48: FROM pn_leases_all pl
49: , pn_tenancies_all pt
50: , pn_lease_details_all pld
51: , fnd_user fnr
52: , fnd_lookups lse_lkp
53: , fnd_lookups flg_lkp

Line 80: , pn_tenancies_all pt

76: , pt.location_id
77: , pld.lease_commencement_date
78: , pld.lease_termination_date
79: FROM pn_leases_all pl
80: , pn_tenancies_all pt
81: , pn_lease_details_all pld
82: , fnd_user fnr
83: , fnd_lookups lse_lkp
84: , fnd_lookups flg_lkp

Line 111: , pn_tenancies_all pt

107: , pt.location_id
108: , pld.lease_commencement_date
109: , pld.lease_termination_date
110: FROM pn_leases_all pl
111: , pn_tenancies_all pt
112: , pn_lease_details_all pld
113: , fnd_user fnr
114: , fnd_lookups lse_lkp
115: , fnd_lookups flg_lkp

Line 333: FROM pn_tenancies_all pt

329: IS
330: CURSOR c_location_id
331: IS
332: SELECT pl.location_id
333: FROM pn_tenancies_all pt
334: , pn_locations_all pl
335: , pn_properties_all prop
336: , fnd_lookups loc_lkp
337: , fnd_lookups flg_lkp

Line 353: FROM pn_tenancies_all pt

349:
350: CURSOR c_location_code
351: IS
352: SELECT pl.location_id
353: FROM pn_tenancies_all pt
354: , pn_locations_all pl
355: , pn_properties_all prop
356: , fnd_lookups loc_lkp
357: , fnd_lookups flg_lkp