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.OKS_RULE_MIGRATE dependencies on OKC_RULE_GROUPS_B

Line 232: From OKC_RULE_GROUPS_B rgp ;

228: max(rgp.id) maxid,
229: avg(rgp.id) avgid,
230: stddev(rgp.id) stdid,
231: count(*) total
232: From OKC_RULE_GROUPS_B rgp ;
233:
234: Cursor l_hdr_agg_csr2 IS
235: Select /*+ PARALLEL(hdr) */
236: min(hdr.id) minid,

Line 250: From OKC_RULE_GROUPS_BH rgp ;

246: max(rgp.id) maxid,
247: avg(rgp.id) avgid,
248: stddev(rgp.id) stdid,
249: count(*) total
250: From OKC_RULE_GROUPS_BH rgp ;
251:
252: Cursor l_hdr_agg_csr4 IS
253: Select /*+ PARALLEL(hdr) */
254: min(hdr.id) minid,

Line 419: -- The following csr is on OKC_RULE_GROUPS_B

415: DBMS_SQL.CLOSE_CURSOR(trunc_curs);
416:
417:
418: If (p_status is null and p_org_id is null ) then
419: -- The following csr is on OKC_RULE_GROUPS_B
420: open l_hdr_agg_csr1;
421: fetch l_hdr_agg_csr1 into l_hdr_agg_rec;
422: close l_hdr_agg_csr1;
423:

Line 508: -- The following csr is on OKC_RULE_GROUPS_BH

504: rc := dbms_sql.execute(trunc_curs);
505: DBMS_SQL.CLOSE_CURSOR(trunc_curs);
506:
507: If (p_status is null and p_org_id is null ) then
508: -- The following csr is on OKC_RULE_GROUPS_BH
509: open l_hdr_agg_csr3;
510: fetch l_hdr_agg_csr3 into l_hdr_agg_rec;
511: close l_hdr_agg_csr3;
512:

Line 597: -- The following csr is on OKC_RULE_GROUPS_B

593: rc := dbms_sql.execute(trunc_curs);
594: DBMS_SQL.CLOSE_CURSOR(trunc_curs);
595:
596: If (p_status is null and p_org_id is null ) then
597: -- The following csr is on OKC_RULE_GROUPS_B
598: open l_hdr_agg_csr1;
599: fetch l_hdr_agg_csr1 into l_hdr_agg_rec;
600: close l_hdr_agg_csr1;
601:

Line 682: -- The following csr is on OKC_RULE_GROUPS_B

678: rc := dbms_sql.execute(trunc_curs);
679: DBMS_SQL.CLOSE_CURSOR(trunc_curs);
680:
681: If (p_status is null and p_org_id is null ) then
682: -- The following csr is on OKC_RULE_GROUPS_B
683: open l_hdr_agg_csr3;
684: fetch l_hdr_agg_csr3 into l_hdr_agg_rec;
685: close l_hdr_agg_csr3;
686:

Line 770: -- The following csr is on OKC_RULE_GROUPS_BH

766: DBMS_SQL.CLOSE_CURSOR(trunc_curs);
767:
768:
769: If (p_status is null and p_org_id is null ) then
770: -- The following csr is on OKC_RULE_GROUPS_BH
771: open l_hdr_agg_csr3;
772: fetch l_hdr_agg_csr3 into l_hdr_agg_rec;
773: close l_hdr_agg_csr3;
774:

Line 818: -- The following csr is on OKC_RULE_GROUPS_B

814:
815:
816:
817: If (p_status is null and p_org_id is null ) then
818: -- The following csr is on OKC_RULE_GROUPS_B
819: open l_hdr_agg_csr1;
820: fetch l_hdr_agg_csr1 into l_hdr_agg_rec;
821: close l_hdr_agg_csr1;
822:

Line 1295: FROM OKC_RULE_GROUPS_B RGP

1291: '!abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ_,.','!'),
1292: MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'PRE' ,RUL.OBJECT1_ID1)),NULL,
1293: MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'PRE' ,RUL.OBJECT1_ID1)))
1294: PRICE_LIST_ID --OKC
1295: FROM OKC_RULE_GROUPS_B RGP
1296: , OKC_RULES_B RUL
1297: WHERE rgp.id = rul.rgp_id
1298: AND rgp.cle_id is null
1299: AND rgp.chr_id is not null

Line 1535: FROM OKC_RULE_GROUPS_B RGP

1531: '!abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ_,.','!'),
1532: MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'PRE' ,RUL.OBJECT1_ID1)),NULL,
1533: MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'PRE' ,RUL.OBJECT1_ID1)))
1534: PRICE_LIST_ID --OKC
1535: FROM OKC_RULE_GROUPS_B RGP
1536: , OKC_RULES_B RUL
1537: , OKC_K_HEADERS_B HDR
1538: WHERE rgp.id = rul.rgp_id
1539: and rgp.cle_id is null

Line 1780: FROM OKC_RULE_GROUPS_B RGP

1776: '!abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ_,.','!'),
1777: MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'PRE' ,RUL.OBJECT1_ID1)),NULL,
1778: MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'PRE' ,RUL.OBJECT1_ID1)))
1779: PRICE_LIST_ID --OKC
1780: FROM OKC_RULE_GROUPS_B RGP
1781: , OKC_RULES_B RUL
1782: WHERE rgp.id = rul.rgp_id
1783: AND rgp.cle_id is null
1784: AND rgp.chr_id is not null

Line 2020: FROM OKC_RULE_GROUPS_B RGP

2016: '!abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ_,.','!'),
2017: MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'PRE' ,RUL.OBJECT1_ID1)),NULL,
2018: MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'PRE' ,RUL.OBJECT1_ID1)))
2019: PRICE_LIST_ID --OKC
2020: FROM OKC_RULE_GROUPS_B RGP
2021: , OKC_RULES_B RUL
2022: , OKC_K_HEADERS_B HDR
2023: WHERE rgp.id = rul.rgp_id
2024: and rgp.cle_id is null

Line 2085: , OKC_RULE_GROUPS_B RGP

2081: , HDR.CONTRACT_NUMBER_MODIFIER
2082: , RUL.ID
2083: , RGP.ID RGP_ID
2084: FROM OKC_K_HEADERS_B HDR
2085: , OKC_RULE_GROUPS_B RGP
2086: , OKC_RULES_B RUL
2087: WHERE HDR.ID = P_HDR_ID
2088: AND RGP.DNZ_CHR_ID = P_HDR_ID
2089: AND RGP.CHR_ID = P_HDR_ID

Line 3628: FROM OKC_RULE_GROUPS_B RGP

3624: '!abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ_,','!'),
3625: MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'SLL' ,RUL.RULE_INFORMATION6)),NULL,
3626: MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'SLL' ,RUL.RULE_INFORMATION6)))
3627: LEVEL_AMOUNT
3628: FROM OKC_RULE_GROUPS_B RGP
3629: , OKC_RULES_B RUL
3630: WHERE RGP.ID = RUL.RGP_ID
3631: AND RUL.RULE_INFORMATION_CATEGORY IN ('DST','ARL','CCR','GPR','IRT','TAX','IBR','PDL','QRE','SLH','CAN','BTO','IRE','LRT','STO','PTR',
3632: 'ECE','PMP','DST','RCN','RSN','LMT','PRE','SLL')

Line 3863: FROM OKC_RULE_GROUPS_B RGP

3859: '!abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ_,','!'),
3860: MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'SLL' ,RUL.RULE_INFORMATION6)),NULL,
3861: MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'SLL' ,RUL.RULE_INFORMATION6)))
3862: LEVEL_AMOUNT
3863: FROM OKC_RULE_GROUPS_B RGP
3864: , OKC_RULES_B RUL
3865: , OKC_K_HEADERS_B HDR
3866: WHERE RGP.ID = RUL.RGP_ID
3867: AND RUL.RULE_INFORMATION_CATEGORY IN ('DST','ARL','CCR','GPR','IRT','TAX','IBR','PDL','QRE','SLH','CAN','BTO','IRE','LRT','STO','PTR',

Line 4101: FROM OKC_RULE_GROUPS_B RGP

4097: '!abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ_.','!'),
4098: MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'SLL' ,RUL.RULE_INFORMATION6)),NULL,
4099: MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'SLL' ,RUL.RULE_INFORMATION6)))
4100: LEVEL_AMOUNT
4101: FROM OKC_RULE_GROUPS_B RGP
4102: , OKC_RULES_B RUL
4103: WHERE RGP.ID = RUL.RGP_ID
4104: AND RUL.RULE_INFORMATION_CATEGORY IN ('DST','ARL','CCR','GPR','IRT','TAX','IBR','PDL','QRE','SLH','CAN','BTO','IRE','LRT','STO','PTR',
4105: 'ECE','PMP','DST','RCN','RSN','LMT','PRE','SLL')

