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_DUNNING_PLANS_VL

Line 409: , iex_dunning_plans_vl

405: cust_account_id,
406: customer_site_use_id,
407: score_value
408: FROM IEX_DELINQUENCIES
409: , iex_dunning_plans_vl
410: WHERE STATUS in ('DELINQUENT', 'PREDELINQUENT')
411: and iex_dunning_plans_vl.dunning_plan_id = p_dunning_plan_id
412: and iex_delinquencies.score_id = iex_dunning_plans_vl.score_id;
413: --AND DUNN_YN = 'Y';

Line 411: and iex_dunning_plans_vl.dunning_plan_id = p_dunning_plan_id

407: score_value
408: FROM IEX_DELINQUENCIES
409: , iex_dunning_plans_vl
410: WHERE STATUS in ('DELINQUENT', 'PREDELINQUENT')
411: and iex_dunning_plans_vl.dunning_plan_id = p_dunning_plan_id
412: and iex_delinquencies.score_id = iex_dunning_plans_vl.score_id;
413: --AND DUNN_YN = 'Y';
414: --
415: -- Changed by gnramasa for bug 5661324 14-Mar-07

Line 412: and iex_delinquencies.score_id = iex_dunning_plans_vl.score_id;

408: FROM IEX_DELINQUENCIES
409: , iex_dunning_plans_vl
410: WHERE STATUS in ('DELINQUENT', 'PREDELINQUENT')
411: and iex_dunning_plans_vl.dunning_plan_id = p_dunning_plan_id
412: and iex_delinquencies.score_id = iex_dunning_plans_vl.score_id;
413: --AND DUNN_YN = 'Y';
414: --
415: -- Changed by gnramasa for bug 5661324 14-Mar-07
416: /* CURSOR C_GET_CUSTOMER (p_dunning_plan_id number) IS

Line 419: , iex_dunning_plans_vl

415: -- Changed by gnramasa for bug 5661324 14-Mar-07
416: /* CURSOR C_GET_CUSTOMER (p_dunning_plan_id number) IS
417: SELECT distinct party_cust_id
418: FROM IEX_DELINQUENCIES
419: , iex_dunning_plans_vl
420: WHERE STATUS in ('DELINQUENT', 'PREDELINQUENT')
421: and iex_dunning_plans_vl.dunning_plan_id = p_dunning_plan_id
422: -- begin bug 4914799 ctlee 12/30/2005, party/account/site level dunning does not have score in delinquency
423: -- and iex_delinquencies.score_id = iex_dunning_plans_vl.score_id

Line 421: and iex_dunning_plans_vl.dunning_plan_id = p_dunning_plan_id

417: SELECT distinct party_cust_id
418: FROM IEX_DELINQUENCIES
419: , iex_dunning_plans_vl
420: WHERE STATUS in ('DELINQUENT', 'PREDELINQUENT')
421: and iex_dunning_plans_vl.dunning_plan_id = p_dunning_plan_id
422: -- begin bug 4914799 ctlee 12/30/2005, party/account/site level dunning does not have score in delinquency
423: -- and iex_delinquencies.score_id = iex_dunning_plans_vl.score_id
424: -- end bug 4914799 ctlee 12/30/2005, party/account/site level dunning does not have score in delinquency
425: --AND DUNN_YN = 'Y'

Line 423: -- and iex_delinquencies.score_id = iex_dunning_plans_vl.score_id

419: , iex_dunning_plans_vl
420: WHERE STATUS in ('DELINQUENT', 'PREDELINQUENT')
421: and iex_dunning_plans_vl.dunning_plan_id = p_dunning_plan_id
422: -- begin bug 4914799 ctlee 12/30/2005, party/account/site level dunning does not have score in delinquency
423: -- and iex_delinquencies.score_id = iex_dunning_plans_vl.score_id
424: -- end bug 4914799 ctlee 12/30/2005, party/account/site level dunning does not have score in delinquency
425: --AND DUNN_YN = 'Y'
426: order by party_cust_id;
427: --

Line 431: , iex_dunning_plans_vl

427: --
428: CURSOR C_GET_CUSTOMER_DEL( in_party_id NUMBER, p_dunning_plan_id number) IS
429: SELECT party_cust_id, cust_account_id, customer_site_use_id, delinquency_ID
430: FROM IEX_DELINQUENCIES
431: , iex_dunning_plans_vl
432: WHERE STATUS in ('DELINQUENT', 'PREDELINQUENT')
433: AND party_cust_id = in_party_id
434: and iex_dunning_plans_vl.dunning_plan_id = p_dunning_plan_id
435: -- begin bug 4914799 ctlee 12/30/2005, party/account/site level dunning does not have score in delinquency

Line 434: and iex_dunning_plans_vl.dunning_plan_id = p_dunning_plan_id

430: FROM IEX_DELINQUENCIES
431: , iex_dunning_plans_vl
432: WHERE STATUS in ('DELINQUENT', 'PREDELINQUENT')
433: AND party_cust_id = in_party_id
434: and iex_dunning_plans_vl.dunning_plan_id = p_dunning_plan_id
435: -- begin bug 4914799 ctlee 12/30/2005, party/account/site level dunning does not have score in delinquency
436: -- and iex_delinquencies.score_id = iex_dunning_plans_vl.score_id
437: -- end bug 4914799 ctlee 12/30/2005, party/account/site level dunning does not have score in delinquency
438: --AND DUNN_YN = 'Y'

Line 436: -- and iex_delinquencies.score_id = iex_dunning_plans_vl.score_id

432: WHERE STATUS in ('DELINQUENT', 'PREDELINQUENT')
433: AND party_cust_id = in_party_id
434: and iex_dunning_plans_vl.dunning_plan_id = p_dunning_plan_id
435: -- begin bug 4914799 ctlee 12/30/2005, party/account/site level dunning does not have score in delinquency
436: -- and iex_delinquencies.score_id = iex_dunning_plans_vl.score_id
437: -- end bug 4914799 ctlee 12/30/2005, party/account/site level dunning does not have score in delinquency
438: --AND DUNN_YN = 'Y'
439: ORDER BY cust_account_id, delinquency_id;
440: --

Line 444: , iex_dunning_plans_vl

440: --
441: CURSOR C_GET_ACCOUNT (p_dunning_plan_id number) IS
442: SELECT distinct cust_account_id
443: FROM IEX_DELINQUENCIES
444: , iex_dunning_plans_vl
445: WHERE STATUS in ('DELINQUENT', 'PREDELINQUENT')
446: and iex_dunning_plans_vl.dunning_plan_id = p_dunning_plan_id
447: -- begin bug 4914799 ctlee 12/30/2005, party/account/site level dunning does not have score in delinquency
448: -- and iex_delinquencies.score_id = iex_dunning_plans_vl.score_id

Line 446: and iex_dunning_plans_vl.dunning_plan_id = p_dunning_plan_id

442: SELECT distinct cust_account_id
443: FROM IEX_DELINQUENCIES
444: , iex_dunning_plans_vl
445: WHERE STATUS in ('DELINQUENT', 'PREDELINQUENT')
446: and iex_dunning_plans_vl.dunning_plan_id = p_dunning_plan_id
447: -- begin bug 4914799 ctlee 12/30/2005, party/account/site level dunning does not have score in delinquency
448: -- and iex_delinquencies.score_id = iex_dunning_plans_vl.score_id
449: -- end bug 4914799 ctlee 12/30/2005, party/account/site level dunning does not have score in delinquency
450: --AND DUNN_YN = 'Y'

Line 448: -- and iex_delinquencies.score_id = iex_dunning_plans_vl.score_id

444: , iex_dunning_plans_vl
445: WHERE STATUS in ('DELINQUENT', 'PREDELINQUENT')
446: and iex_dunning_plans_vl.dunning_plan_id = p_dunning_plan_id
447: -- begin bug 4914799 ctlee 12/30/2005, party/account/site level dunning does not have score in delinquency
448: -- and iex_delinquencies.score_id = iex_dunning_plans_vl.score_id
449: -- end bug 4914799 ctlee 12/30/2005, party/account/site level dunning does not have score in delinquency
450: --AND DUNN_YN = 'Y'
451: ORDER BY cust_account_id;
452: --

Line 456: , iex_dunning_plans_vl

452: --
453: CURSOR C_GET_ACCOUNT_DEL(IN_ACCOUNT_ID NUMBER, p_dunning_plan_id number) IS
454: SELECT party_cust_id, cust_account_id, customer_site_use_id, delinquency_ID
455: FROM IEX_DELINQUENCIES
456: , iex_dunning_plans_vl
457: WHERE STATUS in ('DELINQUENT', 'PREDELINQUENT')
458: --AND DUNN_YN = 'Y'
459: AND cust_account_id = in_account_id
460: and iex_dunning_plans_vl.dunning_plan_id = p_dunning_plan_id

Line 460: and iex_dunning_plans_vl.dunning_plan_id = p_dunning_plan_id

456: , iex_dunning_plans_vl
457: WHERE STATUS in ('DELINQUENT', 'PREDELINQUENT')
458: --AND DUNN_YN = 'Y'
459: AND cust_account_id = in_account_id
460: and iex_dunning_plans_vl.dunning_plan_id = p_dunning_plan_id
461: -- begin bug 4914799 ctlee 12/30/2005, party/account/site level dunning does not have score in delinquency
462: -- and iex_delinquencies.score_id = iex_dunning_plans_vl.score_id
463: -- end bug 4914799 ctlee 12/30/2005, party/account/site level dunning does not have score in delinquency
464: ORDER BY cust_account_id, delinquency_id;

Line 462: -- and iex_delinquencies.score_id = iex_dunning_plans_vl.score_id

458: --AND DUNN_YN = 'Y'
459: AND cust_account_id = in_account_id
460: and iex_dunning_plans_vl.dunning_plan_id = p_dunning_plan_id
461: -- begin bug 4914799 ctlee 12/30/2005, party/account/site level dunning does not have score in delinquency
462: -- and iex_delinquencies.score_id = iex_dunning_plans_vl.score_id
463: -- end bug 4914799 ctlee 12/30/2005, party/account/site level dunning does not have score in delinquency
464: ORDER BY cust_account_id, delinquency_id;
465: --
466: CURSOR C_GET_SITE (p_dunning_plan_id number) IS

Line 469: , iex_dunning_plans_vl

465: --
466: CURSOR C_GET_SITE (p_dunning_plan_id number) IS
467: SELECT distinct customer_site_use_id
468: FROM IEX_DELINQUENCIES
469: , iex_dunning_plans_vl
470: WHERE STATUS in ('DELINQUENT', 'PREDELINQUENT')
471: and iex_dunning_plans_vl.dunning_plan_id = p_dunning_plan_id
472: -- begin bug 4914799 ctlee 12/30/2005, party/account/site level dunning does not have score in delinquency
473: -- and iex_delinquencies.score_id = iex_dunning_plans_vl.score_id

Line 471: and iex_dunning_plans_vl.dunning_plan_id = p_dunning_plan_id

467: SELECT distinct customer_site_use_id
468: FROM IEX_DELINQUENCIES
469: , iex_dunning_plans_vl
470: WHERE STATUS in ('DELINQUENT', 'PREDELINQUENT')
471: and iex_dunning_plans_vl.dunning_plan_id = p_dunning_plan_id
472: -- begin bug 4914799 ctlee 12/30/2005, party/account/site level dunning does not have score in delinquency
473: -- and iex_delinquencies.score_id = iex_dunning_plans_vl.score_id
474: -- end bug 4914799 ctlee 12/30/2005, party/account/site level dunning does not have score in delinquency
475: ORDER BY customer_site_use_id;

Line 473: -- and iex_delinquencies.score_id = iex_dunning_plans_vl.score_id

469: , iex_dunning_plans_vl
470: WHERE STATUS in ('DELINQUENT', 'PREDELINQUENT')
471: and iex_dunning_plans_vl.dunning_plan_id = p_dunning_plan_id
472: -- begin bug 4914799 ctlee 12/30/2005, party/account/site level dunning does not have score in delinquency
473: -- and iex_delinquencies.score_id = iex_dunning_plans_vl.score_id
474: -- end bug 4914799 ctlee 12/30/2005, party/account/site level dunning does not have score in delinquency
475: ORDER BY customer_site_use_id;
476: --
477: CURSOR C_GET_SITE_DEL(IN_SITE_ID NUMBER, p_dunning_plan_id number) IS

Line 480: , iex_dunning_plans_vl

476: --
477: CURSOR C_GET_SITE_DEL(IN_SITE_ID NUMBER, p_dunning_plan_id number) IS
478: SELECT party_cust_id, cust_account_id, customer_site_use_id,delinquency_ID
479: FROM IEX_DELINQUENCIES
480: , iex_dunning_plans_vl
481: WHERE STATUS in ('DELINQUENT', 'PREDELINQUENT')
482: AND customer_site_use_id = in_site_id
483: and iex_dunning_plans_vl.dunning_plan_id = p_dunning_plan_id
484: -- begin bug 4914799 ctlee 12/30/2005, party/account/site level dunning does not have score in delinquency

Line 483: and iex_dunning_plans_vl.dunning_plan_id = p_dunning_plan_id

479: FROM IEX_DELINQUENCIES
480: , iex_dunning_plans_vl
481: WHERE STATUS in ('DELINQUENT', 'PREDELINQUENT')
482: AND customer_site_use_id = in_site_id
483: and iex_dunning_plans_vl.dunning_plan_id = p_dunning_plan_id
484: -- begin bug 4914799 ctlee 12/30/2005, party/account/site level dunning does not have score in delinquency
485: -- and iex_delinquencies.score_id = iex_dunning_plans_vl.score_id
486: -- end bug 4914799 ctlee 12/30/2005, party/account/site level dunning does not have score in delinquency
487: ORDER BY customer_site_use_id, delinquency_id;

Line 485: -- and iex_delinquencies.score_id = iex_dunning_plans_vl.score_id

481: WHERE STATUS in ('DELINQUENT', 'PREDELINQUENT')
482: AND customer_site_use_id = in_site_id
483: and iex_dunning_plans_vl.dunning_plan_id = p_dunning_plan_id
484: -- begin bug 4914799 ctlee 12/30/2005, party/account/site level dunning does not have score in delinquency
485: -- and iex_delinquencies.score_id = iex_dunning_plans_vl.score_id
486: -- end bug 4914799 ctlee 12/30/2005, party/account/site level dunning does not have score in delinquency
487: ORDER BY customer_site_use_id, delinquency_id;
488: */
489: --

