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 42: FROM ar_payment_schedules ps, hz_cust_accounts ca

38: --Start of comment for Bug 8201317 14-Jun-2010 barathsr
39: /* SELECT sum(TRUNC(sysdate) - ps.due_date)
40: / COUNT(1)
41: INTO l_avg_days_late
42: FROM ar_payment_schedules ps, hz_cust_accounts ca
43: WHERE ps.gl_date between TRUNC(add_months(sysdate, -12)) and TRUNC(sysdate)
44: AND ps.class in ('INV','DEP','DM','CB')
45: AND ps.gl_date_closed > TRUNC(sysdate)
46: -- Begin fix bug #4949609-JYPARK-2/15/2006-add condition for performance

Line 57: FROM ar_payment_schedules ps

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

Line 71: FROM ar_payment_schedules ps

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

Line 86: FROM ar_payment_schedules ps, iex_delinquencies del

82: --Begin Bug 8201317 14-Jun-2010 barathsr
83: SELECT round(sum(TRUNC(decode(sign(gl_date_closed-trunc(sysdate)),1,sysdate,ps.gl_date_closed)) - ps.due_date)
84: / COUNT(1)) AVG_DAYS_LATE
85: INTO l_avg_days_late
86: FROM ar_payment_schedules ps, iex_delinquencies del
87: WHERE ps.gl_date between TRUNC(add_months(sysdate, -12)) and TRUNC(sysdate)
88: and ps.payment_schedule_id=del.payment_schedule_id
89: AND ps.class in ('INV','DEP','DM','CB')
90: AND ps.due_date <= TRUNC(sysdate)

Line 97: FROM ar_payment_schedules ps, iex_delinquencies del

93: ELSIF p_cust_account_id IS NOT NULL THEN
94: SELECT round(sum(TRUNC(decode(sign(gl_date_closed-trunc(sysdate)),1,sysdate,ps.gl_date_closed)) - ps.due_date)
95: / COUNT(1))AVG_DAYS_LATE
96: INTO l_avg_days_late
97: FROM ar_payment_schedules ps, iex_delinquencies del
98: WHERE ps.gl_date between TRUNC(add_months(sysdate, -12)) and TRUNC(sysdate)
99: and ps.payment_schedule_id=del.payment_schedule_id
100: AND ps.class in ('INV','DEP','DM','CB')
101: AND ps.due_date <= TRUNC(sysdate)

Line 108: FROM ar_payment_schedules ps,iex_delinquencies del

104: ELSIF p_customer_site_use_id IS NOT NULL THEN
105: SELECT round(sum(TRUNC(decode(sign(gl_date_closed-trunc(sysdate)),1,sysdate,ps.gl_date_closed)) - ps.due_date)
106: / COUNT(1))AVG_DAYS_LATE
107: INTO l_avg_days_late
108: FROM ar_payment_schedules ps,iex_delinquencies del
109: WHERE ps.gl_date between TRUNC(add_months(sysdate, -12)) and TRUNC(sysdate)
110: and ps.payment_schedule_id=del.payment_schedule_id
111: AND ps.class in ('INV','DEP','DM','CB')
112: AND ps.due_date <= TRUNC(sysdate)

Line 186: FROM ar_payment_schedules ps, hz_cust_accounts ca

182: GET_ADJ_TOTAL(ps.payment_schedule_id, TRUNC(sysdate)) +
183: nvl(ps.acctd_amount_due_remaining, 0)
184: )
185: INTO l_wtd_days_late
186: FROM ar_payment_schedules ps, hz_cust_accounts ca
187: WHERE ps.gl_date between TRUNC(add_months(sysdate, -12)) and TRUNC(sysdate)
188: AND ps.class in ('INV','DEP','DM','CB')
189: -- Begin fix bug #4917851-jypark-11/47/2005-remove invalid condition
190: --AND ps.gl_date_closed > TRUNC(sysdate)

Line 215: FROM ar_payment_schedules ps

211: GET_ADJ_TOTAL(ps.payment_schedule_id, TRUNC(sysdate)) +
212: nvl(ps.acctd_amount_due_remaining, 0)
213: )
214: INTO l_wtd_days_late
215: FROM ar_payment_schedules ps
216: WHERE ps.gl_date between TRUNC(add_months(sysdate, -12)) and TRUNC(sysdate)
217: AND ps.class in ('INV','DEP','DM','CB')
218: -- Begin fix bug #4917851-jypark-11/47/2005-remove invalid condition
219: -- AND ps.gl_date_closed > TRUNC(sysdate)

Line 243: FROM ar_payment_schedules ps

239: GET_ADJ_TOTAL(ps.payment_schedule_id, TRUNC(sysdate)) +
240: nvl(ps.acctd_amount_due_remaining, 0)
241: )
242: INTO l_wtd_days_late
243: FROM ar_payment_schedules ps
244: WHERE ps.gl_date between TRUNC(add_months(sysdate, -12)) and TRUNC(sysdate)
245: AND ps.class in ('INV','DEP','DM','CB')
246: -- Begin fix bug #4917851-jypark-11/47/2005-remove invalid condition
247: -- AND ps.gl_date_closed > TRUNC(sysdate)

Line 272: FROM ar_payment_schedules ps,iex_delinquencies del

268: GET_ADJ_TOTAL(ps.payment_schedule_id, TRUNC(sysdate)) +
269: nvl(ps.acctd_amount_due_remaining, 0)
270: ))WTD_AVG_DAYS_LATE
271: INTO l_wtd_days_late
272: FROM ar_payment_schedules ps,iex_delinquencies del
273: WHERE ps.gl_date between TRUNC(add_months(sysdate, -12)) and TRUNC(sysdate)
274: and ps.payment_schedule_id=del.payment_schedule_id
275: AND ps.class in ('INV','DEP','DM','CB')
276: AND ps.due_date <= TRUNC(sysdate)

Line 296: FROM ar_payment_schedules ps, iex_delinquencies del

292: GET_ADJ_TOTAL(ps.payment_schedule_id, TRUNC(sysdate)) +
293: nvl(ps.acctd_amount_due_remaining, 0)
294: ))WTD_AVG_DAYS_LATE
295: INTO l_wtd_days_late
296: FROM ar_payment_schedules ps, iex_delinquencies del
297: WHERE ps.gl_date between TRUNC(add_months(sysdate, -12)) and TRUNC(sysdate)
298: and ps.payment_schedule_id=del.payment_schedule_id
299: AND ps.class in ('INV','DEP','DM','CB')
300: AND ps.due_date <= TRUNC(sysdate)

Line 320: FROM ar_payment_schedules ps, iex_delinquencies del

316: GET_ADJ_TOTAL(ps.payment_schedule_id, TRUNC(sysdate)) +
317: nvl(ps.acctd_amount_due_remaining, 0)
318: ))WTD_AVG_DAYS_LATE
319: INTO l_wtd_days_late
320: FROM ar_payment_schedules ps, iex_delinquencies del
321: WHERE ps.gl_date between TRUNC(add_months(sysdate, -12)) and TRUNC(sysdate)
322: and ps.payment_schedule_id=del.payment_schedule_id
323: AND ps.class in ('INV','DEP','DM','CB')
324: AND ps.due_date <= TRUNC(sysdate)

Line 383: ar_payment_schedules ps,

379: / SUM(ra.amount_applied)
380: , 0) WEIGHTED_AVG_DAYS_PAID
381: INTO l_wtd_days_paid
382: FROM ar_receivable_applications ra,
383: ar_payment_schedules ps,
384: hz_cust_accounts ca
385: WHERE ps.customer_id = ca.cust_account_id
386: AND ca.party_id = p_party_id
387: AND ra.status = 'APP'

Line 405: ar_payment_schedules ps

401: / SUM(ra.amount_applied)
402: , 0) WEIGHTED_AVG_DAYS_PAID
403: INTO l_wtd_days_paid
404: FROM ar_receivable_applications ra,
405: ar_payment_schedules ps
406: WHERE ps.customer_id = p_cust_account_id
407: AND ra.status = 'APP'
408: AND ps.payment_schedule_id = ra.applied_payment_schedule_id
409: AND ps.gl_date between TRUNC(add_months(sysdate, -12)) and TRUNC(sysdate)

Line 425: ar_payment_schedules ps

421: / SUM(ra.amount_applied)
422: , 0) WEIGHTED_AVG_DAYS_PAID
423: INTO l_wtd_days_paid
424: FROM ar_receivable_applications ra,
425: ar_payment_schedules ps
426: WHERE ps.customer_site_use_id = p_customer_site_use_id
427: AND ra.status = 'APP'
428: AND ps.payment_schedule_id = ra.applied_payment_schedule_id
429: AND ps.gl_date between TRUNC(add_months(sysdate, -12)) and TRUNC(sysdate)

Line 504: FROM ar_payment_schedules ps, hz_cust_accounts ca

500: GET_ADJ_TOTAL(ps.payment_schedule_id, TRUNC(sysdate)) +
501: nvl(ps.acctd_amount_due_remaining, 0)
502: )
503: INTO l_wtd_days_terms
504: FROM ar_payment_schedules ps, hz_cust_accounts ca
505: WHERE ps.gl_date between TRUNC(add_months(sysdate, -12)) and TRUNC(sysdate)
506: AND ps.class in ('INV','DEP','DM','CB')
507: -- Begin fix bug #4917851-jypark-11/47/2005-remove invalid condition
508: -- AND ps.gl_date_closed > TRUNC(sysdate)

Line 530: FROM ar_payment_schedules ps

526: GET_ADJ_TOTAL(ps.payment_schedule_id, TRUNC(sysdate)) +
527: nvl(ps.acctd_amount_due_remaining, 0)
528: )
529: INTO l_wtd_days_terms
530: FROM ar_payment_schedules ps
531: WHERE ps.gl_date between TRUNC(add_months(sysdate, -12)) and TRUNC(sysdate)
532: AND ps.class in ('INV','DEP','DM','CB')
533: -- Begin fix bug #4917851-jypark-11/47/2005-remove invalid condition
534: -- AND ps.gl_date_closed > TRUNC(sysdate)

Line 555: FROM ar_payment_schedules ps

551: GET_ADJ_TOTAL(ps.payment_schedule_id, TRUNC(sysdate)) +
552: nvl(ps.acctd_amount_due_remaining, 0)
553: )
554: INTO l_wtd_days_terms
555: FROM ar_payment_schedules ps
556: WHERE ps.gl_date between TRUNC(add_months(sysdate, -12)) and TRUNC(sysdate)
557: AND ps.class in ('INV','DEP','DM','CB')
558: -- Begin fix bug #4917851-jypark-11/47/2005-remove invalid condition
559: -- AND ps.gl_date_closed > TRUNC(sysdate)

Line 715: ar_payment_schedules ps

711: ), 0) /* DSO */
712: INTO l_conv_dso
713: FROM ar_system_parameters sp,
714: hz_cust_accounts cust_acct,
715: ar_payment_schedules ps
716: WHERE ps.customer_id = cust_acct.cust_account_id
717: AND cust_acct.party_id = p_party_id
718: -- Begin fix bug #5261855-jypark-06/16/2006-add addtional condition for performance
719: AND ps.status = 'OP'