Line 4336: FROM OKC_RULE_GROUPS_B RGP

4332: '!abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ_.','!'),
4333: MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'SLL' ,RUL.RULE_INFORMATION6)),NULL,
4334: MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'SLL' ,RUL.RULE_INFORMATION6)))
4335: LEVEL_AMOUNT
4336: FROM OKC_RULE_GROUPS_B RGP
4337: , OKC_RULES_B RUL
4338: , OKC_K_HEADERS_B HDR
4339: WHERE RGP.ID = RUL.RGP_ID
4340: AND RUL.RULE_INFORMATION_CATEGORY IN ('DST','ARL','CCR','GPR','IRT','TAX','IBR','PDL','QRE','SLH','CAN','BTO','IRE','LRT','STO','PTR',

Line 4400: , OKC_RULE_GROUPS_B RGP

4396: , LIN.LINE_NUMBER
4397: , RUL.ID
4398: , RGP.ID RGP_ID
4399: FROM OKC_K_HEADERS_B HDR
4400: , OKC_RULE_GROUPS_B RGP
4401: , OKC_RULES_B RUL
4402: , OKC_K_LINES_B LIN
4403: WHERE HDR.ID = P_HDR_ID
4404: AND LIN.ID= P_CLE_ID

Line 6071: FROM OKC_RULE_GROUPS_BH RGP

6067: '!abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ_,','!'),
6068: MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'SLL' ,RUL.RULE_INFORMATION6)),NULL,
6069: MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'SLL' ,RUL.RULE_INFORMATION6)))
6070: LEVEL_AMOUNT
6071: FROM OKC_RULE_GROUPS_BH RGP
6072: , OKC_RULES_BH RUL
6073: WHERE RGP.ID = RUL.RGP_ID
6074: AND RGP.MAJOR_VERSION = RUL.MAJOR_VERSION
6075: AND RGP.DNZ_CHR_ID = RUL.DNZ_CHR_ID

Line 6309: FROM OKC_RULE_GROUPS_BH RGP

6305: '!abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ_,','!'),
6306: MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'SLL' ,RUL.RULE_INFORMATION6)),NULL,
6307: MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'SLL' ,RUL.RULE_INFORMATION6)))
6308: LEVEL_AMOUNT
6309: FROM OKC_RULE_GROUPS_BH RGP
6310: , OKC_RULES_BH RUL
6311: , OKC_K_HEADERS_BH HDR
6312: WHERE RGP.ID = RUL.RGP_ID
6313: AND RUL.RULE_INFORMATION_CATEGORY IN ('DST','ARL','CCR','GPR','IRT','TAX','IBR','PDL','QRE','SLH','CAN','BTO','IRE','LRT','STO','PTR',

Line 6547: FROM OKC_RULE_GROUPS_BH RGP

6543: '!abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ_.','!'),
6544: MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'SLL' ,RUL.RULE_INFORMATION6)),NULL,
6545: MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'SLL' ,RUL.RULE_INFORMATION6)))
6546: LEVEL_AMOUNT
6547: FROM OKC_RULE_GROUPS_BH RGP
6548: , OKC_RULES_BH RUL
6549: WHERE RGP.ID = RUL.RGP_ID
6550: AND RGP.MAJOR_VERSION = RUL.MAJOR_VERSION
6551: AND RGP.DNZ_CHR_ID = RUL.DNZ_CHR_ID

Line 6785: FROM OKC_RULE_GROUPS_BH RGP

6781: '!abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ_.','!'),
6782: MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'SLL' ,RUL.RULE_INFORMATION6)),NULL,
6783: MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'SLL' ,RUL.RULE_INFORMATION6)))
6784: LEVEL_AMOUNT
6785: FROM OKC_RULE_GROUPS_BH RGP
6786: , OKC_RULES_BH RUL
6787: , OKC_K_HEADERS_BH HDR
6788: WHERE RGP.ID = RUL.RGP_ID
6789: AND RUL.RULE_INFORMATION_CATEGORY IN ('DST','ARL','CCR','GPR','IRT','TAX','IBR','PDL','QRE','SLH','CAN','BTO','IRE','LRT','STO','PTR',

Line 6853: , OKC_RULE_GROUPS_BH RGP

6849: , LIN.LINE_NUMBER
6850: , RUL.ID
6851: , RGP.ID RGP_ID
6852: FROM OKC_K_HEADERS_BH HDR
6853: , OKC_RULE_GROUPS_BH RGP
6854: , OKC_RULES_BH RUL
6855: , OKC_K_LINES_BH LIN
6856: WHERE HDR.ID = P_HDR_ID
6857: AND LIN.ID= P_CLE_ID

Line 8537: FROM OKC_RULE_GROUPS_BH RGP

8533: '!abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ_,.','!'),
8534: MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'PRE' ,RUL.OBJECT1_ID1)),NULL,
8535: MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'PRE' ,RUL.OBJECT1_ID1)))
8536: PRICE_LIST_ID --OKC
8537: FROM OKC_RULE_GROUPS_BH RGP
8538: , OKC_RULES_BH RUL
8539: WHERE rgp.id = rul.rgp_id
8540: and rgp.cle_id is null
8541: and rgp.chr_id is not null

Line 8777: FROM OKC_RULE_GROUPS_BH RGP

8773: '!abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ_,.','!'),
8774: MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'PRE' ,RUL.OBJECT1_ID1)),NULL,
8775: MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'PRE' ,RUL.OBJECT1_ID1)))
8776: PRICE_LIST_ID --OKC
8777: FROM OKC_RULE_GROUPS_BH RGP
8778: , OKC_RULES_BH RUL
8779: , OKC_K_HEADERS_BH HDR
8780: WHERE rgp.id = rul.rgp_id
8781: and rgp.cle_id is null

Line 9018: FROM OKC_RULE_GROUPS_BH RGP

9014: '!abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ_,.','!'),
9015: MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'PRE' ,RUL.OBJECT1_ID1)),NULL,
9016: MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'PRE' ,RUL.OBJECT1_ID1)))
9017: PRICE_LIST_ID --OKC
9018: FROM OKC_RULE_GROUPS_BH RGP
9019: , OKC_RULES_BH RUL
9020: WHERE rgp.id = rul.rgp_id
9021: and rgp.cle_id is null
9022: and rgp.chr_id is not null

Line 9258: FROM OKC_RULE_GROUPS_BH RGP

9254: '!abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ_,.','!'),
9255: MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'PRE' ,RUL.OBJECT1_ID1)),NULL,
9256: MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'PRE' ,RUL.OBJECT1_ID1)))
9257: PRICE_LIST_ID --OKC
9258: FROM OKC_RULE_GROUPS_BH RGP
9259: , OKC_RULES_BH RUL
9260: , OKC_K_HEADERS_BH HDR
9261: WHERE rgp.id = rul.rgp_id
9262: and rgp.cle_id is null

Line 9323: , OKC_RULE_GROUPS_BH RGP

9319: , HDR.MAJOR_VERSION
9320: , RUL.ID
9321: , RGP.ID RGP_ID
9322: FROM OKC_K_HEADERS_BH HDR
9323: , OKC_RULE_GROUPS_BH RGP
9324: , OKC_RULES_BH RUL
9325: WHERE HDR.ID = P_HDR_ID
9326: AND RGP.DNZ_CHR_ID = P_HDR_ID
9327: AND RGP.CHR_ID = P_HDR_ID

Line 11029: FROM OKC_RULE_GROUPS_B RGP

11025: MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'SLL' ,RUL.RULE_INFORMATION6)),NULL,
11026: MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'SLL' ,RUL.RULE_INFORMATION6)))
11027: LEVEL_AMOUNT
11028:
11029: FROM OKC_RULE_GROUPS_B RGP
11030: , OKC_RULES_B RUL
11031: WHERE rgp.id = rul.rgp_id
11032: AND rgp.rgd_code = 'SVC_K'
11033: AND RUL.RULE_INFORMATION_CATEGORY IN

Line 11409: FROM OKC_RULE_GROUPS_B RGP

11405: MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'SLL' ,RUL.RULE_INFORMATION6)),NULL,
11406: MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'SLL' ,RUL.RULE_INFORMATION6)))
11407: LEVEL_AMOUNT
11408:
11409: FROM OKC_RULE_GROUPS_B RGP
11410: , OKC_RULES_B RUL
11411: , OKC_K_HEADERS_B HDR
11412: WHERE rgp.id = rul.rgp_id
11413: and rgp.rgd_code = 'SVC_K'

Line 11790: FROM OKC_RULE_GROUPS_B RGP

11786: MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'SLL' ,RUL.RULE_INFORMATION6)),NULL,
11787: MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'SLL' ,RUL.RULE_INFORMATION6)))
11788: LEVEL_AMOUNT
11789:
11790: FROM OKC_RULE_GROUPS_B RGP
11791: , OKC_RULES_B RUL
11792: WHERE rgp.id = rul.rgp_id
11793: AND rgp.rgd_code = 'SVC_K'
11794: AND RUL.RULE_INFORMATION_CATEGORY IN

Line 12170: FROM OKC_RULE_GROUPS_B RGP

12166: MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'SLL' ,RUL.RULE_INFORMATION6)),NULL,
12167: MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'SLL' ,RUL.RULE_INFORMATION6)))
12168: LEVEL_AMOUNT
12169:
12170: FROM OKC_RULE_GROUPS_B RGP
12171: , OKC_RULES_B RUL
12172: , OKC_K_HEADERS_B HDR
12173: WHERE rgp.id = rul.rgp_id
12174: and rgp.rgd_code = 'SVC_K'

Line 12257: , OKC_RULE_GROUPS_B RGP

12253: , HDR.CONTRACT_NUMBER_MODIFIER
12254: , RUL.ID
12255: , RGP.ID RGP_ID
12256: FROM OKC_K_HEADERS_B HDR
12257: , OKC_RULE_GROUPS_B RGP
12258: , OKC_RULES_B RUL
12259: WHERE HDR.ID = P_HDR_ID
12260: AND RGP.DNZ_CHR_ID = P_HDR_ID
12261: AND RGP.CHR_ID = P_HDR_ID

Line 12279: , OKC_RULE_GROUPS_B RGP

12275: , LIN.LINE_NUMBER
12276: , RUL.ID
12277: , RGP.ID RGP_ID
12278: FROM OKC_K_HEADERS_B HDR
12279: , OKC_RULE_GROUPS_B RGP
12280: , OKC_RULES_B RUL
12281: , OKC_K_LINES_B LIN
12282: WHERE HDR.ID = P_HDR_ID
12283: AND LIN.ID= P_CLE_ID

Line 15873: FROM OKC_RULE_GROUPS_BH RGP

15869: MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'SLL' ,RUL.RULE_INFORMATION6)),NULL,
15870: MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'SLL' ,RUL.RULE_INFORMATION6)))
15871: LEVEL_AMOUNT
15872:
15873: FROM OKC_RULE_GROUPS_BH RGP
15874: , OKC_RULES_BH RUL
15875: WHERE rgp.id = rul.rgp_id
15876: AND rgp.rgd_code = 'SVC_K'
15877: AND RUL.RULE_INFORMATION_CATEGORY IN

Line 16254: FROM OKC_RULE_GROUPS_BH RGP

16250: MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'SLL' ,RUL.RULE_INFORMATION6)),NULL,
16251: MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'SLL' ,RUL.RULE_INFORMATION6)))
16252: LEVEL_AMOUNT
16253:
16254: FROM OKC_RULE_GROUPS_BH RGP
16255: , OKC_RULES_BH RUL
16256: , OKC_K_HEADERS_BH HDR
16257: WHERE rgp.id = rul.rgp_id
16258: and rgp.rgd_code = 'SVC_K'

Line 16635: FROM OKC_RULE_GROUPS_BH RGP

16631: MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'SLL' ,RUL.RULE_INFORMATION6)),NULL,
16632: MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'SLL' ,RUL.RULE_INFORMATION6)))
16633: LEVEL_AMOUNT
16634:
16635: FROM OKC_RULE_GROUPS_BH RGP
16636: , OKC_RULES_BH RUL
16637: WHERE rgp.id = rul.rgp_id
16638: AND rgp.rgd_code = 'SVC_K'
16639: AND RUL.RULE_INFORMATION_CATEGORY IN

Line 17016: FROM OKC_RULE_GROUPS_BH RGP

17012: MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'SLL' ,RUL.RULE_INFORMATION6)),NULL,
17013: MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'SLL' ,RUL.RULE_INFORMATION6)))
17014: LEVEL_AMOUNT
17015:
17016: FROM OKC_RULE_GROUPS_BH RGP
17017: , OKC_RULES_BH RUL
17018: , OKC_K_HEADERS_BH HDR
17019: WHERE rgp.id = rul.rgp_id
17020: and rgp.rgd_code = 'SVC_K'

Line 17105: , OKC_RULE_GROUPS_BH RGP

17101: , HDR.MAJOR_VERSION
17102: , RUL.ID
17103: , RGP.ID RGP_ID
17104: FROM OKC_K_HEADERS_BH HDR
17105: , OKC_RULE_GROUPS_BH RGP
17106: , OKC_RULES_BH RUL
17107: WHERE HDR.ID = P_HDR_ID
17108: AND RGP.DNZ_CHR_ID = P_HDR_ID
17109: AND RGP.CHR_ID = P_HDR_ID

Line 17128: , OKC_RULE_GROUPS_BH RGP

17124: , LIN.LINE_NUMBER
17125: , RUL.ID
17126: , RGP.ID RGP_ID
17127: FROM OKC_K_HEADERS_BH HDR
17128: , OKC_RULE_GROUPS_BH RGP
17129: , OKC_RULES_BH RUL
17130: , OKC_K_LINES_BH LIN
17131: WHERE HDR.ID = P_HDR_ID
17132: AND LIN.ID= P_CLE_ID

Line 20567: FROM OKC_RULE_GROUPS_B RGP

20563: ,MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'PTR' ,RUL.OBJECT1_ID1)) PAYMENT_TERM_ID --OKC
20564:
20565: ,TRANSLATE(MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'PRE' ,RUL.OBJECT1_ID1)),
20566: '!,.','!') PRICE_LIST_ID --OKC
20567: FROM OKC_RULE_GROUPS_B RGP
20568: , OKC_RULES_B RUL
20569: WHERE rgp.id = rul.rgp_id
20570: and rgp.cle_id is null
20571: and rgp.rgd_code = 'SVC_K'

Line 20759: FROM OKC_RULE_GROUPS_B RGP

20755: ,MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'PTR' ,RUL.OBJECT1_ID1)) PAYMENT_TERM_ID --OKC
20756:
20757: ,TRANSLATE(MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'PRE' ,RUL.OBJECT1_ID1)),
20758: '!,. ','!') PRICE_LIST_ID --OKC
20759: FROM OKC_RULE_GROUPS_B RGP
20760: , OKC_RULES_B RUL
20761: WHERE rgp.id = rul.rgp_id
20762: and rgp.cle_id is null
20763: and rgp.rgd_code = 'SVC_K'

Line 20781: , OKC_RULE_GROUPS_B RGP

20777: , HDR.CONTRACT_NUMBER_MODIFIER
20778: , RUL.ID
20779: , RGP.ID RGP_ID
20780: FROM OKC_K_HEADERS_B HDR
20781: , OKC_RULE_GROUPS_B RGP
20782: , OKC_RULES_B RUL
20783: WHERE HDR.ID = P_HDR_ID
20784: AND RGP.DNZ_CHR_ID = P_HDR_ID
20785: AND RGP.CHR_ID = P_HDR_ID

Line 20792: --Cursor to check whether the record exists in OKC_RULE_GROUPS_B table.

20788: AND RUL.RULE_INFORMATION_CATEGORY = P_CATEGORY ;
20789:
20790: L_HDR_DTLS_REC L_HDR_DTLS_CSR%ROWTYPE;
20791: ----------------------------------------------------------------------------
20792: --Cursor to check whether the record exists in OKC_RULE_GROUPS_B table.
20793: ----------------------------------------------------------------------------
20794: CURSOR L_CHECK_RGP_CSR ( P_ID IN NUMBER ) IS
20795: SELECT CHR_ID
20796: FROM OKC_RULE_GROUPS_B

Line 20796: FROM OKC_RULE_GROUPS_B

20792: --Cursor to check whether the record exists in OKC_RULE_GROUPS_B table.
20793: ----------------------------------------------------------------------------
20794: CURSOR L_CHECK_RGP_CSR ( P_ID IN NUMBER ) IS
20795: SELECT CHR_ID
20796: FROM OKC_RULE_GROUPS_B
20797: WHERE ID = P_ID;
20798:
20799: -------------------------------------------------------
20800: -- Cursor to lock okc_k_lines_b before going for update

Line 20805: , OKC_RULE_GROUPS_B RGP

20801: -------------------------------------------------------
20802: CURSOR L_LOCK_LINE_CSR (p_rgp_id in number ) IS
20803: SELECT OKC.DNZ_CHR_ID
20804: FROM OKC_K_LINES_B OKC
20805: , OKC_RULE_GROUPS_B RGP
20806: WHERE OKC.DNZ_CHR_ID = RGP.DNZ_CHR_ID
20807: AND RGP.ID = p_rgp_id
20808: AND LSE_ID in ( 1,12,19,46)
20809: FOR UPDATE NOWAIT;

Line 22568: FROM OKC_RULE_GROUPS_B RGP

