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.

[Home] [Help]

APPS.PN_CREATE_ACC dependencies on PN_PAYMENT_ITEMS_ALL

Line 25: PN_PAYMENT_ITEMS_ALL pi,

21: ps.payment_schedule_id,
22: pi1.actual_amount
23: FROM PN_PAYMENT_TERMS pt,
24: PN_LEASES_ALL le ,
25: PN_PAYMENT_ITEMS_ALL pi,
26: PN_PAYMENT_ITEMS_ALL pi1,
27: PN_PAYMENT_SCHEDULES_ALL ps
28: WHERE pt.lease_id = le.lease_id
29: AND le.lease_class_code in ('THIRD_PARTY','SUB_LEASE')

Line 26: PN_PAYMENT_ITEMS_ALL pi1,

22: pi1.actual_amount
23: FROM PN_PAYMENT_TERMS pt,
24: PN_LEASES_ALL le ,
25: PN_PAYMENT_ITEMS_ALL pi,
26: PN_PAYMENT_ITEMS_ALL pi1,
27: PN_PAYMENT_SCHEDULES_ALL ps
28: WHERE pt.lease_id = le.lease_id
29: AND le.lease_class_code in ('THIRD_PARTY','SUB_LEASE')
30: AND LE.LEASE_ID BETWEEN P_LOW_LEASE_ID AND P_HIGH_LEASE_ID

Line 64: PN_PAYMENT_ITEMS_ALL pi,

60: pt.customer_id customer_id,
61: pt.cust_trx_type_id cust_trx_type_id
62: FROM PN_PAYMENT_TERMS pt,
63: PN_LEASES_ALL le ,
64: PN_PAYMENT_ITEMS_ALL pi,
65: PN_PAYMENT_ITEMS_ALL pi1,
66: PN_PAYMENT_SCHEDULES_ALL ps
67: WHERE pt.lease_id = le.lease_id
68: AND le.lease_class_code in ('THIRD_PARTY','SUB_LEASE')

Line 65: PN_PAYMENT_ITEMS_ALL pi1,

61: pt.cust_trx_type_id cust_trx_type_id
62: FROM PN_PAYMENT_TERMS pt,
63: PN_LEASES_ALL le ,
64: PN_PAYMENT_ITEMS_ALL pi,
65: PN_PAYMENT_ITEMS_ALL pi1,
66: PN_PAYMENT_SCHEDULES_ALL ps
67: WHERE pt.lease_id = le.lease_id
68: AND le.lease_class_code in ('THIRD_PARTY','SUB_LEASE')
69: AND LE.LEASE_ID BETWEEN P_LOW_LEASE_ID AND P_HIGH_LEASE_ID

Line 109: pn_payment_items_all pi,

105: ps.payment_schedule_id,
106: pi1.actual_amount
107: FROM pn_payment_terms pt,
108: pn_leases_all le ,
109: pn_payment_items_all pi,
110: pn_payment_items_all pi1,
111: pn_payment_schedules_all ps
112: WHERE pt.lease_id = le.lease_id
113: AND le.lease_class_code = 'DIRECT'

Line 110: pn_payment_items_all pi1,

106: pi1.actual_amount
107: FROM pn_payment_terms pt,
108: pn_leases_all le ,
109: pn_payment_items_all pi,
110: pn_payment_items_all pi1,
111: pn_payment_schedules_all ps
112: WHERE pt.lease_id = le.lease_id
113: AND le.lease_class_code = 'DIRECT'
114: and LE.LEASE_ID BETWEEN P_LOW_LEASE_ID AND P_HIGH_LEASE_ID

Line 149: pn_payment_items_all pi,

145: pt.vendor_id vendor_id,
146: pt.vendor_site_id vendor_site_id
147: FROM pn_payment_terms pt,
148: pn_leases_all le ,
149: pn_payment_items_all pi,
150: pn_payment_items_all pi1,
151: pn_payment_schedules_all ps
152: WHERE pt.lease_id = le.lease_id
153: AND le.lease_class_code = 'DIRECT'

Line 150: pn_payment_items_all pi1,

146: pt.vendor_site_id vendor_site_id
147: FROM pn_payment_terms pt,
148: pn_leases_all le ,
149: pn_payment_items_all pi,
150: pn_payment_items_all pi1,
151: pn_payment_schedules_all ps
152: WHERE pt.lease_id = le.lease_id
153: AND le.lease_class_code = 'DIRECT'
154: AND LE.LEASE_ID BETWEEN P_LOW_LEASE_ID AND P_HIGH_LEASE_ID

Line 217: TYPE item_id_tbl_typ IS TABLE OF pn_payment_items_all.payment_item_id%TYPE INDEX BY BINARY_INTEGER;

213: l_last_update_date DATE;
214: l_creation_date DATE;
215:
216: TYPE NUMBER_tbl_typ IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
217: TYPE item_id_tbl_typ IS TABLE OF pn_payment_items_all.payment_item_id%TYPE INDEX BY BINARY_INTEGER;
218: TYPE schedule_id_tbl_typ IS TABLE OF pn_payment_schedules_all.payment_schedule_id%TYPE INDEX BY BINARY_INTEGER;
219: TYPE event_id_tbl_typ IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
220:
221: term_ID_tbl NUMBER_tbl_typ;

Line 356: UPDATE pn_payment_items_all

352:
353: pnp_debug_pkg.log('Updating payment items');
354:
355: FORALL i IN item_id_tbl.FIRST..item_id_tbl.LAST
356: UPDATE pn_payment_items_all
357: SET transferred_to_ap_flag = 'Y',
358: xla_event_id = event_id_tbl(i),
359: last_updated_by = l_last_updated_by,
360: last_update_login = l_last_update_login,