Line 757: ar_payment_schedules ps

753: )
754: ), 0) /* DSO */
755: INTO l_conv_dso
756: FROM ar_system_parameters sp,
757: ar_payment_schedules ps
758: WHERE ps.customer_id = p_cust_account_id
759: -- Begin fix bug #5261855-jypark-06/16/2006-add addtional condition for performance
760: AND ps.status = 'OP'
761: -- End fix bug #5261855-jypark-06/16/2006-add addtional condition for performance

Line 799: ar_payment_schedules ps

795: )
796: ), 0) /* DSO */
797: INTO l_conv_dso
798: FROM ar_system_parameters sp,
799: ar_payment_schedules ps
800: WHERE ps.customer_site_use_id = p_customer_site_use_id
801: -- Begin fix bug #5261855-jypark-06/16/2006-add addtional condition for performance
802: AND ps.status = 'OP'
803: -- End fix bug #5261855-jypark-06/16/2006-add addtional condition for performance

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

1008: IF p_party_id IS NOT NULL THEN
1009: SELECT
1010: sum( nvl(adj.acctd_amount,0))
1011: INTO l_adj
1012: FROM ar_payment_schedules ps, ar_adjustments adj, hz_cust_accounts ca
1013: WHERE ps.class in ('INV', 'DM', 'CB', 'DEP' )
1014: AND ps.payment_schedule_id <> -1
1015: AND ps.gl_date BETWEEN TRUNC(add_months(sysdate, -12)) AND TRUNC(sysdate)
1016: AND ps.customer_id = ca.cust_account_id

