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_CREATE_ACC dependencies on PN_LEASES_ALL

Line 28: PN_LEASES_ALL le ,

24: pi.export_currency_amount,
25: pi.export_currency_code,
26: pi.accounted_amount
27: FROM PN_PAYMENT_TERMS pt,
28: PN_LEASES_ALL le ,
29: PN_PAYMENT_ITEMS_ALL pi,
30: PN_PAYMENT_ITEMS_ALL pi1,
31: PN_PAYMENT_SCHEDULES_ALL ps
32: WHERE pt.lease_id = le.lease_id

Line 67: PN_LEASES_ALL le ,

63: pt.org_id org_id,
64: pt.customer_id customer_id,
65: pt.cust_trx_type_id cust_trx_type_id
66: FROM PN_PAYMENT_TERMS pt,
67: PN_LEASES_ALL le ,
68: PN_PAYMENT_ITEMS_ALL pi,
69: PN_PAYMENT_ITEMS_ALL pi1,
70: PN_PAYMENT_SCHEDULES_ALL ps
71: WHERE pt.lease_id = le.lease_id

Line 115: pn_leases_all le ,

111: pi.export_currency_amount,
112: pi.export_currency_code,
113: pi.accounted_amount
114: FROM pn_payment_terms pt,
115: pn_leases_all le ,
116: pn_payment_items_all pi,
117: pn_payment_items_all pi1,
118: pn_payment_schedules_all ps
119: WHERE pt.lease_id = le.lease_id

Line 155: pn_leases_all le ,

151: pt.org_id org_id,
152: pt.vendor_id vendor_id,
153: pt.vendor_site_id vendor_site_id
154: FROM pn_payment_terms pt,
155: pn_leases_all le ,
156: pn_payment_items_all pi,
157: pn_payment_items_all pi1,
158: pn_payment_schedules_all ps
159: WHERE pt.lease_id = le.lease_id

Line 185: FROM pn_leases_all

181:
182: CURSOR c_lease_num(p_lease_id pn_leases.lease_id%TYPE)
183: IS
184: SELECT lease_num
185: FROM pn_leases_all
186: WHERE lease_id = p_lease_id;
187:
188:
189:

Line 1635: PN_LEASES_ALL le ,

1631: pi.accounted_amount,
1632: pi1.actual_amount,
1633: ps.schedule_date
1634: FROM PN_PAYMENT_TERMS pt,
1635: PN_LEASES_ALL le ,
1636: PN_PAYMENT_ITEMS_ALL pi,
1637: PN_PAYMENT_ITEMS_ALL pi1,
1638: PN_PAYMENT_SCHEDULES_ALL ps
1639: WHERE pt.lease_id = le.lease_id

Line 2388: pn_leases_all le ,

2384: pi.accounted_amount,
2385: pi1.actual_amount,
2386: ps.schedule_date
2387: FROM pn_payment_terms pt,
2388: pn_leases_all le ,
2389: pn_payment_items_all pi,
2390: pn_payment_items_all pi1,
2391: pn_payment_schedules_all ps
2392: WHERE pt.lease_id = le.lease_id