DBA Data[Home] [Help]

APPS.OKS_COVERAGE_MIGRATION dependencies on OKC_RULE_GROUPS_BH

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