APPS.OKS_COVERAGE_MIGRATION dependencies on OKC_K_LINES_BH

Line 2545: OKC_K_LINES_BH LINE,

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
2549: AND LINE.ID = RGP.CLE_ID

Line 3286: OKC_K_LINES_BH LINE,

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
3290: AND LINE.DNZ_CHR_ID = KINE.DNZ_CHR_ID

Line 3611: UPDATE OKC_K_LINES_BH

3607:
3608:
3609: IF COV_RULE_INFO_TBL(i) = 'PRE' THEN
3610:
3611: UPDATE OKC_K_LINES_BH
3612: SET PRICE_LIST_ID = LINE_OBJECT1_ID1_TBL(i),
3613: CURRENCY_CODE = l_OU_CURRENCY
3614: WHERE ID = LINE_ID_TBL(i);
3615:

Line 4321: OKC_K_LINES_BH LINE,

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
4325: AND LINE.ID = RGP.CLE_ID

Line 5061: OKC_K_LINES_BH LINE

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)
5065: --AND RUL.RULE_INFORMATION_CATEGORY IN ('LMT')