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_CUST_OVERVIEW_PVT dependencies on IEX_DELINQUENCIES

Line 60: -- iex_delinquencies del

56: -- SELECT COUNT(DECODE(ps.class, 'INV', ps.payment_schedule_id, 'DM', ps.payment_schedule_id, 'CB', ps.payment_schedule_id, NULL)) cnt_inv,
57: -- COUNT(DECODE(ps.class, 'INV', DECODE(del.status, 'DELINQUENT', del.delinquency_id, 'PREDELINQUENT', del.delinquency_id, NULL), NULL)) cnt_del
58: -- FROM ar_payment_schedules ps,
59: -- hz_cust_accounts ca,
60: -- iex_delinquencies del
61: -- WHERE ca.party_id = p_party_id
62: -- AND ps.customer_id = ca.cust_account_id
63: -- AND ps.status = 'OP'
64: -- AND del.payment_schedule_id(+) = ps.payment_schedule_id;

Line 79: iex_delinquencies del

75: CURSOR c_delinquent_inv IS
76: SELECT COUNT(del.delinquency_id) cnt_del
77: FROM ar_payment_schedules ps,
78: hz_cust_accounts ca,
79: iex_delinquencies del
80: WHERE ca.party_id = p_party_id
81: AND ps.customer_id = ca.cust_account_id
82: AND ps.status = 'OP'
83: AND ps.class = 'INV'

Line 91: FROM iex_delinquencies del

87:
88: -- Delinquencies in Past Year
89: CURSOR c_delinquencies IS
90: SELECT Count(1)
91: FROM iex_delinquencies del
92: WHERE del.party_cust_id = p_party_id
93: AND del.creation_date between sysdate - 365 and sysdate ;
94:
95: -- added by jypark for status in header

Line 229: ' FROM iex_delinquencies' ||

225: ' AND close_date IS NULL ' ||
226: ' AND NVL(DISPOSITION_CODE, '' '') NOT IN (''DISMISSED'',''WITHDRAWN'' )';
227: ELSIF l_delinquency_status = 'DELINQUENT' THEN
228: l_sql_stmt := 'SELECT count(1)' ||
229: ' FROM iex_delinquencies' ||
230: ' WHERE party_cust_id = :party_id' ||
231: -- fix bug #4157131 ' AND status not in (''CURRENT'', ''CLOSE'')';
232: ' AND status = ''DELINQUENT''';
233: ELSIF l_delinquency_status = 'LITIGATION' THEN

Line 236: ' FROM iex_litigations ltg, iex_delinquencies del' ||

232: ' AND status = ''DELINQUENT''';
233: ELSIF l_delinquency_status = 'LITIGATION' THEN
234: l_sql_stmt_lsd := ' select count(1) from (' ||
235: ' SELECT litigation_id' ||
236: ' FROM iex_litigations ltg, iex_delinquencies del' ||
237: ' WHERE del.party_cust_id = :party_id' ||
238: ' AND ltg.delinquency_id = del.delinquency_id' ||
239: ' AND del.status not in (''CURRENT'', ''CLOSE'')' ||
240: ' AND ltg.disposition_code IS NULL ' ||

Line 251: ' FROM iex_repossessions rps, iex_delinquencies del' ||

247: ' AND disposition_code IS NULL )';
248: ELSIF l_delinquency_status = 'REPOSSESSION' THEN
249: l_sql_stmt_lsd := ' select count(1) from (' ||
250: ' SELECT repossession_id' ||
251: ' FROM iex_repossessions rps, iex_delinquencies del' ||
252: ' WHERE del.party_cust_id = :party_id' ||
253: ' AND rps.delinquency_id = del.delinquency_id' ||
254: ' AND del.status not in (''CURRENT'', ''CLOSE'')' ||
255: ' AND (rps.disposition_code IS NULL or rps.disposition_code = ''A'' or rps.disposition_code = ''W'') ' ||

Line 267: ' FROM iex_writeoffs wrf, iex_delinquencies del' ||

