APPS.IEX_DUNNING_PVT dependencies on IEX_XML_REQUEST_HISTORIES

Line 10364: FROM iex_xml_request_histories

10360: l_inv_xdo_template_id number;
10361: l_as_of_date date;
10362: CURSOR c_get_resend_resource (p_xml_req_id number) is
10363: SELECT resource_id
10364: FROM iex_xml_request_histories
10365: WHERE xml_request_id = p_xml_req_id;
10366:
10367: cursor c_as_of_date (p_dunning_id number) is
10368: select nvl(dunn.as_of_date,sysdate)

Line 14063: from IEX_XML_REQUEST_HISTORIES

14059:
14060: --Start for bug 9970642 gnramasa 4th Aug 10
14061: cursor c_get_resend_data(p_request_id number) is
14062: select QUERY_TEMP_ID, ADDT_QUERY_TEMP_ID, DESTINATION
14063: from IEX_XML_REQUEST_HISTORIES
14064: where XML_REQUEST_ID = p_request_id;
14065:
14066: --Bug5233002. Fix by LKKUMAR on 31-May-2006. Start.
14067: CURSOR C_GET_RES_USER_ID IS

Line 17873: 'from iex_xml_request_histories ixr, ' ||

17869: 'ixr.destination DESTINATION, ' ||
17870: 'decode(id.DUNNING_MODE, ''DRAFT'', iex_utilities.get_lookup_meaning(''IEX_CONFIRMATION_MODE'', nvl(id.CONFIRMATION_MODE,''DRAFT'')),iex_utilities.get_lookup_meaning(''IEX_CONFIRMATION_MODE'',''CONFIRMED'')) CONFIRMATION_STATUS '||
17871: --'ixr.xml_request_id REQUEST_ID ' ||
17872: --' ''http://techcm.us.oracle.com:8000/OA_HTML/IEXDUNCPRRedirect.jsp?RequestId='' || ixr.xml_request_id DOWNLOAD_URL ' ||
17873: 'from iex_xml_request_histories ixr, ' ||
17874: 'hz_parties p, ' ||
17875: 'iex_dunnings id, ' ||
17876: 'XDO_TEMPLATES_B xtb, ' ||
17877: 'XDO_TEMPLATES_TL xtvl ' ||

Line 17905: 'from iex_xml_request_histories ixr, ' ||

17901: 'ixr.destination DESTINATION, ' ||
17902: 'decode(id.DUNNING_MODE, ''DRAFT'', iex_utilities.get_lookup_meaning(''IEX_CONFIRMATION_MODE'', nvl(id.CONFIRMATION_MODE,''DRAFT'')),iex_utilities.get_lookup_meaning(''IEX_CONFIRMATION_MODE'',''CONFIRMED'')) CONFIRMATION_STATUS '||
17903: --'ixr.xml_request_id REQUEST_ID ' ||
17904: --' ''http://techcm.us.oracle.com:8000/OA_HTML/IEXDUNCPRRedirect.jsp?RequestId='' || ixr.xml_request_id DOWNLOAD_URL ' ||
17905: 'from iex_xml_request_histories ixr, ' ||
17906: 'hz_parties p, ' ||
17907: 'hz_cust_accounts hcu, ' ||
17908: 'iex_dunnings id, ' ||
17909: 'XDO_TEMPLATES_B xtb, ' ||

Line 17940: 'from iex_xml_request_histories ixr, ' ||

17936: 'ixr.destination DESTINATION, ' ||
17937: 'decode(id.DUNNING_MODE, ''DRAFT'', iex_utilities.get_lookup_meaning(''IEX_CONFIRMATION_MODE'', nvl(id.CONFIRMATION_MODE,''DRAFT'')),iex_utilities.get_lookup_meaning(''IEX_CONFIRMATION_MODE'',''CONFIRMED'')) CONFIRMATION_STATUS '||
17938: --'ixr.xml_request_id REQUEST_ID ' ||
17939: --' ''http://techcm.us.oracle.com:8000/OA_HTML/IEXDUNCPRRedirect.jsp?RequestId='' || ixr.xml_request_id DOWNLOAD_URL ' ||
17940: 'from iex_xml_request_histories ixr, ' ||
17941: 'hz_parties p, ' ||
17942: 'hz_cust_accounts hcu,' ||
17943: 'hz_cust_acct_sites_all acct_sites, ' ||
17944: 'hz_cust_site_uses_all site_uses, ' ||

Line 17979: 'from iex_xml_request_histories ixr, ' ||

17975: 'ixr.destination DESTINATION, ' ||
17976: 'decode(id.DUNNING_MODE, ''DRAFT'', iex_utilities.get_lookup_meaning(''IEX_CONFIRMATION_MODE'', nvl(id.CONFIRMATION_MODE,''DRAFT'')),iex_utilities.get_lookup_meaning(''IEX_CONFIRMATION_MODE'',''CONFIRMED'')) CONFIRMATION_STATUS '||
17977: --'ixr.xml_request_id REQUEST_ID ' ||
17978: --' ''http://techcm.us.oracle.com:8000/OA_HTML/IEXDUNCPRRedirect.jsp?RequestId='' || ixr.xml_request_id DOWNLOAD_URL ' ||
17979: 'from iex_xml_request_histories ixr, ' ||
17980: 'hz_parties p, ' ||
17981: 'iex_dunnings id, ' ||
17982: 'XDO_TEMPLATES_B xtb, ' ||
17983: 'XDO_TEMPLATES_TL xtvl, ' ||

Line 18183: --and not exists (select 1 from iex_xml_request_histories xml

18179: and dunn.request_id = p_conc_req_id
18180: and dunn.ag_dn_xref_id = xref.ag_dn_xref_id
18181: and xref.invoice_copies = 'Y'
18182: and idt.cust_trx_id is not null;
18183: --and not exists (select 1 from iex_xml_request_histories xml
18184: -- where xml.xml_request_id = dunn.xml_request_id);
18185: */
18186:
18187: begin