22564: ,MAX(decode(RUL.RULE_INFORMATION_CATEGORY,'LMT',RUL.RULE_INFORMATION4)) DISCOUNT_PERCENT
22565: ,MAX(decode(RUL.RULE_INFORMATION_CATEGORY,'LMT','N'))Sync_Date_Install
22566:
22567:
22568: FROM OKC_RULE_GROUPS_B RGP
22569: , OKC_RULES_B RUL
22570: WHERE RGP.ID = RUL.RGP_ID
22571: AND RUL.RULE_INFORMATION_CATEGORY IN ('DST','ARL','CCR','GPR','IRT','TAX','IBR','PDL','QRE','SLH','CAN','BTO','IRE','LRT','STO','PTR',
22572: 'ECE','WHE','UGE','STR','CVE','PMP','BTD','RCN','RSN','LMT','OFS','PRE','CVR')

Line 22732: FROM OKC_RULE_GROUPS_B RGP

22728: -- '!%. ','!') DISCOUNT_PERCENT
22729: ,MAX(decode(RUL.RULE_INFORMATION_CATEGORY,'LMT',RUL.RULE_INFORMATION4)) DISCOUNT_PERCENT
22730: ,MAX(decode(RUL.RULE_INFORMATION_CATEGORY,'LMT','N'))Sync_Date_Install
22731:
22732: FROM OKC_RULE_GROUPS_B RGP
22733: , OKC_RULES_B RUL
22734: WHERE RGP.ID = RUL.RGP_ID
22735: AND RUL.RULE_INFORMATION_CATEGORY IN ('DST','ARL','CCR','GPR','IRT','TAX','IBR','PDL','QRE','SLH','CAN','BTO','IRE','LRT','STO','PTR',
22736: 'ECE','WHE','UGE','STR','CVE','PMP','BTD','RCN','RSN','LMT','OFS','PRE','CVR')

Line 22753: , OKC_RULE_GROUPS_B RGP

22749: , LIN.LINE_NUMBER
22750: , RUL.ID
22751: , RGP.ID RGP_ID
22752: FROM OKC_K_HEADERS_B HDR
22753: , OKC_RULE_GROUPS_B RGP
22754: , OKC_RULES_B RUL
22755: , OKC_K_LINES_B LIN
22756: WHERE HDR.ID = P_HDR_ID
22757: AND LIN.ID= P_CLE_ID

Line 22766: --Cursor to check whether the record exists in OKC_RULE_GROUPS_b table.

22762: AND RUL.RULE_INFORMATION_CATEGORY = P_CATEGORY ;
22763:
22764: L_LINE_DTLS_REC L_LINE_DTLS_CSR%ROWTYPE;
22765: ----------------------------------------------------------------------------
22766: --Cursor to check whether the record exists in OKC_RULE_GROUPS_b table.
22767: ----------------------------------------------------------------------------
22768: CURSOR L_CHECK_RGP_CSR ( P_ID IN NUMBER ) IS
22769: SELECT CLE_ID ,DNZ_CHR_ID
22770: FROM OKC_RULE_GROUPS_B

Line 22770: FROM OKC_RULE_GROUPS_B

22766: --Cursor to check whether the record exists in OKC_RULE_GROUPS_b table.
22767: ----------------------------------------------------------------------------
22768: CURSOR L_CHECK_RGP_CSR ( P_ID IN NUMBER ) IS
22769: SELECT CLE_ID ,DNZ_CHR_ID
22770: FROM OKC_RULE_GROUPS_B
22771: WHERE ID = P_ID;
22772:
22773: -----------------------------------------------------------------
22774: -- Newly added code to synchronize cc_no , po , Price list from--

Line 22802: , okc_rule_groups_b rgp

22798: , okcl.lse_id
22799: from oks_k_headers_b oks
22800: , okc_k_headers_b okc
22801: , okc_k_lines_b okcl
22802: , okc_rule_groups_b rgp
22803: where oks.chr_id = okc.id
22804: and okcl.lse_id in ( 1,12,19,46)
22805: and okcl.dnz_chr_id = oks.chr_id
22806: and okcl.dnz_chr_id = okc.id

Line 23142: from okc_timevalues_b tim ,okc_timevalues_b tim2,okc_rules_b rul,okc_rule_groups_b rgp

23138: l_upd_cle_id := l_cle_id ;
23139: update oks_k_lines_b t1
23140: set (t1.offset_period ,t1.offset_duration) =
23141: (select tim2.uom_code,tim2.duration
23142: from okc_timevalues_b tim ,okc_timevalues_b tim2,okc_rules_b rul,okc_rule_groups_b rgp
23143: where tim.id = offset_duration
23144: and rgp.cle_id = l_upd_cle_id
23145: and rul.rule_information1 = tim.id
23146: and rul.rule_information_category = 'OFS'

Line 23433: from okc_timevalues_b tim ,okc_timevalues_b tim2,okc_rules_b rul,okc_rule_groups_b rgp

23429: l_upd_cle_id := cle_id ;
23430: update oks_k_lines_b t1
23431: set (t1.offset_period ,t1.offset_duration) =
23432: (select tim2.uom_code,tim2.duration
23433: from okc_timevalues_b tim ,okc_timevalues_b tim2,okc_rules_b rul,okc_rule_groups_b rgp
23434: where tim.id = offset_duration
23435: and rgp.cle_id = l_upd_cle_id
23436: and rul.rule_information1 = tim.id
23437: and rul.rule_information_category = 'OFS'

Line 24780: FROM OKC_RULE_GROUPS_BH RGP

24776: ,MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'PTR' ,RUL.OBJECT1_ID1)) PAYMENT_TERM_ID --OKC
24777:
24778: ,TRANSLATE(MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'PRE' ,RUL.OBJECT1_ID1)),
24779: '!,.','!') PRICE_LIST_ID --OKC
24780: FROM OKC_RULE_GROUPS_BH RGP
24781: , OKC_RULES_BH RUL
24782: WHERE rgp.id = rul.rgp_id
24783: and rul.major_version=rgp.major_version
24784: and rgp.cle_id is null

Line 24974: FROM OKC_RULE_GROUPS_B RGP

24970: ,MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'PTR' ,RUL.OBJECT1_ID1)) PAYMENT_TERM_ID --OKC
24971:
24972: ,TRANSLATE(MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'PRE' ,RUL.OBJECT1_ID1)),
24973: '!,. ','!') PRICE_LIST_ID --OKC
24974: FROM OKC_RULE_GROUPS_B RGP
24975: , OKC_RULES_B RUL
24976: WHERE rgp.id = rul.rgp_id
24977: and rgp.cle_id is null
24978: and rgp.rgd_code = 'SVC_K'

Line 24998: , OKC_RULE_GROUPS_BH RGP

24994: , RUL.MAJOR_VERSION
24995: , RUL.ID
24996: , RGP.ID RGP_ID
24997: FROM OKC_K_HEADERS_BH HDR
24998: , OKC_RULE_GROUPS_BH RGP
24999: , OKC_RULES_BH RUL
25000: WHERE HDR.ID = P_HDR_ID
25001: AND RGP.DNZ_CHR_ID = P_HDR_ID
25002: AND RGP.CHR_ID = P_HDR_ID

Line 25012: --Cursor to check whether the record exists in OKC_RULE_GROUPS_BH table.

25008: AND RUL.RULE_INFORMATION_CATEGORY = P_CATEGORY ;
25009:
25010: L_HDR_DTLS_REC L_HDR_DTLS_CSR%ROWTYPE;
25011: ----------------------------------------------------------------------------
25012: --Cursor to check whether the record exists in OKC_RULE_GROUPS_BH table.
25013: ----------------------------------------------------------------------------
25014: CURSOR L_CHECK_RGP_CSR ( P_ID IN NUMBER , P_MAJOR_VERSION IN NUMBER ) IS
25015: SELECT CHR_ID
25016: FROM OKC_RULE_GROUPS_BH

Line 25016: FROM OKC_RULE_GROUPS_BH

25012: --Cursor to check whether the record exists in OKC_RULE_GROUPS_BH table.
25013: ----------------------------------------------------------------------------
25014: CURSOR L_CHECK_RGP_CSR ( P_ID IN NUMBER , P_MAJOR_VERSION IN NUMBER ) IS
25015: SELECT CHR_ID
25016: FROM OKC_RULE_GROUPS_BH
25017: WHERE ID = P_ID
25018: AND MAJOR_VERSION = P_MAJOR_VERSION;
25019: ----------------------------------------------------------------------------
25020:

Line 26492: , OKC_RULE_GROUPS_B RGP

26488: , LINES.DNZ_CHR_ID DNZ_CHR_ID
26489: , NVL(LINES.CLE_ID , LINES.ID ) PARENT_CLE_ID
26490: FROM OKC_RULES_B RUL
26491: , OKC_K_LINES_B LINES
26492: , OKC_RULE_GROUPS_B RGP
26493: WHERE RUL.RULE_INFORMATION_CATEGORY = 'SLL'
26494: AND RUL.RGP_ID = RGP.ID
26495: AND RGP.DNZ_CHR_ID = LINES.DNZ_CHR_ID
26496: AND RGP.CLE_ID = LINES.ID

