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_INDEX_RENT_UTILS dependencies on PN_LEASE_DETAILS_ALL

Line 245: ,pn_lease_details_all PLD

241: ,PLD.lease_termination_date termination_date
242: ,PLD.lease_execution_date lease_execution_date
243: ,PLD.lease_extension_end_date
244: FROM pn_leases_all PL
245: ,pn_lease_details_all PLD
246: WHERE PLD.lease_id = PL.lease_id
247: AND PL.lease_id = x_lease_id
248: AND PLD.org_id = PL.org_id
249: AND PL.org_id = p_org_id;

Line 260: ,pn_lease_details_all PLD

256: ,PLD.lease_termination_date termination_date
257: ,PLD.lease_execution_date lease_execution_date
258: ,PLD.lease_extension_end_date
259: FROM pn_leases_all PL
260: ,pn_lease_details_all PLD
261: WHERE PL.lease_num = p_lease_number
262: AND PLD.lease_id = PL.lease_id
263: -- AND PL.lease_id = x_lease_id
264: AND PLD.org_id = PL.org_id

Line 277: ,pn_lease_details_all PLD

273: ,PLD.lease_termination_date termination_date
274: ,PLD.lease_execution_date lease_execution_date
275: ,PLD.lease_extension_end_date
276: FROM pn_leases_all PL
277: ,pn_lease_details_all PLD
278: WHERE PL.name = p_lease_name
279: AND PLD.lease_id = PL.lease_id
280: --AND PL.lease_id = x_lease_id
281: AND PLD.org_id = PL.org_id