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_DELINQUENCY_PUB dependencies on DUAL

Line 335: select iex_del_wf_s.nextval INTO l_seq from dual;

331: IEX_DEBUG_PUB.logMessage('Program Run Date:'||SYSDATE);
332: END IF;
333:
334:
335: select iex_del_wf_s.nextval INTO l_seq from dual;
336: l_key := l_event_name ||'-'||l_request_id || '-'||l_seq;
337: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
338: IEX_DEBUG_PUB.logMessage(' EVENT KEY ' ||l_key );
339: IEX_DEBUG_PUB.logMessage(

Line 467: from dual

463: from iex_delinquencies
464: where payment_schedule_id = idb.score_object_id)
465: AND NOT EXISTS
466: (select 1
467: from dual
468: where IDS.del_status = vf_current)
469: AND HZCA.cust_account_id = ARPS.customer_id
470: AND ARPS.payment_schedule_id = IDB.score_object_id
471: AND IDB.score_value between

Line 496: from dual

492: iex_del_buffers idb,
493: iex_del_statuses ids
494: where NOT EXISTS
495: (select 1
496: from dual
497: where id.status = ids.del_status)
498: and idb.score_id = ids.score_id
499: and idb.score_value between ids.score_value_low
500: and ids.score_value_high

Line 644: From dual ;

640: into --v_org_id, --Commneted for MOAC
641: v_user_id,
642: v_debug_level,
643: v_today
644: From dual ;
645:
646: Select count(1)
647: into v_score_range
648: from iex_del_statuses

Line 703: from dual

699: iex_del_buffers idb,
700: iex_del_statuses ids
701: where NOT EXISTS
702: (select 1
703: from dual
704: -- Begin - Andre Araujo - 12/21/2004 - Remove the pre-del 2 del constraint bug#4072687
705: --where (id.status = vf_delinquent
706: -- and ids.del_status = vf_predelinquent)
707: -- OR id.status = ids.del_status)

Line 997: from dual

993: where payment_schedule_id = idb.score_object_id)
994: -- start bug 9794774 sunagesh 11 jul 2011
995: /* AND NOT EXISTS
996: (select 1
997: from dual
998: where IDS.del_status = vf_current) */
999: AND IDS.del_status <> vf_current
1000: -- end bug 9794774 sunagesh 11 jul 2011
1001: AND HZCA.cust_account_id = ARPS.customer_id

Line 1222: from dual

1218: iex_del_statuses ids
1219: where
1220: NOT EXISTS
1221: (select 1
1222: from dual
1223: where (id.status = vf_delinquent and ids.del_status = vf_predelinquent)
1224: OR id.status = ids.del_status)
1225: and idb.score_id = ids.score_id
1226: and idb.score_value between ids.score_value_low

Line 1452: from dual

1448: from iex_delinquencies
1449: where case_id = idb.score_object_id)
1450: AND NOT EXISTS
1451: (select 1
1452: from dual
1453: where IDS.del_status = vf_current)
1454: AND ICV.cas_id = IDB.score_object_id
1455: AND IDB.score_value between
1456: IDS.score_value_low and IDS.score_value_high

Line 1958: From dual ;

1954: into
1955: --v_org_id , --Commneted for MOAC
1956: v_user_id ,
1957: v_today
1958: From dual ;
1959:
1960: -- Loop Through the Table of Cases and Create Delinquencies.
1961: IF p_object_code = 'IEX_CASE' then
1962: FOR cnt IN v_first..v_last

Line 1967: From dual ;

1963: LOOP
1964:
1965: Select IEX_DELINQUENCIES_S.NEXTVAL
1966: into x_del_id_tbl(v_count)
1967: From dual ;
1968:
1969: INSERT INTO IEX_DELINQUENCIES_ALL
1970: (DELINQUENCY_ID ,
1971: LAST_UPDATE_DATE ,

Line 2007: from dual;

2003: IEX_DEBUG_PUB.LOGMESSAGE('In for Current invoice insertion....');
2004:
2005: select IEX_DELINQUENCIES_S.NEXTVAL
2006: into l_deln_id
2007: from dual;
2008:
2009: if p_object_id_tbl.count = 1 then
2010: for i in v_first..v_last loop
2011:

Line 2425: FROM dual

2421: update IEX_DLN_UWQ_SUMMARY sum
2422: set
2423: sum.active_delinquencies =
2424: (SELECT 1
2425: FROM dual
2426: WHERE EXISTS
2427: (SELECT 1
2428: FROM iex_delinquencies_all
2429: WHERE party_cust_id = sum.party_id

Line 2437: FROM dual

2433: )
2434: ),
2435: sum.complete_delinquencies =
2436: (SELECT 1
2437: FROM dual
2438: WHERE EXISTS
2439: (SELECT 1
2440: FROM iex_delinquencies_all
2441: WHERE party_cust_id = sum.party_id

Line 2448: FROM dual

2444: AND(TRUNC(uwq_complete_date) + fnd_profile.VALUE('IEX_UWQ_COMPLETION_DAYS') > TRUNC(sysdate))))
2445: ),
2446: sum.pending_delinquencies =
2447: (SELECT 1
2448: FROM dual
2449: WHERE EXISTS
2450: (SELECT 1
2451: FROM iex_delinquencies_all
2452: WHERE party_cust_id = sum.party_id

Line 2468: FROM dual

2464: update IEX_DLN_UWQ_SUMMARY sum
2465: set
2466: sum.active_delinquencies =
2467: (SELECT 1
2468: FROM dual
2469: WHERE EXISTS
2470: (SELECT 1
2471: FROM iex_delinquencies_all
2472: WHERE party_cust_id = party_id

Line 2480: FROM dual

2476: )
2477: ),
2478: sum.complete_delinquencies =
2479: (SELECT 1
2480: FROM dual
2481: WHERE EXISTS
2482: (SELECT 1
2483: FROM iex_delinquencies_all
2484: WHERE cust_account_id = sum.cust_account_id

Line 2491: FROM dual

2487: AND(TRUNC(uwq_complete_date) + fnd_profile.VALUE('IEX_UWQ_COMPLETION_DAYS') > TRUNC(sysdate))))
2488: ),
2489: sum.pending_delinquencies =
2490: (SELECT 1
2491: FROM dual
2492: WHERE EXISTS
2493: (SELECT 1
2494: FROM iex_delinquencies_all
2495: WHERE cust_account_id = sum.cust_account_id

Line 2511: FROM dual

2507: update IEX_DLN_UWQ_SUMMARY sum
2508: set
2509: sum.active_delinquencies =
2510: (SELECT 1
2511: FROM dual
2512: WHERE EXISTS
2513: (SELECT 1
2514: FROM iex_delinquencies_all
2515: WHERE customer_site_use_id = sum.site_use_id

Line 2523: FROM dual

2519: )
2520: ),
2521: sum.complete_delinquencies =
2522: (SELECT 1
2523: FROM dual
2524: WHERE EXISTS
2525: (SELECT 1
2526: FROM iex_delinquencies_all
2527: WHERE customer_site_use_id = sum.site_use_id

Line 2534: FROM dual

2530: AND(TRUNC(uwq_complete_date) + fnd_profile.VALUE('IEX_UWQ_COMPLETION_DAYS') > TRUNC(sysdate))))
2531: ),
2532: sum.pending_delinquencies =
2533: (SELECT 1
2534: FROM dual
2535: WHERE EXISTS
2536: (SELECT 1
2537: FROM iex_delinquencies_all
2538: WHERE customer_site_use_id = sum.site_use_id