Line 491: select aging_bucket_id from iex_dunning_plans_vl

487: ORDER BY customer_site_use_id, delinquency_id;
488: */
489: --
490: CURSOR C_GET_BUCKET (p_dunning_plan_id number) IS
491: select aging_bucket_id from iex_dunning_plans_vl
492: where dunning_plan_id = p_dunning_plan_id;
493: -- CURSOR C_GET_BUCKET IS
494: -- SELECT preference_value
495: -- FROM IEX_APP_PREFERENCES_VL

Line 532: from iex_dunning_plans_vl d

528:
529: cursor c_scoring_engine(p_dunning_plan_id number) is
530: select sc.score_id
531: ,sc.score_name
532: from iex_dunning_plans_vl d
533: ,iex_scores sc
534: where d.dunning_plan_id = p_dunning_plan_id
535: and sc.score_id = d.score_id;
536:

Line 542: from IEX_OBJECT_FILTERS iof,iex_dunning_plans_vl ipd, IEX_SCORES isc

538: l_score_engine_name varchar2(60);
539: --Start bug 7197038 gnramasa 9th july 08
540: cursor c_filter_object(p_dunning_plan_id number) is
541: select iof.select_column, iof.entity_name
542: from IEX_OBJECT_FILTERS iof,iex_dunning_plans_vl ipd, IEX_SCORES isc
543: where ipd.dunning_plan_id = p_dunning_plan_id
544: and ipd.score_id=isc.score_id
545: and isc.score_id=iof.object_id;
546:

