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

Line 432: ' iex_delinquencies_all delin ' ||

428: ' hz_party_sites party_site, ' ||
429: ' hz_cust_accounts ca, ' ||
430: ' hz_cust_site_uses_all site_uses, ' ||
431: ' hz_parties p,' ||
432: ' iex_delinquencies_all delin ' ||
433: ' WHERE acct_sites.cust_account_id = ca.cust_account_id ' ||
434: ' AND acct_sites.party_site_id = party_site.party_site_id ' ||
435: ' AND acct_sites.cust_acct_site_id = site_uses.cust_acct_site_id ' ||
436: ' AND site_uses.site_use_code = ''BILL_TO'' ' ||

Line 896: ' FROM IEX_DELINQUENCIES del' ||

892: ' ,party_cust_id ' ||
893: ' ,cust_account_id ' ||
894: ' ,customer_site_use_id ' ||
895: --' ,score_value ' ||
896: ' FROM IEX_DELINQUENCIES del' ||
897: ' ,iex_dunning_plans_vl ' ||
898: ' WHERE STATUS in (''DELINQUENT'', ''PREDELINQUENT'') ' ||
899: ' AND DELINQUENCY_ID = :1 ' ||
900: ' AND iex_dunning_plans_vl.dunning_plan_id = :p_dunning_plan_id ' ;

Line 933: select count(*) into t_cnt from iex_delinquencies , iex_dunning_plans_vl

929: end if;
930:
931: -- Begin Bills Receivables
932: begin
933: select count(*) into t_cnt from iex_delinquencies , iex_dunning_plans_vl
934: where (status = DECODE(include_current,'Y','CURRENT','') or status in ('PREDELINQUENT','DELINQUENT'))
935: and exists (select 1 from hz_cust_site_uses_all site_uses where site_use_code = 'BILL_TO' and site_uses.site_use_id = customer_site_use_id)
936: and iex_dunning_plans_vl.dunning_plan_id = p_dunning_plan_id;
937:

Line 943: -- fetch the party/account/site_use/delinquency from iex_delinquencies table

939: when others then null;
940: end;
941: -- end Bills Receivables
942:
943: -- fetch the party/account/site_use/delinquency from iex_delinquencies table
944: if p_parent_request_id is null then
945: /*
946: vPLSQL := ' SELECT distinct ' || vSelectColumn ||
947: ' FROM IEX_DELINQUENCIES , IEX_DUNNING_PLANS_VL '||

Line 947: ' FROM IEX_DELINQUENCIES , IEX_DUNNING_PLANS_VL '||

943: -- fetch the party/account/site_use/delinquency from iex_delinquencies table
944: if p_parent_request_id is null then
945: /*
946: vPLSQL := ' SELECT distinct ' || vSelectColumn ||
947: ' FROM IEX_DELINQUENCIES , IEX_DUNNING_PLANS_VL '||
948: ' where (status = DECODE(include_current,''Y'',''CURRENT'','' '') or status in (''PREDELINQUENT'',''DELINQUENT'')) ' || -- Bills Receivables
949: ' and iex_dunning_plans_vl.dunning_plan_id = :p_dunning_plan_id ' ||
950: ' order by ' || vSelectColumn;
951: */

Line 955: ' FROM IEX_DELINQUENCIES , IEX_DUNNING_PLANS_VL '||

951: */
952: /* bug 16303059 start...
953: if t_cnt > 0 then
954: vPLSQL := ' SELECT distinct ' || vSelectColumn ||
955: ' FROM IEX_DELINQUENCIES , IEX_DUNNING_PLANS_VL '||
956: ' where (status = DECODE(include_current,''Y'',''CURRENT'','' '') or status in (''PREDELINQUENT'',''DELINQUENT'')) ' || -- Bills Receivables
957: ' and exists (select 1 from hz_cust_site_uses_all site_uses where site_use_code = ''BILL_TO'' and site_uses.site_use_id = customer_site_use_id) ' ||
958: -- ' WHERE STATUS in (''DELINQUENT'', ''PREDELINQUENT'') ' || Bills Receivables
959: ' and iex_dunning_plans_vl.dunning_plan_id = :p_dunning_plan_id ' ||

Line 964: ' FROM IEX_DELINQUENCIES , IEX_DUNNING_PLANS_VL '||

960: ' order by ' || vSelectColumn;
961: else
962: bug 16303059 end... */
963: vPLSQL := ' SELECT distinct ' || vSelectColumn ||
964: ' FROM IEX_DELINQUENCIES , IEX_DUNNING_PLANS_VL '||
965: ' where (status = DECODE(include_current,''Y'',''CURRENT'','' '') or status in (''PREDELINQUENT'',''DELINQUENT'')) '|| -- Bills Receivables
966: ' and exists (select 1 from hz_cust_site_uses_all site_uses where (site_use_code = ''DRAWEE'' or site_use_code = ''BILL_TO'') and site_uses.site_use_id = customer_site_use_id) ' ||
967: ' and iex_dunning_plans_vl.dunning_plan_id = :p_dunning_plan_id ' ||
968: ' order by ' || vSelectColumn;

Line 1432: update iex_delinquencies_all

1428: exit when sql_cur5%NOTFOUND;
1429: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_payment_schedule_id :' || l_payment_schedule_id);
1430: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_stage_number :' || l_stage_number);
1431:
1432: update iex_delinquencies_all
1433: set staged_dunning_level = l_stage_number
1434: where payment_schedule_id = l_payment_schedule_id;
1435: end loop;
1436: close sql_cur5;

Line 2569: from iex_delinquencies_all iex,

2565:
2566: cursor c_staged_dunning_level is
2567: select ar.staged_dunning_level,
2568: ar.payment_schedule_id
2569: from iex_delinquencies_all iex,
2570: ar_payment_schedules_all ar
2571: where iex.payment_schedule_id = ar.payment_schedule_id
2572: and ar.staged_dunning_level is not null
2573: and iex.staged_dunning_level is null

Line 2801: --Copy the Staged level of an Invoice from AR_PAYMENT_SCHEDULES_ALL table to IEX_DELINQUENCIES_ALL table.

2797: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2798:
2799: l_staged_dunning_level.delete;
2800: l_payment_schedule_id.delete;
2801: --Copy the Staged level of an Invoice from AR_PAYMENT_SCHEDULES_ALL table to IEX_DELINQUENCIES_ALL table.
2802: --It will update only the records that have staged_dunning_level as NULL
2803: BEGIN
2804: OPEN c_staged_dunning_level;
2805: LOOP

Line 2812: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - No of rows updated in iex_delinquencies_all is: ' || l_no_updated_rows);

2808: l_payment_schedule_id
2809: LIMIT G_BATCH_SIZE;
2810: IF l_staged_dunning_level.count = 0 THEN
2811:
2812: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - No of rows updated in iex_delinquencies_all is: ' || l_no_updated_rows);
2813: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Exit after Updating iex_delinquencies_all staged_dunning_level...');
2814: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2815: FND_FILE.PUT_LINE(FND_FILE.LOG, '3. Copied Transaction''s stage level from AR to Advanced Collections. No of rows updated in iex_delinquencies_all table is: ' || l_no_updated_rows);
2816: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

Line 2813: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Exit after Updating iex_delinquencies_all staged_dunning_level...');

2809: LIMIT G_BATCH_SIZE;
2810: IF l_staged_dunning_level.count = 0 THEN
2811:
2812: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - No of rows updated in iex_delinquencies_all is: ' || l_no_updated_rows);
2813: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Exit after Updating iex_delinquencies_all staged_dunning_level...');
2814: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2815: FND_FILE.PUT_LINE(FND_FILE.LOG, '3. Copied Transaction''s stage level from AR to Advanced Collections. No of rows updated in iex_delinquencies_all table is: ' || l_no_updated_rows);
2816: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2817: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Used the following SQL to copy the Transaction''s stage level from AR to Advanced Collections.');

Line 2815: FND_FILE.PUT_LINE(FND_FILE.LOG, '3. Copied Transaction''s stage level from AR to Advanced Collections. No of rows updated in iex_delinquencies_all table is: ' || l_no_updated_rows);

2811:
2812: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - No of rows updated in iex_delinquencies_all is: ' || l_no_updated_rows);
2813: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Exit after Updating iex_delinquencies_all staged_dunning_level...');
2814: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2815: FND_FILE.PUT_LINE(FND_FILE.LOG, '3. Copied Transaction''s stage level from AR to Advanced Collections. No of rows updated in iex_delinquencies_all table is: ' || l_no_updated_rows);
2816: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2817: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Used the following SQL to copy the Transaction''s stage level from AR to Advanced Collections.');
2818: FND_FILE.PUT_LINE(FND_FILE.LOG, ' UPDATE IEX_DELINQUENCIES_ALL IEX ');
2819: FND_FILE.PUT_LINE(FND_FILE.LOG, ' SET STAGED_DUNNING_LEVEL = l_staged_dunning_level (I) ');

Line 2818: FND_FILE.PUT_LINE(FND_FILE.LOG, ' UPDATE IEX_DELINQUENCIES_ALL IEX ');

2814: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2815: FND_FILE.PUT_LINE(FND_FILE.LOG, '3. Copied Transaction''s stage level from AR to Advanced Collections. No of rows updated in iex_delinquencies_all table is: ' || l_no_updated_rows);
2816: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2817: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Used the following SQL to copy the Transaction''s stage level from AR to Advanced Collections.');
2818: FND_FILE.PUT_LINE(FND_FILE.LOG, ' UPDATE IEX_DELINQUENCIES_ALL IEX ');
2819: FND_FILE.PUT_LINE(FND_FILE.LOG, ' SET STAGED_DUNNING_LEVEL = l_staged_dunning_level (I) ');
2820: FND_FILE.PUT_LINE(FND_FILE.LOG, ' WHERE PAYMENT_SCHEDULE_ID = l_payment_schedule_id(I); ');
2821: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2822:

Line 2827: UPDATE IEX_DELINQUENCIES_ALL IEX

2823: CLOSE c_staged_dunning_level;
2824: EXIT;
2825: ELSE
2826: FORALL I IN l_staged_dunning_level.first..l_staged_dunning_level.last
2827: UPDATE IEX_DELINQUENCIES_ALL IEX
2828: SET STAGED_DUNNING_LEVEL = l_staged_dunning_level (I)
2829: WHERE PAYMENT_SCHEDULE_ID = l_payment_schedule_id(I);
2830:
2831: l_no_updated_rows := l_no_updated_rows + l_staged_dunning_level.count;

Line 2838: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' Rows updated in iex_delinquencies_all staged_dunning_level...');

2834: l_payment_schedule_id.delete;
2835:
2836: commit;
2837:
2838: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' Rows updated in iex_delinquencies_all staged_dunning_level...');
2839: FND_FILE.PUT_LINE(FND_FILE.LOG, '3. Copied Transactions stage level from AR to Advanced Collections');
2840: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2841:
2842: END IF;