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 OKS_K_LINES_B

Line 54: AND NOT EXISTS (SELECT CLE_ID FROM OKS_K_LINES_B WHERE CLE_ID = LINE.ID)

50: AND LINE.LSE_ID IN (2,15,20)
51: -- AND RUL.RULE_INFORMATION_CATEGORY IN ('ECE','WHE','UGE','STR','CVE','PMP')
52: AND LINE.DNZ_CHR_ID = RGP.DNZ_CHR_ID
53: -- AND RUL.RULE_INFORMATION15 IS NULL
54: AND NOT EXISTS (SELECT CLE_ID FROM OKS_K_LINES_B WHERE CLE_ID = LINE.ID)
55: AND Rul.rowid BETWEEN l_start_rowid and l_end_rowid
56: ORDER BY LINE.ID;
57:
58: G_Exception_Halt Exception;

Line 433: AND NOT EXISTS (SELECT CLE_ID FROM OKS_K_Lines_B where cle_id = LINE.ID)

429: AND RUL.RULE_INFORMATION_CATEGORY IN ('OFS','CVR','DST','PRE','BTD')
430: AND LINE.DNZ_CHR_ID = RGP.DNZ_CHR_ID
431: -- AND RUL.RULE_INFORMATION15 IS NULL
432: AND Rul.rowid BETWEEN l_start_rowid and l_end_rowid
433: AND NOT EXISTS (SELECT CLE_ID FROM OKS_K_Lines_B where cle_id = LINE.ID)
434: ORDER BY LINE.ID;
435:
436:
437:

Line 1270: AND NOT EXISTS (SELECT CLE_ID FROM OKS_K_LINES_B WHERE CLE_ID = LINE.ID)

1266: AND LINE.LSE_ID IN (4,17,22)
1267: AND RUL.RULE_INFORMATION_CATEGORY IN ('RCN','RSN')
1268: -- AND RUL.RULE_INFORMATION15 IS NULL
1269: AND Rul.rowid BETWEEN l_start_rowid and l_end_rowid
1270: AND NOT EXISTS (SELECT CLE_ID FROM OKS_K_LINES_B WHERE CLE_ID = LINE.ID)
1271: ORDER BY LINE.ID;
1272:
1273:
1274: TYPE RowId_Tbl_Type IS TABLE OF ROWID INDEX BY BINARY_INTEGER;

Line 1851: AND NOT EXISTS (SELECT CLE_ID FROM OKS_K_LINES_B WHERE CLE_ID = LINE.ID)

1847: AND LINE.LSE_ID IN (5,59,23)
1848: --AND RUL.RULE_INFORMATION_CATEGORY IN ('LMT')
1849: -- AND RUL.RULE_INFORMATION15 IS NULL
1850: AND Rul.rowid BETWEEN l_start_rowid and l_end_rowid
1851: AND NOT EXISTS (SELECT CLE_ID FROM OKS_K_LINES_B WHERE CLE_ID = LINE.ID)
1852: ORDER BY LINE.ID;
1853:
1854:
1855:

Line 2254: INSERT INTO OKS_K_LINES_BH

