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.OKL_CO_WF dependencies on IEX_DELINQUENCIES_ALL

Line 21: FROM iex_delinquencies_all ida

17: l_return_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;
18:
19: CURSOR l_khr_csr(cp_delinquency_id IN NUMBER) IS SELECT ico.object_id
20: ,ica.case_number
21: FROM iex_delinquencies_all ida
22: ,iex_case_objects ico
23: ,iex_cases_all_b ica
24: WHERE ida.delinquency_id = cp_delinquency_id
25: AND ida.case_id = ico.cas_id

Line 119: FROM iex_delinquencies_all ida

115: l_return_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;
116:
117: CURSOR l_khr_csr(cp_delinquency_id IN NUMBER) IS SELECT ico.object_id
118: , okh.contract_number
119: FROM iex_delinquencies_all ida
120: ,iex_case_objects ico
121: ,okc_k_headers_b okh
122: WHERE ida.delinquency_id = cp_delinquency_id
123: AND ida.case_id = ico.cas_id

Line 225: FROM iex_delinquencies_all ida

221: l_return_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;
222:
223: CURSOR l_khr_csr(cp_delinquency_id IN NUMBER) IS SELECT ico.object_id
224: , okh.contract_number
225: FROM iex_delinquencies_all ida
226: ,iex_case_objects ico
227: ,okc_k_headers_b okh
228: WHERE ida.delinquency_id = cp_delinquency_id
229: AND ida.case_id = ico.cas_id

Line 331: FROM iex_delinquencies_all ida

327: l_return_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;
328:
329: CURSOR l_khr_csr(cp_delinquency_id IN NUMBER) IS SELECT ico.object_id
330: , okh.contract_number
331: FROM iex_delinquencies_all ida
332: ,iex_case_objects ico
333: ,okc_k_headers_b okh
334: WHERE ida.delinquency_id = cp_delinquency_id
335: AND ida.case_id = ico.cas_id

Line 533: FROM iex_delinquencies_all ida

529: lx_msg_count NUMBER ;
530: lx_msg_data VARCHAR2(2000);
531:
532: CURSOR l_khr_csr(cp_delinquency_id IN NUMBER) IS SELECT ico.object_id
533: FROM iex_delinquencies_all ida
534: ,iex_case_objects ico
535: WHERE ida.delinquency_id = cp_delinquency_id
536: AND ida.case_id = ico.cas_id;
537: BEGIN

Line 647: FROM iex_delinquencies_all ida

643: lx_msg_count NUMBER ;
644: lx_msg_data VARCHAR2(2000);
645:
646: CURSOR l_khr_csr(cp_delinquency_id IN NUMBER) IS SELECT ico.object_id
647: FROM iex_delinquencies_all ida
648: ,iex_case_objects ico
649: WHERE ida.delinquency_id = cp_delinquency_id
650: AND ida.case_id = ico.cas_id;
651: BEGIN

Line 840: FROM iex_delinquencies_all ida

836: lx_msg_count NUMBER ;
837: lx_msg_data VARCHAR2(2000);
838:
839: CURSOR l_khr_csr(cp_delinquency_id IN NUMBER) IS SELECT ico.object_id
840: FROM iex_delinquencies_all ida
841: ,iex_case_objects ico
842: WHERE ida.delinquency_id = cp_delinquency_id
843: AND ida.case_id = ico.cas_id;
844: BEGIN

Line 931: FROM iex_delinquencies_all ida

927: IOH.STATUS,
928: IOH.REQUEST_DATE,
929: IOH.PROCESS_DATE,
930: IOH.EXT_AGNCY_ID
931: FROM iex_delinquencies_all ida
932: ,iex_case_objects ico
933: ,Okl_Open_Int OIN
934: ,Iex_Open_Int_Hst IOH
935: WHERE ida.delinquency_id = cp_delinquency_id

Line 1035: FROM iex_delinquencies_all ida

1031: IOH.OBJECT1_ID1,
1032: IOH.OBJECT1_ID2,
1033: IOH.JTOT_OBJECT1_CODE,
1034: IOH.EXT_AGNCY_ID
1035: FROM iex_delinquencies_all ida
1036: ,iex_case_objects ico
1037: ,Okl_Open_Int OIN
1038: ,Iex_Open_Int_Hst IOH
1039: WHERE ida.delinquency_id = cp_delinquency_id