263: --' AND disposition_code IS NULL )';
264: ELSIF l_delinquency_status = 'WRITEOFF' THEN
265: l_sql_stmt_lsd := ' select count(1) from (' ||
266: ' SELECT writeoff_id' ||
267: ' FROM iex_writeoffs wrf, iex_delinquencies del' ||
268: ' WHERE del.party_cust_id = :party_id' ||
269: ' AND wrf.delinquency_id = del.delinquency_id' ||
270: ' AND del.status not in (''CURRENT'', ''CLOSE'')' ||
271: ' AND (wrf.disposition_code IS NULL or wrf.disposition_code = ''A'' or wrf.disposition_code = ''W'') ' ||

Line 283: ' FROM iex_delinquencies' ||

279: ' AND (disposition_code IS NULL or disposition_code = ''A'' or disposition_code = ''W''))' ;
280: --' AND disposition_code IS NULL )';
281: ELSIF l_delinquency_status = 'PREDELINQUENT' THEN
282: l_sql_stmt := 'SELECT count(1)' ||
283: ' FROM iex_delinquencies' ||
284: ' WHERE party_cust_id = :party_id' ||
285: -- fix bug #4157131 ' AND status not in (''CURRENT'', ''CLOSE'')';
286: ' AND status = ''PREDELINQUENT''';
287: END IF;

Line 332: ' FROM iex_delinquencies' ||

328: ' AND close_date IS NULL ' ||
329: ' AND NVL(DISPOSITION_CODE , '' '') NOT IN (''DISMISSED'',''WITHDRAWN'' )';
330: ELSIF l_delinquency_status = 'DELINQUENT' THEN
331: l_sql_stmt := 'SELECT count(1)' ||
332: ' FROM iex_delinquencies' ||
333: ' WHERE party_cust_id = :party_id' ||
334: -- fix bug #4157131 ' AND status not in (''CURRENT'', ''CLOSE'')';
335: ' AND status = ''DELINQUENT''';
336: ELSIF l_delinquency_status = 'LITIGATION' THEN

Line 339: ' FROM iex_litigations ltg, iex_delinquencies del' ||

335: ' AND status = ''DELINQUENT''';
336: ELSIF l_delinquency_status = 'LITIGATION' THEN
337: l_sql_stmt_lsd := 'select count(1) from (' ||
338: ' SELECT litigation_id' ||
339: ' FROM iex_litigations ltg, iex_delinquencies del' ||
340: ' WHERE del.party_cust_id = :party_id' ||
341: ' AND ltg.delinquency_id = del.delinquency_id' ||
342: ' AND del.status not in (''CURRENT'', ''CLOSE'')' ||
343: ' AND ltg.disposition_code IS NULL ' ||

Line 354: ' FROM iex_repossessions rps, iex_delinquencies del' ||

350: ' AND disposition_code IS NULL )';
351: ELSIF l_delinquency_status = 'REPOSSESSION' THEN
352: l_sql_stmt_lsd := ' select count(1) from (' ||
353: ' SELECT repossession_id' ||
354: ' FROM iex_repossessions rps, iex_delinquencies del' ||
355: ' WHERE del.party_cust_id = :party_id' ||
356: ' AND rps.delinquency_id = del.delinquency_id' ||
357: ' AND del.status not in (''CURRENT'', ''CLOSE'')' ||
358: ' AND (rps.disposition_code IS NULL or rps.disposition_code = ''A'' or rps.disposition_code = ''W'') ' ||

Line 371: ' FROM iex_writeoffs wrf, iex_delinquencies del' ||

367: --' AND disposition_code IS NULL )';
368: ELSIF l_delinquency_status = 'WRITEOFF' THEN
369: l_sql_stmt_lsd := ' select count(1) from (' ||
370: ' SELECT writeoff_id' ||
371: ' FROM iex_writeoffs wrf, iex_delinquencies del' ||
372: ' WHERE del.party_cust_id = :party_id' ||
373: ' AND wrf.delinquency_id = del.delinquency_id' ||
374: ' AND del.status not in (''CURRENT'', ''CLOSE'')' ||
375: ' AND (wrf.disposition_code IS NULL or wrf.disposition_code = ''A'' or wrf.disposition_code = ''W'') ' ||

