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_DUNNINGS

Line 619: from iex_dunnings

615: l_object_type varchar2(20);
616:
617: cursor c_req_dunn_mode (p_req_id number) is
618: select dunning_mode
619: from iex_dunnings
620: where request_id = p_req_id;
621:
622: cursor c_req_is_confirmed (p_req_id number) is
623: select count(1)

Line 624: from iex_dunnings

620: where request_id = p_req_id;
621:
622: cursor c_req_is_confirmed (p_req_id number) is
623: select count(1)
624: from iex_dunnings
625: where request_id = p_req_id
626: and confirmation_mode = 'CONFIRMED';
627:
628: cursor c_no_err_dunn_rec (p_req_id number) is

Line 630: from iex_dunnings id

626: and confirmation_mode = 'CONFIRMED';
627:
628: cursor c_no_err_dunn_rec (p_req_id number) is
629: select count(1)
630: from iex_dunnings id
631: where id.request_id = p_req_id
632: and id.delivery_status is not null
633: and id.object_type <> 'IEX_INVOICES'
634: and id.dunning_id = (select max(d.dunning_id) from iex_dunnings d

Line 634: and id.dunning_id = (select max(d.dunning_id) from iex_dunnings d

630: from iex_dunnings id
631: where id.request_id = p_req_id
632: and id.delivery_status is not null
633: and id.object_type <> 'IEX_INVOICES'
634: and id.dunning_id = (select max(d.dunning_id) from iex_dunnings d
635: where d.dunning_object_id = id.dunning_object_id
636: and d.dunning_level = id.dunning_level and d.request_id = id.request_id
637: and d.object_type <> 'IEX_INVOICES');
638:

Line 641: from iex_dunnings id

637: and d.object_type <> 'IEX_INVOICES');
638:
639: cursor c_no_success_dunn_rec (p_req_id number) is
640: select count(1)
641: from iex_dunnings id
642: where id.request_id = p_req_id
643: and id.delivery_status is null
644: and id.object_type <> 'IEX_INVOICES'
645: and id.dunning_id = (select max(d.dunning_id) from iex_dunnings d

Line 645: and id.dunning_id = (select max(d.dunning_id) from iex_dunnings d

641: from iex_dunnings id
642: where id.request_id = p_req_id
643: and id.delivery_status is null
644: and id.object_type <> 'IEX_INVOICES'
645: and id.dunning_id = (select max(d.dunning_id) from iex_dunnings d
646: where d.dunning_object_id = id.dunning_object_id
647: and d.dunning_level = id.dunning_level and d.request_id = id.request_id
648: and d.object_type <> 'IEX_INVOICES');
649:

Line 652: from iex_dunnings id

648: and d.object_type <> 'IEX_INVOICES');
649:
650: cursor c_no_success_inv_rec (p_req_id number) is
651: select count(1)
652: from iex_dunnings id
653: where id.request_id = p_req_id
654: and id.delivery_status is null
655: and id.object_type = 'IEX_INVOICES'
656: and id.dunning_id = (select max(d.dunning_id) from iex_dunnings d

Line 656: and id.dunning_id = (select max(d.dunning_id) from iex_dunnings d

652: from iex_dunnings id
653: where id.request_id = p_req_id
654: and id.delivery_status is null
655: and id.object_type = 'IEX_INVOICES'
656: and id.dunning_id = (select max(d.dunning_id) from iex_dunnings d
657: where d.dunning_object_id = id.dunning_object_id
658: and d.dunning_level = id.dunning_level and d.request_id = id.request_id
659: and d.object_type = 'IEX_INVOICES');
660:

Line 664: iex_dunnings dunn,

660:
661: cursor c_get_invoice_ct (p_conc_req_id number) is
662: select count(idt.cust_trx_id)
663: from iex_dunning_transactions idt,
664: iex_dunnings dunn,
665: iex_ag_dn_xref xref,
666: ra_customer_trx trx
667: where idt.dunning_id = dunn.dunning_id
668: and dunn.request_id = p_conc_req_id

Line 678: iex_dunnings dunn,

674:
675: cursor c_get_inv_count_in_errmode (p_conc_req_id number, p_max_dunn_trx_id number) is
676: select count(idt.cust_trx_id)
677: from iex_dunning_transactions idt,
678: iex_dunnings dunn,
679: iex_ag_dn_xref xref,
680: ra_customer_trx trx
681: where idt.dunning_id = dunn.dunning_id
682: and dunn.request_id = p_conc_req_id

Line 693: iex_dunnings dunn

689:
690: cursor c_max_dunning_trx_id (p_conc_req_id number) is
691: select max(idt.dunning_trx_id)
692: from iex_dunning_transactions idt,
693: iex_dunnings dunn
694: where idt.dunning_id = dunn.dunning_id
695: and dunn.request_id = p_conc_req_id;
696:
697: cursor c_object_type (p_req_id number) is

Line 699: from iex_dunnings

695: and dunn.request_id = p_conc_req_id;
696:
697: cursor c_object_type (p_req_id number) is
698: select object_type
699: from iex_dunnings
700: where request_id = p_req_id
701: order by dunning_id;
702:
703: l_payment_schedule_id number;

Line 972: ' FROM IEX_DUNNINGS ID ' ||

968: ' order by ' || vSelectColumn;
969: -- end if;
970: else
971: vPLSQL := ' SELECT distinct object_id ' ||
972: ' FROM IEX_DUNNINGS ID ' ||
973: --' WHERE DELIVERY_STATUS = ''ERROR'' ' ||
974: ' WHERE DELIVERY_STATUS IS NOT NULL ' ||
975: --' AND STATUS = ''OPEN'' ' ||
976: ' AND REQUEST_ID = :1 ' ||

Line 979: ' AND dunning_id = (select max(d.dunning_id) from iex_dunnings d ' ||

975: --' AND STATUS = ''OPEN'' ' ||
976: ' AND REQUEST_ID = :1 ' ||
977: ' AND DUNNING_LEVEL = :2 ' ||
978: ' AND ID.object_type <> ''IEX_INVOICES'' ' ||
979: ' AND dunning_id = (select max(d.dunning_id) from iex_dunnings d ' ||
980: ' where d.dunning_object_id = id.dunning_object_id ' ||
981: ' and d.dunning_level=id.dunning_level and d.request_id = id.request_id ' ||
982: ' and d.object_type <> ''IEX_INVOICES'' )';
983: end if;

Line 1240: 'from iex_dunnings dun ' ||

1236: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' checking whether to span the IEX: Bulk xml manager or not');
1237: if (p_dunning_mode = 'FINAL' and l_confirmation_mode is not null) then
1238:
1239: vPLSQL3 := 'select dun.dunning_id, dun.dunning_object_id, dun.dunning_level, dun.ag_dn_xref_id ' ||
1240: 'from iex_dunnings dun ' ||
1241: 'where dun.request_id = :1 ' ||
1242: ' and dun.delivery_status IS NULL ' ||
1243: ' and dun.confirmation_mode is null ';
1244: if l_custom_select IS NOT NULL then

Line 1334: 'from iex_dunnings dun, iex_xml_request_histories xml ' ||

1330: end loop;
1331: close sql_cur3;
1332:
1333: vPLSQL4 := 'select xml.xml_request_id ' ||
1334: 'from iex_dunnings dun, iex_xml_request_histories xml ' ||
1335: 'where xml.conc_request_id = :1 ' ||
1336: ' and xml.xml_request_id = dun.xml_request_id ' ||
1337: ' and xml.confirmation_mode is null ';
1338: if l_custom_select IS NOT NULL then

Line 1372: 'from iex_dunnings dun, iex_xml_request_histories xml ' ||

1368: close sql_cur4;
1369:
1370: if l_dunning_type = 'STAGED_DUNNING' then
1371: vPLSQL6 := 'select xml.xml_request_id ' ||
1372: 'from iex_dunnings dun, iex_xml_request_histories xml ' ||
1373: 'where xml.conc_request_id = :1 ' ||
1374: ' and xml.xml_request_id = dun.xml_request_id ' ||
1375: ' and xml.confirmation_mode is null ' ||
1376: ' and dun.object_type = ''INX_INVOICES'' ';

Line 1408: 'from iex_dunnings dun, iex_dunning_transactions iet ' ||

1404: end if; --if (p_dunning_mode = 'FINAL' and l_confirmation_mode is not null) then
1405:
1406: if p_dunning_mode = 'FINAL' and l_dunning_type = 'STAGED_DUNNING' then
1407: vPLSQL5 := 'select iet.payment_schedule_id, iet.stage_number ' ||
1408: 'from iex_dunnings dun, iex_dunning_transactions iet ' ||
1409: 'where dun.request_id = :1 ' ||
1410: ' and dun.dunning_id = iet.dunning_id ' ||
1411: ' and dun.delivery_status is null ' ||
1412: ' and iet.cust_trx_id is not null ' ||

Line 2082: from iex_dunnings

2078: l_business_level VARCHAR2(20);
2079:
2080: cursor c_req_dunn_mode (p_req_id number) is
2081: select dunning_mode
2082: from iex_dunnings
2083: where request_id = p_req_id;
2084:
2085: cursor c_ou_running_level is
2086: select define_ou_running_level