2250:
2251:
2252: FORALL I IN 1 .. l_tabsize
2253:
2254: INSERT INTO OKS_K_LINES_BH
2255: (
2256: ID,
2257: MAJOR_VERSION ,
2258: CLE_ID,

Line 2546: OKS_K_LINES_B KINE

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
2550: AND RGP.ID = RUL.RGP_ID

Line 2555: AND NOT EXISTS (SELECT CLE_ID FROM OKS_K_LINES_BH WHERE CLE_ID = LINE.ID)

2551: AND LINE.LSE_ID IN (2,15,20)
2552: -- AND RUL.RULE_INFORMATION_CATEGORY IN ('ECE','WHE','UGE','STR','CVE','PMP')
2553: AND LINE.DNZ_CHR_ID = RGP.DNZ_CHR_ID
2554: -- AND RUL.RULE_INFORMATION15 IS NULL
2555: AND NOT EXISTS (SELECT CLE_ID FROM OKS_K_LINES_BH WHERE CLE_ID = LINE.ID)
2556: AND Rul.rowid BETWEEN l_start_rowid and l_end_rowid
2557: AND LINE.major_version = RGP.major_version
2558: AND RGP.major_version = RUL.major_version
2559: ORDER BY LINE.ID,RUL.major_version;

Line 2964: INSERT INTO OKS_K_LINES_BH

2960: l_tabsize := i_clev_tbl_in.COUNT;
2961: -- dbms_output.put_line('Value of l_tabsize='||TO_CHAR(l_tabsize));
2962: FORALL I IN 1 .. l_tabsize
2963:
2964: INSERT INTO OKS_K_LINES_BH
2965: (
2966: ID,
2967: MAJOR_VERSION ,
2968: CLE_ID,

Line 3287: OKS_K_LINES_B KINE

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

Line 3298: AND NOT EXISTS (SELECT CLE_ID FROM OKS_K_Lines_BH where cle_id = LINE.ID)

3294: AND RUL.RULE_INFORMATION_CATEGORY IN ('OFS','CVR','DST','PRE','BTD')
3295: AND LINE.DNZ_CHR_ID = RGP.DNZ_CHR_ID
3296: -- AND RUL.RULE_INFORMATION15 IS NULL
3297: AND Rul.rowid BETWEEN l_start_rowid and l_end_rowid
3298: AND NOT EXISTS (SELECT CLE_ID FROM OKS_K_Lines_BH where cle_id = LINE.ID)
3299: AND LINE.MAJOR_VERSION = RGP.MAJOR_VERSION
3300: AND RGP.MAJOR_VERSION = RUL.MAJOR_VERSION
3301: ORDER BY LINE.ID,RUL.MAJOR_VERSION;
3302:

Line 4322: OKS_K_LINES_B KINE

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
4326: AND RGP.ID = RUL.RGP_ID

Line 4333: AND NOT EXISTS (SELECT CLE_ID FROM OKS_K_LINES_BH WHERE CLE_ID = LINE.ID)

4329: AND RGP.MAJOR_VERSION = RUL.MAJOR_VERSION
4330: AND LINE.MAJOR_VERSION = RGP.MAJOR_VERSION
4331: -- AND RUL.RULE_INFORMATION15 IS NULL
4332: AND Rul.rowid BETWEEN l_start_rowid and l_end_rowid
4333: AND NOT EXISTS (SELECT CLE_ID FROM OKS_K_LINES_BH WHERE CLE_ID = LINE.ID)
4334: ORDER BY LINE.ID;
4335:
4336: CURSOR Get_Rule_TlH (P_ID IN NUMBER) IS
4337: SELECT ID,

Line 4360: FROM OKS_K_LINES_B

4356: WHERE CLE_ID = p_Cle_ID;
4357:
4358: CURSOR Get_Action_Type_Id (p_Id IN NUMBER) IS
4359: SELECT CLE_ID,object_version_number --CLE_ID
4360: FROM OKS_K_LINES_B
4361: WHERE ID = P_ID;
4362:
4363:
4364: TYPE RowId_Tbl_Type IS TABLE OF ROWID INDEX BY BINARY_INTEGER;

Line 5069: AND NOT EXISTS (SELECT CLE_ID FROM OKS_K_LINES_BH WHERE CLE_ID = LINE.ID)

5065: --AND RUL.RULE_INFORMATION_CATEGORY IN ('LMT')
5066: AND Rul.rowid BETWEEN l_start_rowid and l_end_rowid
5067: AND RGP.MAJOR_VERSION = LINE.MAJOR_VERSION
5068: AND RGP.MAJOR_VERSION = RUL.MAJOR_VERSION
5069: AND NOT EXISTS (SELECT CLE_ID FROM OKS_K_LINES_BH WHERE CLE_ID = LINE.ID)
5070: ORDER BY LINE.ID;
5071:
5072: CURSOR Get_Rule_TlH (P_ID IN NUMBER) IS
5073: SELECT ID,