Line 387: ' FROM iex_delinquencies' ||

383: ' AND (disposition_code IS NULL or disposition_code = ''A'' or disposition_code = ''W''))' ;
384: --' AND disposition_code IS NULL )';
385: ELSIF l_delinquency_status = 'PREDELINQUENT' THEN
386: l_sql_stmt := 'SELECT count(1)' ||
387: ' FROM iex_delinquencies' ||
388: ' WHERE party_cust_id = :party_id' ||
389: -- fix bug #4157131 ' AND status not in (''CURRENT'', ''CLOSE'')';
390: ' AND status = ''PREDELINQUENT''';
391: END IF;

Line 452: -- FROM iex_delinquencies del

448: -- Begin fix bug #4930425-jypark-01/10/2006-removed obsolete query
449: -- -- Delinquent Cases
450: -- CURSOR c_del_cases IS
451: -- SELECT Count(1)
452: -- FROM iex_delinquencies del
453: -- WHERE del.party_cust_id = p_party_id
454: -- and del.case_id is not null
455: -- and del.status = 'DELINQUENT';
456: --

Line 468: -- FROM iex_delinquencies del

464: --
465: -- -- Delinquent Cases in Past Year
466: -- CURSOR c_del_cases_past_year IS
467: -- SELECT Count(1)
468: -- FROM iex_delinquencies del
469: -- WHERE del.party_cust_id = p_party_id
470: -- AND del.creation_date between sysdate - 365 and sysdate
471: -- and del.case_id is not null
472: -- and del.status = 'DELINQUENT';

Line 534: FROM iex_delinquencies

530: l_last_okl_pmt_info_rec Last_OKL_Pmt_Info_Rec_Type;
531:
532: CURSOR c_del(x_delinquency_id NUMBER) IS
533: SELECT payment_schedule_id
534: FROM iex_delinquencies
535: WHERE delinquency_id = x_delinquency_id
536: AND status not in ('CURRENT', 'CLOSE');
537:
538: l_cnt_cur_codes number; --added for MOAC

Line 597: -- iex_delinquencies del,

593: ), 0) dso
594: FROM ar_payment_schedules ps,
595: hz_cust_accounts ca,
596: -- Begin fix bug #5261855-jypark-06/16/2006-change to based table for performance
597: -- iex_delinquencies del,
598: iex_delinquencies_all del,
599: -- End fix bug #5261855-jypark-06/16/2006-change to based table for performance
600: ar_system_parameters sp
601: WHERE ca.party_id = l_party_id

Line 598: iex_delinquencies_all del,

594: FROM ar_payment_schedules ps,
595: hz_cust_accounts ca,
596: -- Begin fix bug #5261855-jypark-06/16/2006-change to based table for performance
597: -- iex_delinquencies del,
598: iex_delinquencies_all del,
599: -- End fix bug #5261855-jypark-06/16/2006-change to based table for performance
600: ar_system_parameters sp
601: WHERE ca.party_id = l_party_id
602: AND ps.customer_id = ca.cust_account_id

Line 655: FROM ar_payment_schedules ps, iex_delinquencies del

651: else
652: --end moac change
653: OPEN c_overdue FOR
654: SELECT sum(acctd_amount_due_remaining) amount
655: FROM ar_payment_schedules ps, iex_delinquencies del
656: WHERE ps.customer_id = p_object_id
657: -- fix bug #3561828 AND ps.due_date < sysdate
658: --BEGIN-FIX BUG#4356388-05/24/2005-JYPARK-amount overdue should inculde Pre-Delinquent transactions which are not past due
659: -- AND TRUNC(ps.due_date) < TRUNC(sysdate)

Line 763: FROM ar_payment_schedules ps, iex_delinquencies del