Line 1025: FROM ar_payment_schedules ps, ar_adjustments adj

1021: ELSIF p_cust_account_id IS NOT NULL THEN
1022: SELECT
1023: sum( nvl(adj.acctd_amount,0))
1024: INTO l_adj
1025: FROM ar_payment_schedules ps, ar_adjustments adj
1026: WHERE ps.class in ('INV', 'DM', 'CB', 'DEP' )
1027: AND ps.payment_schedule_id <> -1
1028: AND ps.gl_date BETWEEN TRUNC(add_months(sysdate, -12)) AND TRUNC(sysdate)
1029: AND ps.customer_id = p_cust_account_id

Line 1037: FROM ar_payment_schedules ps, ar_adjustments adj

1033: ELSIF p_customer_site_use_id IS NOT NULL THEN
1034: SELECT
1035: sum( nvl(adj.acctd_amount,0))
1036: INTO l_adj
1037: FROM ar_payment_schedules ps, ar_adjustments adj
1038: WHERE ps.class in ('INV', 'DM', 'CB', 'DEP' )
1039: AND ps.payment_schedule_id <> -1
1040: AND ps.gl_date BETWEEN TRUNC(add_months(sysdate, -12)) AND TRUNC(sysdate)
1041: AND ps.customer_site_use_id = p_customer_site_use_id

