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_QUOTE_TO_CONTRACT_PVT dependencies on OKL_LEASEAPP_TEMPL_VERSIONS_B

Line 4535: FROM okl_leaseapp_templ_versions_b olvv,

4531: -- ER# 9161779 - Start
4532: -- Cursor to get the contract template attached to a lease application template of a lease app
4533: CURSOR c_get_contract_temp(p_lap_id IN okl_lease_applications_v.ID%TYPE) IS
4534: SELECT olvv.contract_template_id
4535: FROM okl_leaseapp_templ_versions_b olvv,
4536: okl_lease_applications_b olav
4537: WHERE olav.leaseapp_template_id = olvv.ID -- lease app stores the template version id
4538: AND olav.ID = p_lap_id
4539: AND EXISTS (SELECT 1

Line 5353: FROM okl_leaseapp_templ_versions_b olvv,

5349: SELECT chr.id , chr.description, khr.ATTRIBUTE_CATEGORY
5350: , khr.ATTRIBUTE1, khr.ATTRIBUTE2, khr.ATTRIBUTE3, khr.ATTRIBUTE4, khr.ATTRIBUTE5, khr.ATTRIBUTE6
5351: , khr.ATTRIBUTE7, khr.ATTRIBUTE8, khr.ATTRIBUTE9, khr.ATTRIBUTE10, khr.ATTRIBUTE11, khr.ATTRIBUTE12
5352: , khr.ATTRIBUTE13, khr.ATTRIBUTE14, khr.ATTRIBUTE15
5353: FROM okl_leaseapp_templ_versions_b olvv,
5354: okl_lease_applications_b olav,
5355: okc_k_headers_v chr,
5356: okl_k_headers khr
5357: WHERE olav.leaseapp_template_id = olvv.ID -- lease app stores the template version id