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_CASE_OBJECTS

Line 22: ,iex_case_objects ico

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
26: AND ico.cas_id = ica.cas_id;

Line 120: ,iex_case_objects ico

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
124: AND ico.object_id = okh.id;

Line 226: ,iex_case_objects ico

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
230: AND ico.object_id = okh.id;

Line 332: ,iex_case_objects ico

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
336: AND ico.object_id = okh.id;

Line 434: ,iex_case_objects ico

430: CURSOR l_vendor_csr(cp_case_number IN VARCHAR2) IS SELECT pv.vendor_id
431: ,pv.vendor_name
432: --,pvs.email_address
433: FROM iex_cases_all_b ica
434: ,iex_case_objects ico
435: ,okc_k_party_roles_v opr
436: ,po_vendors pv
437: --,po_vendor_sites_all pvs
438: WHERE ica.case_number = cp_case_number

Line 449: ,iex_case_objects ico

445: --get contracts on case
446: CURSOR l_khr_csr(cp_case_number IN VARCHAR2) IS SELECT ico.object_id
447: , okh.contract_number
448: FROM iex_cases_all_b ica
449: ,iex_case_objects ico
450: ,okc_k_headers_b okh
451: WHERE ica.case_number = cp_case_number
452: AND ica.cas_id = ico.cas_id
453: AND ico.object_id = okh.id;

Line 534: ,iex_case_objects ico

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
538: if (funcmode = 'RUN') then

Line 648: ,iex_case_objects ico

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
652: if (funcmode = 'RUN') then

Line 841: ,iex_case_objects ico

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
845: if (funcmode = 'RUN') then

Line 932: ,iex_case_objects ico

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
936: AND ida.case_id = ico.cas_id

Line 1036: ,iex_case_objects ico

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
1040: AND ida.case_id = ico.cas_id

Line 1412: ,IEX_CASE_OBJECTS ico

1408: ---------------------------------------------------------------------------
1409: FUNCTION get_case_contracts(p_case_number in varchar2) RETURN VARCHAR2 AS
1410: CURSOR l_contract_csr(cp_case_number in varchar2) IS SELECT okh.contract_number
1411: FROM IEX_CASES_ALL_B ica
1412: ,IEX_CASE_OBJECTS ico
1413: ,OKC_K_HEADERS_V okh
1414: WHERE ica.case_number = cp_case_number
1415: AND ica.cas_id = ico.cas_id
1416: AND ico.object_id = okh.id;

Line 1434: ,IEX_CASE_OBJECTS ico

1430: ---------------------------------------------------------------------------
1431: FUNCTION get_case_total_value(p_case_number in varchar2) RETURN NUMBER AS
1432: CURSOR l_contract_csr(cp_case_number in varchar2) IS SELECT okh.id
1433: FROM IEX_CASES_ALL_B ica
1434: ,IEX_CASE_OBJECTS ico
1435: ,OKC_K_HEADERS_V okh
1436: WHERE ica.case_number = cp_case_number
1437: AND ica.cas_id = ico.cas_id
1438: AND ico.object_id = okh.id;

Line 1458: ,iex_case_objects ico

1454: FUNCTION get_amt_overdue(p_case_number in varchar2) RETURN NUMBER AS
1455: CURSOR l_khr_past_due_csr(cp_case_number in varchar2) IS
1456: SELECT sum(nvl(aps.amount_due_remaining, 0)) past_due_amount
1457: FROM iex_cases_all_b ica
1458: ,iex_case_objects ico
1459: ,okl_cnsld_ar_strms_b ocas
1460: ,ar_payment_schedules_all aps
1461: WHERE ica.case_number = cp_case_number
1462: AND ica.cas_id = ico.cas_id

Line 1484: ,iex_case_objects ico

1480: FUNCTION get_vendor_name(p_case_number in varchar2) RETURN VARCHAR2 AS
1481: --how to obtain the vendor site
1482: CURSOR l_vendor_csr(cp_case_number in varchar2) IS SELECT pv.vendor_name
1483: FROM iex_cases_all_b ica
1484: ,iex_case_objects ico
1485: ,okc_k_party_roles_v opr
1486: ,po_vendors pv
1487: ,po_vendor_sites_all pvs
1488: WHERE ica.case_number = cp_case_number