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

Line 1092: okc_rules_b rul

1088: select rul.id rul_id,
1089: rgp.id rgp_id,
1090: rul.rule_information1
1091: from okc_rule_groups_b rgp,
1092: okc_rules_b rul
1093: where rgp.id = rul.rgp_id
1094: and rgp.rgd_code = 'LARLES'
1095: and rul.rule_information_category = 'LARLES'
1096: and rgp.dnz_chr_id = p_chr_id

Line 3233: okc_rules_b crl

3229: p_rul_cat IN VARCHAR2
3230: ) IS
3231: SELECT crl.rule_information1
3232: FROM okc_rule_groups_b crg,
3233: okc_rules_b crl
3234: WHERE crl.rgp_id = crg.id
3235: AND crg.rgd_code = p_rgd_code
3236: AND crl.rule_information_category = p_rul_cat
3237: AND crg.dnz_chr_id = p_chr_id;

Line 3309: FROM okc_rules_b sll,

3305: NVL(TO_NUMBER(sll.rule_information3),1) *
3306: DECODE(sll.object1_id1, 'M',1,'Q',3,'S',6,'A',12)) - 1),
3307: FND_DATE.canonical_to_date(sll.rule_information2) +
3308: TO_NUMBER(sll.rule_information7) - 1) end_date
3309: FROM okc_rules_b sll,
3310: okc_rules_b slh,
3311: okc_rule_groups_b rgp,
3312: okl_strm_type_b sty
3313: WHERE rgp.dnz_chr_id = p_chr_id

Line 3310: okc_rules_b slh,

3306: DECODE(sll.object1_id1, 'M',1,'Q',3,'S',6,'A',12)) - 1),
3307: FND_DATE.canonical_to_date(sll.rule_information2) +
3308: TO_NUMBER(sll.rule_information7) - 1) end_date
3309: FROM okc_rules_b sll,
3310: okc_rules_b slh,
3311: okc_rule_groups_b rgp,
3312: okl_strm_type_b sty
3313: WHERE rgp.dnz_chr_id = p_chr_id
3314: AND rgp.cle_id = p_cle_id

Line 3651: FROM okc_rules_b sll,

3647: sll.object2_id2,
3648: sll.jtot_object2_code,
3649: sll.id sll_id,
3650: sty.stream_type_purpose
3651: FROM okc_rules_b sll,
3652: okc_rules_b slh,
3653: okc_rule_groups_b rgp,
3654: okl_strm_type_b sty
3655: WHERE rgp.dnz_chr_id = p_chr_id

Line 3652: okc_rules_b slh,

3648: sll.jtot_object2_code,
3649: sll.id sll_id,
3650: sty.stream_type_purpose
3651: FROM okc_rules_b sll,
3652: okc_rules_b slh,
3653: okc_rule_groups_b rgp,
3654: okl_strm_type_b sty
3655: WHERE rgp.dnz_chr_id = p_chr_id
3656: AND rgp.rgd_code = 'LALEVL'

Line 3667: FROM okc_rules_b slh

