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_CONTRACT_STATUS_PVT dependencies on OKL_K_HEADERS

Line 92: okl_k_headers khr

88: CURSOR l_chk_template_csr (p_chr_id IN Number) IS
89: SELECT chr.template_yn,
90: khr.template_type_code
91: FROM okc_k_headers_b chr,
92: okl_k_headers khr
93: WHERE chr.id = p_chr_id
94: AND chr.id = khr.id;
95:
96: l_chk_template_rec l_chk_template_csr%ROWTYPE;

Line 231: okl_k_headers c

227: --Bug# 4502754
228: c.template_type_code
229: from okc_statuses_v a,
230: okc_k_headers_b b,
231: okl_k_headers c
232: where a.code = b.sts_code
233: and b.id = c.id
234: and b.id = chrId;
235:

Line 236: CURSOR chr_csr(p_chr_id OKL_K_HEADERS.KHR_ID%TYPE) IS

232: where a.code = b.sts_code
233: and b.id = c.id
234: and b.id = chrId;
235:
236: CURSOR chr_csr(p_chr_id OKL_K_HEADERS.KHR_ID%TYPE) IS
237: SELECT chr.SCS_CODE class,
238: chr.STS_CODE okc_status
239: FROM OKC_K_HEADERS_B chr,
240: OKL_K_HEADERS khr

Line 240: OKL_K_HEADERS khr

236: CURSOR chr_csr(p_chr_id OKL_K_HEADERS.KHR_ID%TYPE) IS
237: SELECT chr.SCS_CODE class,
238: chr.STS_CODE okc_status
239: FROM OKC_K_HEADERS_B chr,
240: OKL_K_HEADERS khr
241: WHERE chr.id = p_chr_id
242: AND chr.id = khr.id;
243:
244: CURSOR Product_csr (p_contract_id IN NUMBER ) IS

Line 249: ,okl_k_headers khr

245: SELECT pdt.id product_id
246: ,pdt.name product_name
247: ,chr.sts_code okl_status
248: FROM okl_products_v pdt
249: ,okl_k_headers khr
250: ,okc_k_headers_b chr
251: WHERE 1=1
252: AND khr.id = p_contract_id
253: AND khr.pdt_id = pdt.id