716: fht.hierarchy_object_name,
717: fht.hier_obj_def_display_name,
718: TO_NUMBER(NULL),
719: gs_table_row_tab(i)
720: FROM fem_hierarchies_t fht
721: WHERE fht.dimension_varchar_label = gs_hier_dim_label_tab(i)
722: AND gs_hier_obj_def_id_tab(i) = -1
723: AND gs_hier_obj_id_tab(i) = -1;
724:
734: fht.hierarchy_object_name,
735: fht.hier_obj_def_display_name,
736: TO_NUMBER(NULL),
737: gs_table_row_tab(i)
738: FROM fem_hierarchies_t fht,
739: fem_object_catalog_vl focb,
740: fem_object_definition_vl fodb
741: WHERE fht.dimension_varchar_label = gs_hier_dim_label_tab(i)
742: AND fht.hierarchy_object_name = focb.object_name
760: fht.hierarchy_object_name,
761: fht.hier_obj_def_display_name,
762: TO_NUMBER(NULL),
763: gs_table_row_tab(i)
764: FROM fem_hierarchies_t fht,
765: fem_hierarchies fh,
766: fem_object_catalog_vl focb,
767: fem_object_definition_vl fodb
768: WHERE fht.dimension_varchar_label = gs_hier_dim_label_tab(i)