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.OKE_VERSION_COMPARISON_PKG dependencies on OKC_K_LINES_B

Line 59: FROM OKC_K_LINES_BH

55: IS
56: l_linenum varchar2(300):=null;
57: cursor c_lines is
58: SELECT line_number
59: FROM OKC_K_LINES_BH
60: WHERE major_version = vVersion
61: CONNECT BY PRIOR cle_id=id
62: START WITH id= vk_line_id AND major_version = vVersion;
63:

Line 84: FROM OKC_K_LINES_B

80: IS
81: l_linenum varchar2(300):=null;
82: cursor c_lines is
83: SELECT line_number
84: FROM OKC_K_LINES_B
85: CONNECT BY PRIOR cle_id=id
86: START WITH id= vk_line_id;
87:
88: BEGIN

Line 1471: FROM OKC_K_LINES_BH a

1467: nSublines number;
1468:
1469: CURSOR c_nDifferent_lines_1 IS
1470: SELECT ID K_LINE_ID
1471: FROM OKC_K_LINES_BH a
1472: WHERE DNZ_CHR_ID=vHeader_id
1473: AND MAJOR_VERSION=vVersion1
1474: AND CLE_ID IS NULL
1475: AND NOT EXISTS

Line 1477: FROM OKC_K_LINES_BH b

1473: AND MAJOR_VERSION=vVersion1
1474: AND CLE_ID IS NULL
1475: AND NOT EXISTS
1476: ( SELECT 'x'
1477: FROM OKC_K_LINES_BH b
1478: WHERE b.ID=a.ID
1479: AND CLE_ID IS NULL
1480: AND MAJOR_VERSION=vVersion2)
1481: ORDER BY LINE_NUMBER;

Line 1485: FROM OKC_K_LINES_B a

