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_PVT dependencies on OKC_K_HEADERS_BH

Line 284: FROM okc_k_headers_bh chrh,

280:
281: --Cursor to check if the contract was ever booked
282: Cursor Ever_Booked_crs(p_cle_id IN Number) is
283: SELECT 'Y'
284: FROM okc_k_headers_bh chrh,
285: okc_k_headers_b chr,
286: okc_k_lines_b cle
287: WHERE chrh.contract_number = chr.contract_number
288: AND chr.ID = cle.dnz_chr_id

Line 511: FROM okc_k_headers_bh chrh,

507:
508: --Cursor to check if the contract was ever booked
509: Cursor Ever_Booked_csr(p_chr_id IN Number) is
510: SELECT 'Y'
511: FROM okc_k_headers_bh chrh,
512: okc_k_headers_b chr
513: WHERE chrh.contract_number = chr.contract_number
514: AND chr.ID = p_chr_id
515: AND chrh.sts_code = G_OKL_BOOKED_STS_CODE

Line 4361: FROM okc_k_headers_bh chrh,

4357: AND rownum < 2;
4358:
4359: CURSOR Ever_Booked_crs(p_id number) IS
4360: SELECT 'Y'
4361: FROM okc_k_headers_bh chrh,
4362: okc_k_headers_b chr
4363: WHERE chrh.contract_number = chr.contract_number
4364: AND chr.id = p_id
4365: AND chrh.sts_code = G_OKL_BOOKED_STS_CODE