489: decode(level3_fk_key,NULL,0,1) +
490: decode(level2_fk_key,NULL,0,1) +
491: decode(level1_fk_key,NULL,0,1)) over(PARTITION BY hierarchy_id)
492: max_level--maximum level in the hierarchy
493: FROM mth_item_denorm_d
494: WHERE item_fk_key != MTH_UTIL_PKG.MTH_UA_GET_VAL
495: )
496: WHERE c_level
520:
521: --bulk update using forall
522: FORALL i IN
523: denorm_rec.baselevel_fk_key.first..denorm_rec.baselevel_fk_key.last
524: UPDATE mth_item_denorm_d
525: SET
526: level8_fk_key = denorm_rec.level9_fk_key(i),
527: level7_fk_key = denorm_rec.level7_fk_key(i),
528: level6_fk_key = denorm_rec.level6_fk_key(i),