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_CPY_PDT_RULS_PVT dependencies on OKL_OPT_VALUES

Line 693: SELECT pov.OVE_ID, --required fk to okl_opt_values (okl_opv_rules_v.ove_id)

689: l_slctd_opt_rec l_slctd_opt_csr%ROWTYPE;
690:
691: --cursor to get product option values
692: CURSOR l_pdt_opt_vals_csr (p_pov_id IN NUMBER) is
693: SELECT pov.OVE_ID, --required fk to okl_opt_values (okl_opv_rules_v.ove_id)
694: pov.ID,
695: pov.PON_ID,
696: pon.opt_id --product option id fk okl_pdt_opts
697: FROM OKL_PDT_OPT_VALS pov,

Line 712: SELECT ovd.OVE_ID, -- fk to okl_opt_values (okl_opv_rules_v.ove_id)

708:
709:
710: --cursor to fetch option value rules
711: CURSOR l_opv_ruls_csr (p_ove_id IN NUMBER) is
712: SELECT ovd.OVE_ID, -- fk to okl_opt_values (okl_opv_rules_v.ove_id)
713: ovd.ID,
714: ovd.ORL_ID, --required fk to okl_opt_ruls
715: ovd.CONTEXT_INTENT, --should be same as khr intent
716: ovd.COPY_OR_ENTER_FLAG, --if it 'CPY' copy to k and do not allow modfn, else sllow mdfn

Line 722: OKL_OPT_VALUES ove

718: ovd.CONTEXT_ORG, --should be same as contract org_id
719: ovd.CONTEXT_ASSET_BOOK, --what chk on this??
720: ovd.INDIVIDUAL_INSTRUCTIONS
721: FROM OKL_OPV_RULES ovd,
722: OKL_OPT_VALUES ove
723: WHERE ovd.ove_id = ove.id
724: AND nvl(ove.FROM_DATE,sysdate) <= sysdate
725: AND nvl(ove.TO_DATE,sysdate+1) > sysdate
726: AND ove.ID = p_ove_id; --(p_ove id will be ove id fetched in last csr)