Line 26838: FROM OKC_RULE_GROUPS_BH RGP

26834: -- '!%,','!') DISCOUNT_PERCENT
26835: ,MAX(decode(RUL.RULE_INFORMATION_CATEGORY,'LMT',RUL.RULE_INFORMATION4)) DISCOUNT_PERCENT
26836: ,MAX(decode(RUL.RULE_INFORMATION_CATEGORY,'LMT','N'))Sync_Date_Install
26837:
26838: FROM OKC_RULE_GROUPS_BH RGP
26839: , OKC_RULES_BH RUL
26840: WHERE RGP.ID = RUL.RGP_ID
26841: and rul.major_version=rgp.major_version
26842: AND RUL.RULE_INFORMATION_CATEGORY IN ('DST','ARL','CCR','GPR','IRT','TAX','IBR','PDL','QRE','SLH','CAN','BTO','IRE','LRT','STO','PTR',

Line 27001: FROM OKC_RULE_GROUPS_BH RGP

26997: --,TRANSLATE(MAX(decode(RUL.RULE_INFORMATION_CATEGORY,'LMT',RUL.RULE_INFORMATION4)),
26998: -- '!%. ','!') DISCOUNT_PERCENT
26999: ,MAX(decode(RUL.RULE_INFORMATION_CATEGORY,'LMT',RUL.RULE_INFORMATION4)) DISCOUNT_PERCENT
27000: ,MAX(decode(RUL.RULE_INFORMATION_CATEGORY,'LMT','N'))Sync_Date_Install
27001: FROM OKC_RULE_GROUPS_BH RGP
27002: , OKC_RULES_BH RUL
27003: WHERE RGP.ID = RUL.RGP_ID
27004: and rul.major_version=rgp.major_version
27005: AND RUL.RULE_INFORMATION_CATEGORY IN ('DST','ARL','CCR','GPR','IRT','TAX','IBR','PDL','QRE','SLH','CAN','BTO','IRE','LRT','STO','PTR',

Line 27027: , OKC_RULE_GROUPS_BH RGP

27023: , RUL.MAJOR_VERSION
27024: , RUL.ID
27025: , RGP.ID RGP_ID
27026: FROM OKC_K_HEADERS_BH HDR
27027: , OKC_RULE_GROUPS_BH RGP
27028: , OKC_RULES_BH RUL
27029: , OKC_K_LINES_BH LIN
27030: WHERE HDR.ID = P_HDR_ID
27031: AND LIN.ID= P_CLE_ID

Line 27045: --Cursor to check whether the record exists in OKC_RULE_GROUPS_BH table.

27041:
27042: L_LINE_DTLS_REC L_LINE_DTLS_CSR%ROWTYPE;
27043: L_USERENV_LANG VARCHAR2(100) := OKC_UTIL.get_userenv_lang ;
27044: ----------------------------------------------------------------------------
27045: --Cursor to check whether the record exists in OKC_RULE_GROUPS_BH table.
27046: ----------------------------------------------------------------------------
27047: CURSOR L_CHECK_RGP_CSR ( P_ID IN NUMBER , P_MAJOR_VERSION IN NUMBER ) IS
27048: SELECT CLE_ID,DNZ_CHR_ID
27049: FROM OKC_RULE_GROUPS_BH

Line 27049: FROM OKC_RULE_GROUPS_BH

27045: --Cursor to check whether the record exists in OKC_RULE_GROUPS_BH table.
27046: ----------------------------------------------------------------------------
27047: CURSOR L_CHECK_RGP_CSR ( P_ID IN NUMBER , P_MAJOR_VERSION IN NUMBER ) IS
27048: SELECT CLE_ID,DNZ_CHR_ID
27049: FROM OKC_RULE_GROUPS_BH
27050: WHERE ID = P_ID
27051: AND MAJOR_VERSION = P_MAJOR_VERSION;
27052: ----------------------------------------------------------------------------
27053:

Line 27405: FROM okc_timevalues_b TIM ,okc_timevalues_b TIM2,okc_rules_b Rul,OKC_RULE_GROUPS_B RGP

27401:
27402: UPDATE OKS_K_LINES_B T1
27403: SET (T1.offset_period ,T1.offset_duration) =
27404: (SELECT TIM2.UOM_CODE,TIM2.DURATION
27405: FROM okc_timevalues_b TIM ,okc_timevalues_b TIM2,okc_rules_b Rul,OKC_RULE_GROUPS_B RGP
27406: WHERE TIM.Id = OFFSET_DURATION
27407: AND RGP.CLE_ID = l_upd_cle_id
27408: AND RUL.rule_information1 = TIM.Id
27409: AND RUL.rule_information_category = 'OFS'

Line 29267: FROM OKC_RULE_GROUPS_B RGP

29263: ,MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'PTR' ,RUL.OBJECT1_ID1)) PAYMENT_TERM_ID --OKC
29264:
29265: ,TRANSLATE(MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'PRE' ,RUL.OBJECT1_ID1)),
29266: '!,.','!') PRICE_LIST_ID --OKC
29267: FROM OKC_RULE_GROUPS_B RGP
29268: , OKC_RULES_B RUL
29269: WHERE rgp.id = rul.rgp_id
29270: and rgp.chr_id = P_CHR_ID
29271: and rgp.rgd_code = 'SVC_K'

Line 29454: FROM OKC_RULE_GROUPS_B RGP

29450: ,MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'PTR' ,RUL.OBJECT1_ID1)) PAYMENT_TERM_ID --OKC
29451:
29452: ,TRANSLATE(MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'PRE' ,RUL.OBJECT1_ID1)),
29453: '!,. ','!') PRICE_LIST_ID --OKC
29454: FROM OKC_RULE_GROUPS_B RGP
29455: , OKC_RULES_B RUL
29456: WHERE rgp.id = rul.rgp_id
29457: and rgp.chr_id = P_CHR_ID
29458: and rgp.rgd_code = 'SVC_K'

Line 29474: , OKC_RULE_GROUPS_B RGP

29470: , HDR.CONTRACT_NUMBER_MODIFIER
29471: , RUL.ID
29472: , RGP.ID RGP_ID
29473: FROM OKC_K_HEADERS_B HDR
29474: , OKC_RULE_GROUPS_B RGP
29475: , OKC_RULES_B RUL
29476: WHERE HDR.ID = P_HDR_ID
29477: AND RGP.DNZ_CHR_ID = P_HDR_ID
29478: AND RGP.CHR_ID = P_HDR_ID

Line 29496: --in okc_rule_groups_b

29492: where chr_id=p_chrid;
29493:
29494: -----------------------------------------------------------------
29495: --Cursor to check if the records corresponding to rgp_id exists
29496: --in okc_rule_groups_b
29497: -----------------------------------------------------------------
29498: Cursor Cur_RGP_exists(P_RGP_ID in number) IS
29499: select 'x'
29500: from okc_rule_groups_b

Line 29500: from okc_rule_groups_b

29496: --in okc_rule_groups_b
29497: -----------------------------------------------------------------
29498: Cursor Cur_RGP_exists(P_RGP_ID in number) IS
29499: select 'x'
29500: from okc_rule_groups_b
29501: where id = P_RGP_ID
29502: and chr_id = P_CHR_ID;
29503:
29504: -----------------------------------------------------------------

Line 31361: FROM OKC_RULE_GROUPS_B RGP

31357: -- '!%,','!') DISCOUNT_PERCENT
31358: ,MAX(decode(RUL.RULE_INFORMATION_CATEGORY,'LMT',RUL.RULE_INFORMATION4)) DISCOUNT_PERCENT
31359: ,MAX(decode(RUL.RULE_INFORMATION_CATEGORY,'LMT','N'))Sync_Date_Install
31360: --------------------------------------------------------------------------------------------------------------------
31361: FROM OKC_RULE_GROUPS_B RGP
31362: , OKC_RULES_B RUL
31363: WHERE RGP.ID = RUL.RGP_ID
31364: AND RUL.RULE_INFORMATION_CATEGORY IN ('DST','ARL','CCR','GPR','IRT','TAX','IBR','PDL','QRE','SLH','CAN','BTO','IRE','LRT','STO','PTR',
31365: 'ECE','WHE','UGE','STR','CVE','PMP','BTD','RCN','RSN','LMT','OFS','PRE')

Line 31518: FROM OKC_RULE_GROUPS_B RGP

