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.MTH_ITEM_DIMENSION_PKG dependencies on MTH_ITEM_DENORM_D_TMP

Line 959: FROM MTH_ITEM_DENORM_D_TMP

955: decode(level3_fk_key,NULL,0,1) +
956: decode(level2_fk_key,NULL,0,1) +
957: decode(level1_fk_key,NULL,0,1)) over(PARTITION BY hierarchy_id)
958: max_level--maximum level in the hierarchy
959: FROM MTH_ITEM_DENORM_D_TMP
960: WHERE item_fk_key != MTH_UTIL_PKG.MTH_UA_GET_VAL
961: )
962: WHERE c_level 963: AND level9_fk_key IS NOT NULL

Line 990: UPDATE MTH_ITEM_DENORM_D_TMP

986:
987: --bulk update using forall
988: FORALL i IN
989: denorm_rec.baselevel_fk_key.first..denorm_rec.baselevel_fk_key.last
990: UPDATE MTH_ITEM_DENORM_D_TMP
991: SET
992: level8_fk_key = denorm_rec.level9_fk_key(i),
993: level7_fk_key = denorm_rec.level7_fk_key(i),
994: level6_fk_key = denorm_rec.level6_fk_key(i),

Line 1072: INTO MTH.MTH_ITEM_DENORM_D_TMP

1068: v_unassigned_item_name := null;
1069: end;
1070:
1071: INSERT
1072: INTO MTH.MTH_ITEM_DENORM_D_TMP
1073: (
1074: HIERARCHY_ID,
1075: ITEM_FK_KEY,
1076: LEVEL1_FK_KEY,

Line 1269: mth_hrchy_balance_load('MTH.MTH_ITEM_DENORM_D_TMP');

1265: where mdh.dimension_name= 'ITEM' and
1266: mdll.hierarchy_id (+) = mdh.hierarchy_id);
1267:
1268: -- Balance the item denorm table
1269: mth_hrchy_balance_load('MTH.MTH_ITEM_DENORM_D_TMP');
1270: -- Push up and fill the level key and name for the ones with NULL
1271:
1272: UPDATE MTH.MTH_ITEM_DENORM_D_TMP
1273: SET level1_fk_key = nvl(level1_fk_key, v_unassigned_key),

Line 1272: UPDATE MTH.MTH_ITEM_DENORM_D_TMP

1268: -- Balance the item denorm table
1269: mth_hrchy_balance_load('MTH.MTH_ITEM_DENORM_D_TMP');
1270: -- Push up and fill the level key and name for the ones with NULL
1271:
1272: UPDATE MTH.MTH_ITEM_DENORM_D_TMP
1273: SET level1_fk_key = nvl(level1_fk_key, v_unassigned_key),
1274: level1_name = decode(level1_fk_key, NULL, v_unassigned_category_name, level1_name),
1275: level2_fk_key = nvl(level2_fk_key, v_unassigned_key),
1276: level2_name = Decode(level2_fk_key, NULL, v_unassigned_category_name, level2_name),

Line 1296: Insert into MTH.MTH_ITEM_DENORM_D_TMP