Line 997: ' ,iex_dunning_plans_vl ' ||

993: ' ''BILL_TO'', decode(site_use.primary_flag, ''Y'', 2, 3)) Display_Order ' ||
994: 'from HZ_CUST_SITE_USES site_use ' ||
995: ' ,HZ_CUST_ACCT_SITES acct_site ' ||
996: ' ,hz_party_sites par_site ' ||
997: ' ,iex_dunning_plans_vl ' ||
998: 'where ' ||
999: ' par_site.party_id = :1 and ' ||
1000: ' par_site.status = ''A'' and ' ||
1001: ' par_site.party_site_id = acct_site.party_site_id and ' ||

Line 1005: ' iex_dunning_plans_vl.dunning_plan_id = :p_dunning_plan_id and' ||

1001: ' par_site.party_site_id = acct_site.party_site_id and ' ||
1002: ' acct_site.status = ''A'' and ' ||
1003: ' acct_site.cust_acct_site_id = site_use.cust_acct_site_id and ' ||
1004: ' site_use.status = ''A'' and ' ||
1005: ' iex_dunning_plans_vl.dunning_plan_id = :p_dunning_plan_id and' ||
1006: ' exists (select ' || l_select_column || ' from ' || l_entity_name || ' where '|| l_select_column ||' = par_site.party_id) ' ||
1007: ' order by Display_Order ';
1008: elsif p_running_level = 'ACCOUNT' then
1009: vSelectColumn := 'cust_account_id';

