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_JTOT_CONTACT_EXTRACT_PUB dependencies on OKC_RULE_GROUPS_V

Line 1304: from okc_rg_party_roles_v rgpr, okc_rule_groups_v rgp

1300: --end modified abhsaxen for performance SQLID 20562568
1301: ;
1302: cursor l_rg_party_csr is
1303: select rgpr.id ,rgpr.rgp_id
1304: from okc_rg_party_roles_v rgpr, okc_rule_groups_v rgp
1305: where rgpr.dnz_chr_id = p_chr_id
1306: and rgpr.cpl_id = p_cpl_id
1307: and rgpr.dnz_chr_id = rgp.dnz_chr_id
1308: and rgpr.dnz_chr_id = rgp.chr_id

Line 1313: from okc_rg_party_roles_v rgpr, okc_rule_groups_v rgp, okc_rules_v rul

1309: and rgpr.rgp_id = rgp.id;
1310:
1311: cursor l_r_party_csr is
1312: select rul.id
1313: from okc_rg_party_roles_v rgpr, okc_rule_groups_v rgp, okc_rules_v rul
1314: where rgpr.dnz_chr_id = p_chr_id
1315: and rgpr.cpl_id = p_cpl_id
1316: and rgpr.dnz_chr_id = rgp.dnz_chr_id
1317: and rgpr.dnz_chr_id = rgp.chr_id