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_BH

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 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 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 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 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 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 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 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 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 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 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 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