Line 1119: FROM ar_payment_schedules ps,

1115: g_curr_rec.base_precision,
1116: g_curr_rec.base_min_acc_unit) +
1117: GET_ADJ_FOR_TOT_REC(ps.payment_schedule_id,p_end_date))
1118: INTO l_tot_rec
1119: FROM ar_payment_schedules ps,
1120: hz_cust_accounts ca
1121: WHERE ps.class in ('INV', 'DM', 'CB', 'DEP' )
1122: AND ps.payment_schedule_id <> -1
1123: AND ps.gl_date BETWEEN l_temp_start AND p_end_date

Line 1135: FROM ar_payment_schedules ps

1131: g_curr_rec.base_precision,
1132: g_curr_rec.base_min_acc_unit) +
1133: GET_ADJ_FOR_TOT_REC(ps.payment_schedule_id,p_end_date))
1134: INTO l_tot_rec
1135: FROM ar_payment_schedules ps
1136: WHERE ps.class in ('INV', 'DM', 'CB', 'DEP' )
1137: AND ps.payment_schedule_id <> -1
1138: AND ps.gl_date BETWEEN l_temp_start AND p_end_date
1139: AND ps.customer_id = p_cust_account_id;

Line 1149: FROM ar_payment_schedules ps

1145: g_curr_rec.base_precision,
1146: g_curr_rec.base_min_acc_unit) +
1147: GET_ADJ_FOR_TOT_REC(ps.payment_schedule_id,p_end_date))
1148: INTO l_tot_rec
1149: FROM ar_payment_schedules ps
1150: WHERE ps.class in ('INV', 'DM', 'CB', 'DEP' )
1151: AND ps.payment_schedule_id <> -1
1152: AND ps.gl_date BETWEEN l_temp_start AND p_end_date
1153: AND ps.customer_site_use_id = p_customer_site_use_id;

Line 1216: FROM ar_payment_schedules ps,

1212: SELECT sum(GET_APPS_TOTAL(ps.payment_schedule_id,p_end_date) -
1213: GET_ADJ_TOTAL(ps.payment_schedule_id,p_end_date) +
1214: nvl(ps.acctd_amount_due_remaining,0))
1215: INTO l_rem_sales
1216: FROM ar_payment_schedules ps,
1217: hz_cust_accounts ca
1218: WHERE ps.gl_date between p_start_date and p_end_date
1219: AND ps.class in ('INV','DEP','DM','CB')
1220: AND ps.gl_date_closed > p_end_date

Line 1233: FROM ar_payment_schedules ps

1229: SELECT sum(GET_APPS_TOTAL(ps.payment_schedule_id,p_end_date) -
1230: GET_ADJ_TOTAL(ps.payment_schedule_id,p_end_date) +
1231: nvl(ps.acctd_amount_due_remaining,0))
1232: INTO l_rem_sales
1233: FROM ar_payment_schedules ps
1234: WHERE ps.gl_date between p_start_date and p_end_date
1235: AND ps.class in ('INV','DEP','DM','CB')
1236: AND ps.gl_date_closed > p_end_date
1237: -- Begin fix bug #4949598-JYPARK-2/15/2006-add condition for performance