Line 1020: ' ,iex_dunning_plans_vl ' ||

1016: ' ''BILL_TO'', decode(site_use.primary_flag, ''Y'', 2, 3)) Display_Order ' ||
1017: 'from HZ_CUST_SITE_USES site_use ' ||
1018: ' ,HZ_CUST_ACCT_SITES acct_site ' ||
1019: ' ,hz_party_sites par_site ' ||
1020: ' ,iex_dunning_plans_vl ' ||
1021: 'where ' ||
1022: ' acct_site.cust_account_id = :1 and ' ||
1023: ' par_site.status = ''A'' and ' ||
1024: ' par_site.party_site_id = acct_site.party_site_id and ' ||

Line 1028: ' iex_dunning_plans_vl.dunning_plan_id = :p_dunning_plan_id and' ||

1024: ' par_site.party_site_id = acct_site.party_site_id and ' ||
1025: ' acct_site.status = ''A'' and ' ||
1026: ' acct_site.cust_acct_site_id = site_use.cust_acct_site_id and ' ||
1027: ' site_use.status = ''A'' and ' ||
1028: ' iex_dunning_plans_vl.dunning_plan_id = :p_dunning_plan_id and' ||
1029: ' exists (select ' || l_select_column || ' from ' || l_entity_name || ' where '|| l_select_column ||' = acct_site.cust_account_id) ' ||
1030: ' order by Display_Order ';
1031: elsif p_running_level = 'BILL_TO' then
1032: vSelectColumn := 'customer_site_use_id';

