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_V

Line 4149: FROM okl_leaseapp_templ_versions_v olvv,

4145: --Cursor declaration
4146: --Get the contract template id associated with lease app template
4147: CURSOR c_get_contract_temp(p_lap_id IN okl_lease_applications_v.ID%TYPE) IS
4148: SELECT olav.ID,olvv.CONTRACT_TEMPLATE_ID
4149: FROM okl_leaseapp_templ_versions_v olvv,
4150: okl_lease_applications_v olav
4151: WHERE olav.leaseapp_template_id = olvv.ID
4152: AND olav.ID = p_lap_id;
4153:

Line 4154: CURSOR c_rgpv (p_chr_tmp_id okl_leaseapp_templ_versions_v.CONTRACT_TEMPLATE_ID%TYPE)IS

4150: okl_lease_applications_v olav
4151: WHERE olav.leaseapp_template_id = olvv.ID
4152: AND olav.ID = p_lap_id;
4153:
4154: CURSOR c_rgpv (p_chr_tmp_id okl_leaseapp_templ_versions_v.CONTRACT_TEMPLATE_ID%TYPE)IS
4155: SELECT rgp.id
4156: FROM okc_rule_groups_b rgp, okc_subclass_rg_defs rg_defs
4157: WHERE rgp.dnz_chr_id = p_chr_tmp_id
4158: AND rgp.rgd_code = rg_defs.rgd_code