APPS.OKS_COVERAGE_MIGRATION dependencies on OKC_RULE_GROUPS_B

Line 45: OKC_RULE_GROUPS_B RGP,

41: RULE_INFORMATION15 COV_RULE_INFO15,
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

Line 423: OKC_RULE_GROUPS_B RGP,

419: RULE_INFORMATION15 COV_RULE_INFO15,
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

Line 985: OKC_RULE_GROUPS_B RGP,

981: Times.Last_Update_Date Times_Last_Update_Date,
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

Line 1261: OKC_RULE_GROUPS_B RGP,

1257: RULE_INFORMATION15 COV_RULE_INFO15,
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

Line 1842: OKC_RULE_GROUPS_B RGP,

1838: RULE_INFORMATION15 COV_RULE_INFO15,
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

Line 2543: OKC_RULE_GROUPS_BH RGP,

2539: RUL.OBJECT_VERSION_NUMBER COV_OBJ_VER_NUMBER,
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

Line 3284: OKC_RULE_GROUPS_BH RGP,

3280: RUL.OBJECT_VERSION_NUMBER COV_OBJ_VER_NUMBER,
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

Line 3866: OKC_RULE_GROUPS_BH RGP,

3862: Times.Attribute15 Times_Attribute15,
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

Line 4319: OKC_RULE_GROUPS_BH RGP,

4315: RUL.OBJECT_VERSION_NUMBER COV_OBJ_VER_NUMBER,
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

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 5059: OKC_RULE_GROUPS_BH RGP,

5055: RULE_INFORMATION_CATEGORY COV_RULE_INFO,
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