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

Line 46: OKC_RULES_B RUL,

42: RULE_INFORMATION_CATEGORY COV_RULE_INFO,
43: RUL.OBJECT_VERSION_NUMBER COV_OBJ_VER_NUMBER
44: FROM
45: OKC_RULE_GROUPS_B RGP,
46: OKC_RULES_B RUL,
47: OKC_K_LINES_B LINE
48: WHERE LINE.ID = RGP.CLE_ID
49: AND RGP.ID = RUL.RGP_ID
50: AND LINE.LSE_ID IN (2,15,20)

Line 424: OKC_RULES_B RUL,

420: RULE_INFORMATION_CATEGORY COV_RULE_INFO,
421: RUL.OBJECT_VERSION_NUMBER COV_OBJ_VER_NUMBER
422: FROM
423: OKC_RULE_GROUPS_B RGP,
424: OKC_RULES_B RUL,
425: OKC_K_LINES_B LINE
426: WHERE LINE.ID = RGP.CLE_ID
427: AND RGP.ID = RUL.RGP_ID
428: AND LINE.LSE_ID in (3,16,21)

Line 986: OKC_RULES_B RUL,

982: Times.Last_Update_Login Times_Last_Update_Login,
983: Times.Attribute15 Times_Attribute15
984: FROM OKS_COVERAGE_TIMEZONES CTZ,
985: OKC_RULE_GROUPS_B RGP,
986: OKC_RULES_B RUL,
987: OKC_COVER_TIMES CVT,
988: OKC_TIMEVALUES_B TIMES
989: WHERE CTZ.Cle_Id = RGP.CLE_ID
990: AND CTZ.DNZ_CHR_ID = RGP.DNZ_CHR_ID

Line 1262: OKC_RULES_B RUL,

1258: RULE_INFORMATION_CATEGORY COV_RULE_INFO,
1259: RUL.OBJECT_VERSION_NUMBER COV_OBJ_VER_NUMBER
1260: FROM
1261: OKC_RULE_GROUPS_B RGP,
1262: OKC_RULES_B RUL,
1263: OKC_K_LINES_B LINE
1264: WHERE LINE.ID = RGP.CLE_ID
1265: AND RGP.ID = RUL.RGP_ID
1266: AND LINE.LSE_ID IN (4,17,22)

Line 1843: OKC_RULES_B RUL,

1839: RULE_INFORMATION_CATEGORY COV_RULE_INFO,
1840: RUL.OBJECT_VERSION_NUMBER COV_OBJ_VER_NUMBER
1841: FROM
1842: OKC_RULE_GROUPS_B RGP,
1843: OKC_RULES_B RUL,
1844: OKC_K_LINES_B LINE
1845: WHERE LINE.ID = RGP.CLE_ID
1846: AND RGP.ID = RUL.RGP_ID
1847: AND LINE.LSE_ID IN (5,59,23)

Line 2544: OKC_RULES_BH RUL,

2540: RUL.MAJOR_VERSION MAJOR_VERSION,
2541: KINE.ID k_line_id
2542: FROM
2543: OKC_RULE_GROUPS_BH RGP,
2544: OKC_RULES_BH RUL,
2545: OKC_K_LINES_BH LINE,
2546: OKS_K_LINES_B KINE
2547: WHERE LINE.ID = KINE.CLE_ID
2548: AND LINE.DNZ_CHR_ID = KINE.DNZ_CHR_ID

Line 3285: OKC_RULES_BH RUL,

3281: RUL.MAJOR_VERSION MAJOR_VERSION,
3282: KINE.ID k_line_id
3283: FROM
3284: OKC_RULE_GROUPS_BH RGP,
3285: OKC_RULES_BH RUL,
3286: OKC_K_LINES_BH LINE,
3287: OKS_K_LINES_B KINE
3288: WHERE KINE.ID > -1
3289: AND LINE.ID = KINE.CLE_ID

Line 3867: OKC_RULES_BH RUL,

3863: Times.object_version_number Times_object_version_number,
3864: Times.major_version Times_major_version
3865: FROM OKS_COVERAGE_TIMEZONES CTZ,
3866: OKC_RULE_GROUPS_BH RGP,
3867: OKC_RULES_BH RUL,
3868: OKC_COVER_TIMES_H CVT,
3869: OKC_TIMEVALUES_BH TIMES
3870: WHERE CTZ.Cle_Id = RGP.CLE_ID
3871: AND CTZ.DNZ_CHR_ID = RGP.DNZ_CHR_ID

Line 4320: OKC_RULES_BH RUL,

4316: KINE.ID k_line_id,
4317: Rul.major_version Rul_major_version
4318: FROM
4319: OKC_RULE_GROUPS_BH RGP,
4320: OKC_RULES_BH RUL,
4321: OKC_K_LINES_BH LINE,
4322: OKS_K_LINES_B KINE
4323: WHERE LINE.ID = KINE.CLE_ID
4324: AND LINE.DNZ_CHR_ID = KINE.DNZ_CHR_ID

Line 4680: okc_rule_groups_bh RGP,okc_rules_bh RUL,

4676: TIM.TVE_TYPE TVE_TYPE,
4677: Rul.ID RUL_ID,
4678: Rul.major_version Rul_major_version
4679: FROM oks_action_time_types_h TYP,
4680: okc_rule_groups_bh RGP,okc_rules_bh RUL,
4681: okc_timevalues_bh TIM,okc_react_intervals_h RIN
4682: WHERE RGP.CLE_ID = TYP.CLE_ID
4683: AND RGP.DNZ_CHR_ID = TYP.DNZ_CHR_ID
4684: AND RGP.ID = RUL.RGP_ID

Line 5060: OKC_RULES_BH RUL,

5056: RUL.OBJECT_VERSION_NUMBER COV_OBJ_VER_NUMBER,
5057: RUL.MAJOR_VERSION RUL_MAJOR_VERSION
5058: FROM
5059: OKC_RULE_GROUPS_BH RGP,
5060: OKC_RULES_BH RUL,
5061: OKC_K_LINES_BH LINE
5062: WHERE LINE.ID = RGP.CLE_ID
5063: AND RGP.ID = RUL.RGP_ID
5064: AND LINE.LSE_ID IN (5,59,23)