1292:
1293: -- Add entries for all the rest of levels
1294:
1295:
1296: Insert into MTH.MTH_ITEM_DENORM_D_TMP
1297: (
1298: HIERARCHY_ID,
1299: ITEM_FK_KEY,
1300: LEVEL1_FK_KEY,

Line 1344: From MTH.MTH_ITEM_DENORM_D_TMP

1340: LEVEL6_NAME,
1341: LEVEL7_NAME,
1342: LEVEL8_NAME,
1343: LEVEL9_NAME
1344: From MTH.MTH_ITEM_DENORM_D_TMP
1345: Where LEVEL9_FK_KEY is not null and level_NUM = 10;
1346:
1347: -- insert level 8 entries
1348: Insert into MTH.MTH_ITEM_DENORM_D_TMP

Line 1348: Insert into MTH.MTH_ITEM_DENORM_D_TMP

1344: From MTH.MTH_ITEM_DENORM_D_TMP
1345: Where LEVEL9_FK_KEY is not null and level_NUM = 10;
1346:
1347: -- insert level 8 entries
1348: Insert into MTH.MTH_ITEM_DENORM_D_TMP
1349: (
1350: HIERARCHY_ID,
1351: ITEM_FK_KEY,
1352: LEVEL1_FK_KEY,

Line 1396: From MTH.MTH_ITEM_DENORM_D_TMP

1392: LEVEL6_NAME,
1393: LEVEL7_NAME,
1394: LEVEL8_NAME,
1395: NULL
1396: From MTH.MTH_ITEM_DENORM_D_TMP
1397: Where LEVEL8_FK_KEY is not null and level_NUM = 9;
1398:
1399: -- insert level 7 entries
1400: Insert into MTH.MTH_ITEM_DENORM_D_TMP

Line 1400: Insert into MTH.MTH_ITEM_DENORM_D_TMP

1396: From MTH.MTH_ITEM_DENORM_D_TMP
1397: Where LEVEL8_FK_KEY is not null and level_NUM = 9;
1398:
1399: -- insert level 7 entries
1400: Insert into MTH.MTH_ITEM_DENORM_D_TMP
1401: (
1402: HIERARCHY_ID,
1403: ITEM_FK_KEY,
1404: LEVEL1_FK_KEY,

Line 1448: From MTH.MTH_ITEM_DENORM_D_TMP

1444: LEVEL6_NAME,
1445: LEVEL7_NAME,
1446: NULL,
1447: NULL
1448: From MTH.MTH_ITEM_DENORM_D_TMP
1449: Where LEVEL7_FK_KEY is not null and level_NUM = 8;
1450:
1451: -- insert level 6 entries
1452: Insert into MTH.MTH_ITEM_DENORM_D_TMP

Line 1452: Insert into MTH.MTH_ITEM_DENORM_D_TMP

1448: From MTH.MTH_ITEM_DENORM_D_TMP
1449: Where LEVEL7_FK_KEY is not null and level_NUM = 8;
1450:
1451: -- insert level 6 entries
1452: Insert into MTH.MTH_ITEM_DENORM_D_TMP
1453: (
1454: HIERARCHY_ID,
1455: ITEM_FK_KEY,
1456: LEVEL1_FK_KEY,

Line 1500: From MTH.MTH_ITEM_DENORM_D_TMP

1496: LEVEL6_NAME,
1497: NULL,
1498: NULL,
1499: NULL
1500: From MTH.MTH_ITEM_DENORM_D_TMP
1501: Where LEVEL6_FK_KEY is not null and level_NUM = 7;
1502:
1503: -- insert level 5 entries
1504: Insert into MTH.MTH_ITEM_DENORM_D_TMP

Line 1504: Insert into MTH.MTH_ITEM_DENORM_D_TMP

1500: From MTH.MTH_ITEM_DENORM_D_TMP
1501: Where LEVEL6_FK_KEY is not null and level_NUM = 7;
1502:
1503: -- insert level 5 entries
1504: Insert into MTH.MTH_ITEM_DENORM_D_TMP
1505: (
1506: HIERARCHY_ID,
1507: ITEM_FK_KEY,
1508: LEVEL1_FK_KEY,

Line 1552: From MTH.MTH_ITEM_DENORM_D_TMP

1548: NULL,
1549: NULL,
1550: NULL,
1551: NULL
1552: From MTH.MTH_ITEM_DENORM_D_TMP
1553: Where LEVEL5_FK_KEY is not null and level_NUM = 6;
1554:
1555: -- insert level 4 entries
1556: Insert into MTH.MTH_ITEM_DENORM_D_TMP

Line 1556: Insert into MTH.MTH_ITEM_DENORM_D_TMP

1552: From MTH.MTH_ITEM_DENORM_D_TMP
1553: Where LEVEL5_FK_KEY is not null and level_NUM = 6;
1554:
1555: -- insert level 4 entries
1556: Insert into MTH.MTH_ITEM_DENORM_D_TMP
1557: (
1558: HIERARCHY_ID,
1559: ITEM_FK_KEY,
1560: LEVEL1_FK_KEY,

Line 1604: From MTH.MTH_ITEM_DENORM_D_TMP

1600: NULL,
1601: NULL,
1602: NULL,
1603: NULL
1604: From MTH.MTH_ITEM_DENORM_D_TMP
1605: Where LEVEL4_FK_KEY is not null and level_NUM = 5;
1606:
1607:
1608: -- insert level 3 entries

Line 1609: Insert into MTH.MTH_ITEM_DENORM_D_TMP

1605: Where LEVEL4_FK_KEY is not null and level_NUM = 5;
1606:
1607:
1608: -- insert level 3 entries
1609: Insert into MTH.MTH_ITEM_DENORM_D_TMP
1610: (
1611: HIERARCHY_ID,
1612: ITEM_FK_KEY,
1613: LEVEL1_FK_KEY,

Line 1657: From MTH.MTH_ITEM_DENORM_D_TMP

1653: NULL,
1654: NULL,
1655: NULL,
1656: NULL
1657: From MTH.MTH_ITEM_DENORM_D_TMP
1658: Where LEVEL3_FK_KEY is not null and level_NUM = 4;
1659:
1660:
1661: -- insert level 2 entries

Line 1662: Insert into MTH.MTH_ITEM_DENORM_D_TMP

1658: Where LEVEL3_FK_KEY is not null and level_NUM = 4;
1659:
1660:
1661: -- insert level 2 entries
1662: Insert into MTH.MTH_ITEM_DENORM_D_TMP
1663: (
1664: HIERARCHY_ID,
1665: ITEM_FK_KEY,
1666: LEVEL1_FK_KEY,

Line 1710: From MTH.MTH_ITEM_DENORM_D_TMP

1706: NULL,
1707: NULL,
1708: NULL,
1709: NULL
1710: From MTH.MTH_ITEM_DENORM_D_TMP
1711: Where LEVEL2_FK_KEY is not null and level_NUM = 3;
1712:
1713:
1714:

Line 1716: Insert into MTH.MTH_ITEM_DENORM_D_TMP

1712:
1713:
1714:
1715: -- insert level 1 entries
1716: Insert into MTH.MTH_ITEM_DENORM_D_TMP
1717: (
1718: HIERARCHY_ID,
1719: ITEM_FK_KEY,
1720: LEVEL1_FK_KEY,

Line 1764: From MTH.MTH_ITEM_DENORM_D_TMP

1760: NULL,
1761: NULL,
1762: NULL,
1763: NULL
1764: From MTH.MTH_ITEM_DENORM_D_TMP
1765: Where LEVEL1_FK_KEY is not null and level_NUM = 2;
1766:
1767:
1768: EXCEPTION

Line 1838: INTO MTH_ITEM_DENORM_D_TMP

1834: IS
1835: BEGIN
1836:
1837: INSERT
1838: INTO MTH_ITEM_DENORM_D_TMP
1839: (
1840: HIERARCHY_ID,
1841: ITEM_FK_KEY,
1842: LEVEL1_FK_KEY,

Line 2052: INTO MTH_ITEM_DENORM_D_TMP

2048: BEGIN
2049:
2050: v_unassigned_val := MTH_UTIL_PKG.MTH_UA_GET_VAL;
2051: INSERT
2052: INTO MTH_ITEM_DENORM_D_TMP
2053: (
2054: HIERARCHY_ID,
2055: ITEM_FK_KEY,
2056: LEVEL1_FK_KEY,

Line 2242: UPDATE MTH.MTH_ITEM_DENORM_D_TMP

2238: PROCEDURE UPD_ITEM_DENORM_TMP_UNASSIGNED(p_unassigned_key IN NUMBER,
2239: p_unassigned_category_name IN VARCHAR2)
2240: IS
2241: BEGIN
2242: UPDATE MTH.MTH_ITEM_DENORM_D_TMP
2243: SET level1_fk_key = nvl(level1_fk_key, p_unassigned_key),
2244: level1_name = decode(level1_fk_key, NULL, p_unassigned_category_name, level1_name),
2245: level2_fk_key = nvl(level2_fk_key, p_unassigned_key),
2246: level2_name = Decode(level2_fk_key, NULL, p_unassigned_category_name, level2_name),

Line 2365: FROM MTH_ITEM_DENORM_D_TMP

2361: decode(level4_fk_key,MTH_UTIL_PKG.MTH_UA_GET_VAL,0,NULL,0,1) +
2362: decode(level3_fk_key,MTH_UTIL_PKG.MTH_UA_GET_VAL,0,NULL,0,1) +
2363: decode(level2_fk_key,MTH_UTIL_PKG.MTH_UA_GET_VAL,0,NULL,0,1) +
2364: decode(level1_fk_key,MTH_UTIL_PKG.MTH_UA_GET_VAL,0,NULL,0,1)) diff_level
2365: FROM MTH_ITEM_DENORM_D_TMP
2366: WHERE item_fk_key <> MTH_UTIL_PKG.MTH_UA_GET_VAL AND
2367: hierarchy_id = p_hierarchy_id AND
2368: p_expected_level> (decode(level9_fk_key,MTH_UTIL_PKG.MTH_UA_GET_VAL,0,NULL,0,1) +
2369: decode(level8_fk_key,MTH_UTIL_PKG.MTH_UA_GET_VAL,0,NULL,0,1) +

Line 2424: UPDATE MTH_ITEM_DENORM_D_TMP

2420:
2421: --bulk update using forall
2422: FORALL i IN
2423: denorm_rec.baselevel_fk_key.first..denorm_rec.baselevel_fk_key.last
2424: UPDATE MTH_ITEM_DENORM_D_TMP
2425: SET
2426: level8_fk_key = denorm_rec.level9_fk_key(i),
2427: level7_fk_key = denorm_rec.level7_fk_key(i),
2428: level6_fk_key = denorm_rec.level6_fk_key(i),

Line 2647: * MTH_ITEM_DENORM_D_TMP when the hierarchy does not exist *

2643:
2644: /* ****************************************************************************
2645: * Procedure :INSERT_UNASS_ITEM_DENORM_TMP *
2646: * Description :This procedure inserts unassigned entry into *
2647: * MTH_ITEM_DENORM_D_TMP when the hierarchy does not exist *
2648: * in item denorm table *
2649: * File Name :MTHITEMDB.PLS *
2650: * Visibility :Private *
2651: * Parameters : *

Line 2664: INSERT INTO MTH_ITEM_DENORM_D_TMP

2660: p_unassigned_category_name IN VARCHAR2)
2661: IS
2662: BEGIN
2663:
2664: INSERT INTO MTH_ITEM_DENORM_D_TMP
2665: ( HIERARCHY_ID, ITEM_FK_KEY, LEVEL9_FK_KEY, LEVEL8_FK_KEY,
2666: LEVEL7_FK_KEY, LEVEL6_FK_KEY, LEVEL5_FK_KEY, LEVEL4_FK_KEY,
2667: LEVEL3_FK_KEY, LEVEL2_FK_KEY, LEVEL1_FK_KEY,
2668: LEVEL_NUM, ITEM_NAME, LEVEL9_NAME, LEVEL8_NAME, LEVEL7_NAME,

Line 3224: Insert into MTH_ITEM_DENORM_D_TMP

3220: PROCEDURE BUILD_LVL_1_9_item_denorm_tmp (p_hierarchy_id IN NUMBER)
3221: IS
3222: BEGIN
3223:
3224: Insert into MTH_ITEM_DENORM_D_TMP
3225: (
3226: HIERARCHY_ID,
3227: ITEM_FK_KEY,
3228: LEVEL1_FK_KEY,

Line 3272: From MTH_ITEM_DENORM_D_TMP

3268: LEVEL6_NAME,
3269: LEVEL7_NAME,
3270: LEVEL8_NAME,
3271: LEVEL9_NAME
3272: From MTH_ITEM_DENORM_D_TMP
3273: Where LEVEL9_FK_KEY is not null and level_NUM = 10 AND
3274: hierarchy_id = p_hierarchy_id;
3275:
3276:

Line 3278: Insert into MTH_ITEM_DENORM_D_TMP

3274: hierarchy_id = p_hierarchy_id;
3275:
3276:
3277: -- insert level 8 entries
3278: Insert into MTH_ITEM_DENORM_D_TMP
3279: (
3280: HIERARCHY_ID,
3281: ITEM_FK_KEY,
3282: LEVEL1_FK_KEY,

Line 3326: From MTH_ITEM_DENORM_D_TMP

3322: LEVEL6_NAME,
3323: LEVEL7_NAME,
3324: LEVEL8_NAME,
3325: NULL
3326: From MTH_ITEM_DENORM_D_TMP
3327: Where LEVEL8_FK_KEY is not null and level_NUM = 9 AND
3328: hierarchy_id = p_hierarchy_id;
3329:
3330:

Line 3332: Insert into MTH_ITEM_DENORM_D_TMP

3328: hierarchy_id = p_hierarchy_id;
3329:
3330:
3331: -- insert level 7 entries
3332: Insert into MTH_ITEM_DENORM_D_TMP
3333: (
3334: HIERARCHY_ID,
3335: ITEM_FK_KEY,
3336: LEVEL1_FK_KEY,

Line 3380: From MTH_ITEM_DENORM_D_TMP

3376: LEVEL6_NAME,
3377: LEVEL7_NAME,
3378: NULL,
3379: NULL
3380: From MTH_ITEM_DENORM_D_TMP
3381: Where LEVEL7_FK_KEY is not null and level_NUM = 8 AND
3382: hierarchy_id = p_hierarchy_id;
3383:
3384:

Line 3386: Insert into MTH_ITEM_DENORM_D_TMP

3382: hierarchy_id = p_hierarchy_id;
3383:
3384:
3385: -- insert level 6 entries
3386: Insert into MTH_ITEM_DENORM_D_TMP
3387: (
3388: HIERARCHY_ID,
3389: ITEM_FK_KEY,
3390: LEVEL1_FK_KEY,

Line 3434: From MTH_ITEM_DENORM_D_TMP

3430: LEVEL6_NAME,
3431: NULL,
3432: NULL,
3433: NULL
3434: From MTH_ITEM_DENORM_D_TMP
3435: Where LEVEL6_FK_KEY is not null and level_NUM = 7 AND
3436: hierarchy_id = p_hierarchy_id;
3437:
3438:

Line 3440: Insert into MTH_ITEM_DENORM_D_TMP

3436: hierarchy_id = p_hierarchy_id;
3437:
3438:
3439: -- insert level 5 entries
3440: Insert into MTH_ITEM_DENORM_D_TMP
3441: (
3442: HIERARCHY_ID,
3443: ITEM_FK_KEY,
3444: LEVEL1_FK_KEY,

Line 3488: From MTH_ITEM_DENORM_D_TMP

3484: NULL,
3485: NULL,
3486: NULL,
3487: NULL
3488: From MTH_ITEM_DENORM_D_TMP
3489: Where LEVEL5_FK_KEY is not null and level_NUM = 6 AND
3490: hierarchy_id = p_hierarchy_id;
3491:
3492:

Line 3494: Insert into MTH_ITEM_DENORM_D_TMP

3490: hierarchy_id = p_hierarchy_id;
3491:
3492:
3493: -- insert level 4 entries
3494: Insert into MTH_ITEM_DENORM_D_TMP
3495: (
3496: HIERARCHY_ID,
3497: ITEM_FK_KEY,
3498: LEVEL1_FK_KEY,

Line 3542: From MTH_ITEM_DENORM_D_TMP

3538: NULL,
3539: NULL,
3540: NULL,
3541: NULL
3542: From MTH_ITEM_DENORM_D_TMP
3543: Where LEVEL4_FK_KEY is not null and level_NUM = 5 AND
3544: hierarchy_id = p_hierarchy_id;
3545:
3546:

Line 3549: Insert into MTH_ITEM_DENORM_D_TMP

3545:
3546:
3547:
3548: -- insert level 3 entries
3549: Insert into MTH_ITEM_DENORM_D_TMP
3550: (
3551: HIERARCHY_ID,
3552: ITEM_FK_KEY,
3553: LEVEL1_FK_KEY,

Line 3597: From MTH_ITEM_DENORM_D_TMP

3593: NULL,
3594: NULL,
3595: NULL,
3596: NULL
3597: From MTH_ITEM_DENORM_D_TMP
3598: Where LEVEL3_FK_KEY is not null and level_NUM = 4 AND
3599: hierarchy_id = p_hierarchy_id;
3600:
3601:

Line 3604: Insert into MTH_ITEM_DENORM_D_TMP

3600:
3601:
3602:
3603: -- insert level 2 entries
3604: Insert into MTH_ITEM_DENORM_D_TMP
3605: (
3606: HIERARCHY_ID,
3607: ITEM_FK_KEY,
3608: LEVEL1_FK_KEY,

Line 3652: From MTH_ITEM_DENORM_D_TMP

3648: NULL,
3649: NULL,
3650: NULL,
3651: NULL
3652: From MTH_ITEM_DENORM_D_TMP
3653: Where LEVEL2_FK_KEY is not null and level_NUM = 3 AND
3654: hierarchy_id = p_hierarchy_id;
3655:
3656:

Line 3660: Insert into MTH_ITEM_DENORM_D_TMP

3656:
3657:
3658:
3659: -- insert level 1 entries
3660: Insert into MTH_ITEM_DENORM_D_TMP
3661: (
3662: HIERARCHY_ID,
3663: ITEM_FK_KEY,
3664: LEVEL1_FK_KEY,

Line 3708: From MTH_ITEM_DENORM_D_TMP

3704: NULL,
3705: NULL,
3706: NULL,
3707: NULL
3708: From MTH_ITEM_DENORM_D_TMP
3709: Where LEVEL1_FK_KEY is not null and level_NUM = 2 AND
3710: hierarchy_id = p_hierarchy_id;
3711:
3712:

Line 3801: FROM mth_item_denorm_d_tmp tmp

3797: v_unassigned_val,
3798: v_unassigned_val,
3799: v_log_to_date,
3800: v_log_to_date
3801: FROM mth_item_denorm_d_tmp tmp
3802: WHERE tmp.level_num < 10 AND
3803: tmp.hierarchy_id = p_hierarchy_id AND
3804: NOT EXISTS
3805: (SELECT 1

Line 3866: FROM (SELECT * FROM mth_item_denorm_d_tmp WHERE level_num < 10 )) tmp

3862: level4_name,
3863: level3_name,
3864: level2_name,
3865: level1_name
3866: FROM (SELECT * FROM mth_item_denorm_d_tmp WHERE level_num < 10 )) tmp
3867: ON (mid.hierarchy_id = p_hierarchy_id AND tmp.hierarchy_id = mid.hierarchy_id
3868: AND ((mid.level_num = 9 AND tmp.level_num = 9 AND mid.level9_fk_key = tmp.level9_fk_key)
3869: OR (mid.level_num = 8 AND tmp.level_num = 8 AND mid.level8_fk_key = tmp.level8_fk_key)
3870: OR (mid.level_num = 7 AND tmp.level_num = 7 AND mid.level7_fk_key = tmp.level7_fk_key)

Line 3992: FROM MTH_ITEM_DENORM_D_TMP

3988: decode(level4_fk_key,NULL,0,MTH_UTIL_PKG.MTH_UA_GET_VAL,0,1) +
3989: decode(level3_fk_key,NULL,0,MTH_UTIL_PKG.MTH_UA_GET_VAL,0,1) +
3990: decode(level2_fk_key,NULL,0,MTH_UTIL_PKG.MTH_UA_GET_VAL,0,1) +
3991: decode(level1_fk_key,NULL,0,MTH_UTIL_PKG.MTH_UA_GET_VAL,0,1)) min_level
3992: FROM MTH_ITEM_DENORM_D_TMP
3993: WHERE item_fk_key <> MTH_UTIL_PKG.MTH_UA_GET_VAL
3994: GROUP BY hierarchy_id) id,
3995: mth_dim_hierarchy mdh
3996: WHERE id.hierarchy_id = mdh.hierarchy_id;

Line 4202: FROM mth_item_denorm_d_tmp idt

4198: DELETE FROM mth_item_denorm_d id
4199: WHERE id.hierarchy_id = r_hid_and_levels.hierarchy_id AND
4200: level_num = 10 AND
4201: item_fk_key IN (SELECT idt.item_fk_key
4202: FROM mth_item_denorm_d_tmp idt
4203: WHERE idt.hierarchy_id = id.hierarchy_id AND
4204: idt.level_num = 10);
4205: v_num_rows_deleted := (SQL%ROWCOUNT > 0);
4206: END IF;

Line 4301: FROM MTH_ITEM_DENORM_D_TMP

4297: v_unassigned_key, v_unassigned_key, v_log_to_date, v_log_to_date,
4298: LEVEL_NUM, ITEM_NAME, LEVEL9_NAME, LEVEL8_NAME, LEVEL7_NAME,
4299: LEVEL6_NAME, LEVEL5_NAME, LEVEL4_NAME, LEVEL3_NAME, LEVEL2_NAME,
4300: LEVEL1_NAME
4301: FROM MTH_ITEM_DENORM_D_TMP
4302: WHERE hierarchy_id = r_hid_and_levels.hierarchy_id AND
4303: level_num = 10;
4304:
4305: