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_K_LINES_B

Line 47: OKC_K_LINES_B LINE

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)
51: -- AND RUL.RULE_INFORMATION_CATEGORY IN ('ECE','WHE','UGE','STR','CVE','PMP')

Line 425: OKC_K_LINES_B LINE

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)
429: AND RUL.RULE_INFORMATION_CATEGORY IN ('OFS','CVR','DST','PRE','BTD')

Line 733: UPDATE OKC_K_LINES_B

729:
730:
731: IF COV_RULE_INFO_TBL(i) = 'PRE' THEN
732:
733: UPDATE OKC_K_LINES_B
734: SET PRICE_LIST_ID = LINE_OBJECT1_ID1_TBL(i),
735: CURRENCY_CODE = l_OU_CURRENCY
736: WHERE ID = LINE_ID_TBL(i);
737:

Line 1263: OKC_K_LINES_B LINE

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)
1267: AND RUL.RULE_INFORMATION_CATEGORY IN ('RCN','RSN')

Line 1844: OKC_K_LINES_B LINE

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

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')