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 29: PN_PAYMENT_ITEMS_ALL pi,

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
33: AND le.lease_class_code in ('THIRD_PARTY','SUB_LEASE')

Line 30: PN_PAYMENT_ITEMS_ALL pi1,

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
33: AND le.lease_class_code in ('THIRD_PARTY','SUB_LEASE')
34: AND LE.LEASE_ID BETWEEN P_LOW_LEASE_ID AND P_HIGH_LEASE_ID

Line 68: PN_PAYMENT_ITEMS_ALL pi,

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
72: AND le.lease_class_code in ('THIRD_PARTY','SUB_LEASE')

Line 69: PN_PAYMENT_ITEMS_ALL pi1,

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
72: AND le.lease_class_code in ('THIRD_PARTY','SUB_LEASE')
73: AND LE.LEASE_ID BETWEEN P_LOW_LEASE_ID AND P_HIGH_LEASE_ID

Line 116: pn_payment_items_all pi,

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
120: AND le.lease_class_code = 'DIRECT'

Line 117: pn_payment_items_all pi1,

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
120: AND le.lease_class_code = 'DIRECT'
121: and LE.LEASE_ID BETWEEN P_LOW_LEASE_ID AND P_HIGH_LEASE_ID

Line 156: pn_payment_items_all pi,

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
160: AND le.lease_class_code = 'DIRECT'

Line 157: pn_payment_items_all pi1,

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
160: AND le.lease_class_code = 'DIRECT'
161: AND LE.LEASE_ID BETWEEN P_LOW_LEASE_ID AND P_HIGH_LEASE_ID

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

637: l_creation_date DATE;
638: l_due_date DATE;
639:
640: TYPE NUMBER_tbl_typ IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
641: TYPE item_id_tbl_typ IS TABLE OF pn_payment_items_all.payment_item_id%TYPE INDEX BY BINARY_INTEGER;
642: TYPE schedule_id_tbl_typ IS TABLE OF pn_payment_schedules_all.payment_schedule_id%TYPE INDEX BY BINARY_INTEGER;
643: TYPE event_id_tbl_typ IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
644:
645: term_ID_tbl NUMBER_tbl_typ;

Line 801: UPDATE pn_payment_items_all

797:
798: pnp_debug_pkg.log('Updating payment items');
799:
800: FORALL i IN item_id_tbl.FIRST..item_id_tbl.LAST
801: UPDATE pn_payment_items_all
802: SET transferred_to_ap_flag = 'Y',
803: xla_event_id = event_id_tbl(i),
804: last_updated_by = l_last_updated_by,
805: last_update_login = l_last_update_login,

Line 856: UPDATE pn_payment_items_all

852:
853: IF item_id_tbl.COUNT > 0 THEN
854:
855: FORALL i IN item_id_tbl.FIRST..item_id_tbl.LAST
856: UPDATE pn_payment_items_all
857: SET transferred_to_ap_flag = 'Y' ,
858: xla_event_id = event_id_tbl(i),
859: last_updated_by = l_last_updated_by,
860: last_update_login = l_last_update_login,

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

928: l_high_lease_id pn_leases.lease_id%TYPE;
929: l_sch_start_date pn_payment_schedules.schedule_date%TYPE;
930: l_sch_end_date pn_payment_schedules.schedule_date%TYPE;
931:
932: TYPE item_id_tbl_typ IS TABLE OF pn_payment_items_all.payment_item_id%TYPE INDEX BY BINARY_INTEGER;
933: TYPE schedule_id_tbl_typ IS TABLE OF pn_payment_schedules_all.payment_schedule_id%TYPE INDEX BY BINARY_INTEGER;
934: TYPE NUMBER_tbl_typ IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
935: TYPE event_id_tbl_typ IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
936:

Line 1093: UPDATE pn_payment_items_all

1089:
1090: pnp_debug_pkg.log('Updating payment items');
1091:
1092: FORALL i IN item_id_tbl.FIRST..item_id_tbl.LAST
1093: UPDATE pn_payment_items_all
1094: SET transferred_to_ar_flag = 'Y' ,
1095: xla_event_id = event_id_tbl(i),
1096: last_updated_by = l_last_updated_by,
1097: last_update_login = l_last_update_login,

Line 1148: UPDATE pn_payment_items_all

1144:
1145: IF item_id_tbl.COUNT > 0 THEN
1146:
1147: FORALL i IN item_id_tbl.FIRST..item_id_tbl.LAST
1148: UPDATE pn_payment_items_all
1149: SET transferred_to_ar_flag = 'Y' ,
1150: xla_event_id = event_id_tbl(i),
1151: last_updated_by = l_last_updated_by,
1152: last_update_login = l_last_update_login,

Line 1636: PN_PAYMENT_ITEMS_ALL pi,

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
1640: AND le.lease_class_code in ('THIRD_PARTY','SUB_LEASE')

Line 1637: PN_PAYMENT_ITEMS_ALL pi1,

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
1640: AND le.lease_class_code in ('THIRD_PARTY','SUB_LEASE')
1641: AND LE.LEASE_ID BETWEEN L_LOW_LEASE_ID AND L_HIGH_LEASE_ID

Line 2199: UPDATE pn_payment_items_all

2195: l_context := 'Updating Payment Items';
2196: pnp_debug_pkg.log('Updating payment items for payment item id : ' ||
2197: to_char(v_pn_payment_item_id) );
2198:
2199: UPDATE pn_payment_items_all
2200: SET transferred_to_ar_flag = 'Y' ,
2201: ar_ref_code = v_pn_payment_item_id,
2202: last_updated_by = l_last_updated_by,
2203: last_update_login = l_last_update_login,

Line 2389: pn_payment_items_all pi,

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
2393: AND le.lease_class_code = 'DIRECT'

Line 2390: pn_payment_items_all pi1,

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
2393: AND le.lease_class_code = 'DIRECT'
2394: and LE.LEASE_ID BETWEEN L_LOW_LEASE_ID AND L_HIGH_LEASE_ID

Line 2961: UPDATE pn_payment_items_all

2957: l_context := 'Updating Payment Items';
2958: pnp_debug_pkg.log('Updating payment items for payment item id : ' ||
2959: to_char(v_pn_payment_item_id) );
2960:
2961: UPDATE pn_payment_items_all
2962: SET transferred_to_ap_flag = 'Y' ,
2963: last_updated_by = l_last_updated_by,
2964: last_update_login = l_last_update_login,
2965: last_update_date = l_last_update_date