759: else
760: --end moac change
761: OPEN c_overdue FOR
762: SELECT ps.acctd_amount_due_remaining
763: FROM ar_payment_schedules ps, iex_delinquencies del
764: WHERE del.delinquency_id = p_object_id
765: AND ps.payment_schedule_id = del.payment_schedule_id
766: AND ps.status = 'OP'
767: AND del.status IN ('DELINQUENT', 'PREDELINQUENT');

Line 784: FROM ar_payment_schedules ps, iex_delinquencies del

780: from ra_cm_requests cm
781: where cm.customer_trx_id in
782: (
783: SELECT distinct ps.customer_trx_id
784: FROM ar_payment_schedules ps, iex_delinquencies del
785: WHERE del.delinquency_id = p_object_id
786: AND ps.payment_schedule_id = del.payment_schedule_id
787: AND ps.status = 'OP'
788: AND del.status IN ('DELINQUENT', 'PREDELINQUENT'))

Line 855: FROM ar_payment_schedules ps, iex_delinquencies del

851: --end moac change
852:
853: OPEN c_overdue FOR
854: SELECT sum(acctd_amount_due_remaining) amount
855: FROM ar_payment_schedules ps, iex_delinquencies del
856: WHERE ps.customer_site_use_id = p_object_id
857: --BEGIN-FIX BUG#4356388-05/24/2005-JYPARK-amount overdue should inculde Pre-Delinquent transactions which are not past due
858: -- AND ps.due_date < sysdate
859: --END-FIX BUG#4356388-05/24/2005-JYPARK-amount overdue should inculde Pre-Delinquent transactions which are not past due

Line 1122: iex_delinquencies del

1118: FROM ar_payment_schedules apsa,
1119: ar_cash_receipts acr,
1120: ar_receivable_applications ara,
1121: ar_cash_receipt_history acrh,
1122: iex_delinquencies del
1123: WHERE ara.cash_receipt_id = acr.cash_receipt_id
1124: AND ara.applied_payment_schedule_id = apsa.payment_schedule_id
1125: AND apsa.payment_schedule_id = del.payment_schedule_id
1126: AND del.delinquency_id = p_object_id

Line 1404: iex_delinquencies del

1400: FROM ar_payment_schedules apsa,
1401: ar_cash_receipts acr,
1402: ar_receivable_applications ara,
1403: ar_cash_receipt_history acrh,
1404: iex_delinquencies del
1405: WHERE ara.cash_receipt_id = acr.cash_receipt_id
1406: AND ara.applied_payment_schedule_id = apsa.payment_schedule_id
1407: AND apsa.payment_schedule_id = del.payment_schedule_id
1408: AND del.delinquency_id = p_object_id

Line 1844: iex_delinquencies del,

1840: )
1841: ), 0) dso
1842: FROM ar_payment_schedules ps,
1843: hz_cust_accounts ca,
1844: iex_delinquencies del,
1845: ar_system_parameters sp
1846: WHERE ca.party_id = p_party_id
1847: AND ps.customer_id = ca.cust_account_id
1848: AND ps.status = 'OP'

Line 1857: iex_delinquencies del

1853: SELECT COUNT(DECODE(ps.class, 'INV', ps.payment_schedule_id, 'DM', ps.payment_schedule_id, 'CB', ps.payment_schedule_id, NULL)) cnt_inv,
1854: COUNT(DECODE(ps.class, 'INV', DECODE(del.status, 'DELINQUENT', del.delinquency_id, 'PREDELINQUENT', del.delinquency_id, NULL), NULL)) cnt_del
1855: FROM ar_payment_schedules ps,
1856: hz_cust_accounts ca,
1857: iex_delinquencies del
1858: WHERE ca.party_id = p_party_id
1859: AND ps.customer_id = ca.cust_account_id
1860: AND ps.status = 'OP'
1861: AND del.payment_schedule_id(+) = ps.payment_schedule_id;

Line 1903: iex_delinquencies del,

