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 OKC_K_HEADERS_B

Line 121: ,okc_k_headers_b okh

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;
125:

Line 133: FROM okc_k_headers_b prog,

129: ,lease.id contract_id
130: ,rgp.dnz_chr_id
131: ,lease.contract_number contract_number
132: ,rgp.rgd_code
133: FROM okc_k_headers_b prog,
134: okc_k_headers_b lease,
135: okl_k_headers khr,
136: okc_rule_groups_b rgp
137: WHERE khr.id = lease.id

Line 134: okc_k_headers_b lease,

130: ,rgp.dnz_chr_id
131: ,lease.contract_number contract_number
132: ,rgp.rgd_code
133: FROM okc_k_headers_b prog,
134: okc_k_headers_b lease,
135: okl_k_headers khr,
136: okc_rule_groups_b rgp
137: WHERE khr.id = lease.id
138: AND khr.khr_id = prog.id

Line 227: ,okc_k_headers_b okh

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;
231:

Line 239: FROM okc_k_headers_b prog,

235: ,lease.id contract_id
236: ,rgp.dnz_chr_id
237: ,lease.contract_number contract_number
238: ,rgp.rgd_code
239: FROM okc_k_headers_b prog,
240: okc_k_headers_b lease,
241: okl_k_headers khr,
242: okc_rule_groups_b rgp
243: WHERE khr.id = lease.id

Line 240: okc_k_headers_b lease,

236: ,rgp.dnz_chr_id
237: ,lease.contract_number contract_number
238: ,rgp.rgd_code
239: FROM okc_k_headers_b prog,
240: okc_k_headers_b lease,
241: okl_k_headers khr,
242: okc_rule_groups_b rgp
243: WHERE khr.id = lease.id
244: AND khr.khr_id = prog.id

Line 333: ,okc_k_headers_b okh

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;
337:

Line 345: FROM okc_k_headers_b prog,

341: ,lease.id contract_id
342: ,rgp.dnz_chr_id
343: ,lease.contract_number contract_number
344: ,rgp.rgd_code
345: FROM okc_k_headers_b prog,
346: okc_k_headers_b lease,
347: okl_k_headers khr,
348: okc_rule_groups_b rgp
349: WHERE khr.id = lease.id

Line 346: okc_k_headers_b lease,

342: ,rgp.dnz_chr_id
343: ,lease.contract_number contract_number
344: ,rgp.rgd_code
345: FROM okc_k_headers_b prog,
346: okc_k_headers_b lease,
347: okl_k_headers khr,
348: okc_rule_groups_b rgp
349: WHERE khr.id = lease.id
350: AND khr.khr_id = prog.id

Line 450: ,okc_k_headers_b okh

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;
454:

Line 463: FROM okc_k_headers_b prog,

459: ,lease.id contract_id
460: ,rgp.dnz_chr_id
461: ,lease.contract_number contract_number
462: ,rgp.rgd_code
463: FROM okc_k_headers_b prog,
464: okc_k_headers_b lease,
465: okl_k_headers khr,
466: okc_rule_groups_b rgp
467: WHERE khr.id = lease.id

Line 464: okc_k_headers_b lease,

460: ,rgp.dnz_chr_id
461: ,lease.contract_number contract_number
462: ,rgp.rgd_code
463: FROM okc_k_headers_b prog,
464: okc_k_headers_b lease,
465: okl_k_headers khr,
466: okc_rule_groups_b rgp
467: WHERE khr.id = lease.id
468: AND khr.khr_id = prog.id

Line 1130: l_contract_id OKC_K_HEADERS_B.ID%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;
1134: l_subject VARCHAR2(2000);