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.IEX_COLL_IND dependencies on AR_PAYMENT_SCHEDULES

Line 41: FROM ar_payment_schedules ps, hz_cust_accounts ca

37: IF p_party_id IS NOT NULL THEN
38: SELECT sum(TRUNC(sysdate) - ps.due_date)
39: / COUNT(1)
40: INTO l_avg_days_late
41: FROM ar_payment_schedules ps, hz_cust_accounts ca
42: WHERE ps.gl_date between TRUNC(add_months(sysdate, -12)) and TRUNC(sysdate)
43: AND ps.class in ('INV','DEP','DM','CB')
44: AND ps.gl_date_closed > TRUNC(sysdate)
45: -- Begin fix bug #4949609-JYPARK-2/15/2006-add condition for performance

Line 56: FROM ar_payment_schedules ps

52: ELSIF p_cust_account_id IS NOT NULL THEN
53: SELECT sum(TRUNC(sysdate) - ps.due_date)
54: / COUNT(1)
55: INTO l_avg_days_late
56: FROM ar_payment_schedules ps
57: WHERE ps.gl_date between TRUNC(add_months(sysdate, -12)) and TRUNC(sysdate)
58: AND ps.class in ('INV','DEP','DM','CB')
59: AND ps.gl_date_closed > TRUNC(sysdate)
60: -- Begin fix bug #4949609-JYPARK-2/15/2006-add condition for performance

Line 70: FROM ar_payment_schedules ps

66: ELSIF p_customer_site_use_id IS NOT NULL THEN
67: SELECT sum(TRUNC(sysdate) - ps.due_date)
68: / COUNT(1)
69: INTO l_avg_days_late
70: FROM ar_payment_schedules ps
71: WHERE ps.gl_date between TRUNC(add_months(sysdate, -12)) and TRUNC(sysdate)
72: AND ps.class in ('INV','DEP','DM','CB')
73: AND ps.gl_date_closed > TRUNC(sysdate)
74: -- Begin fix bug #4949609-JYPARK-2/15/2006-add condition for performance

Line 149: FROM ar_payment_schedules ps, hz_cust_accounts ca

145: GET_ADJ_TOTAL(ps.payment_schedule_id, TRUNC(sysdate)) +
146: nvl(ps.acctd_amount_due_remaining, 0)
147: )
148: INTO l_wtd_days_late
149: FROM ar_payment_schedules ps, hz_cust_accounts ca
150: WHERE ps.gl_date between TRUNC(add_months(sysdate, -12)) and TRUNC(sysdate)
151: AND ps.class in ('INV','DEP','DM','CB')
152: -- Begin fix bug #4917851-jypark-11/47/2005-remove invalid condition
153: --AND ps.gl_date_closed > TRUNC(sysdate)

Line 178: FROM ar_payment_schedules ps

174: GET_ADJ_TOTAL(ps.payment_schedule_id, TRUNC(sysdate)) +
175: nvl(ps.acctd_amount_due_remaining, 0)
176: )
177: INTO l_wtd_days_late
178: FROM ar_payment_schedules ps
179: WHERE ps.gl_date between TRUNC(add_months(sysdate, -12)) and TRUNC(sysdate)
180: AND ps.class in ('INV','DEP','DM','CB')
181: -- Begin fix bug #4917851-jypark-11/47/2005-remove invalid condition
182: -- AND ps.gl_date_closed > TRUNC(sysdate)

Line 206: FROM ar_payment_schedules ps

202: GET_ADJ_TOTAL(ps.payment_schedule_id, TRUNC(sysdate)) +
203: nvl(ps.acctd_amount_due_remaining, 0)
204: )
205: INTO l_wtd_days_late
206: FROM ar_payment_schedules ps
207: WHERE ps.gl_date between TRUNC(add_months(sysdate, -12)) and TRUNC(sysdate)
208: AND ps.class in ('INV','DEP','DM','CB')
209: -- Begin fix bug #4917851-jypark-11/47/2005-remove invalid condition
210: -- AND ps.gl_date_closed > TRUNC(sysdate)

Line 272: ar_payment_schedules ps,

268: / SUM(ra.amount_applied)
269: , 0) WEIGHTED_AVG_DAYS_PAID
270: INTO l_wtd_days_paid
271: FROM ar_receivable_applications ra,
272: ar_payment_schedules ps,
273: hz_cust_accounts ca
274: WHERE ps.customer_id = ca.cust_account_id
275: AND ca.party_id = p_party_id
276: AND ra.status = 'APP'

Line 294: ar_payment_schedules ps

290: / SUM(ra.amount_applied)
291: , 0) WEIGHTED_AVG_DAYS_PAID
292: INTO l_wtd_days_paid
293: FROM ar_receivable_applications ra,
294: ar_payment_schedules ps
295: WHERE ps.customer_id = p_cust_account_id
296: AND ra.status = 'APP'
297: AND ps.payment_schedule_id = ra.applied_payment_schedule_id
298: AND ps.gl_date between TRUNC(add_months(sysdate, -12)) and TRUNC(sysdate)

Line 314: ar_payment_schedules ps

310: / SUM(ra.amount_applied)
311: , 0) WEIGHTED_AVG_DAYS_PAID
312: INTO l_wtd_days_paid
313: FROM ar_receivable_applications ra,
314: ar_payment_schedules ps
315: WHERE ps.customer_site_use_id = p_customer_site_use_id
316: AND ra.status = 'APP'
317: AND ps.payment_schedule_id = ra.applied_payment_schedule_id
318: AND ps.gl_date between TRUNC(add_months(sysdate, -12)) and TRUNC(sysdate)

Line 393: FROM ar_payment_schedules ps, hz_cust_accounts ca

389: GET_ADJ_TOTAL(ps.payment_schedule_id, TRUNC(sysdate)) +
390: nvl(ps.acctd_amount_due_remaining, 0)
391: )
392: INTO l_wtd_days_terms
393: FROM ar_payment_schedules ps, hz_cust_accounts ca
394: WHERE ps.gl_date between TRUNC(add_months(sysdate, -12)) and TRUNC(sysdate)
395: AND ps.class in ('INV','DEP','DM','CB')
396: -- Begin fix bug #4917851-jypark-11/47/2005-remove invalid condition
397: -- AND ps.gl_date_closed > TRUNC(sysdate)

Line 419: FROM ar_payment_schedules ps

415: GET_ADJ_TOTAL(ps.payment_schedule_id, TRUNC(sysdate)) +
416: nvl(ps.acctd_amount_due_remaining, 0)
417: )
418: INTO l_wtd_days_terms
419: FROM ar_payment_schedules ps
420: WHERE ps.gl_date between TRUNC(add_months(sysdate, -12)) and TRUNC(sysdate)
421: AND ps.class in ('INV','DEP','DM','CB')
422: -- Begin fix bug #4917851-jypark-11/47/2005-remove invalid condition
423: -- AND ps.gl_date_closed > TRUNC(sysdate)

Line 444: FROM ar_payment_schedules ps

440: GET_ADJ_TOTAL(ps.payment_schedule_id, TRUNC(sysdate)) +
441: nvl(ps.acctd_amount_due_remaining, 0)
442: )
443: INTO l_wtd_days_terms
444: FROM ar_payment_schedules ps
445: WHERE ps.gl_date between TRUNC(add_months(sysdate, -12)) and TRUNC(sysdate)
446: AND ps.class in ('INV','DEP','DM','CB')
447: -- Begin fix bug #4917851-jypark-11/47/2005-remove invalid condition
448: -- AND ps.gl_date_closed > TRUNC(sysdate)

Line 604: ar_payment_schedules ps

600: ), 0) /* DSO */
601: INTO l_conv_dso
602: FROM ar_system_parameters sp,
603: hz_cust_accounts cust_acct,
604: ar_payment_schedules ps
605: WHERE ps.customer_id = cust_acct.cust_account_id
606: AND cust_acct.party_id = p_party_id
607: -- Begin fix bug #5261855-jypark-06/16/2006-add addtional condition for performance
608: AND ps.status = 'OP'

Line 646: ar_payment_schedules ps