1899: )
1900: ), 0) dso
1901: FROM ar_payment_schedules ps,
1902: hz_cust_accounts ca,
1903: iex_delinquencies del,
1904: ar_system_parameters sp
1905: WHERE ca.party_id = p_party_id
1906: AND ps.customer_id = ca.cust_account_id
1907: AND ps.status = 'OP'

Line 1915: FROM iex_delinquencies del

1911:
1912: -- Delinquencies in Past Year
1913: CURSOR c_delinquencies IS
1914: SELECT Count(1)
1915: FROM iex_delinquencies del
1916: WHERE del.party_cust_id = p_party_id
1917: AND del.creation_date between sysdate - 365 and sysdate ;
1918:
1919: -- added by jypark for status in header

Line 2086: ' FROM iex_delinquencies' ||

2082: ' AND close_date IS NULL ' ||
2083: ' AND NVL(DISPOSITION_CODE, '' '') NOT IN (''DISMISSED'',''WITHDRAWN'' )';
2084: ELSIF l_delinquency_status = 'DELINQUENT' THEN
2085: l_sql_stmt := 'SELECT count(1)' ||
2086: ' FROM iex_delinquencies' ||
2087: ' WHERE party_cust_id = :party_id' ||
2088: -- fix bug #4157131 ' AND status not in (''CURRENT'', ''CLOSE'')';
2089: ' AND status = ''DELINQUENT''';
2090: ELSIF l_delinquency_status = 'LITIGATION' THEN

Line 2093: ' FROM iex_litigations ltg, iex_delinquencies del' ||

2089: ' AND status = ''DELINQUENT''';
2090: ELSIF l_delinquency_status = 'LITIGATION' THEN
2091: l_sql_stmt_lsd := 'select count(1) from (' ||
2092: ' SELECT litigation_id' ||
2093: ' FROM iex_litigations ltg, iex_delinquencies del' ||
2094: ' WHERE del.party_cust_id = :party_id' ||
2095: ' AND ltg.delinquency_id = del.delinquency_id' ||
2096: ' AND del.status not in (''CURRENT'', ''CLOSE'')' ||
2097: ' AND ltg.disposition_code IS NULL ' ||

Line 2108: ' FROM iex_repossessions rps, iex_delinquencies del' ||

2104: ' AND disposition_code IS NULL )';
2105: ELSIF l_delinquency_status = 'REPOSSESSION' THEN
2106: l_sql_stmt_lsd := ' select count(1) from (' ||
2107: ' SELECT repossession_id' ||
2108: ' FROM iex_repossessions rps, iex_delinquencies del' ||
2109: ' WHERE del.party_cust_id = :party_id' ||
2110: ' AND rps.delinquency_id = del.delinquency_id' ||
2111: ' AND del.status not in (''CURRENT'', ''CLOSE'')' ||
2112: ' AND (rps.disposition_code IS NULL or rps.disposition_code = ''A'' or rps.disposition_code = ''W'') ' ||

Line 2125: ' FROM iex_writeoffs wrf, iex_delinquencies del' ||

2121: -- Bug 766183 ' AND disposition_code IS NULL )';
2122: ELSIF l_delinquency_status = 'WRITEOFF' THEN
2123: l_sql_stmt_lsd := ' select count(1) from (' ||
2124: ' SELECT writeoff_id' ||
2125: ' FROM iex_writeoffs wrf, iex_delinquencies del' ||
2126: ' WHERE del.party_cust_id = :party_id' ||
2127: ' AND wrf.delinquency_id = del.delinquency_id' ||
2128: ' AND del.status not in (''CURRENT'', ''CLOSE'')' ||
2129: ' AND (wrf.disposition_code IS NULL or wrf.disposition_code = ''A'' or wrf.disposition_code = ''W'') ' ||

Line 2141: ' FROM iex_delinquencies' ||

