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_VP_SYNC_CR_PVT dependencies on OKC_RULES_B

Line 1374: okc_rules_b rulb

1370: hz_cust_site_uses_all hzcsu,
1371: okc_rg_party_roles rgrp,
1372: okc_rule_groups_b rgpb,
1373: hz_parties hzp,
1374: okc_rules_b rulb
1375: WHERE cplv.dnz_chr_id = chrb.id
1376: and cplv.chr_id = chrb.id
1377: and hzc.cust_account_id(+) = cplv.cust_acct_id
1378: and hzcsu.site_use_id(+) = cplv.bill_to_site_use_id

Line 1412: ,okc_rules_b rul_lainpr

1408: ,rul_lapmth.object1_id2 rul_lapmth_o1id2
1409: FROM okc_k_headers_b chr
1410: ,okl_k_headers khr
1411: ,okc_rule_groups_b rgp_lavenb
1412: ,okc_rules_b rul_lainpr
1413: ,okc_rules_b rul_lainvd
1414: ,okc_rules_b rul_labacc
1415: ,okc_rules_b rul_lapmth
1416: WHERE chr.id = khr.id

Line 1413: ,okc_rules_b rul_lainvd

1409: FROM okc_k_headers_b chr
1410: ,okl_k_headers khr
1411: ,okc_rule_groups_b rgp_lavenb
1412: ,okc_rules_b rul_lainpr
1413: ,okc_rules_b rul_lainvd
1414: ,okc_rules_b rul_labacc
1415: ,okc_rules_b rul_lapmth
1416: WHERE chr.id = khr.id
1417: AND rgp_lavenb.dnz_chr_id(+) = chr.id

Line 1414: ,okc_rules_b rul_labacc

1410: ,okl_k_headers khr
1411: ,okc_rule_groups_b rgp_lavenb
1412: ,okc_rules_b rul_lainpr
1413: ,okc_rules_b rul_lainvd
1414: ,okc_rules_b rul_labacc
1415: ,okc_rules_b rul_lapmth
1416: WHERE chr.id = khr.id
1417: AND rgp_lavenb.dnz_chr_id(+) = chr.id
1418: AND rgp_lavenb.rgd_code(+) = 'LAVENB'

Line 1415: ,okc_rules_b rul_lapmth

1411: ,okc_rule_groups_b rgp_lavenb
1412: ,okc_rules_b rul_lainpr
1413: ,okc_rules_b rul_lainvd
1414: ,okc_rules_b rul_labacc
1415: ,okc_rules_b rul_lapmth
1416: WHERE chr.id = khr.id
1417: AND rgp_lavenb.dnz_chr_id(+) = chr.id
1418: AND rgp_lavenb.rgd_code(+) = 'LAVENB'
1419: AND rgp_lavenb.id = rul_lainpr.rgp_id(+)

Line 2472: CURSOR c_rl_exist_csr (cp_rul_info_cat okc_rules_b.rule_information_category%TYPE,

2468: AND orig.rgd_code = creq.rgd_code
2469: AND orig.dnz_chr_id = cp_orig_chr_id
2470: AND orig.cle_id IS NULL);
2471:
2472: CURSOR c_rl_exist_csr (cp_rul_info_cat okc_rules_b.rule_information_category%TYPE,
2473: cp_chr_id okc_k_headers_b.id%TYPE,
2474: cp_rgd_code okc_rule_groups_b.rgd_code%TYPE) IS
2475: SELECT rul.id
2476: ,rul.rgp_id

Line 2478: FROM okc_rules_b rul

2474: cp_rgd_code okc_rule_groups_b.rgd_code%TYPE) IS
2475: SELECT rul.id
2476: ,rul.rgp_id
2477: ,rul.object_version_number
2478: FROM okc_rules_b rul
2479: ,okc_rule_groups_b rgp
2480: WHERE rgp.id = rul.rgp_id
2481: AND rgp.chr_id = rul.dnz_chr_id
2482: AND rul.rule_information_category = cp_rul_info_cat

Line 2528: lv_rule_information1 okc_rules_b.rule_information1%TYPE;

2524: x_rulv2_tbl okl_rule_pub.rulv_tbl_type;
2525: lv_rgp_id okc_rule_groups_b.id%TYPE;
2526: lx_rulv2_tbl OKL_RULE_PUB.rulv_tbl_type;
2527: lv_rgpv_del_tbl okl_vp_rule_pub.rgpv_tbl_type;
2528: lv_rule_information1 okc_rules_b.rule_information1%TYPE;
2529:
2530: lx_rulv_count NUMBER;
2531: lv_rulv2_count NUMBER;
2532: lv_process_idx PLS_INTEGER;