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_PROPERTIES_ALL

Line 55: , pn_properties_all prop

51: , fnd_user fnr
52: , fnd_lookups lse_lkp
53: , fnd_lookups flg_lkp
54: , pn_locations_all ploc
55: , pn_properties_all prop
56: WHERE pt.lease_id(+) = pl.lease_id
57: AND ploc.location_id(+) = pt.location_id
58: AND prop.property_id(+) = ploc.property_id
59: AND NVL (pt.occupancy_date

Line 86: , pn_properties_all prop

82: , fnd_user fnr
83: , fnd_lookups lse_lkp
84: , fnd_lookups flg_lkp
85: , pn_locations_all ploc
86: , pn_properties_all prop
87: WHERE pt.lease_id(+) = pl.lease_id
88: AND ploc.location_id(+) = pt.location_id
89: AND prop.property_id(+) = ploc.property_id
90: AND NVL (pt.occupancy_date

Line 117: , pn_properties_all prop

113: , fnd_user fnr
114: , fnd_lookups lse_lkp
115: , fnd_lookups flg_lkp
116: , pn_locations_all ploc
117: , pn_properties_all prop
118: WHERE pt.lease_id(+) = pl.lease_id
119: AND ploc.location_id(+) = pt.location_id
120: AND prop.property_id(+) = ploc.property_id
121: AND NVL (pt.occupancy_date

Line 335: , pn_properties_all prop

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
338: WHERE pt.location_id = pl.location_id
339: AND prop.property_id(+) = pl.property_id

Line 355: , pn_properties_all prop

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
358: WHERE pt.location_id = pl.location_id
359: AND prop.property_id(+) = pl.property_id