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_CASES_ALL_B

Line 23: ,iex_cases_all_b ica

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;
27: BEGIN

Line 433: FROM iex_cases_all_b ica

429: --get vendor info
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

Line 448: FROM iex_cases_all_b ica

444:
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

Line 729: l_case_number IEX_CASES_ALL_B.CASE_NUMBER%TYPE;

725: l_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
726: l_bind_val JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
727: l_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
728:
729: l_case_number IEX_CASES_ALL_B.CASE_NUMBER%TYPE;
730: l_vendor_id PO_VENDORS.VENDOR_ID%TYPE;
731: l_vendor_name PO_VENDORS.VENDOR_NAME%TYPE;
732: l_email HZ_CONTACT_POINTS.EMAIL_ADDRESS%TYPE;
733: l_subject VARCHAR2(2000);

Line 1129: l_case_number IEX_CASES_ALL_B.CASE_NUMBER%TYPE;

1125: l_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
1126: l_bind_val JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
1127: l_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
1128:
1129: l_case_number IEX_CASES_ALL_B.CASE_NUMBER%TYPE;
1130: l_contract_id OKC_K_HEADERS_B.ID%TYPE;
1131: l_vendor_id PO_VENDORS.VENDOR_ID%TYPE;
1132: l_vendor_name PO_VENDORS.VENDOR_NAME%TYPE;
1133: l_email HZ_CONTACT_POINTS.EMAIL_ADDRESS%TYPE;

Line 1394: FROM IEX_CASES_ALL_B ica

1390: l_party_name VARCHAR2(360);
1391: l_return_status VARCHAR2(1) := 'S';
1392:
1393: CURSOR l_party_csr(cp_case_number in varchar2) IS SELECT hp.party_name
1394: FROM IEX_CASES_ALL_B ica
1395: ,HZ_PARTIES hp
1396: WHERE ica.case_number = cp_case_number
1397: AND ica.party_id = hp.party_id;
1398: BEGIN

Line 1411: FROM IEX_CASES_ALL_B ica

1407: -- FUNCTION get_case_contracts
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

Line 1433: FROM IEX_CASES_ALL_B ica

1429: -- FUNCTION get_case_total_value
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

Line 1457: FROM iex_cases_all_b ica

1453: ---------------------------------------------------------------------------
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

Line 1483: FROM iex_cases_all_b ica

1479: ---------------------------------------------------------------------------
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