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 2573: FROM okc_rule_groups_v rglease

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

Line 2578: FROM okc_rule_groups_v rg,

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

Line 2701: l_rgp_id okc_rule_groups_v.id%TYPE;

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

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

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

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

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

Line 2705: x_rgp_id okc_rule_groups_v.id%TYPE;

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

Line 2747: FROM okc_rule_groups_v rg,

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

Line 2760: FROM okc_rule_groups_v rglease

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

Line 2859: FROM okc_rule_groups_v rgpv

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

Line 8104: FROM okc_rule_groups_v rgp, okc_rules_v rul

8100: AND gvr.dnz_chr_id = p_durv_rec.chr_id;
8101:
8102: CURSOR l_dff_rule_csr(p_rgd_code VARCHAR2, p_rule_information_category VARCHAR2) IS
8103: SELECT rgp.id, rul.id, rul.rule_information1
8104: FROM okc_rule_groups_v rgp, okc_rules_v rul
8105: WHERE rgp.id = rul.rgp_id
8106: AND rgp.rgd_code = p_rgd_code
8107: AND rul.rule_information_category = p_rule_information_category
8108: AND rul.dnz_chr_id = p_durv_rec.chr_id

Line 8123: FROM okc_rule_groups_v rgp, okc_rules_v rul

8119: --end modified abhsaxen for performance SQLID 20563248
8120: ;
8121: CURSOR l_customer_account_csr IS
8122: SELECT rgp.id, rul.id, rul.object1_id1,rul.object1_id2,rul.jtot_object1_code
8123: FROM okc_rule_groups_v rgp, okc_rules_v rul
8124: WHERE rgp.id = rul.rgp_id
8125: AND rgp.rgd_code = 'LACAN'
8126: AND rul.rule_information_category = 'CAN'
8127: AND rul.dnz_chr_id = p_durv_rec.chr_id