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 4256: FROM okl_leaseapp_templ_versions_v olvv,

4252: --Cursor declaration
4253: --Get the contract template id associated with lease app template
4254: CURSOR c_get_contract_temp(p_lap_id IN okl_lease_applications_v.ID%TYPE) IS
4255: SELECT olav.ID,olvv.CONTRACT_TEMPLATE_ID
4256: FROM okl_leaseapp_templ_versions_v olvv,
4257: okl_lease_applications_v olav
4258: WHERE olav.leaseapp_template_id = olvv.ID
4259: AND olav.ID = p_lap_id;
4260:

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

4257: okl_lease_applications_v olav
4258: WHERE olav.leaseapp_template_id = olvv.ID
4259: AND olav.ID = p_lap_id;
4260:
4261: CURSOR c_rgpv (p_chr_tmp_id okl_leaseapp_templ_versions_v.CONTRACT_TEMPLATE_ID%TYPE)IS
4262: SELECT rgp.id
4263: FROM okc_rule_groups_b rgp, okc_subclass_rg_defs rg_defs
4264: WHERE rgp.dnz_chr_id = p_chr_tmp_id
4265: AND rgp.rgd_code = rg_defs.rgd_code