642: )
643: ), 0) /* DSO */
644: INTO l_conv_dso
645: FROM ar_system_parameters sp,
646: ar_payment_schedules ps
647: WHERE ps.customer_id = p_cust_account_id
648: -- Begin fix bug #5261855-jypark-06/16/2006-add addtional condition for performance
649: AND ps.status = 'OP'
650: -- End fix bug #5261855-jypark-06/16/2006-add addtional condition for performance

Line 688: ar_payment_schedules ps

684: )
685: ), 0) /* DSO */
686: INTO l_conv_dso
687: FROM ar_system_parameters sp,
688: ar_payment_schedules ps
689: WHERE ps.customer_site_use_id = p_customer_site_use_id
690: -- Begin fix bug #5261855-jypark-06/16/2006-add addtional condition for performance
691: AND ps.status = 'OP'
692: -- End fix bug #5261855-jypark-06/16/2006-add addtional condition for performance

Line 901: FROM ar_payment_schedules ps, ar_adjustments adj, hz_cust_accounts ca

897: IF p_party_id IS NOT NULL THEN
898: SELECT
899: sum( nvl(adj.acctd_amount,0))
900: INTO l_adj
901: FROM ar_payment_schedules ps, ar_adjustments adj, hz_cust_accounts ca
902: WHERE ps.class in ('INV', 'DM', 'CB', 'DEP' )
903: AND ps.payment_schedule_id <> -1
904: AND ps.gl_date BETWEEN TRUNC(add_months(sysdate, -12)) AND TRUNC(sysdate)
905: AND ps.customer_id = ca.cust_account_id

Line 914: FROM ar_payment_schedules ps, ar_adjustments adj

910: ELSIF p_cust_account_id IS NOT NULL THEN
911: SELECT
912: sum( nvl(adj.acctd_amount,0))
913: INTO l_adj
914: FROM ar_payment_schedules ps, ar_adjustments adj
915: WHERE ps.class in ('INV', 'DM', 'CB', 'DEP' )
916: AND ps.payment_schedule_id <> -1
917: AND ps.gl_date BETWEEN TRUNC(add_months(sysdate, -12)) AND TRUNC(sysdate)
918: AND ps.customer_id = p_cust_account_id

Line 926: FROM ar_payment_schedules ps, ar_adjustments adj

922: ELSIF p_customer_site_use_id IS NOT NULL THEN
923: SELECT
924: sum( nvl(adj.acctd_amount,0))
925: INTO l_adj
926: FROM ar_payment_schedules ps, ar_adjustments adj
927: WHERE ps.class in ('INV', 'DM', 'CB', 'DEP' )
928: AND ps.payment_schedule_id <> -1
929: AND ps.gl_date BETWEEN TRUNC(add_months(sysdate, -12)) AND TRUNC(sysdate)
930: AND ps.customer_site_use_id = p_customer_site_use_id

Line 1008: FROM ar_payment_schedules ps,

1004: g_curr_rec.base_precision,
1005: g_curr_rec.base_min_acc_unit) +
1006: GET_ADJ_FOR_TOT_REC(ps.payment_schedule_id,p_end_date))
1007: INTO l_tot_rec
1008: FROM ar_payment_schedules ps,
1009: hz_cust_accounts ca
1010: WHERE ps.class in ('INV', 'DM', 'CB', 'DEP' )
1011: AND ps.payment_schedule_id <> -1
1012: AND ps.gl_date BETWEEN l_temp_start AND p_end_date

Line 1024: FROM ar_payment_schedules ps

1020: g_curr_rec.base_precision,
1021: g_curr_rec.base_min_acc_unit) +
1022: GET_ADJ_FOR_TOT_REC(ps.payment_schedule_id,p_end_date))
1023: INTO l_tot_rec
1024: FROM ar_payment_schedules ps
1025: WHERE ps.class in ('INV', 'DM', 'CB', 'DEP' )
1026: AND ps.payment_schedule_id <> -1
1027: AND ps.gl_date BETWEEN l_temp_start AND p_end_date
1028: AND ps.customer_id = p_cust_account_id;

Line 1038: FROM ar_payment_schedules ps