Line 1248: FROM ar_payment_schedules ps

1244: SELECT sum(GET_APPS_TOTAL(ps.payment_schedule_id,p_end_date) -
1245: GET_ADJ_TOTAL(ps.payment_schedule_id,p_end_date) +
1246: nvl(ps.acctd_amount_due_remaining,0))
1247: INTO l_rem_sales
1248: FROM ar_payment_schedules ps
1249: WHERE ps.gl_date between p_start_date and p_end_date
1250: AND ps.class in ('INV','DEP','DM','CB')
1251: AND ps.gl_date_closed > p_end_date
1252: -- Begin fix bug #4949598-JYPARK-2/15/2006-add condition for performance

Line 1313: FROM ar_payment_schedules ps,

1309: -- compute Remaining balance for given date range
1310:
1311: SELECT sum(nvl(ps.acctd_amount_due_remaining,0))
1312: INTO l_curr_rec
1313: FROM ar_payment_schedules ps,
1314: hz_cust_accounts ca
1315: WHERE ps.gl_date between p_start_date and p_end_date
1316: AND ps.class in ('INV','DEP','DM','CB')
1317: AND ps.gl_date_closed > p_end_date

Line 1327: FROM ar_payment_schedules ps

1323: -- compute Remaining balance for given date range
1324:
1325: SELECT sum(nvl(ps.acctd_amount_due_remaining,0))
1326: INTO l_curr_rec
1327: FROM ar_payment_schedules ps
1328: WHERE ps.gl_date between p_start_date and p_end_date
1329: AND ps.class in ('INV','DEP','DM','CB')
1330: AND ps.gl_date_closed > p_end_date
1331: AND ps.status = 'OP'

Line 1339: FROM ar_payment_schedules ps

1335: -- compute Remaining balance for given date range
1336:
1337: SELECT sum(nvl(ps.acctd_amount_due_remaining,0))
1338: INTO l_curr_rec
1339: FROM ar_payment_schedules ps
1340: WHERE ps.gl_date between p_start_date and p_end_date
1341: AND ps.class in ('INV','DEP','DM','CB')
1342: AND ps.gl_date_closed > p_end_date
1343: AND ps.status = 'OP'

Line 2001: from ar_payment_schedules_all a, hz_cust_accounts b

1997:
1998: /* Numerator (Sysdate - Invoice date) * Invoice Amount */
1999: cursor c_invoices_party (p_party_id number) is
2000: select (sysdate-gl_date)* amount_due_original amount, to_char(gl_date,'MM') month,payment_schedule_id
2001: from ar_payment_schedules_all a, hz_cust_accounts b
2002: where a.customer_id = b.cust_account_id
2003: AND b.party_id = p_party_id
2004: AND a.CLASS IN ('INV','DEP','DM','CB')
2005: and a.gl_date between trunc(sysdate-365) AND TRUNC(sysdate);

Line 2009: from ar_payment_schedules_all

2005: and a.gl_date between trunc(sysdate-365) AND TRUNC(sysdate);
2006:
2007: cursor c_invoices_acct (p_cust_account_id number) is
2008: select (sysdate-gl_date)* amount_due_original amount, to_char(gl_date,'MM') month,payment_schedule_id
2009: from ar_payment_schedules_all
2010: where customer_id = p_cust_account_id
2011: AND CLASS IN ('INV','DEP','DM','CB')
2012: and gl_date between trunc(sysdate-365) AND TRUNC(sysdate);
2013:

Line 2016: from ar_payment_schedules_all

2012: and gl_date between trunc(sysdate-365) AND TRUNC(sysdate);
2013:
2014: cursor c_invoices_site (p_customer_site_use_id number) is
2015: select (sysdate-gl_date)* amount_due_original amount, to_char(gl_date,'MM') month,payment_schedule_id
2016: from ar_payment_schedules_all
2017: where customer_site_use_id = p_customer_site_use_id
2018: AND CLASS IN ('INV','DEP','DM','CB')
2019: and gl_date between trunc(sysdate-365) AND TRUNC(sysdate);
2020: