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 510: select aging_bucket_id from iex_dunning_plans_vl

506: x_msg_count OUT NOCOPY NUMBER,
507: x_msg_data OUT NOCOPY VARCHAR2) IS
508:
509: CURSOR C_GET_BUCKET (p_dunning_plan_id number) IS
510: select aging_bucket_id from iex_dunning_plans_vl
511: where dunning_plan_id = p_dunning_plan_id;
512:
513: --
514: l_api_name CONSTANT VARCHAR2(30) := 'Send_Dunning';

Line 556: from iex_dunning_plans_vl d

552:
553: cursor c_scoring_engine(p_dunning_plan_id number) is
554: select sc.score_id
555: ,sc.score_name
556: from iex_dunning_plans_vl d
557: ,iex_scores sc
558: where d.dunning_plan_id = p_dunning_plan_id
559: and sc.score_id = d.score_id;
560:

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

562: l_score_engine_name varchar2(60);
563: --Start bug 7197038 gnramasa 9th july 08
564: cursor c_filter_object(p_dunning_plan_id number) is
565: select iof.select_column, iof.entity_name
566: from IEX_OBJECT_FILTERS iof,iex_dunning_plans_vl ipd, IEX_SCORES isc
567: where ipd.dunning_plan_id = p_dunning_plan_id
568: and ipd.score_id=isc.score_id
569: and isc.score_id=iof.object_id
570: and object_filter_type = 'IEXSCORE';

Line 803: ' ,iex_dunning_plans_vl ' ||

799: ' ''BILL_TO'', decode(site_use.primary_flag, ''Y'', 2, 3)) Display_Order ' ||
800: 'from HZ_CUST_SITE_USES site_use ' ||
801: ' ,HZ_CUST_ACCT_SITES acct_site ' ||
802: ' ,hz_party_sites par_site ' ||
803: ' ,iex_dunning_plans_vl ' ||
804: 'where ' ||
805: ' par_site.party_id = :1 and ' ||
806: ' par_site.status = ''A'' and ' ||
807: ' par_site.party_site_id = acct_site.party_site_id and ' ||

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

807: ' par_site.party_site_id = acct_site.party_site_id and ' ||
808: ' acct_site.status = ''A'' and ' ||
809: ' acct_site.cust_acct_site_id = site_use.cust_acct_site_id and ' ||
810: ' site_use.status = ''A'' and ' ||
811: ' iex_dunning_plans_vl.dunning_plan_id = :p_dunning_plan_id and' ||
812: ' exists (select ' || l_select_column || ' from ' || l_entity_name || ' where '|| l_select_column ||' = par_site.party_id) ' ;
813: if l_custom_select IS NOT NULL then
814: vPLSQL2 := vPLSQL2 || ' and exists ( ' || l_custom_select ||' = par_site.party_id) ' ;
815: end if;

Line 830: ' ,iex_dunning_plans_vl ' ||

826: ' ''BILL_TO'', decode(site_use.primary_flag, ''Y'', 2, 3)) Display_Order ' ||
827: 'from HZ_CUST_SITE_USES site_use ' ||
828: ' ,HZ_CUST_ACCT_SITES acct_site ' ||
829: ' ,hz_party_sites par_site ' ||
830: ' ,iex_dunning_plans_vl ' ||
831: 'where ' ||
832: ' acct_site.cust_account_id = :1 and ' ||
833: ' par_site.status = ''A'' and ' ||
834: ' par_site.party_site_id = acct_site.party_site_id and ' ||

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

834: ' par_site.party_site_id = acct_site.party_site_id and ' ||
835: ' acct_site.status = ''A'' and ' ||
836: ' acct_site.cust_acct_site_id = site_use.cust_acct_site_id and ' ||
837: ' site_use.status = ''A'' and ' ||
838: ' iex_dunning_plans_vl.dunning_plan_id = :p_dunning_plan_id and' ||
839: ' exists (select ' || l_select_column || ' from ' || l_entity_name || ' where '|| l_select_column ||' = acct_site.cust_account_id) ';
840: if l_custom_select IS NOT NULL then
841: vPLSQL2 := vPLSQL2 || ' and exists ( ' || l_custom_select ||' = acct_site.cust_account_id) ';
842: end if;

Line 865: ' ,iex_dunning_plans_vl ' ||

861: ' ''BILL_TO'', decode(site_use.primary_flag, ''Y'', 2, 3)) Display_Order ' ||
862: 'from HZ_CUST_SITE_USES site_use ' ||
863: ' ,HZ_CUST_ACCT_SITES acct_site ' ||
864: ' ,hz_party_sites par_site ' ||
865: ' ,iex_dunning_plans_vl ' ||
866: 'where ' ||
867: ' site_use.site_use_id = :1 and ' ||
868: ' par_site.status = ''A'' and ' ||
869: ' par_site.party_site_id = acct_site.party_site_id and ' ||

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

869: ' par_site.party_site_id = acct_site.party_site_id and ' ||
870: ' acct_site.status = ''A'' and ' ||
871: ' acct_site.cust_acct_site_id = site_use.cust_acct_site_id and ' ||
872: ' site_use.status = ''A'' and ' ||
873: ' iex_dunning_plans_vl.dunning_plan_id = :p_dunning_plan_id and' ||
874: ' exists (select ' || l_select_column || ' from ' || l_entity_name || ' where '|| l_select_column ||' = site_use.site_use_id) ';
875: if l_custom_select IS NOT NULL then
876: vPLSQL2 := vPLSQL2 || ' and exists ( ' || l_custom_select ||' = site_use.site_use_id) ';
877: end if;

Line 897: ' ,iex_dunning_plans_vl ' ||

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 ' ;
901: --||

Line 900: ' AND iex_dunning_plans_vl.dunning_plan_id = :p_dunning_plan_id ' ;

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 ' ;
901: --||
902: --' AND del.score_id = iex_dunning_plans_vl.score_id' ;
903: --' AND exists (select ' || l_select_column || ' from ' || l_entity_name || ' where '|| l_select_column ||' = del.DELINQUENCY_ID) ';
904:

Line 902: --' AND del.score_id = iex_dunning_plans_vl.score_id' ;

898: ' WHERE STATUS in (''DELINQUENT'', ''PREDELINQUENT'') ' ||
899: ' AND DELINQUENCY_ID = :1 ' ||
900: ' AND iex_dunning_plans_vl.dunning_plan_id = :p_dunning_plan_id ' ;
901: --||
902: --' AND del.score_id = iex_dunning_plans_vl.score_id' ;
903: --' AND exists (select ' || l_select_column || ' from ' || l_entity_name || ' where '|| l_select_column ||' = del.DELINQUENCY_ID) ';
904:
905: -- bug 14797201.... begin...
906: if l_select_column = 'PAYMENT_SCHEDULE_ID' then

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 936: and iex_dunning_plans_vl.dunning_plan_id = p_dunning_plan_id;

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:
938: exception
939: when others then null;
940: end;

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 949: ' and iex_dunning_plans_vl.dunning_plan_id = :p_dunning_plan_id ' ||

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: */
952: /* bug 16303059 start...
953: if t_cnt > 0 then

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 959: ' and iex_dunning_plans_vl.dunning_plan_id = :p_dunning_plan_id ' ||

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 ' ||
960: ' order by ' || vSelectColumn;
961: else
962: bug 16303059 end... */
963: vPLSQL := ' SELECT distinct ' || vSelectColumn ||

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 967: ' and iex_dunning_plans_vl.dunning_plan_id = :p_dunning_plan_id ' ||

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;
969: -- end if;
970: else
971: vPLSQL := ' SELECT distinct object_id ' ||

Line 2033: select dunning_level from iex_dunning_plans_vl

2029: p_billto_location_high IN VARCHAR2, -- added by gnramasa for bug 8489610 28-May-09
2030: p_order_output_by IN VARCHAR2) -- added by snuthala for bug 14541439 06-Feb-13
2031: is
2032: CURSOR C_GET_LEVEL (iex_dunning_plan_id number) IS
2033: select dunning_level from iex_dunning_plans_vl
2034: where dunning_plan_id = iex_dunning_plan_id;
2035: -- 12.0 ctlee, get it from the dunning_plan
2036: -- SELECT preference_value
2037: -- FROM IEX_APP_PREFERENCES_VL

Line 2041: select aging_bucket_id from iex_dunning_plans_vl

2037: -- FROM IEX_APP_PREFERENCES_VL
2038: -- WHERE upper(PREFERENCE_NAME) = 'COLLECTIONS DUNNING LEVEL';
2039: --
2040: CURSOR C_GET_BUCKET (iex_dunning_plan_id number) IS
2041: select aging_bucket_id from iex_dunning_plans_vl
2042: where dunning_plan_id = iex_dunning_plan_id;
2043: -- 12.0 ctlee, get it from the dunning_plan
2044: -- SELECT preference_value
2045: -- FROM IEX_APP_PREFERENCES_VL