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_LEASE_DETAILS_ALL

Line 50: , pn_lease_details_all pld

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
54: , pn_locations_all ploc

Line 81: , pn_lease_details_all pld

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
85: , pn_locations_all ploc

Line 112: , pn_lease_details_all pld

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
116: , pn_locations_all ploc

Line 1695: ,pn_lease_details_all PLD

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
1699: AND PLA.lease_id=p_lease_id;