1481: ORDER BY LINE_NUMBER;
1482:
1483: CURSOR c_nDifferent_lines_1_latest IS
1484: SELECT ID K_LINE_ID
1485: FROM OKC_K_LINES_B a
1486: WHERE DNZ_CHR_ID=vHeader_id
1487: AND CLE_ID IS NULL
1488: AND NOT EXISTS
1489: ( SELECT 'x'

Line 1490: FROM OKC_K_LINES_BH b

1486: WHERE DNZ_CHR_ID=vHeader_id
1487: AND CLE_ID IS NULL
1488: AND NOT EXISTS
1489: ( SELECT 'x'
1490: FROM OKC_K_LINES_BH b
1491: WHERE b.ID=a.ID
1492: AND CLE_ID IS NULL
1493: AND MAJOR_VERSION=vVersion2)
1494: ORDER BY LINE_NUMBER;

Line 1498: FROM OKC_K_LINES_BH a

1494: ORDER BY LINE_NUMBER;
1495:
1496: CURSOR c_nDifferent_lines_2 IS
1497: SELECT ID K_LINE_ID
1498: FROM OKC_K_LINES_BH a
1499: WHERE DNZ_CHR_ID=vHeader_id
1500: AND MAJOR_VERSION=vVersion2
1501: AND CLE_ID IS NULL
1502: AND NOT EXISTS

Line 1504: FROM OKC_K_LINES_BH b

1500: AND MAJOR_VERSION=vVersion2
1501: AND CLE_ID IS NULL
1502: AND NOT EXISTS
1503: ( SELECT 'x'
1504: FROM OKC_K_LINES_BH b
1505: WHERE b.ID=a.ID
1506: AND CLE_ID IS NULL
1507: AND MAJOR_VERSION=vVersion1)
1508: ORDER BY LINE_NUMBER;

Line 1512: FROM OKC_K_LINES_BH a

1508: ORDER BY LINE_NUMBER;
1509:
1510: CURSOR c_nDifferent_lines_2_latest IS
1511: SELECT ID K_LINE_ID
1512: FROM OKC_K_LINES_BH a
1513: WHERE DNZ_CHR_ID=vHeader_id
1514: AND MAJOR_VERSION=vVersion2
1515: AND CLE_ID IS NULL
1516: AND NOT EXISTS

Line 1518: FROM OKC_K_LINES_B b

1514: AND MAJOR_VERSION=vVersion2
1515: AND CLE_ID IS NULL
1516: AND NOT EXISTS
1517: ( SELECT 'x'
1518: FROM OKC_K_LINES_B b
1519: WHERE b.ID=a.ID
1520: AND CLE_ID IS NULL)
1521: ORDER BY LINE_NUMBER;
1522:

Line 1579: FROM OKC_K_LINES_BH A, OKC_K_LINES_BH B

1575: END LOOP;
1576:
1577: OPEN v_top_nodes FOR
1578: SELECT a.ID K_LINE_ID
1579: FROM OKC_K_LINES_BH A, OKC_K_LINES_BH B
1580: WHERE a.DNZ_CHR_ID=vHeader_id
1581: AND a.MAJOR_VERSION=vVersion1
1582: AND a.CLE_ID IS NULL
1583: AND a.ID = b.ID

Line 1624: FROM OKC_K_LINES_B A, OKC_K_LINES_BH B

1620: END LOOP;
1621:
1622: OPEN v_top_nodes FOR
1623: SELECT a.ID K_LINE_ID
1624: FROM OKC_K_LINES_B A, OKC_K_LINES_BH B
1625: WHERE a.DNZ_CHR_ID=vHeader_id
1626: AND a.CLE_ID IS NULL
1627: AND a.ID = b.ID
1628: AND b.CLE_ID IS NULL

Line 2910: FROM okc_k_lines_bh

2906: and major_version=vVersion1;
2907:
2908: SELECT count(*)
2909: INTO nSublines
2910: FROM okc_k_lines_bh
2911: WHERE CLE_ID=nCurrent_line_id
2912: AND MAJOR_VERSION= vVersion1;
2913:
2914: ELSE

Line 2923: FROM okc_k_lines_b

2919: and k_line_id=nCurrent_line_id;
2920:
2921: SELECT count(*)
2922: INTO nSublines
2923: FROM okc_k_lines_b
2924: WHERE CLE_ID=nCurrent_line_id;
2925: END IF;
2926:
2927: IF nDeliverables>0 THEN

Line 3067: FROM OKC_K_LINES_BH a

3063: c_sub_node OKE_K_LINES_SECURE_HV.parent_line_id%TYPE;
3064:
3065: CURSOR c_nDifferent_lines_1 IS
3066: SELECT ID K_LINE_ID
3067: FROM OKC_K_LINES_BH a
3068: WHERE DNZ_CHR_ID=vHeader_id
3069: AND CLE_ID=vParentLineId
3070: AND MAJOR_VERSION=vVersion1
3071: AND NOT EXISTS

Line 3073: FROM OKC_K_LINES_BH b

3069: AND CLE_ID=vParentLineId
3070: AND MAJOR_VERSION=vVersion1
3071: AND NOT EXISTS
3072: ( SELECT 'x'
3073: FROM OKC_K_LINES_BH b
3074: WHERE b.ID=a.ID
3075: AND CLE_ID=vParentLineId
3076: AND MAJOR_VERSION=vVersion2)
3077: ORDER BY LINE_NUMBER;

Line 3081: FROM OKC_K_LINES_B a

3077: ORDER BY LINE_NUMBER;
3078:
3079: CURSOR c_nDifferent_lines_1_latest IS
3080: SELECT ID K_LINE_ID
3081: FROM OKC_K_LINES_B a
3082: WHERE DNZ_CHR_ID=vHeader_id
3083: AND CLE_ID=vParentLineId
3084: AND NOT EXISTS
3085: ( SELECT 'x'

Line 3086: FROM OKC_K_LINES_BH b

3082: WHERE DNZ_CHR_ID=vHeader_id
3083: AND CLE_ID=vParentLineId
3084: AND NOT EXISTS
3085: ( SELECT 'x'
3086: FROM OKC_K_LINES_BH b
3087: WHERE b.ID=a.ID
3088: AND CLE_ID=vParentLineId
3089: AND MAJOR_VERSION=vVersion2)
3090: ORDER BY LINE_NUMBER;

Line 3094: FROM OKC_K_LINES_BH a

3090: ORDER BY LINE_NUMBER;
3091:
3092: CURSOR c_nDifferent_lines_2 IS
3093: SELECT ID K_LINE_ID
3094: FROM OKC_K_LINES_BH a
3095: WHERE DNZ_CHR_ID=vHeader_id
3096: AND CLE_ID=vParentLineId
3097: AND MAJOR_VERSION=vVersion2
3098: AND NOT EXISTS

Line 3100: FROM OKC_K_LINES_BH b

3096: AND CLE_ID=vParentLineId
3097: AND MAJOR_VERSION=vVersion2
3098: AND NOT EXISTS
3099: ( SELECT 'x'
3100: FROM OKC_K_LINES_BH b
3101: WHERE b.ID=a.ID
3102: AND CLE_ID=vParentLineId
3103: AND MAJOR_VERSION=vVersion1)
3104: ORDER BY LINE_NUMBER;

Line 3108: FROM OKC_K_LINES_BH a

3104: ORDER BY LINE_NUMBER;
3105:
3106: CURSOR c_nDifferent_lines_2_latest IS
3107: SELECT ID K_LINE_ID
3108: FROM OKC_K_LINES_BH a
3109: WHERE DNZ_CHR_ID=vHeader_id
3110: AND CLE_ID=vParentLineId
3111: AND MAJOR_VERSION=vVersion2
3112: AND NOT EXISTS

Line 3114: FROM OKC_K_LINES_B b

3110: AND CLE_ID=vParentLineId
3111: AND MAJOR_VERSION=vVersion2
3112: AND NOT EXISTS
3113: ( SELECT 'x'
3114: FROM OKC_K_LINES_B b
3115: WHERE b.ID=a.ID
3116: AND CLE_ID=vParentLineId)
3117: ORDER BY LINE_NUMBER;
3118:

Line 3178: FROM OKC_K_LINES_BH A, OKC_K_LINES_BH B

3174: END LOOP;
3175:
3176: OPEN v_sub_nodes FOR
3177: SELECT a.ID K_LINE_ID
3178: FROM OKC_K_LINES_BH A, OKC_K_LINES_BH B
3179: WHERE a.DNZ_CHR_ID=vHeader_id
3180: AND a.MAJOR_VERSION=vVersion1
3181: AND a.CLE_ID=vParentLineId
3182: AND a.ID = b.ID

Line 3224: FROM OKC_K_LINES_B A, OKC_K_LINES_BH B

3220: END LOOP;
3221:
3222: OPEN v_sub_nodes FOR
3223: SELECT a.ID K_LINE_ID
3224: FROM OKC_K_LINES_B A, OKC_K_LINES_BH B
3225: WHERE a.DNZ_CHR_ID=vHeader_id
3226: AND a.CLE_ID=vParentLineId
3227: AND a.ID = b.ID
3228: AND b.CLE_ID=vParentLineId

Line 4493: FROM OKC_K_LINES_BH

4489: AND MAJOR_VERSION=vVersion1;
4490:
4491: SELECT count(*)
4492: INTO l_numOfSublines
4493: FROM OKC_K_LINES_BH
4494: WHERE DNZ_CHR_ID=vHeader_id
4495: AND CLE_ID=nCurrent_line_id
4496: AND MAJOR_VERSION=vVersion1;
4497:

Line 4507: FROM OKC_K_LINES_B

4503: and k_line_id=nCurrent_line_id;
4504:
4505: SELECT count(*)
4506: INTO l_numOfSublines
4507: FROM OKC_K_LINES_B
4508: WHERE DNZ_CHR_ID=vHeader_id
4509: AND CLE_ID=nCurrent_line_id;
4510: END IF;
4511: