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

Line 832: FROM okc_rule_groups_v

828:
829: CURSOR del_rgp_csr(p_chr_id OKC_K_HEADERS_V.ID%TYPE,
830: p_rgp_id NUMBER) IS
831: SELECT id
832: FROM okc_rule_groups_v
833: WHERE dnz_chr_id = p_chr_id
834: AND id = p_rgp_id
835: AND rgd_code = 'LALEVL';
836:

Line 992: FROM okc_rule_groups_v

988: CURSOR lalevl_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
989: p_cle_id OKC_K_LINES_V.ID%TYPE) IS
990: SELECT id,
991: cle_id
992: FROM okc_rule_groups_v
993: WHERE dnz_chr_id = p_chr_id
994: AND cle_id = p_cle_id
995: AND rgd_code = 'LALEVL';
996:

Line 1000: FROM okc_rule_groups_v

996:
997: CURSOR old_lalevl_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
998: p_cle_id OKC_K_LINES_V.ID%TYPE) IS
999: SELECT id
1000: FROM okc_rule_groups_v
1001: WHERE dnz_chr_id = p_chr_id
1002: AND rgd_code = 'LALEVL'
1003: AND (cle_id = p_cle_id
1004: OR ( cle_id IS NULL

Line 1070: FROM okc_rule_groups_v

1066:
1067: CURSOR lalevl_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
1068: SELECT id,
1069: cle_id
1070: FROM okc_rule_groups_v
1071: WHERE dnz_chr_id = p_chr_id
1072: AND cle_id IS NULL -- Bug 2376998
1073: AND rgd_code = 'LALEVL';
1074:

Line 1078: FROM okc_rule_groups_v

1074:
1075: CURSOR old_lalevl_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
1076: p_cle_id OKC_K_LINES_V.ID%TYPE) IS
1077: SELECT id
1078: FROM okc_rule_groups_v
1079: WHERE dnz_chr_id = p_chr_id
1080: AND rgd_code = 'LALEVL'
1081: AND (cle_id = p_cle_id
1082: OR ( cle_id IS NULL

Line 2576: FROM okc_rule_groups_v rglease

2572:
2573: -- returns rgp id thet exist in lease as well as vp
2574: CURSOR c_prev_src_crs(p_vp_tmpl_id IN NUMBER) IS
2575: SELECT rglease.id, rglease.rgd_code
2576: FROM okc_rule_groups_v rglease
2577: WHERE dnz_chr_id = p_dest_id
2578: AND chr_id = p_dest_id
2579: AND EXISTS(
2580: SELECT '1'

Line 2581: FROM okc_rule_groups_v rg,

2577: WHERE dnz_chr_id = p_dest_id
2578: AND chr_id = p_dest_id
2579: AND EXISTS(
2580: SELECT '1'
2581: FROM okc_rule_groups_v rg,
2582: okc_k_headers_v hdr
2583: WHERE rg.chr_id = p_vp_tmpl_id
2584: AND hdr.id = rg.chr_id
2585: AND hdr.id = rg.dnz_chr_id

Line 2704: l_rgp_id okc_rule_groups_v.id%TYPE;

2700:
2701: l_api_name VARCHAR2(30) := 'COPY_RULES';
2702: l_api_version CONSTANT NUMBER := 1.0;
2703:
2704: l_rgp_id okc_rule_groups_v.id%TYPE;
2705: l_cle_id okc_rule_groups_v.cle_id%TYPE DEFAULT NULL;
2706: l_chr_id okc_rule_groups_v.chr_id%TYPE := p_dest_id;
2707: l_to_template_yn VARCHAR2(5) :='N';
2708: x_rgp_id okc_rule_groups_v.id%TYPE;

Line 2705: l_cle_id okc_rule_groups_v.cle_id%TYPE DEFAULT NULL;

2701: l_api_name VARCHAR2(30) := 'COPY_RULES';
2702: l_api_version CONSTANT NUMBER := 1.0;
2703:
2704: l_rgp_id okc_rule_groups_v.id%TYPE;
2705: l_cle_id okc_rule_groups_v.cle_id%TYPE DEFAULT NULL;
2706: l_chr_id okc_rule_groups_v.chr_id%TYPE := p_dest_id;
2707: l_to_template_yn VARCHAR2(5) :='N';
2708: x_rgp_id okc_rule_groups_v.id%TYPE;
2709:

Line 2706: l_chr_id okc_rule_groups_v.chr_id%TYPE := p_dest_id;

2702: l_api_version CONSTANT NUMBER := 1.0;
2703:
2704: l_rgp_id okc_rule_groups_v.id%TYPE;
2705: l_cle_id okc_rule_groups_v.cle_id%TYPE DEFAULT NULL;
2706: l_chr_id okc_rule_groups_v.chr_id%TYPE := p_dest_id;
2707: l_to_template_yn VARCHAR2(5) :='N';
2708: x_rgp_id okc_rule_groups_v.id%TYPE;
2709:
2710: l_func_curr_code okc_k_headers_b.currency_code%TYPE := NULL;

Line 2708: x_rgp_id okc_rule_groups_v.id%TYPE;

2704: l_rgp_id okc_rule_groups_v.id%TYPE;
2705: l_cle_id okc_rule_groups_v.cle_id%TYPE DEFAULT NULL;
2706: l_chr_id okc_rule_groups_v.chr_id%TYPE := p_dest_id;
2707: l_to_template_yn VARCHAR2(5) :='N';
2708: x_rgp_id okc_rule_groups_v.id%TYPE;
2709:
2710: l_func_curr_code okc_k_headers_b.currency_code%TYPE := NULL;
2711: l_k_curr_code okc_k_headers_b.currency_code%TYPE := NULL;
2712: l_start_date okc_k_headers_b.start_date%TYPE;

Line 2750: FROM okc_rule_groups_v rg,

2746:
2747: -- returns vendor program rgd codes which are qualified for lease
2748: CURSOR c_src_crs(p_vp_tmpl_id IN NUMBER) IS
2749: SELECT rg.id
2750: FROM okc_rule_groups_v rg,
2751: okc_k_headers_v hdr
2752: WHERE rg.chr_id = p_vp_tmpl_id
2753: AND hdr.id = rg.chr_id
2754: AND hdr.id = rg.dnz_chr_id

Line 2763: FROM okc_rule_groups_v rglease

2759: WHERE rgdfs.rgd_code = rg.rgd_code
2760: AND rgdfs.scs_code = 'LEASE')
2761: AND NOT EXISTS
2762: (SELECT '1'
2763: FROM okc_rule_groups_v rglease
2764: WHERE dnz_chr_id =p_dest_id
2765: AND chr_id = p_dest_id
2766: AND rglease.rgd_code = rg.rgd_code);
2767:

Line 2862: FROM okc_rule_groups_v rgpv

2858: AND rgrdfs.sre_id = sre.id;
2859:
2860: CURSOR c_vndr_blng_id_csr IS
2861: SELECT rgpv.id
2862: FROM okc_rule_groups_v rgpv
2863: WHERE rgpv.rgd_code = G_VENDOR_BILL_RGD_CODE
2864: AND rgpv.dnz_chr_id = p_source_id;
2865:
2866: CURSOR c_vp_cpl_csr IS

Line 8113: FROM okc_rule_groups_v rgp, okc_rules_v rul

8109: AND gvr.dnz_chr_id = p_durv_rec.chr_id;
8110:
8111: CURSOR l_dff_rule_csr(p_rgd_code VARCHAR2, p_rule_information_category VARCHAR2) IS
8112: SELECT rgp.id, rul.id, rul.rule_information1
8113: FROM okc_rule_groups_v rgp, okc_rules_v rul
8114: WHERE rgp.id = rul.rgp_id
8115: AND rgp.rgd_code = p_rgd_code
8116: AND rul.rule_information_category = p_rule_information_category
8117: AND rul.dnz_chr_id = p_durv_rec.chr_id

Line 8132: FROM okc_rule_groups_v rgp, okc_rules_v rul

8128: --end modified abhsaxen for performance SQLID 20563248
8129: ;
8130: CURSOR l_customer_account_csr IS
8131: SELECT rgp.id, rul.id, rul.object1_id1,rul.object1_id2,rul.jtot_object1_code
8132: FROM okc_rule_groups_v rgp, okc_rules_v rul
8133: WHERE rgp.id = rul.rgp_id
8134: AND rgp.rgd_code = 'LACAN'
8135: AND rul.rule_information_category = 'CAN'
8136: AND rul.dnz_chr_id = p_durv_rec.chr_id