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_LEASES_ALL

Line 48: FROM pn_leases_all pl

44: , pl.payment_term_proration_rule
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

Line 79: FROM pn_leases_all pl

75: , pl.payment_term_proration_rule
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

Line 110: FROM pn_leases_all pl

106: , pl.payment_term_proration_rule
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

Line 1694: FROM pn_leases_all PLA

1690: IS
1691: SELECT PLA.lease_id lease_id
1692: ,PLD.lease_commencement_date lease_commencement_date
1693: ,PLD.lease_termination_date lease_termination_date
1694: FROM pn_leases_all PLA
1695: ,pn_lease_details_all PLD
1696: WHERE PLD.org_id=PLA.org_id
1697: AND PLA.org_id=FND_PROFILE.VALUE('ORG_ID')
1698: AND PLD.lease_id=PLA.lease_id