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_RULES_B

Line 181: L_STMT := 'UPDATE OKC_RULES_B SET '|| P_COLUMN_NAME ||

177: X_RETURN_STATUS := 'S' ;
178:
179: IF(P_MAJOR_VERSION IS NULL) THEN
180:
181: L_STMT := 'UPDATE OKC_RULES_B SET '|| P_COLUMN_NAME ||
182: ' = :1 ' || ' WHERE ID = :2 AND RULE_INFORMATION_CATEGORY = :3 ';
183: EXECUTE IMMEDIATE L_STMT USING P_NEW_VALUE , P_ID , P_RULE_INFO_CATEGORY;
184:
185: ELSE

Line 187: L_STMT := 'UPDATE OKC_RULES_BH SET '|| P_COLUMN_NAME ||

183: EXECUTE IMMEDIATE L_STMT USING P_NEW_VALUE , P_ID , P_RULE_INFO_CATEGORY;
184:
185: ELSE
186:
187: L_STMT := 'UPDATE OKC_RULES_BH SET '|| P_COLUMN_NAME ||
188: ' = :1 ' || ' WHERE ID = :2 AND RULE_INFORMATION_CATEGORY = :3
189: AND MAJOR_VERSION = :4';
190:
191: EXECUTE IMMEDIATE L_STMT USING P_NEW_VALUE , P_ID , P_RULE_INFO_CATEGORY,P_MAJOR_VERSION;

Line 1296: , OKC_RULES_B RUL

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
1300: AND rgp.rgd_code = 'SVC_K'

Line 1536: , OKC_RULES_B RUL

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
1540: and rgp.chr_id is not null

Line 1781: , OKC_RULES_B RUL

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
1785: AND rgp.rgd_code = 'SVC_K'

Line 2021: , OKC_RULES_B RUL

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
2025: and rgp.chr_id is not null

Line 2086: , OKC_RULES_B RUL

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
2090: AND RGP.DNZ_CHR_ID = RUL.DNZ_CHR_ID

Line 3629: , OKC_RULES_B RUL

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')
3633: AND RGP.CLE_ID IS NOT NULL

Line 3864: , OKC_RULES_B RUL

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',
3868: 'ECE','PMP','DST','RCN','RSN','LMT','PRE','SLL')

Line 4102: , OKC_RULES_B RUL

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')
4106: AND RGP.CLE_ID IS NOT NULL

Line 4337: , OKC_RULES_B RUL

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',
4341: 'ECE','PMP','DST','RCN','RSN','LMT','PRE','SLL')

Line 4401: , OKC_RULES_B RUL

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
4405: AND RGP.DNZ_CHR_ID = P_HDR_ID

Line 6072: , OKC_RULES_BH RUL

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
6076: AND RUL.RULE_INFORMATION_CATEGORY IN ('DST','ARL','CCR','GPR','IRT','TAX','IBR','PDL','QRE','SLH','CAN','BTO','IRE','LRT','STO','PTR',

Line 6310: , OKC_RULES_BH RUL

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',
6314: 'ECE','PMP','DST','RCN','RSN','LMT','PRE','SLL')

Line 6548: , OKC_RULES_BH RUL

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
6552: AND RUL.RULE_INFORMATION_CATEGORY IN ('DST','ARL','CCR','GPR','IRT','TAX','IBR','PDL','QRE','SLH','CAN','BTO','IRE','LRT','STO','PTR',

Line 6786: , OKC_RULES_BH RUL

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',
6790: 'ECE','PMP','DST','RCN','RSN','LMT','PRE','SLL')

Line 6854: , OKC_RULES_BH RUL

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
6858: AND RGP.DNZ_CHR_ID = P_HDR_ID

Line 8538: , OKC_RULES_BH RUL

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
8542: and rgp.rgd_code = 'SVC_K'

Line 8778: , OKC_RULES_BH RUL

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
8782: and rgp.chr_id is not null

Line 9019: , OKC_RULES_BH RUL

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
9023: and rgp.rgd_code = 'SVC_K'

Line 9259: , OKC_RULES_BH RUL

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
9263: and rgp.chr_id is not null

Line 9324: , OKC_RULES_BH RUL

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
9328: AND RGP.ID = RUL.RGP_ID

Line 11030: , OKC_RULES_B RUL

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
11034: ('ARL','CCR','GPR','RVE','IRT','TAX','ERN','QTO', 'RPO', 'RPT','RER', 'RRU',

Line 11410: , OKC_RULES_B RUL

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'
11414: AND RUL.RULE_INFORMATION_CATEGORY IN

Line 11791: , OKC_RULES_B RUL

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
11795: ('ARL','CCR','GPR','RVE','IRT','TAX','ERN','QTO', 'RPO', 'RPT','RER', 'RRU',

Line 12171: , OKC_RULES_B RUL

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'
12175: AND RUL.RULE_INFORMATION_CATEGORY IN

Line 12258: , OKC_RULES_B RUL

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
12262: AND RGP.ID = RUL.RGP_ID

Line 12280: , OKC_RULES_B RUL

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
12284: AND RGP.DNZ_CHR_ID = P_HDR_ID

Line 15874: , OKC_RULES_BH RUL

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
15878: ('ARL','CCR','GPR','RVE','IRT','TAX','ERN','QTO', 'RPO', 'RPT','RER', 'RRU',

Line 16255: , OKC_RULES_BH RUL

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'
16259: AND RUL.RULE_INFORMATION_CATEGORY IN

Line 16636: , OKC_RULES_BH RUL

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
16640: ('ARL','CCR','GPR','RVE','IRT','TAX','ERN','QTO', 'RPO', 'RPT','RER', 'RRU',

Line 17017: , OKC_RULES_BH RUL

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'
17021: AND RUL.RULE_INFORMATION_CATEGORY IN

Line 17106: , OKC_RULES_BH RUL

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
17110: AND RGP.ID = RUL.RGP_ID

Line 17129: , OKC_RULES_BH RUL

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
17133: AND RGP.DNZ_CHR_ID = P_HDR_ID

Line 20568: , OKC_RULES_B RUL

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'
20572: AND RUL.RULE_INFORMATION_CATEGORY IN

Line 20760: , OKC_RULES_B RUL

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'
20764: AND RUL.RULE_INFORMATION_CATEGORY IN

Line 20782: , OKC_RULES_B RUL

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
20786: AND RGP.ID = RUL.RGP_ID

Line 22569: , OKC_RULES_B RUL

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')
22573: AND RGP.CLE_ID IS NOT NULL

Line 22733: , OKC_RULES_B RUL

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')
22737: AND RGP.CLE_ID IS NOT NULL

Line 22754: , OKC_RULES_B RUL

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
22758: AND RGP.DNZ_CHR_ID = P_HDR_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 24781: , OKC_RULES_BH RUL

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
24785: and rgp.rgd_code = 'SVC_K'

Line 24975: , OKC_RULES_B RUL

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'
24979: AND RUL.RULE_INFORMATION_CATEGORY IN

Line 24999: , OKC_RULES_BH RUL

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
25003: AND RGP.ID = RUL.RGP_ID

Line 26490: FROM OKC_RULES_B RUL

26486: SELECT RUL.ID RUL_ID
26487: , LINES.ID CLE_ID
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

Line 26839: , OKC_RULES_BH RUL

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',
26843: 'ECE','WHE','UGE','STR','CVE','PMP','BTD','RCN','RSN','LMT','OFS','PRE','CVR')

Line 27002: , OKC_RULES_BH RUL

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',
27006: 'ECE','WHE','UGE','STR','CVE','PMP','BTD','RCN','RSN','LMT','OFS','PRE','CVR')

Line 27028: , OKC_RULES_BH RUL

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
27032: AND RGP.DNZ_CHR_ID = P_HDR_ID

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 29268: , OKC_RULES_B RUL

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'
29272: AND RUL.RULE_INFORMATION_CATEGORY IN

Line 29455: , OKC_RULES_B RUL

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'
29459: AND RUL.RULE_INFORMATION_CATEGORY IN

Line 29475: , OKC_RULES_B RUL

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
29479: AND RGP.ID = RUL.RGP_ID

Line 31362: , OKC_RULES_B RUL

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')
31366: AND RGP.CLE_ID = P_CLE_ID

Line 31519: , OKC_RULES_B RUL

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')
31523: AND RGP.CLE_ID = P_CLE_ID

Line 31539: , OKC_RULES_B RUL

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
31543: AND RGP.DNZ_CHR_ID = P_HDR_ID

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 33433: , OKC_RULES_BH RUL

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',
33437: 'ECE','WHE','UGE','STR','CVE','PMP','BTD','RCN','RSN','LMT','OFS','PRE')

Line 33594: , OKC_RULES_BH RUL

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',
33598: 'ECE','WHE','UGE','STR','CVE','PMP','BTD','RCN','RSN','LMT','OFS','PRE')

Line 33617: , OKC_RULES_BH RUL

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
33621: AND RGP.DNZ_CHR_ID = P_HDR_ID

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 35474: , OKC_RULES_BH RUL

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
35478: and rgp.rgd_code = 'SVC_K'

Line 35664: , OKC_RULES_BH RUL

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
35668: and rgp.rgd_code = 'SVC_K'

Line 35689: , OKC_RULES_BH RUL

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
35693: AND RGP.ID = RUL.RGP_ID

Line 37174: FROM OKC_RULES_B RUL

37170: SELECT RUL.ID RUL_ID
37171: , LINES.ID CLE_ID
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

Line 37264: okc_rules_b rules

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'
37268: and rgp.id = p_rgp_id

Line 37327: okc_rules_b rules

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'
37331: and rgp.id = p_rgp_id

Line 37416: okc_rules_b rules

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
37420: and rules.rgp_id = rgp.id

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 37770: okc_rules_b rules,

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
37774: and rgp.dnz_chr_id = rules.dnz_chr_id

Line 37804: okc_rules_b rules,

37800: decode(time_val.start_day_of_week, 'SUN', 'Y', 'N' ) sunday_yn, 2003,
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

Line 37859: okc_rules_bh rules,

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
37863: and rgp.dnz_chr_id = rules.dnz_chr_id

Line 37897: okc_rules_bh rules,

37893: decode(time_val.start_day_of_week, 'SUN', 'Y', 'N' ) sunday_yn, 1,
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

Line 37956: OKC_RULES_B RUL

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
37960: AND RGP.CLE_ID IS NOT NULL

Line 38204: okc_rules_b rul,

38200: max(decode( tim.day_of_week, 'SAT', rin.duration)), 'MIN', 2003, sysdate, 2003,
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

Line 38267: OKC_RULES_BH RUL

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
38271: AND RGP.CLE_ID IS NOT NULL

Line 38536: okc_rules_bh rul,

38532: max(decode( tim.day_of_week, 'SAT', rin.duration)), 'MIN', 1, sysdate, 1,
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

Line 38638: FROM OKC_RULES_B RUL,

38634: SYSDATE,
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'

Line 38698: FROM OKC_RULES_B PMP,

38694: SYSDATE,
38695: 1,
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

Line 38699: OKC_RULES_B PML,

38695: 1,
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

Line 38876: , OKC_RULES_B RULE

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 )
38880: AND NOT EXISTS ( SELECT 1 FROM OKS_K_HEADERS_B OKSHI