1034: g_curr_rec.base_precision,
1035: g_curr_rec.base_min_acc_unit) +
1036: GET_ADJ_FOR_TOT_REC(ps.payment_schedule_id,p_end_date))
1037: INTO l_tot_rec
1038: FROM ar_payment_schedules ps
1039: WHERE ps.class in ('INV', 'DM', 'CB', 'DEP' )
1040: AND ps.payment_schedule_id <> -1
1041: AND ps.gl_date BETWEEN l_temp_start AND p_end_date
1042: AND ps.customer_site_use_id = p_customer_site_use_id;

Line 1105: FROM ar_payment_schedules ps,

1101: SELECT sum(GET_APPS_TOTAL(ps.payment_schedule_id,p_end_date) -
1102: GET_ADJ_TOTAL(ps.payment_schedule_id,p_end_date) +
1103: nvl(ps.acctd_amount_due_remaining,0))
1104: INTO l_rem_sales
1105: FROM ar_payment_schedules ps,
1106: hz_cust_accounts ca
1107: WHERE ps.gl_date between p_start_date and p_end_date
1108: AND ps.class in ('INV','DEP','DM','CB')
1109: AND ps.gl_date_closed > p_end_date

Line 1122: FROM ar_payment_schedules ps

1118: SELECT sum(GET_APPS_TOTAL(ps.payment_schedule_id,p_end_date) -
1119: GET_ADJ_TOTAL(ps.payment_schedule_id,p_end_date) +
1120: nvl(ps.acctd_amount_due_remaining,0))
1121: INTO l_rem_sales
1122: FROM ar_payment_schedules ps
1123: WHERE ps.gl_date between p_start_date and p_end_date
1124: AND ps.class in ('INV','DEP','DM','CB')
1125: AND ps.gl_date_closed > p_end_date
1126: -- Begin fix bug #4949598-JYPARK-2/15/2006-add condition for performance

Line 1137: FROM ar_payment_schedules ps

1133: SELECT sum(GET_APPS_TOTAL(ps.payment_schedule_id,p_end_date) -
1134: GET_ADJ_TOTAL(ps.payment_schedule_id,p_end_date) +
1135: nvl(ps.acctd_amount_due_remaining,0))
1136: INTO l_rem_sales
1137: FROM ar_payment_schedules ps
1138: WHERE ps.gl_date between p_start_date and p_end_date
1139: AND ps.class in ('INV','DEP','DM','CB')
1140: AND ps.gl_date_closed > p_end_date
1141: -- Begin fix bug #4949598-JYPARK-2/15/2006-add condition for performance

Line 1202: FROM ar_payment_schedules ps,

1198: -- compute Remaining balance for given date range
1199:
1200: SELECT sum(nvl(ps.acctd_amount_due_remaining,0))
1201: INTO l_curr_rec
1202: FROM ar_payment_schedules ps,
1203: hz_cust_accounts ca
1204: WHERE ps.gl_date between p_start_date and p_end_date
1205: AND ps.class in ('INV','DEP','DM','CB')
1206: AND ps.gl_date_closed > p_end_date

Line 1216: FROM ar_payment_schedules ps

1212: -- compute Remaining balance for given date range
1213:
1214: SELECT sum(nvl(ps.acctd_amount_due_remaining,0))
1215: INTO l_curr_rec
1216: FROM ar_payment_schedules ps
1217: WHERE ps.gl_date between p_start_date and p_end_date
1218: AND ps.class in ('INV','DEP','DM','CB')
1219: AND ps.gl_date_closed > p_end_date
1220: AND ps.status = 'OP'

Line 1228: FROM ar_payment_schedules ps

1224: -- compute Remaining balance for given date range
1225:
1226: SELECT sum(nvl(ps.acctd_amount_due_remaining,0))
1227: INTO l_curr_rec
1228: FROM ar_payment_schedules ps
1229: WHERE ps.gl_date between p_start_date and p_end_date
1230: AND ps.class in ('INV','DEP','DM','CB')
1231: AND ps.gl_date_closed > p_end_date
1232: AND ps.status = 'OP'