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_TIMEVALUES_B

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 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 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 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 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 37771: okc_timevalues_b times,

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
37775: and rules.rule_information_category = 'CVR'

Line 37860: okc_timevalues_bh times,

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
37864: and rules.rule_information_category = 'CVR'

Line 38202: from okc_timevalues_b tim,

38198: max(decode( tim.day_of_week, 'THU', rin.duration)),
38199: max(decode( tim.day_of_week, 'FRI', rin.duration)),
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

Line 38534: from okc_timevalues_bh tim,

38530: max(decode( tim.day_of_week, 'THU', rin.duration)),
38531: max(decode( tim.day_of_week, 'FRI', rin.duration)),
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