Line 1043: ' ,iex_dunning_plans_vl ' ||

1039: ' ''BILL_TO'', decode(site_use.primary_flag, ''Y'', 2, 3)) Display_Order ' ||
1040: 'from HZ_CUST_SITE_USES site_use ' ||
1041: ' ,HZ_CUST_ACCT_SITES acct_site ' ||
1042: ' ,hz_party_sites par_site ' ||
1043: ' ,iex_dunning_plans_vl ' ||
1044: 'where ' ||
1045: ' site_use.site_use_id = :1 and ' ||
1046: ' par_site.status = ''A'' and ' ||
1047: ' par_site.party_site_id = acct_site.party_site_id and ' ||

Line 1051: ' iex_dunning_plans_vl.dunning_plan_id = :p_dunning_plan_id and' ||

1047: ' par_site.party_site_id = acct_site.party_site_id and ' ||
1048: ' acct_site.status = ''A'' and ' ||
1049: ' acct_site.cust_acct_site_id = site_use.cust_acct_site_id and ' ||
1050: ' site_use.status = ''A'' and ' ||
1051: ' iex_dunning_plans_vl.dunning_plan_id = :p_dunning_plan_id and' ||
1052: ' exists (select ' || l_select_column || ' from ' || l_entity_name || ' where '|| l_select_column ||' = site_use.site_use_id) ' ||
1053: ' order by Display_Order ';
1054:
1055: else -- we are running at delinquency level

Line 1063: ' ,iex_dunning_plans_vl ' ||