3663: AND FND_DATE.canonical_to_date(sll.rule_information2) < p_release_date;
3664:
3665: CURSOR slh_csr(p_chr_id IN NUMBER) IS
3666: SELECT slh.id slh_id
3667: FROM okc_rules_b slh
3668: WHERE slh.dnz_chr_id = p_chr_id
3669: AND slh.rule_information_category = 'LASLH'
3670: AND NOT EXISTS (SELECT NULL FROM okc_rules_b sll
3671: WHERE sll.object2_id1 = slh.id

Line 3670: AND NOT EXISTS (SELECT NULL FROM okc_rules_b sll

3666: SELECT slh.id slh_id
3667: FROM okc_rules_b slh
3668: WHERE slh.dnz_chr_id = p_chr_id
3669: AND slh.rule_information_category = 'LASLH'
3670: AND NOT EXISTS (SELECT NULL FROM okc_rules_b sll
3671: WHERE sll.object2_id1 = slh.id
3672: AND sll.rule_information_category = 'LASLL'
3673: AND sll.dnz_chr_id = slh.dnz_chr_id);
3674:

Line 3680: AND NOT EXISTS (SELECT NULL FROM okc_rules_b slh

3676: SELECT rgp.id rgp_id
3677: FROM okc_rule_groups_b rgp
3678: WHERE rgp.dnz_chr_id = p_chr_id
3679: AND rgp.rgd_code = 'LALEVL'
3680: AND NOT EXISTS (SELECT NULL FROM okc_rules_b slh
3681: WHERE slh.rgp_id = rgp.id
3682: AND slh.rule_information_category = 'LASLH');
3683:
3684: l_rulv_rec OKL_RULE_PUB.rulv_rec_type;

Line 4187: FROM okc_rules_b rul_lafexp,

4183: TO_NUMBER(rul_lafexp.rule_information2) amount,
4184: rul_lafexp.id rul_lafexp_id,
4185: rul_lafreq.id rul_lafreq_id,
4186: rgp.id rgp_id
4187: FROM okc_rules_b rul_lafexp,
4188: okc_rules_b rul_lafreq,
4189: okc_rule_groups_b rgp
4190: WHERE rgp.dnz_chr_id = p_chr_id
4191: AND rgp.cle_id = p_cle_id

Line 4188: okc_rules_b rul_lafreq,

4184: rul_lafexp.id rul_lafexp_id,
4185: rul_lafreq.id rul_lafreq_id,
4186: rgp.id rgp_id
4187: FROM okc_rules_b rul_lafexp,
4188: okc_rules_b rul_lafreq,
4189: okc_rule_groups_b rgp
4190: WHERE rgp.dnz_chr_id = p_chr_id
4191: AND rgp.cle_id = p_cle_id
4192: AND rgp.rgd_code = 'LAFEXP'

Line 4246: FROM okc_rules_b crl

4242: SELECT crl.object1_id1,
4243: crl.rule_information3,
4244: crl.rule_information6,
4245: crl.rule_information8
4246: FROM okc_rules_b crl
4247: WHERE crl.rgp_id = p_rgp_id
4248: AND crl.dnz_chr_id = p_chr_id
4249: AND crl.rule_information_category = p_rul_cat;
4250:

Line 5707: FROM okc_rules_b rul_lafexp,

5703: TO_NUMBER(rul_lafexp.rule_information2) amount,
5704: rul_lafexp.id rul_lafexp_id,
5705: rul_lafreq.id rul_lafreq_id,
5706: rgp.id rgp_id
5707: FROM okc_rules_b rul_lafexp,
5708: okc_rules_b rul_lafreq,
5709: okc_rule_groups_b rgp
5710: WHERE rgp.dnz_chr_id = p_chr_id
5711: AND rgp.cle_id = p_cle_id

Line 5708: okc_rules_b rul_lafreq,

5704: rul_lafexp.id rul_lafexp_id,
5705: rul_lafreq.id rul_lafreq_id,
5706: rgp.id rgp_id
5707: FROM okc_rules_b rul_lafexp,
5708: okc_rules_b rul_lafreq,
5709: okc_rule_groups_b rgp
5710: WHERE rgp.dnz_chr_id = p_chr_id
5711: AND rgp.cle_id = p_cle_id
5712: AND rgp.rgd_code = 'LAFEXP'

Line 6386: FROM okc_rules_b sll,

6382: p_cle_id IN NUMBER) IS
6383: SELECT TO_NUMBER(sll.rule_information6) amount,
6384: TO_NUMBER(sll.rule_information8) stub_amount,
6385: sll.id sll_id
6386: FROM okc_rules_b sll,
6387: okc_rule_groups_b rgp
6388: WHERE rgp.dnz_chr_id = p_chr_id
6389: AND rgp.cle_id = p_cle_id
6390: AND rgp.rgd_code = 'LALEVL'

Line 6709: okc_rules_b rulb

6705: Cursor l_book_class_csr (p_chr_id IN NUMBER) is
6706: select khr.deal_type deal_type,
6707: rulb.rule_information1 tax_owner
6708: from okl_k_headers khr,
6709: okc_rules_b rulb
6710: where rulb.dnz_chr_id = p_chr_id
6711: and rulb.rule_information_category = 'LATOWN'
6712: and khr.id = p_chr_id;
6713:

Line 7525: okc_rules_b rul

7521: p_rul_cat IN VARCHAR2) IS
7522: select rul.id rul_id,
7523: rgp.id rgp_id
7524: from okc_rule_groups_b rgp,
7525: okc_rules_b rul
7526: where rgp.id = rul.rgp_id
7527: and rgp.rgd_code = p_rgd_code
7528: and rul.rule_information_category = p_rul_cat
7529: and rgp.dnz_chr_id = p_chr_id