Line 410: UPDATE pn_payment_items_all

406:
407: IF item_id_tbl.COUNT > 0 THEN
408:
409: FORALL i IN item_id_tbl.FIRST..item_id_tbl.LAST
410: UPDATE pn_payment_items_all
411: SET transferred_to_ap_flag = 'Y' ,
412: xla_event_id = event_id_tbl(i),
413: last_updated_by = l_last_updated_by,
414: last_update_login = l_last_update_login,

Line 486: TYPE item_id_tbl_typ IS TABLE OF pn_payment_items_all.payment_item_id%TYPE INDEX BY BINARY_INTEGER;

482: l_high_lease_id pn_leases.lease_id%TYPE;
483: l_sch_start_date pn_payment_schedules.schedule_date%TYPE;
484: l_sch_end_date pn_payment_schedules.schedule_date%TYPE;
485:
486: TYPE item_id_tbl_typ IS TABLE OF pn_payment_items_all.payment_item_id%TYPE INDEX BY BINARY_INTEGER;
487: TYPE schedule_id_tbl_typ IS TABLE OF pn_payment_schedules_all.payment_schedule_id%TYPE INDEX BY BINARY_INTEGER;
488: TYPE NUMBER_tbl_typ IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
489: TYPE event_id_tbl_typ IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
490:

Line 625: UPDATE pn_payment_items_all

621:
622: pnp_debug_pkg.log('Updating payment items');
623:
624: FORALL i IN item_id_tbl.FIRST..item_id_tbl.LAST
625: UPDATE pn_payment_items_all
626: SET transferred_to_ar_flag = 'Y' ,
627: xla_event_id = event_id_tbl(i),
628: last_updated_by = l_last_updated_by,
629: last_update_login = l_last_update_login,

Line 680: UPDATE pn_payment_items_all

676:
677: IF item_id_tbl.COUNT > 0 THEN
678:
679: FORALL i IN item_id_tbl.FIRST..item_id_tbl.LAST
680: UPDATE pn_payment_items_all
681: SET transferred_to_ar_flag = 'Y' ,
682: xla_event_id = event_id_tbl(i),
683: last_updated_by = l_last_updated_by,
684: last_update_login = l_last_update_login,

Line 1168: PN_PAYMENT_ITEMS_ALL pi,

1164: pi1.actual_amount,
1165: ps.schedule_date
1166: FROM PN_PAYMENT_TERMS pt,
1167: PN_LEASES_ALL le ,
1168: PN_PAYMENT_ITEMS_ALL pi,
1169: PN_PAYMENT_ITEMS_ALL pi1,
1170: PN_PAYMENT_SCHEDULES_ALL ps
1171: WHERE pt.lease_id = le.lease_id
1172: AND le.lease_class_code in ('THIRD_PARTY','SUB_LEASE')

Line 1169: PN_PAYMENT_ITEMS_ALL pi1,

1165: ps.schedule_date
1166: FROM PN_PAYMENT_TERMS pt,
1167: PN_LEASES_ALL le ,
1168: PN_PAYMENT_ITEMS_ALL pi,
1169: PN_PAYMENT_ITEMS_ALL pi1,
1170: PN_PAYMENT_SCHEDULES_ALL ps
1171: WHERE pt.lease_id = le.lease_id
1172: AND le.lease_class_code in ('THIRD_PARTY','SUB_LEASE')
1173: AND LE.LEASE_ID BETWEEN L_LOW_LEASE_ID AND L_HIGH_LEASE_ID

Line 1731: UPDATE pn_payment_items_all

1727: l_context := 'Updating Payment Items';
1728: pnp_debug_pkg.log('Updating payment items for payment item id : ' ||
1729: to_char(v_pn_payment_item_id) );
1730:
1731: UPDATE pn_payment_items_all
1732: SET transferred_to_ar_flag = 'Y' ,
1733: ar_ref_code = v_pn_payment_item_id,
1734: last_updated_by = l_last_updated_by,
1735: last_update_login = l_last_update_login,

Line 1921: pn_payment_items_all pi,

1917: pi1.actual_amount,
1918: ps.schedule_date
1919: FROM pn_payment_terms pt,
1920: pn_leases_all le ,
1921: pn_payment_items_all pi,
1922: pn_payment_items_all pi1,
1923: pn_payment_schedules_all ps
1924: WHERE pt.lease_id = le.lease_id
1925: AND le.lease_class_code = 'DIRECT'

Line 1922: pn_payment_items_all pi1,

1918: ps.schedule_date
1919: FROM pn_payment_terms pt,
1920: pn_leases_all le ,
1921: pn_payment_items_all pi,
1922: pn_payment_items_all pi1,
1923: pn_payment_schedules_all ps
1924: WHERE pt.lease_id = le.lease_id
1925: AND le.lease_class_code = 'DIRECT'
1926: and LE.LEASE_ID BETWEEN L_LOW_LEASE_ID AND L_HIGH_LEASE_ID

Line 2493: UPDATE pn_payment_items_all

2489: l_context := 'Updating Payment Items';
2490: pnp_debug_pkg.log('Updating payment items for payment item id : ' ||
2491: to_char(v_pn_payment_item_id) );
2492:
2493: UPDATE pn_payment_items_all
2494: SET transferred_to_ap_flag = 'Y' ,
2495: last_updated_by = l_last_updated_by,
2496: last_update_login = l_last_update_login,
2497: last_update_date = l_last_update_date