1059: ' ,cust_account_id ' ||
1060: ' ,customer_site_use_id ' ||
1061: ' ,delinquency_ID ' ||
1062: ' FROM IEX_DELINQUENCIES del' ||
1063: ' ,iex_dunning_plans_vl ' ||
1064: ' WHERE STATUS in (''DELINQUENT'', ''PREDELINQUENT'') ' ||
1065: ' AND DELINQUENCY_ID = :1 ' ||
1066: ' AND iex_dunning_plans_vl.dunning_plan_id = :p_dunning_plan_id and' ||
1067: ' exists (select ' || l_select_column || ' from ' || l_entity_name || ' where '|| l_select_column ||' = del.DELINQUENCY_ID) ';

Line 1066: ' AND iex_dunning_plans_vl.dunning_plan_id = :p_dunning_plan_id and' ||

1062: ' FROM IEX_DELINQUENCIES del' ||
1063: ' ,iex_dunning_plans_vl ' ||
1064: ' WHERE STATUS in (''DELINQUENT'', ''PREDELINQUENT'') ' ||
1065: ' AND DELINQUENCY_ID = :1 ' ||
1066: ' AND iex_dunning_plans_vl.dunning_plan_id = :p_dunning_plan_id and' ||
1067: ' exists (select ' || l_select_column || ' from ' || l_entity_name || ' where '|| l_select_column ||' = del.DELINQUENCY_ID) ';
1068:
1069: --'ORDER BY ' || vSelectColumn || ' ,delinquency_id';
1070: end if;

Line 1076: ', IEX_DUNNING_PLANS_VL '||

1072: -- fetch the party/account/site_use/delinquency from iex_delinquencies table
1073: if p_previous_request_id is null then
1074: vPLSQL := ' SELECT distinct ' || vSelectColumn ||
1075: ' FROM IEX_DELINQUENCIES ' ||
1076: ', IEX_DUNNING_PLANS_VL '||
1077: ' WHERE STATUS in (''DELINQUENT'', ''PREDELINQUENT'') ' ||
1078: ' AND iex_dunning_plans_vl.dunning_plan_id = :p_dunning_plan_id ' ||
1079: ' order by ' || vSelectColumn;
1080: else

Line 1078: ' AND iex_dunning_plans_vl.dunning_plan_id = :p_dunning_plan_id ' ||

1074: vPLSQL := ' SELECT distinct ' || vSelectColumn ||
1075: ' FROM IEX_DELINQUENCIES ' ||
1076: ', IEX_DUNNING_PLANS_VL '||
1077: ' WHERE STATUS in (''DELINQUENT'', ''PREDELINQUENT'') ' ||
1078: ' AND iex_dunning_plans_vl.dunning_plan_id = :p_dunning_plan_id ' ||
1079: ' order by ' || vSelectColumn;
1080: else
1081: vPLSQL := ' SELECT distinct object_id ' ||
1082: ' FROM IEX_DUNNINGS ' ||

Line 1525: select dunning_level from iex_dunning_plans_vl

1521: DUNNING_PLAN_ID IN NUMBER,
1522: P_PREVIOUS_REQUEST_ID IN NUMBER)
1523: is
1524: CURSOR C_GET_LEVEL (iex_dunning_plan_id number) IS
1525: select dunning_level from iex_dunning_plans_vl
1526: where dunning_plan_id = iex_dunning_plan_id;
1527: -- 12.0 ctlee, get it from the dunning_plan
1528: -- SELECT preference_value
1529: -- FROM IEX_APP_PREFERENCES_VL

Line 1533: select aging_bucket_id from iex_dunning_plans_vl

1529: -- FROM IEX_APP_PREFERENCES_VL
1530: -- WHERE upper(PREFERENCE_NAME) = 'COLLECTIONS DUNNING LEVEL';
1531: --
1532: CURSOR C_GET_BUCKET (iex_dunning_plan_id number) IS
1533: select aging_bucket_id from iex_dunning_plans_vl
1534: where dunning_plan_id = iex_dunning_plan_id;
1535: -- 12.0 ctlee, get it from the dunning_plan
1536: -- SELECT preference_value
1537: -- FROM IEX_APP_PREFERENCES_VL