31514: -- '!%. ','!') DISCOUNT_PERCENT
31515: ,MAX(decode(RUL.RULE_INFORMATION_CATEGORY,'LMT',RUL.RULE_INFORMATION4)) DISCOUNT_PERCENT
31516: ,MAX(decode(RUL.RULE_INFORMATION_CATEGORY,'LMT','N'))Sync_Date_Install
31517: --------------------------------------------------------------------------------------------------------------------
31518: FROM OKC_RULE_GROUPS_B RGP
31519: , OKC_RULES_B RUL
31520: WHERE RGP.ID = RUL.RGP_ID
31521: AND RUL.RULE_INFORMATION_CATEGORY IN ('DST','ARL','CCR','GPR','IRT','TAX','IBR','PDL','QRE','SLH','CAN','BTO','IRE','LRT','STO','PTR',
31522: 'ECE','WHE','UGE','STR','CVE','PMP','BTD','RCN','RSN','LMT','OFS','PRE')

Line 31538: , OKC_RULE_GROUPS_B RGP

31534: , LIN.LINE_NUMBER
31535: , RUL.ID
31536: , RGP.ID RGP_ID
31537: FROM OKC_K_HEADERS_B HDR
31538: , OKC_RULE_GROUPS_B RGP
31539: , OKC_RULES_B RUL
31540: , OKC_K_LINES_B LIN
31541: WHERE HDR.ID = P_HDR_ID
31542: AND LIN.ID= P_CLE_ID

Line 31561: --in okc_rule_groups_b

31557: where cle_id=p_cleid;
31558:
31559: -----------------------------------------------------------------------------
31560: --Cursor to check if the records corresponding to rgp_id exists
31561: --in okc_rule_groups_b
31562: -----------------------------------------------------------------------------
31563: Cursor Cur_RGP_exists(P_RGP_ID in number) IS
31564: select 'x'
31565: from okc_rule_groups_b

Line 31565: from okc_rule_groups_b

31561: --in okc_rule_groups_b
31562: -----------------------------------------------------------------------------
31563: Cursor Cur_RGP_exists(P_RGP_ID in number) IS
31564: select 'x'
31565: from okc_rule_groups_b
31566: where id = P_RGP_ID
31567: and cle_id is not null;
31568:
31569:

Line 32029: FROM okc_timevalues_b TIM ,okc_timevalues_b TIM2,okc_rules_b Rul,OKC_RULE_GROUPS_B RGP

32025: IF L_OFFSET_DURATION IS NOT NULL THEN
32026: UPDATE OKS_K_LINES_B T1
32027: SET (T1.offset_period ,T1.offset_duration) =
32028: (SELECT TIM2.UOM_CODE,TIM2.DURATION
32029: FROM okc_timevalues_b TIM ,okc_timevalues_b TIM2,okc_rules_b Rul,OKC_RULE_GROUPS_B RGP
32030: WHERE TIM.Id = OFFSET_DURATION
32031: AND RGP.CLE_ID = p_cle_id
32032: AND RUL.rule_information1 = TIM.Id
32033: AND RUL.rule_information_category = 'OFS'

Line 32193: FROM okc_timevalues_b TIM ,okc_timevalues_b TIM2,okc_rules_b Rul,OKC_RULE_GROUPS_B RGP

32189:
32190: UPDATE OKS_K_LINES_B T1
32191: SET (T1.offset_period ,T1.offset_duration) =
32192: (SELECT TIM2.UOM_CODE,TIM2.DURATION
32193: FROM okc_timevalues_b TIM ,okc_timevalues_b TIM2,okc_rules_b Rul,OKC_RULE_GROUPS_B RGP
32194: WHERE TIM.Id = L_OFFSET_DURATION
32195: AND RGP.CLE_ID = p_cle_id
32196: AND RUL.rule_information1 = TIM.Id
32197: AND RUL.rule_information_category = 'OFS'

Line 33432: FROM OKC_RULE_GROUPS_BH RGP

33428: ,MAX(decode(RUL.RULE_INFORMATION_CATEGORY,'LMT',RUL.RULE_INFORMATION4)) DISCOUNT_PERCENT
33429: ,MAX(decode(RUL.RULE_INFORMATION_CATEGORY,'LMT','N'))Sync_Date_Install
33430: --------------------------------------------------------------------------------------------------------------------
33431:
33432: FROM OKC_RULE_GROUPS_BH RGP
33433: , OKC_RULES_BH RUL
33434: WHERE RGP.ID = RUL.RGP_ID
33435: and rul.major_version=rgp.major_version
33436: AND RUL.RULE_INFORMATION_CATEGORY IN ('DST','ARL','CCR','GPR','IRT','TAX','IBR','PDL','QRE','SLH','CAN','BTO','IRE','LRT','STO','PTR',

Line 33593: FROM OKC_RULE_GROUPS_BH RGP

33589: ,MAX(decode(RUL.RULE_INFORMATION_CATEGORY,'LMT',RUL.RULE_INFORMATION4)) DISCOUNT_PERCENT
33590: ,MAX(decode(RUL.RULE_INFORMATION_CATEGORY,'LMT','N'))Sync_Date_Install
33591: --------------------------------------------------------------------------------------------------------------------
33592:
33593: FROM OKC_RULE_GROUPS_BH RGP
33594: , OKC_RULES_BH RUL
33595: WHERE RGP.ID = RUL.RGP_ID
33596: and rul.major_version=rgp.major_version
33597: AND RUL.RULE_INFORMATION_CATEGORY IN ('DST','ARL','CCR','GPR','IRT','TAX','IBR','PDL','QRE','SLH','CAN','BTO','IRE','LRT','STO','PTR',

Line 33616: , OKC_RULE_GROUPS_BH RGP

33612: , RUL.MAJOR_VERSION
33613: , RUL.ID
33614: , RGP.ID RGP_ID
33615: FROM OKC_K_HEADERS_BH HDR
33616: , OKC_RULE_GROUPS_BH RGP
33617: , OKC_RULES_BH RUL
33618: , OKC_K_LINES_BH LIN
33619: WHERE HDR.ID = P_HDR_ID
33620: AND LIN.ID= P_CLE_ID

Line 33646: --in okc_rule_groups_bh

33642: ------------------------------------------------------------------------------
33643:
33644: -----------------------------------------------------------------------------
33645: --Cursor to check if the records corresponding to rgp_id exists
33646: --in okc_rule_groups_bh
33647: -----------------------------------------------------------------------------
33648:
33649: Cursor Cur_RGP_exists(P_RGP_ID in number) IS
33650: select 'x'

Line 33651: from okc_rule_groups_bh

33647: -----------------------------------------------------------------------------
33648:
33649: Cursor Cur_RGP_exists(P_RGP_ID in number) IS
33650: select 'x'
33651: from okc_rule_groups_bh
33652: where id = P_RGP_ID
33653: and cle_id is not null
33654: and major_version = p_major_version;
33655:

Line 34045: FROM okc_timevalues_b TIM ,okc_timevalues_b TIM2,okc_rules_b Rul,OKC_RULE_GROUPS_B RGP

34041:
34042: UPDATE OKS_K_LINES_B T1
34043: SET (T1.offset_period ,T1.offset_duration) =
34044: (SELECT TIM2.UOM_CODE,TIM2.DURATION
34045: FROM okc_timevalues_b TIM ,okc_timevalues_b TIM2,okc_rules_b Rul,OKC_RULE_GROUPS_B RGP
34046: WHERE TIM.Id = L_OFFSET_DURATION
34047: AND RGP.CLE_ID = p_cle_id
34048: AND RUL.rule_information1 = TIM.Id
34049: AND RUL.rule_information_category = 'OFS'

Line 34059: FROM okc_timevalues_b TIM ,okc_rules_b Rul,OKC_RULE_GROUPS_B RGP

34055: /*
34056: UPDATE OKS_K_LINES_B T1
34057: SET (T1.offset_period ,T1.offset_duration) =
34058: (SELECT UOM_CODE,DURATION
34059: FROM okc_timevalues_b TIM ,okc_rules_b Rul,OKC_RULE_GROUPS_B RGP
34060: WHERE RUL.Id = L_OFFSET_DURATION
34061: AND RGP.CLE_ID = p_cle_id
34062: AND RUL.rule_information1 = TIM.Id
34063: AND RUL.rule_information_category = 'OFS'

Line 34220: FROM okc_timevalues_b TIM ,okc_timevalues_b TIM2,okc_rules_b Rul,OKC_RULE_GROUPS_B RGP

34216:
34217: UPDATE OKS_K_LINES_B T1
34218: SET (T1.offset_period ,T1.offset_duration) =
34219: (SELECT TIM2.UOM_CODE,TIM2.DURATION
34220: FROM okc_timevalues_b TIM ,okc_timevalues_b TIM2,okc_rules_b Rul,OKC_RULE_GROUPS_B RGP
34221: WHERE TIM.Id = L_OFFSET_DURATION
34222: AND RGP.CLE_ID = p_cle_id
34223: AND RUL.rule_information1 = TIM.Id
34224: AND RUL.rule_information_category = 'OFS'

Line 34234: FROM okc_timevalues_b TIM ,okc_rules_b Rul,OKC_RULE_GROUPS_B RGP

34230: /*
34231: UPDATE OKS_K_LINES_B T1
34232: SET (T1.offset_period ,T1.offset_duration) =
34233: (SELECT UOM_CODE,DURATION
34234: FROM okc_timevalues_b TIM ,okc_rules_b Rul,OKC_RULE_GROUPS_B RGP
34235: WHERE RUL.Id = L_OFFSET_DURATION
34236: AND RGP.CLE_ID = p_cle_id
34237: AND RUL.rule_information1 = TIM.Id
34238: AND RUL.rule_information_category = 'OFS'

Line 35473: FROM OKC_RULE_GROUPS_BH RGP

35469: ,MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'PTR' ,RUL.OBJECT1_ID1)) PAYMENT_TERM_ID --OKC
35470:
35471: ,TRANSLATE(MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'PRE' ,RUL.OBJECT1_ID1)),
35472: '!,.','!') PRICE_LIST_ID --OKC
35473: FROM OKC_RULE_GROUPS_BH RGP
35474: , OKC_RULES_BH RUL
35475: WHERE rgp.id = rul.rgp_id
35476: and rul.major_version=rgp.major_version
35477: and rgp.chr_id = P_CHR_ID

Line 35663: FROM OKC_RULE_GROUPS_BH RGP

35659: ,MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'PTR' ,RUL.OBJECT1_ID1)) PAYMENT_TERM_ID --OKC
35660:
35661: ,TRANSLATE(MAX(DECODE(RUL.RULE_INFORMATION_CATEGORY , 'PRE' ,RUL.OBJECT1_ID1)),
35662: '!,. ','!') PRICE_LIST_ID --OKC
35663: FROM OKC_RULE_GROUPS_BH RGP
35664: , OKC_RULES_BH RUL
35665: WHERE rgp.id = rul.rgp_id
35666: and rul.major_version=rgp.major_version
35667: and rgp.chr_id = P_CHR_ID

Line 35688: , OKC_RULE_GROUPS_BH RGP

35684: , RUL.MAJOR_VERSION
35685: , RUL.ID
35686: , RGP.ID RGP_ID
35687: FROM OKC_K_HEADERS_BH HDR
35688: , OKC_RULE_GROUPS_BH RGP
35689: , OKC_RULES_BH RUL
35690: WHERE HDR.ID = P_HDR_ID
35691: AND RGP.DNZ_CHR_ID = P_HDR_ID
35692: AND RGP.CHR_ID = P_HDR_ID

Line 35719: --in okc_rule_groups_bh

35715: ------------------------------------------------------------------------------
35716:
35717: -----------------------------------------------------------------------------
35718: --Cursor to check if the records corresponding to rgp_id exists
35719: --in okc_rule_groups_bh
35720: -----------------------------------------------------------------------------
35721:
35722: Cursor Cur_RGP_exists(P_RGP_ID in number) IS
35723: select 'x'

Line 35724: from okc_rule_groups_bh

35720: -----------------------------------------------------------------------------
35721:
35722: Cursor Cur_RGP_exists(P_RGP_ID in number) IS
35723: select 'x'
35724: from okc_rule_groups_bh
35725: where id = P_RGP_ID
35726: and chr_id is not null
35727: and major_version = p_major_version;
35728:

Line 37176: , OKC_RULE_GROUPS_B RGP

37172: , LINES.DNZ_CHR_ID DNZ_CHR_ID
37173: , NVL(LINES.CLE_ID , LINES.ID ) PARENT_CLE_ID
37174: FROM OKC_RULES_B RUL
37175: , OKC_K_LINES_B LINES
37176: , OKC_RULE_GROUPS_B RGP
37177: WHERE RUL.RULE_INFORMATION_CATEGORY = 'SLL'
37178: AND RUL.RGP_ID = RGP.ID
37179: AND RGP.DNZ_CHR_ID = LINES.DNZ_CHR_ID
37180: AND RGP.CLE_ID = LINES.ID

Line 37263: from okc_rule_groups_b rgp,

37259: SYSDATE,
37260: 1,
37261: SYSDATE,
37262: 2003
37263: from okc_rule_groups_b rgp,
37264: okc_rules_b rules
37265: where rgp.rgd_code = 'SVC_K'
37266: and rgp.id = rules.rgp_id
37267: and rules.rule_information_category = 'SLL'

Line 37326: from okc_rule_groups_b rgp,

37322: SYSDATE,
37323: 1,
37324: SYSDATE,
37325: 2003
37326: from okc_rule_groups_b rgp,
37327: okc_rules_b rules
37328: where rgp.rgd_code = 'SVC_K'
37329: and rgp.id = rules.rgp_id
37330: and rules.rule_information_category = 'SLL'

Line 37415: from okc_rule_groups_b rgp,

37411: rules.rule_information9 comments, rules.rule_information10
37412: due_arr_yn, rules.rule_information11 amount, null,
37413: rules.object_version_number object_version_number, null, null, 1,
37414: SYSDATE, 1, SYSDATE, 2003
37415: from okc_rule_groups_b rgp,
37416: okc_rules_b rules
37417: where rgp.rgd_code = 'SVC_K'
37418: and rgp.id = P_RGP_ID
37419: and rgp.chr_id=P_CHR_ID

Line 37466: --in okc_rule_groups_b

37462: where cle_id=p_cleid
37463: AND major_version = p_major_version;
37464: -----------------------------------------------------------------------------
37465: --Cursor to check if the records corresponding to rgp_id exists
37466: --in okc_rule_groups_b
37467: -----------------------------------------------------------------------------
37468:
37469: Cursor Cur_RGP_exists(P_RGP_ID in number) IS
37470: select 'x'

Line 37471: from okc_rule_groups_b

37467: -----------------------------------------------------------------------------
37468:
37469: Cursor Cur_RGP_exists(P_RGP_ID in number) IS
37470: select 'x'
37471: from okc_rule_groups_b
37472: where id = P_RGP_ID
37473: and cle_id is not null;
37474:
37475: Cursor Cur_RGPH_exists(P_RGP_ID in number,p_major_version IN NUMBER) IS

Line 37477: from okc_rule_groups_bh

37473: and cle_id is not null;
37474:
37475: Cursor Cur_RGPH_exists(P_RGP_ID in number,p_major_version IN NUMBER) IS
37476: select 'x'
37477: from okc_rule_groups_bh
37478: where id = P_RGP_ID
37479: AND major_version = p_major_version
37480: and cle_id is not null;
37481: -----------------------------------------------------------------------------

Line 37487: FROM okc_timevalues_b TIM,okc_timevalues_b TIM2 ,okc_rules_b Rul,OKC_RULE_GROUPS_B RGP

37483: -----------------------------------------------------------------------------
37484:
37485: Cursor Cur_Off_Period(l_cleid in number,l_rgp_id IN NUMBER) IS
37486: SELECT TIM2.UOM_CODE,TIM2.DURATION
37487: FROM okc_timevalues_b TIM,okc_timevalues_b TIM2 ,okc_rules_b Rul,OKC_RULE_GROUPS_B RGP
37488: WHERE RGP.CLE_ID = l_cle_id
37489: AND RUL.rule_information1 = TIM.Id
37490: AND RUL.rule_information_category = 'OFS'
37491: AND RGP.ID = RUL.RGP_ID

Line 37500: FROM okc_timevalues_bh TIM,okc_timevalues_bh TIM2 ,okc_rules_bh Rul,OKC_RULE_GROUPS_BH RGP

37496: AND RGP.ID = L_RGP_ID;
37497:
37498: Cursor Cur_Off_Period_H(l_cleid in number,l_rgp_id IN NUMBER,l_major_version IN NUMBER) IS
37499: SELECT TIM2.UOM_CODE,TIM2.DURATION
37500: FROM okc_timevalues_bh TIM,okc_timevalues_bh TIM2 ,okc_rules_bh Rul,OKC_RULE_GROUPS_BH RGP
37501: WHERE RGP.CLE_ID = l_cle_id
37502: AND RUL.rule_information1 = TIM.Id
37503: AND RUL.rule_information_category = 'OFS'
37504: AND RGP.ID = RUL.RGP_ID

Line 37553: FROM okc_timevalues_b TIM,okc_timevalues_b TIM2 ,okc_rules_b Rul,OKC_RULE_GROUPS_B RGP

37549:
37550: UPDATE OKS_K_LINES_B T1
37551: SET (T1.offset_period ,T1.offset_duration) =
37552: (SELECT TIM2.UOM_CODE,TIM2.DURATION
37553: FROM okc_timevalues_b TIM,okc_timevalues_b TIM2 ,okc_rules_b Rul,OKC_RULE_GROUPS_B RGP
37554: WHERE RGP.CLE_ID = l_cle_id
37555: AND RUL.rule_information1 = TIM.Id
37556: AND RUL.rule_information_category = 'OFS'
37557: AND RGP.ID = RUL.RGP_ID

Line 37629: FROM okc_timevalues_bh TIM ,okc_timevalues_bh TIM2,okc_rules_bh Rul,OKC_RULE_GROUPS_BH RGP

37625:
37626: UPDATE OKS_K_LINES_BH T1
37627: SET (T1.offset_period ,T1.offset_duration) =
37628: (SELECT TIM2.UOM_CODE,TIM2.DURATION
37629: FROM okc_timevalues_bh TIM ,okc_timevalues_bh TIM2,okc_rules_bh Rul,OKC_RULE_GROUPS_BH RGP
37630: WHERE RGP.CLE_ID = l_cle_id
37631: AND RUL.rule_information1 = TIM.Id
37632: AND RUL.rule_information_category = 'OFS'
37633: AND RGP.ID = RUL.RGP_ID

Line 37715: from okc_rule_groups_b

37711: L_ERROR_MSG VARCHAR2(2000);
37712:
37713: Cursor Cur_RGP_exists(p_RGP_ID in number) IS
37714: select 'x'
37715: from okc_rule_groups_b
37716: where id = p_RGP_ID
37717: and cle_id is not null;
37718:
37719: Cursor Cur_RGPH_exists(P_RGP_ID in number,p_major_version IN NUMBER) IS

Line 37721: from okc_rule_groups_bh

37717: and cle_id is not null;
37718:
37719: Cursor Cur_RGPH_exists(P_RGP_ID in number,p_major_version IN NUMBER) IS
37720: select 'x'
37721: from okc_rule_groups_bh
37722: where id = P_RGP_ID
37723: AND major_version = p_major_version
37724: and cle_id is not null;
37725:

Line 37769: from okc_rule_groups_b rgp,

37765: program_id, program_update_date, request_id, object_version_number)
37766: select
37767: distinct rgp.cle_id, rgp.cle_id, rgp.dnz_chr_id, times.tze_id, 'Y',
37768: 2003, sysdate, 2003, sysdate, 2003, null, null, null, null, null, 1
37769: from okc_rule_groups_b rgp,
37770: okc_rules_b rules,
37771: okc_timevalues_b times,
37772: okc_cover_times cvt
37773: where rgp.id = rules.rgp_id

Line 37805: okc_rule_groups_b rgp,

37801: sysdate, 2003, sysdate, 2003, null, null, null, null, null, 1
37802: from okc_time_ig_startend_val_v time_val,
37803: okc_cover_times cvt,
37804: okc_rules_b rules,
37805: okc_rule_groups_b rgp,
37806: oks_coverage_timezones tze
37807: where time_val.id = cvt.tve_id
37808: and cvt.rul_id = rules.id
37809: and time_val.dnz_chr_id = cvt.dnz_chr_id

Line 37858: from okc_rule_groups_bh rgp,

37854: last_update_login, security_group_id, program_application_id,
37855: program_id, program_update_date, request_id, object_version_number,major_version)
37856: select distinct rgp.cle_id, rgp.cle_id, rgp.dnz_chr_id, times.tze_id, 'Y',
37857: 1, sysdate, 1, sysdate, 2003, null, null, null, null, null,1, times.major_version
37858: from okc_rule_groups_bh rgp,
37859: okc_rules_bh rules,
37860: okc_timevalues_bh times,
37861: okc_cover_times_h cvt
37862: where rgp.id = rules.rgp_id

Line 37898: okc_rule_groups_bh rgp,

37894: sysdate, 1, sysdate, 2003, null, null, null, null, null,tze.major_version, 1
37895: from oks_covtimes_hist_v time_val, --oks_time_ig_startend_val_hv time_val,
37896: okc_cover_times_h cvt,
37897: okc_rules_bh rules,
37898: okc_rule_groups_bh rgp,
37899: oks_coverage_timezones_h tze
37900: where time_val.id = cvt.tve_id
37901: and cvt.rul_id = rules.id
37902: and time_val.dnz_chr_id = cvt.dnz_chr_id

Line 37955: FROM OKC_RULE_GROUPS_B RGP,

37951: MAX(decode(RUL.RULE_INFORMATION_CATEGORY,'RCN',RUL.RULE_INFORMATION2))RCN_REACT_TIME_NAME,
37952: MAX(decode(RUL.RULE_INFORMATION_CATEGORY,'RCN',RUL.RULE_INFORMATION3))RCN_WORK_THRU_YN,
37953: MAX(decode(RUL.RULE_INFORMATION_CATEGORY,'RCN',RUL.RULE_INFORMATION4))RCN_REACT_ACTIVE_YN,
37954: MAX(decode(RUL.RULE_INFORMATION_CATEGORY,'RSN',RUL.RULE_INFORMATION2))RSN_REACT_TIME_NAME
37955: FROM OKC_RULE_GROUPS_B RGP,
37956: OKC_RULES_B RUL
37957: WHERE RGP.ID = RUL.RGP_ID
37958: AND RUL.RULE_INFORMATION_CATEGORY IN ('RCN','RSN')
37959: AND RUL.DNZ_CHR_ID = RGP.DNZ_CHR_ID

Line 38205: okc_rule_groups_b rgp,

38201: sysdate, 2003, null, null, null, null, null, 1
38202: from okc_timevalues_b tim,
38203: okc_react_intervals rin,
38204: okc_rules_b rul,
38205: okc_rule_groups_b rgp,
38206: oks_action_time_types att
38207: where att.cle_id = rgp.cle_id
38208: and rgp.id = rul.rgp_id
38209: and rul.rule_information_category in ('RCN', 'RSN')

Line 38266: FROM OKC_RULE_GROUPS_BH RGP,

38262: MAX(decode(RUL.RULE_INFORMATION_CATEGORY,'RCN',RUL.RULE_INFORMATION2))RCN_REACT_TIME_NAME,
38263: MAX(decode(RUL.RULE_INFORMATION_CATEGORY,'RCN',RUL.RULE_INFORMATION3))RCN_WORK_THRU_YN,
38264: MAX(decode(RUL.RULE_INFORMATION_CATEGORY,'RCN',RUL.RULE_INFORMATION4))RCN_REACT_ACTIVE_YN,
38265: MAX(decode(RUL.RULE_INFORMATION_CATEGORY,'RSN',RUL.RULE_INFORMATION2))RSN_REACT_TIME_NAME
38266: FROM OKC_RULE_GROUPS_BH RGP,
38267: OKC_RULES_BH RUL
38268: WHERE RGP.ID = RUL.RGP_ID
38269: AND RUL.RULE_INFORMATION_CATEGORY IN ('RCN','RSN')
38270: AND RUL.DNZ_CHR_ID = RGP.DNZ_CHR_ID

Line 38537: okc_rule_groups_bh rgp,

38533: sysdate, 2003, null, null, null, null, null,1, tim.major_version
38534: from okc_timevalues_bh tim,
38535: okc_react_intervals_h rin,
38536: okc_rules_bh rul,
38537: okc_rule_groups_bh rgp,
38538: oks_action_time_types_h att
38539: where att.cle_id = rgp.cle_id
38540: and rgp.id = rul.rgp_id
38541: and rul.rule_information_category in ('RCN', 'RSN')

Line 38639: OKC_RULE_GROUPS_B RGP

38635: 1,
38636: SYSDATE,
38637: 2003
38638: FROM OKC_RULES_B RUL,
38639: OKC_RULE_GROUPS_B RGP
38640: WHERE RUL.RGP_ID = RGP.ID
38641: AND RUL.DNZ_CHR_ID = RGP.DNZ_CHR_ID
38642: AND RUL.rule_information_category = 'PMA'
38643: AND RGP.ID = L_RGP_ID

Line 38700: OKC_RULE_GROUPS_B RGP

38696: SYSDATE,
38697: 2003
38698: FROM OKC_RULES_B PMP,
38699: OKC_RULES_B PML,
38700: OKC_RULE_GROUPS_B RGP
38701: WHERE PML.object1_id1 = PMP.ID
38702: AND RGP.ID = PMP.RGP_ID
38703: AND RGP.ID = PML.RGP_ID
38704: AND PMP.DNZ_CHR_ID = PML.DNZ_CHR_ID

Line 38875: FROM OKC_RULE_GROUPS_B RGP

38871: ,2003
38872: FROM OKS_RULE_UPGRADE UPG1
38873: WHERE UPG1.RIC_CODE = 'HDR'
38874: AND NOT EXISTS ( SELECT 1
38875: FROM OKC_RULE_GROUPS_B RGP
38876: , OKC_RULES_B RULE
38877: WHERE RGP.DNZ_CHR_ID = UPG1.DNZ_CHR_ID
38878: AND RGP.CHR_ID = UPG1.DNZ_CHR_ID
38879: AND RGP.ID = RULE.RGP_ID )