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_SLA_ACC_SOURCES_PVT dependencies on OKL_K_LINES

Line 283: ,okl_k_lines kle

279: 48, 'SERVICE',
280: 52, 'FEE', -- Fee
281: NULL) contract_line_type
282: FROM okc_k_lines_b cleb
283: ,okl_k_lines kle
284: ,okc_k_lines_tl clet
285: WHERE cleb.id = p_kle_id
286: AND kle.id = cleb.id
287: AND cleb.id = clet.id

Line 428: FROM okl_k_lines kle

424: ,kle.attribute12
425: ,kle.attribute13
426: ,kle.attribute14
427: ,kle.attribute15
428: FROM okl_k_lines kle
429: WHERE kle.id = l_kle_id;
430:
431: -- Cursor to fetch the Asset Manufacturer Name, Model Number and Category Name
432: CURSOR c_manufacture_model_csr (p_kle_id NUMBER, p_khr_id NUMBER)

Line 513: FROM okl_k_lines kle,

509: -- Cursor to fetch the Asset Year Manufactured
510: CURSOR c_asset_year_manufactured_csr (p_kle_id NUMBER, p_khr_id NUMBER)
511: IS
512: SELECT kle.Year_built year_of_manufacture
513: FROM okl_k_lines kle,
514: okc_k_lines_b cleb_year
515: WHERE kle.id = cleb_year.id
516: AND cleb_year.cle_id = p_kle_id
517: AND cleb_year.dnz_chr_id = p_khr_id

Line 617: ,okl_k_lines subsidy_line

613: SELECT sub.NAME subsidy_name
614: ,party.vendor_name subsidy_party_name
615: ,party.vendor_id subsidy_vendor_id
616: FROM okl_subsidies_b sub
617: ,okl_k_lines subsidy_line
618: ,okc_k_party_roles_b role
619: ,po_vendors party
620: WHERE sub.id = subsidy_line.subsidy_id
621: AND role.cle_id = subsidy_line.id