2137: ' AND (disposition_code IS NULL or disposition_code = ''A'' or disposition_code = ''W''))' ;
2138: -- ' AND disposition_code IS NULL )';
2139: ELSIF l_delinquency_status = 'PREDELINQUENT' THEN
2140: l_sql_stmt := 'SELECT count(1)' ||
2141: ' FROM iex_delinquencies' ||
2142: ' WHERE party_cust_id = :party_id' ||
2143: -- fix bug #4157131 ' AND status not in (''CURRENT'', ''CLOSE'')';
2144: ' AND status = ''PREDELINQUENT''';
2145: END IF;

Line 2190: ' FROM iex_delinquencies' ||

2186: ' AND close_date IS NULL ' ||
2187: ' AND NVL(DISPOSITION_CODE , '' '') NOT IN (''DISMISSED'',''WITHDRAWN'' )';
2188: ELSIF l_delinquency_status = 'DELINQUENT' THEN
2189: l_sql_stmt := 'SELECT count(1)' ||
2190: ' FROM iex_delinquencies' ||
2191: ' WHERE party_cust_id = :party_id' ||
2192: -- fix bug #4157131 ' AND status not in (''CURRENT'', ''CLOSE'')';
2193: ' AND status = ''DELINQUENT''';
2194: ELSIF l_delinquency_status = 'LITIGATION' THEN

Line 2197: ' FROM iex_litigations ltg, iex_delinquencies del' ||

2193: ' AND status = ''DELINQUENT''';
2194: ELSIF l_delinquency_status = 'LITIGATION' THEN
2195: l_sql_stmt_lsd := 'select count(1) from (' ||
2196: ' SELECT litigation_id' ||
2197: ' FROM iex_litigations ltg, iex_delinquencies del' ||
2198: ' WHERE del.party_cust_id = :party_id' ||
2199: ' AND ltg.delinquency_id = del.delinquency_id' ||
2200: ' AND del.status not in (''CURRENT'', ''CLOSE'')' ||
2201: ' AND ltg.disposition_code IS NULL ' ||

Line 2212: ' FROM iex_repossessions rps, iex_delinquencies del' ||

2208: ' AND disposition_code IS NULL )';
2209: ELSIF l_delinquency_status = 'REPOSSESSION' THEN
2210: l_sql_stmt_lsd := ' select count(1) from (' ||
2211: ' SELECT repossession_id' ||
2212: ' FROM iex_repossessions rps, iex_delinquencies del' ||
2213: ' WHERE del.party_cust_id = :party_id' ||
2214: ' AND rps.delinquency_id = del.delinquency_id' ||
2215: ' AND del.status not in (''CURRENT'', ''CLOSE'')' ||
2216: ' AND (rps.disposition_code IS NULL or rps.disposition_code = ''A'' or rps.disposition_code = ''W'') ' ||

Line 2229: ' FROM iex_writeoffs wrf, iex_delinquencies del' ||

2225: -- Bug 766183 ' AND disposition_code IS NULL )';
2226: ELSIF l_delinquency_status = 'WRITEOFF' THEN
2227: l_sql_stmt_lsd := ' select count(1) from (' ||
2228: ' SELECT writeoff_id' ||
2229: ' FROM iex_writeoffs wrf, iex_delinquencies del' ||
2230: ' WHERE del.party_cust_id = :party_id' ||
2231: ' AND wrf.delinquency_id = del.delinquency_id' ||
2232: ' AND del.status not in (''CURRENT'', ''CLOSE'')' ||
2233: ' AND (wrf.disposition_code IS NULL or wrf.disposition_code = ''A'' or wrf.disposition_code = ''W'') ' ||

Line 2246: ' FROM iex_delinquencies' ||

2242: -- ' AND disposition_code IS NULL )';
2243: -- fix bug #4157131
2244: ELSIF l_delinquency_status = 'PREDELINQUENT' THEN
2245: l_sql_stmt := 'SELECT count(1)' ||
2246: ' FROM iex_delinquencies' ||
2247: ' WHERE party_cust_id = :party_id' ||
2248: ' AND status = ''PREDELINQUENT''';
2249: END IF;
2250: