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_STRATEGY_CNT_PUB dependencies on IEX_DELINQUENCIES_ALL

Line 244: l_del_query := l_del_query || ' from iex_delinquencies_all d';

240: l_del_query := 'select d.party_cust_id, null, null, null, null, null,';
241: l_del_query := l_del_query || ' d.party_cust_id object_id, ''PARTY'' object_type, null';
242: l_del_query := l_del_query || ' , 10 strategy_level, d.PARTY_CUST_ID jtf_object_id, ''PARTY'' jtf_object_type';
243: l_del_query := l_del_query || ' , null status';
244: l_del_query := l_del_query || ' from iex_delinquencies_all d';
245: l_del_query := l_del_query || ' where d.status = ''' || l_DelStatusDel || '''';
246: --Bug#6870773 Naveen
247: if l_org_enabled = 'Y' then
248: l_del_query := l_del_query || ' and d.org_id = ' || l_org_id ;

Line 267: l_del_query := l_del_query || ' from iex_delinquencies_all d';

263: l_del_query := 'select d.party_cust_id, d.cust_account_id, null, null, null, null,';
264: l_del_query := l_del_query || ' d.cust_account_id object_id, ''ACCOUNT'' object_type, null,';
265: l_del_query := l_del_query || ' 20 strategy_level, d.cust_account_id jtf_object_id, ''IEX_ACCOUNT'' jtf_object_type';
266: l_del_query := l_del_query || ' , null status';
267: l_del_query := l_del_query || ' from iex_delinquencies_all d';
268: l_del_query := l_del_query || ' where d.status = ''' || l_DelStatusDel || '''';
269: --Bug#6870773 Naveen
270: if l_org_enabled = 'Y' then
271: l_del_query := l_del_query || ' and d.org_id = ' || l_org_id ;

Line 289: l_del_query := l_del_query || ' from iex_delinquencies_all d';

285: l_del_query := 'select d.party_cust_id, d.cust_account_id, d.customer_site_use_id, null, null, null,';
286: l_del_query := l_del_query || ' d.customer_site_use_id object_id, ''BILL_TO'' object_type, null,';
287: l_del_query := l_del_query || ' 30 strategy_level, d.customer_site_use_id jtf_object_id, ''IEX_BILLTO'' jtf_object_type';
288: l_del_query := l_del_query || ' , null status';
289: l_del_query := l_del_query || ' from iex_delinquencies_all d';
290: l_del_query := l_del_query || ' where d.status = ''' || l_DelStatusDel || '''';
291: --Bug#6870773 Naveen
292: if l_org_enabled = 'Y' then
293: l_del_query := l_del_query || ' and d.org_id = ' || l_org_id ;

Line 314: l_del_query := l_del_query || ' from iex_delinquencies_all d';

310: l_del_query := l_del_query || ' d.delinquency_id object_id, ''DELINQUENT'' object_type ,';
311: l_del_query := l_del_query || ' d.score_value, 40 strategy_level, d.delinquency_id jtf_object_id,';
312: l_del_query := l_del_query || ' ''IEX_DELINQUENCY'' jtf_object_type';
313: l_del_query := l_del_query || ' , d.status status';
314: l_del_query := l_del_query || ' from iex_delinquencies_all d';
315: l_del_query := l_del_query || ' where (d.status = ''' || l_DelStatusDel || '''' || ' or d.status = ''' || l_DelStatusPreDel || '''' || ')';
316: --Bug#6870773 Naveen
317: if l_org_enabled = 'Y' then
318: l_del_query := l_del_query || ' and d.org_id = ' || l_org_id ;

Line 336: l_del_query := l_del_query || ' from iex_delinquencies_all d';

332: l_del_query := l_del_query || ' d.delinquency_id object_id, ''DELINQUENT'' object_type ,';
333: l_del_query := l_del_query || ' d.score_value, 40 strategy_level, d.delinquency_id jtf_object_id,';
334: l_del_query := l_del_query || ' ''IEX_DELINQUENCY'' jtf_object_type';
335: l_del_query := l_del_query || ' , d.status status';
336: l_del_query := l_del_query || ' from iex_delinquencies_all d';
337: l_del_query := l_del_query || ' where d.status = ''' || l_DelStatusDel || '''';
338: --Bug#6870773 Naveen
339: if l_org_enabled = 'Y' then
340: l_del_query := l_del_query || ' and d.org_id = ' || l_org_id ;

Line 471: select c.creation_date from iex_delinquencies_all c

467: -- check grace period
468: -- c_gracePeriod c_gracePeriodCurTyp;
469: IF l_DefaultStrategyLevel = 10 THEN
470: OPEN c_gracePeriod FOR
471: select c.creation_date from iex_delinquencies_all c
472: where (c.status = l_DelStatusDel or c.status = l_delStatusPreDel)
473: and c.party_cust_id = l_stry_cnt_rec.PARTY_CUST_ID
474: order by c.creation_date desc;
475: elsif l_DefaultStrategyLevel = 20 THEN

Line 477: select c.creation_date from iex_delinquencies_all c

473: and c.party_cust_id = l_stry_cnt_rec.PARTY_CUST_ID
474: order by c.creation_date desc;
475: elsif l_DefaultStrategyLevel = 20 THEN
476: OPEN c_gracePeriod FOR
477: select c.creation_date from iex_delinquencies_all c
478: where (c.status = l_DelStatusDel or c.status = l_delStatusPreDel)
479: and c.party_cust_id = l_stry_cnt_rec.PARTY_CUST_ID
480: and c.cust_account_id = l_stry_cnt_rec.CUST_ACCOUNT_ID
481: order by c.creation_date desc;

Line 484: select c.creation_date from iex_delinquencies_all c

480: and c.cust_account_id = l_stry_cnt_rec.CUST_ACCOUNT_ID
481: order by c.creation_date desc;
482: elsif l_DefaultStrategyLevel = 30 THEN
483: OPEN c_gracePeriod FOR
484: select c.creation_date from iex_delinquencies_all c
485: where (c.status = l_DelStatusDel or c.status = l_delStatusPreDel)
486: and c.party_cust_id = l_stry_cnt_rec.PARTY_CUST_ID
487: and c.cust_account_id = l_stry_cnt_rec.CUST_ACCOUNT_ID
488: and c.customer_site_use_id = l_stry_cnt_rec.customer_site_use_ID

Line 492: select c.creation_date from iex_delinquencies_all c

488: and c.customer_site_use_id = l_stry_cnt_rec.customer_site_use_ID
489: order by c.creation_date desc;
490: ELSE
491: OPEN c_gracePeriod FOR
492: select c.creation_date from iex_delinquencies_all c
493: where (c.status = l_DelStatusDel or c.status = l_delStatusPreDel)
494: and c.party_cust_id = l_stry_cnt_rec.PARTY_CUST_ID
495: and c.cust_account_id = l_stry_cnt_rec.CUST_ACCOUNT_ID
496: and c.customer_site_use_id = l_stry_cnt_rec.customer_site_use_ID

Line 596: -- score in iex_strategies diff from score_histories/iex_delinquencies_all table

592: write_log(FND_LOG.LEVEL_PROCEDURE, 'Strategy score tolerance = ' || vScoreTolerance );
593: write_log(FND_LOG.LEVEL_PROCEDURE, 'Change Strategy = ' || vChangeStrategy );
594: END IF;
595:
596: -- score in iex_strategies diff from score_histories/iex_delinquencies_all table
597: -- and score history out of the strategy template score tolerance
598: -- and strategy template change strategy flag is Y
599: if (
600: ( (vScoreValue <> l_stry_cnt_rec.score_value)

Line 1056: select s.strategy_id, s.strategy_template_id, S.STATUS_CODE from iex_strategies s, iex_delinquencies_all d

1052:
1053: IF l_DefaultStrategyLevel = 10 THEN
1054: OPEN c_open_strategies
1055: FOR
1056: select s.strategy_id, s.strategy_template_id, S.STATUS_CODE from iex_strategies s, iex_delinquencies_all d
1057: where s.strategy_level = l_DefaultStrategyLevel and
1058: s.status_code IN (l_StratStatusOpen, l_StratStatusOnhold, l_StratStatusPending) and
1059: /* begin add for bug 4408860 - add checking CLOSE status from case delinquency */
1060: (d.status = l_DelStatusCurrent or d.status = l_DelStatusClose) and d.party_cust_id = s.party_id

Line 1062: and not exists (select null from iex_delinquencies_all dd where dd.status

1058: s.status_code IN (l_StratStatusOpen, l_StratStatusOnhold, l_StratStatusPending) and
1059: /* begin add for bug 4408860 - add checking CLOSE status from case delinquency */
1060: (d.status = l_DelStatusCurrent or d.status = l_DelStatusClose) and d.party_cust_id = s.party_id
1061: /* end add for bug 4408860 - add checking CLOSE status from case delinquency */
1062: and not exists (select null from iex_delinquencies_all dd where dd.status
1063: = l_DelStatusDel and dd.party_cust_id = s.party_id)
1064: --and dd.org_id = decode(l_org_enabled,'Y',l_org_id,dd.org_id))
1065:
1066: and nvl(s.org_id,-99) = decode(l_org_enabled,'Y',l_org_id,nvl(s.org_id,-99)) --Bug# 6870773 Naveen

Line 1073: select s.strategy_id, s.strategy_template_id, S.STATUS_CODE from iex_strategies s, iex_delinquencies_all d

1069:
1070: elsif l_DefaultStrategyLevel = 20 THEN
1071: OPEN c_open_strategies
1072: FOR
1073: select s.strategy_id, s.strategy_template_id, S.STATUS_CODE from iex_strategies s, iex_delinquencies_all d
1074: where s.strategy_level = l_DefaultStrategyLevel and
1075: s.status_code IN (l_StratStatusOpen, l_StratStatusOnhold, l_StratStatusPending) and
1076: /* begin add for bug 4408860 - add checking CLOSE status from case delinquency */
1077: (d.status = l_DelStatusCurrent or d.status = l_DelStatusClose) and d.CUST_ACCOUNT_id = s.CUST_ACCOUNT_id

Line 1079: and not exists (select null from iex_delinquencies_all dd where dd.status

1075: s.status_code IN (l_StratStatusOpen, l_StratStatusOnhold, l_StratStatusPending) and
1076: /* begin add for bug 4408860 - add checking CLOSE status from case delinquency */
1077: (d.status = l_DelStatusCurrent or d.status = l_DelStatusClose) and d.CUST_ACCOUNT_id = s.CUST_ACCOUNT_id
1078: /* end add for bug 4408860 - add checking CLOSE status from case delinquency */
1079: and not exists (select null from iex_delinquencies_all dd where dd.status
1080: = l_DelStatusDel and dd.CUST_ACCOUNT_id = s.CUST_ACCOUNT_id)
1081: --and dd.org_id = decode(l_org_enabled,'Y',l_org_id,dd.org_id))
1082: and nvl(s.org_id,-99) = decode(l_org_enabled,'Y',l_org_id,nvl(s.org_id,-99)) --Bug# 6870773 Naveen
1083: group by s.strategy_id, s.strategy_template_id, S.STATUS_CODE;

Line 1088: select s.strategy_id, s.strategy_template_id, S.STATUS_CODE from iex_strategies s, iex_delinquencies_all d

1084:
1085: elsif l_DefaultStrategyLevel = 30 THEN
1086: OPEN c_open_strategies
1087: FOR
1088: select s.strategy_id, s.strategy_template_id, S.STATUS_CODE from iex_strategies s, iex_delinquencies_all d
1089: where s.strategy_level = l_DefaultStrategyLevel and
1090: s.status_code IN (l_StratStatusOpen, l_StratStatusOnhold, l_StratStatusPending) and
1091: /* begin add for bug 4408860 - add checking CLOSE status from case delinquency */
1092: (d.status = l_DelStatusCurrent or d.status = l_DelStatusClose) and d.customer_site_use_id = s.customer_site_use_id

Line 1094: and not exists (select null from iex_delinquencies_all dd where dd.status

1090: s.status_code IN (l_StratStatusOpen, l_StratStatusOnhold, l_StratStatusPending) and
1091: /* begin add for bug 4408860 - add checking CLOSE status from case delinquency */
1092: (d.status = l_DelStatusCurrent or d.status = l_DelStatusClose) and d.customer_site_use_id = s.customer_site_use_id
1093: /* end add for bug 4408860 - add checking CLOSE status from case delinquency */
1094: and not exists (select null from iex_delinquencies_all dd where dd.status
1095: = l_DelStatusDel and dd.customer_site_use_id = s.customer_site_use_id)
1096: -- and dd.org_id = decode(l_org_enabled,'Y',l_org_id,dd.org_id))
1097: and nvl(s.org_id,-99) = decode(l_org_enabled,'Y',l_org_id,nvl(s.org_id,-99)) --Bug# 6870773 Naveen
1098: group by s.strategy_id, s.strategy_template_id, S.STATUS_CODE;

Line 1106: from iex_strategies s, iex_delinquencies_all d where d.status = l_DelStatusCurrent and

1102: /*
1103: OPEN c_open_strategies
1104: FOR
1105: select s.strategy_id, s.strategy_template_id, s.status_code
1106: from iex_strategies s, iex_delinquencies_all d where d.status = l_DelStatusCurrent and
1107: s.strategy_level = l_DefaultStrategyLevel and
1108: s.object_id = d.delinquency_id and
1109: s.status_code IN (l_StratStatusOpen, l_StratStatusOnhold, l_StratStatusPending);
1110: */

Line 1115: from iex_strategies s, iex_delinquencies_all d

1111: /* end bug 4253030 by ctlee 03/29/2005 */
1112: OPEN c_open_strategies
1113: FOR
1114: select s.strategy_id, s.strategy_template_id, s.status_code
1115: from iex_strategies s, iex_delinquencies_all d
1116: /* begin add for bug 4408860 - add checking CLOSE status from case delinquency */
1117: where (d.status = l_DelStatusCurrent or d.status = l_DelStatusClose) and
1118: /* end add for bug 4408860 - add checking CLOSE status from case delinquency */
1119: s.strategy_level = l_DefaultStrategyLevel and

Line 1185: from iex_strategies s, iex_delinquencies_all d

1181: select s.strategy_id strategy_id,
1182: s.strategy_template_id strategy_template_id,
1183: S.STATUS_CODE STATUS_CODE,
1184: d.party_cust_id party_id
1185: from iex_strategies s, iex_delinquencies_all d
1186: where s.strategy_level = 10 and
1187: s.status_code = 'ONHOLD' and
1188: d.status in ('DELINQUENT','PREDELINQUENT') and
1189: d.party_cust_id = s.party_id and

Line 1201: from iex_strategies s, iex_delinquencies_all d

1197: select s.strategy_id strategy_id,
1198: s.strategy_template_id strategy_template_id,
1199: S.STATUS_CODE STATUS_CODE,
1200: d.cust_account_id cust_account_id
1201: from iex_strategies s, iex_delinquencies_all d
1202: where s.strategy_level = 20 and
1203: s.status_code = 'ONHOLD' and
1204: d.status in ('DELINQUENT','PREDELINQUENT') and
1205: d.CUST_ACCOUNT_id = s.CUST_ACCOUNT_id and

Line 1217: from iex_strategies s, iex_delinquencies_all d

1213: select s.strategy_id strategy_id,
1214: s.strategy_template_id strategy_template_id,
1215: S.STATUS_CODE STATUS_CODE,
1216: d.customer_site_use_id billto_id
1217: from iex_strategies s, iex_delinquencies_all d
1218: where s.strategy_level = 30 and
1219: s.status_code = 'ONHOLD' and
1220: d.status in ('DELINQUENT','PREDELINQUENT') and
1221: d.customer_site_use_id = s.customer_site_use_id and

Line 1760: iex_delinquencies_all del

1756:
1757: cursor c_del_strat_wo_ou(p_org_id number)
1758: is select st.strategy_id,del.org_id
1759: from iex_strategies st,
1760: iex_delinquencies_all del
1761: where st.object_type='DELINQUENT'
1762: and st.org_id is null
1763: and st.object_id=del.delinquency_id
1764: and del.org_id = p_org_id;