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 996: from dual

992: --iex_delinquencies
993: where payment_schedule_id = idb.score_object_id)
994: AND NOT EXISTS
995: (select 1
996: from dual
997: where IDS.del_status = vf_current)
998: AND HZCA.cust_account_id = ARPS.customer_id
999: AND ARPS.payment_schedule_id = IDB.score_object_id
1000: AND IDB.score_value between

Line 1219: from dual

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

Line 1449: from dual

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

Line 1885: From dual ;

1881: into
1882: --v_org_id , --Commneted for MOAC
1883: v_user_id ,
1884: v_today
1885: From dual ;
1886:
1887: -- Loop Through the Table of Cases and Create Delinquencies.
1888: IF p_object_code = 'IEX_CASE' then
1889: FOR cnt IN v_first..v_last

Line 1894: From dual ;

1890: LOOP
1891:
1892: Select IEX_DELINQUENCIES_S.NEXTVAL
1893: into x_del_id_tbl(v_count)
1894: From dual ;
1895:
1896: INSERT INTO IEX_DELINQUENCIES_ALL
1897: (DELINQUENCY_ID ,
1898: LAST_UPDATE_DATE ,

Line 1934: from dual;

1930: IEX_DEBUG_PUB.LOGMESSAGE('In for Current invoice insertion....');
1931:
1932: select IEX_DELINQUENCIES_S.NEXTVAL
1933: into l_deln_id
1934: from dual;
1935:
1936: if p_object_id_tbl.count = 1 then
1937: for i in v_first..v_last loop
1938:

Line 2348: FROM dual

2344: update IEX_DLN_UWQ_SUMMARY sum
2345: set
2346: sum.active_delinquencies =
2347: (SELECT 1
2348: FROM dual
2349: WHERE EXISTS
2350: (SELECT 1
2351: FROM iex_delinquencies_all
2352: WHERE party_cust_id = sum.party_id

Line 2360: FROM dual

2356: )
2357: ),
2358: sum.complete_delinquencies =
2359: (SELECT 1
2360: FROM dual
2361: WHERE EXISTS
2362: (SELECT 1
2363: FROM iex_delinquencies_all
2364: WHERE party_cust_id = sum.party_id

Line 2371: FROM dual

2367: AND(TRUNC(uwq_complete_date) + fnd_profile.VALUE('IEX_UWQ_COMPLETION_DAYS') > TRUNC(sysdate))))
2368: ),
2369: sum.pending_delinquencies =
2370: (SELECT 1
2371: FROM dual
2372: WHERE EXISTS
2373: (SELECT 1
2374: FROM iex_delinquencies_all
2375: WHERE party_cust_id = sum.party_id

Line 2391: FROM dual

2387: update IEX_DLN_UWQ_SUMMARY sum
2388: set
2389: sum.active_delinquencies =
2390: (SELECT 1
2391: FROM dual
2392: WHERE EXISTS
2393: (SELECT 1
2394: FROM iex_delinquencies_all
2395: WHERE party_cust_id = party_id

Line 2403: FROM dual

2399: )
2400: ),
2401: sum.complete_delinquencies =
2402: (SELECT 1
2403: FROM dual
2404: WHERE EXISTS
2405: (SELECT 1
2406: FROM iex_delinquencies_all
2407: WHERE cust_account_id = sum.cust_account_id

Line 2414: FROM dual

2410: AND(TRUNC(uwq_complete_date) + fnd_profile.VALUE('IEX_UWQ_COMPLETION_DAYS') > TRUNC(sysdate))))
2411: ),
2412: sum.pending_delinquencies =
2413: (SELECT 1
2414: FROM dual
2415: WHERE EXISTS
2416: (SELECT 1
2417: FROM iex_delinquencies_all
2418: WHERE cust_account_id = sum.cust_account_id

Line 2434: FROM dual

2430: update IEX_DLN_UWQ_SUMMARY sum
2431: set
2432: sum.active_delinquencies =
2433: (SELECT 1
2434: FROM dual
2435: WHERE EXISTS
2436: (SELECT 1
2437: FROM iex_delinquencies_all
2438: WHERE customer_site_use_id = sum.site_use_id

Line 2446: FROM dual

2442: )
2443: ),
2444: sum.complete_delinquencies =
2445: (SELECT 1
2446: FROM dual
2447: WHERE EXISTS
2448: (SELECT 1
2449: FROM iex_delinquencies_all
2450: WHERE customer_site_use_id = sum.site_use_id

Line 2457: FROM dual

2453: AND(TRUNC(uwq_complete_date) + fnd_profile.VALUE('IEX_UWQ_COMPLETION_DAYS') > TRUNC(sysdate))))
2454: ),
2455: sum.pending_delinquencies =
2456: (SELECT 1
2457: FROM dual
2458: WHERE EXISTS
2459: (SELECT 1
2460: FROM iex_delinquencies_all
2461: WHERE customer_site_use_id = sum.site_use_id