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.ZPB_METADATA_PKG dependencies on ZPB_HIERARCHIES

Line 912: -- zpb_md_records.hierarchies_entry into zpb_hierarchies and

908: end insertDimensionsTLRecord;
909:
910: -------------------------------------------------------------------------------
911: -- insertHierarchyRecord - Private function that inserts a
912: -- zpb_md_records.hierarchies_entry into zpb_hierarchies and
913: -- returns the primary key of the newly created entry
914: -------------------------------------------------------------------------------
915: function insertHierarchyRecord(p_hierarchies_rec in zpb_md_records.hierarchies_entry)
916: return number is

Line 926: from zpb_hierarchies

922:
923: begin
924:
925: select hierarchy_id into l_hierarchies_rec.HierarchyId
926: from zpb_hierarchies
927: where dimension_id = l_hierarchies_rec.DimensionId and
928: pers_cwm_name = l_hierarchies_rec.PersCWMName;
929:
930: update zpb_hierarchies

Line 930: update zpb_hierarchies

926: from zpb_hierarchies
927: where dimension_id = l_hierarchies_rec.DimensionId and
928: pers_cwm_name = l_hierarchies_rec.PersCWMName;
929:
930: update zpb_hierarchies
931: set
932: EPB_ID = l_hierarchies_rec.EpbId,
933: HIER_TYPE = l_hierarchies_rec.HierType,
934: PERS_TABLE_ID = l_hierarchies_rec.PersTableId,

Line 946: SELECT zpb_hierarchies_seq.NEXTVAL INTO l_hierarchies_rec.HierarchyId FROM DUAL;

942: where hierarchy_id = l_hierarchies_rec.HierarchyId;
943:
944: exception
945: when NO_DATA_FOUND then
946: SELECT zpb_hierarchies_seq.NEXTVAL INTO l_hierarchies_rec.HierarchyId FROM DUAL;
947:
948: insert into zpb_hierarchies
949: (
950: DIMENSION_ID,

Line 948: insert into zpb_hierarchies

944: exception
945: when NO_DATA_FOUND then
946: SELECT zpb_hierarchies_seq.NEXTVAL INTO l_hierarchies_rec.HierarchyId FROM DUAL;
947:
948: insert into zpb_hierarchies
949: (
950: DIMENSION_ID,
951: EPB_ID,
952: HIERARCHY_ID,

Line 989: -- zpb_md_records.hierarchies_tl_entry into zpb_hierarchies_tl and

985: end insertHierarchyRecord;
986:
987: -------------------------------------------------------------------------------
988: -- insertHierarchyTLRecord - Private procedure that inserts a
989: -- zpb_md_records.hierarchies_tl_entry into zpb_hierarchies_tl and
990: -------------------------------------------------------------------------------
991: procedure insertHierarchyTLRecord(p_hierarchies_tl_rec in zpb_md_records.hierarchies_tl_entry)
992: is
993: l_hierarchies_tl_rec zpb_md_records.hierarchies_tl_entry;

Line 1001: from zpb_hierarchies_tl

997:
998: l_hierarchies_tl_rec := p_hierarchies_tl_rec;
999:
1000: select count(*) into l_record_count
1001: from zpb_hierarchies_tl
1002: where hierarchy_id = l_hierarchies_tl_rec.HierarchyId and
1003: language = l_hierarchies_tl_rec.Language;
1004:
1005: --Make sure do not try to insert hierarchy entry for same language twice

Line 1008: insert into zpb_hierarchies_tl

1004:
1005: --Make sure do not try to insert hierarchy entry for same language twice
1006: if l_record_count = 0 then
1007:
1008: insert into zpb_hierarchies_tl
1009: (
1010: HIERARCHY_ID,
1011: LANGUAGE,
1012: LONG_NAME,

Line 1040: update zpb_hierarchies_tl

1036: );
1037:
1038: else
1039:
1040: update zpb_hierarchies_tl
1041: set
1042:
1043: LONG_NAME = l_hierarchies_tl_rec.LongName,
1044: NAME = l_hierarchies_tl_rec.Name,

Line 1511: delete zpb_hierarchies_tl

1507: delete zpb_attributes
1508: where dimension_id = p_dimension_id;
1509:
1510: -- delete hierarchies_tl
1511: delete zpb_hierarchies_tl
1512: where hierarchy_id in (select hierarchy_id
1513: from zpb_hierarchies
1514: where dimension_id = p_dimension_id);
1515:

Line 1513: from zpb_hierarchies

1509:
1510: -- delete hierarchies_tl
1511: delete zpb_hierarchies_tl
1512: where hierarchy_id in (select hierarchy_id
1513: from zpb_hierarchies
1514: where dimension_id = p_dimension_id);
1515:
1516: -- delete hier_level
1517: delete zpb_hier_level

Line 1519: from zpb_hierarchies

1515:
1516: -- delete hier_level
1517: delete zpb_hier_level
1518: where hier_id in (select hierarchy_id
1519: from zpb_hierarchies
1520: where dimension_id = p_dimension_id);
1521:
1522: -- delete hier_level_scope
1523: delete zpb_hier_level_scope

Line 1525: from zpb_hierarchies

1521:
1522: -- delete hier_level_scope
1523: delete zpb_hier_level_scope
1524: where hier_id in (select hierarchy_id
1525: from zpb_hierarchies
1526: where dimension_id = p_dimension_id);
1527:
1528: -- delete hier_scope
1529: delete zpb_hier_scope

Line 1531: from zpb_hierarchies

1527:
1528: -- delete hier_scope
1529: delete zpb_hier_scope
1530: where hierarchy_id in (select hierarchy_id
1531: from zpb_hierarchies
1532: where dimension_id = p_dimension_id);
1533:
1534: -- delete hierarchy zpb_tables and zpb_column entries
1535: delete zpb_tables

Line 1536: where table_id in (select pers_table_id from zpb_hierarchies

1532: where dimension_id = p_dimension_id);
1533:
1534: -- delete hierarchy zpb_tables and zpb_column entries
1535: delete zpb_tables
1536: where table_id in (select pers_table_id from zpb_hierarchies
1537: where dimension_id = p_dimension_id);
1538:
1539: delete zpb_columns
1540: where table_id in (select pers_table_id from zpb_hierarchies

Line 1540: where table_id in (select pers_table_id from zpb_hierarchies

1536: where table_id in (select pers_table_id from zpb_hierarchies
1537: where dimension_id = p_dimension_id);
1538:
1539: delete zpb_columns
1540: where table_id in (select pers_table_id from zpb_hierarchies
1541: where dimension_id = p_dimension_id);
1542:
1543: delete zpb_tables
1544: where table_id in (select shar_table_id from zpb_hierarchies

Line 1544: where table_id in (select shar_table_id from zpb_hierarchies

1540: where table_id in (select pers_table_id from zpb_hierarchies
1541: where dimension_id = p_dimension_id);
1542:
1543: delete zpb_tables
1544: where table_id in (select shar_table_id from zpb_hierarchies
1545: where dimension_id = p_dimension_id);
1546:
1547: delete zpb_columns
1548: where table_id in (select shar_table_id from zpb_hierarchies

Line 1548: where table_id in (select shar_table_id from zpb_hierarchies

1544: where table_id in (select shar_table_id from zpb_hierarchies
1545: where dimension_id = p_dimension_id);
1546:
1547: delete zpb_columns
1548: where table_id in (select shar_table_id from zpb_hierarchies
1549: where dimension_id = p_dimension_id);
1550:
1551: -- Finally delete hierarchies entry
1552: delete zpb_hierarchies

Line 1552: delete zpb_hierarchies

1548: where table_id in (select shar_table_id from zpb_hierarchies
1549: where dimension_id = p_dimension_id);
1550:
1551: -- Finally delete hierarchies entry
1552: delete zpb_hierarchies
1553: where dimension_id = p_dimension_id;
1554:
1555: -- delete levels_tl
1556: delete zpb_levels_tl

Line 1632: delete zpb_hierarchies_tl

1628:
1629: begin
1630:
1631: -- delete hierarchies_tl
1632: delete zpb_hierarchies_tl
1633: where hierarchy_id = p_hierarchy_id;
1634:
1635: -- delete hier_level
1636: delete zpb_hier_level

Line 1648: delete zpb_tables where table_id = (select pers_table_id from zpb_hierarchies where hierarchy_id = p_hierarchy_id);

1644: delete zpb_hier_scope
1645: where hierarchy_id = p_hierarchy_id;
1646:
1647: -- delete zpb_tables for hierarchy
1648: delete zpb_tables where table_id = (select pers_table_id from zpb_hierarchies where hierarchy_id = p_hierarchy_id);
1649: delete zpb_columns where table_id = (select pers_table_id from zpb_hierarchies where hierarchy_id = p_hierarchy_id);
1650:
1651: delete zpb_tables where table_id = (select shar_table_id from zpb_hierarchies where hierarchy_id = p_hierarchy_id);
1652: delete zpb_columns where table_id = (select shar_table_id from zpb_hierarchies where hierarchy_id = p_hierarchy_id);

Line 1649: delete zpb_columns where table_id = (select pers_table_id from zpb_hierarchies where hierarchy_id = p_hierarchy_id);

1645: where hierarchy_id = p_hierarchy_id;
1646:
1647: -- delete zpb_tables for hierarchy
1648: delete zpb_tables where table_id = (select pers_table_id from zpb_hierarchies where hierarchy_id = p_hierarchy_id);
1649: delete zpb_columns where table_id = (select pers_table_id from zpb_hierarchies where hierarchy_id = p_hierarchy_id);
1650:
1651: delete zpb_tables where table_id = (select shar_table_id from zpb_hierarchies where hierarchy_id = p_hierarchy_id);
1652: delete zpb_columns where table_id = (select shar_table_id from zpb_hierarchies where hierarchy_id = p_hierarchy_id);
1653:

Line 1651: delete zpb_tables where table_id = (select shar_table_id from zpb_hierarchies where hierarchy_id = p_hierarchy_id);

1647: -- delete zpb_tables for hierarchy
1648: delete zpb_tables where table_id = (select pers_table_id from zpb_hierarchies where hierarchy_id = p_hierarchy_id);
1649: delete zpb_columns where table_id = (select pers_table_id from zpb_hierarchies where hierarchy_id = p_hierarchy_id);
1650:
1651: delete zpb_tables where table_id = (select shar_table_id from zpb_hierarchies where hierarchy_id = p_hierarchy_id);
1652: delete zpb_columns where table_id = (select shar_table_id from zpb_hierarchies where hierarchy_id = p_hierarchy_id);
1653:
1654: -- Finally delete hierarchies entry
1655: delete zpb_hierarchies

Line 1652: delete zpb_columns where table_id = (select shar_table_id from zpb_hierarchies where hierarchy_id = p_hierarchy_id);

1648: delete zpb_tables where table_id = (select pers_table_id from zpb_hierarchies where hierarchy_id = p_hierarchy_id);
1649: delete zpb_columns where table_id = (select pers_table_id from zpb_hierarchies where hierarchy_id = p_hierarchy_id);
1650:
1651: delete zpb_tables where table_id = (select shar_table_id from zpb_hierarchies where hierarchy_id = p_hierarchy_id);
1652: delete zpb_columns where table_id = (select shar_table_id from zpb_hierarchies where hierarchy_id = p_hierarchy_id);
1653:
1654: -- Finally delete hierarchies entry
1655: delete zpb_hierarchies
1656: where hierarchy_id = p_hierarchy_id;

Line 1655: delete zpb_hierarchies

1651: delete zpb_tables where table_id = (select shar_table_id from zpb_hierarchies where hierarchy_id = p_hierarchy_id);
1652: delete zpb_columns where table_id = (select shar_table_id from zpb_hierarchies where hierarchy_id = p_hierarchy_id);
1653:
1654: -- Finally delete hierarchies entry
1655: delete zpb_hierarchies
1656: where hierarchy_id = p_hierarchy_id;
1657:
1658: end deleteHierarchyRecord;
1659: -------------------------------------------------------------------------------

Line 1688: from zpb_hierarchies

1684: v_attribute c_attributes%ROWTYPE;
1685:
1686: CURSOR c_hierarchies is
1687: select hierarchy_id
1688: from zpb_hierarchies
1689: where last_update_date < p_start_time and
1690: dimension_id in (select dimension_id
1691: from zpb_dimensions
1692: where bus_area_id = bus_area_id_num);

Line 1735: from zpb_hierarchies hier,

1731:
1732: delete zpb_hier_level
1733: where last_update_date < p_start_time
1734: and hier_id in (select hier.hierarchy_id
1735: from zpb_hierarchies hier,
1736: zpb_dimensions dim
1737: where hier.dimension_id = dim.dimension_id and
1738: dim.bus_area_id = bus_area_id_num);
1739:

Line 2156: from zpb_hierarchies

2152: begin
2153: select table_id into m_hr_shar_table_en.tableId
2154: from zpb_tables
2155: where table_id = (select shar_table_id
2156: from zpb_hierarchies
2157: where dimension_id = m_dimension_en.DimensionId and
2158: pers_cwm_name = m_hier_en.PersCWMName);
2159: m_shar_table_exists := false;
2160:

Line 2182: from zpb_hierarchies

2178: else
2179: select table_id into m_hr_pers_table_en.tableId
2180: from zpb_tables
2181: where table_id = (select pers_table_id
2182: from zpb_hierarchies
2183: where dimension_id = m_dimension_en.DimensionId and
2184: pers_cwm_name = m_hier_en.PersCWMName);
2185: end if;
2186:

Line 2202: -- zpb_hierarchies as we do not want to store personal-personal table id there

2198: m_hier_en.SharTableId := m_hr_shar_table_en.tableId;
2199: m_hier_en.PersTableId := m_hr_pers_table_en.tableId;
2200:
2201: -- If we are building MD for a personal-personal hierarchy, do not update
2202: -- zpb_hierarchies as we do not want to store personal-personal table id there
2203: if p_type='PERSONAL' then
2204: select hierarchy_id into m_hierarchy_id
2205: from zpb_hierarchies
2206: where dimension_id = m_dimension_en.DimensionId and

Line 2205: from zpb_hierarchies

2201: -- If we are building MD for a personal-personal hierarchy, do not update
2202: -- zpb_hierarchies as we do not want to store personal-personal table id there
2203: if p_type='PERSONAL' then
2204: select hierarchy_id into m_hierarchy_id
2205: from zpb_hierarchies
2206: where dimension_id = m_dimension_en.DimensionId and
2207: pers_cwm_name = m_hier_en.PersCWMName;
2208: else
2209: m_hierarchy_id := insertHierarchyRecord(m_hier_en);

Line 3351: from zpb_hierarchies

3347: -- find MD for this hierarchy
3348: begin
3349:
3350: select hierarchy_id into m_cube_hier_en.hierarchyId
3351: from zpb_hierarchies
3352: where epb_id = l_hier and
3353: dimension_id = m_cube_dims_en.dimensionId;
3354:
3355: exception

Line 3387: from zpb_hierarchies

3383:
3384: begin
3385:
3386: select hierarchy_id into m_cube_hier_en.hierarchyId
3387: from zpb_hierarchies
3388: where dimension_id = m_cube_dims_en.dimensionId and
3389: hier_type = 'NULL';
3390:
3391: exception

Line 4883: from zpb_hierarchies

4879: m_cube_hier_en.ColumnId :=insertColumnRecord(m_column_en);
4880:
4881: -- set hierarchy id for cube-hier relation entry
4882: select hierarchy_id into m_cube_hier_en.hierarchyId
4883: from zpb_hierarchies
4884: where epb_id = l_hier and
4885: dimension_id = m_cube_dims_en.dimensionId;
4886:
4887: m_relation_id := insertCubeHierRecord(m_cube_hier_en);

Line 4902: from zpb_hierarchies

4898: -- insert Column and Reference column_id in cube-hier relation
4899: m_cube_hier_en.ColumnId :=insertColumnRecord(m_column_en);
4900:
4901: select hierarchy_id into m_cube_hier_en.hierarchyId
4902: from zpb_hierarchies
4903: where dimension_id = m_cube_dims_en.dimensionId and
4904: hier_type = 'NULL';
4905:
4906: m_relation_id := insertCubeHierRecord(m_cube_hier_en);

Line 5070: from zpb_hierarchies

5066: m_cube_hier_en.ColumnId :=insertColumnRecord(m_column_en);
5067:
5068: -- set hierarchy id for cube-hier relation entry
5069: select hierarchy_id into m_cube_hier_en.hierarchyId
5070: from zpb_hierarchies
5071: where epb_id = l_hier and
5072: dimension_id = m_cube_dims_en.dimensionId;
5073:
5074: m_relation_id := insertCubeHierRecord(m_cube_hier_en);

Line 5088: from zpb_hierarchies

5084: -- insert Column and Reference column_id in cube-hier relation
5085: m_cube_hier_en.ColumnId :=insertColumnRecord(m_column_en);
5086:
5087: select hierarchy_id into m_cube_hier_en.hierarchyId
5088: from zpb_hierarchies
5089: where dimension_id = m_cube_dims_en.dimensionId and
5090: hier_type = 'NULL';
5091:
5092: m_relation_id := insertCubeHierRecord(m_cube_hier_en);

Line 5317: from zpb_hierarchies hier,

5313: -- clean user scope tables
5314: delete zpb_hier_scope
5315: where user_id = to_number(p_user) and
5316: hierarchy_id in (select hierarchy_id
5317: from zpb_hierarchies hier,
5318: zpb_dimensions dims
5319: where hier.dimension_id = dims.dimension_id and
5320: dims.bus_area_id = bus_area_id_num);
5321:

Line 5325: from zpb_hierarchies hier,

5321:
5322: delete zpb_hier_level_scope
5323: where user_id = to_number(p_user) and
5324: hier_id in (select hierarchy_id
5325: from zpb_hierarchies hier,
5326: zpb_dimensions dims
5327: where hier.dimension_id = dims.dimension_id and
5328: dims.bus_area_id = bus_area_id_num);
5329:

Line 5439: from zpb_hierarchies hier,

5435:
5436: -- cursor for scoping null hierarchies of range dimensions
5437: cursor c_range_dim_null_hiers is
5438: select hier.hierarchy_id, hier.pers_table_id
5439: from zpb_hierarchies hier,
5440: zpb_dimensions dims,
5441: zpb_attributes attr
5442: where dims.bus_area_id = bus_area_id_num and
5443: dims.dimension_id = attr.range_dim_id and

Line 5452: zpb_hierarchies hier

5448: select hl.hier_id, hl.level_id, hl.pers_col_id
5449: from zpb_hier_level hl,
5450: zpb_dimensions dims,
5451: zpb_attributes attr,
5452: zpb_hierarchies hier
5453: where dims.bus_area_id = bus_area_id_num and
5454: dims.dimension_id = attr.range_dim_id and
5455: dims.dimension_id = hier.dimension_id and
5456: hl.hier_id = hier.hierarchy_id;

Line 5509: from zpb_hierarchies hier

5505: -- hierarchy tables. In the case that the user still has personal levels
5506: -- they will be set appropriately back to the personal personal hierarchy tables below.
5507: update zpb_hier_scope hscope
5508: set hscope.pers_table_id = (select pers_table_id
5509: from zpb_hierarchies hier
5510: where hscope.hierarchy_id = hier.hierarchy_id)
5511: where hscope.user_id = l_user_id and
5512: hscope.user_id = nvl(to_number(sys_context('ZPB_CONTEXT', 'resp_id')), FND_GLOBAL.RESP_ID) and
5513: hscope.hierarchy_id in (select hierarchy_id

Line 5514: from zpb_hierarchies hier,

5510: where hscope.hierarchy_id = hier.hierarchy_id)
5511: where hscope.user_id = l_user_id and
5512: hscope.user_id = nvl(to_number(sys_context('ZPB_CONTEXT', 'resp_id')), FND_GLOBAL.RESP_ID) and
5513: hscope.hierarchy_id in (select hierarchy_id
5514: from zpb_hierarchies hier,
5515: zpb_dimensions dims
5516: where hier.dimension_id = dims.dimension_id and
5517: dims.bus_area_id = bus_area_id_num and
5518: dims.dimension_id = l_dimension_id);

Line 5525: from zpb_hierarchies

5521: l_dim_ecm := zpb_ecm.get_dimension_ecm (l_dim, p_aw);
5522:
5523: -- see if we need to later create a scope entry for null hierarchy of this dimension
5524: select count(hierarchy_id) into l_nullHierCnt
5525: from zpb_hierarchies
5526: where dimension_id=l_dimension_id and hier_type='NULL';
5527:
5528: zpb_aw.execute('push '||l_aw||l_dim_data.ExpObj);
5529:

Line 5566: from zpb_hierarchies

5562: l_hier_perscwm := zpb_metadata_names.get_hierarchy_cwm2_name('PRS', l_dim, l_hier);
5563:
5564: select hierarchy_id, pers_table_id
5565: into l_hier_scope_en.HierarchyId, l_hier_scope_en.PersTableId
5566: from zpb_hierarchies
5567: where dimension_id = l_dimension_id and
5568: pers_cwm_name = l_hier_perscwm;
5569:
5570: l_dummy_num := insertHierScopeRecord(l_hier_scope_en);

Line 5696: from zpb_hierarchies

5692: ') text 0 no no)') <> 0) then
5693:
5694: select hierarchy_id, pers_table_id
5695: into l_hier_scope_en.HierarchyId, l_hier_scope_en.PersTableId
5696: from zpb_hierarchies
5697: where dimension_id = l_dimension_id and
5698: hier_type='NULL';
5699:
5700: l_hier_scope_en.UserId := l_user_id;

Line 5807: from zpb_hierarchies hier,

5803: where user_id = l_user_id and
5804: resp_id = nvl(to_number(sys_context('ZPB_CONTEXT', 'resp_id')), FND_GLOBAL.RESP_ID) and
5805: last_update_date < l_start_time and
5806: hierarchy_id in (select hierarchy_id
5807: from zpb_hierarchies hier,
5808: zpb_dimensions dims
5809: where hier.dimension_id = dims.dimension_id and
5810: dims.bus_area_id = bus_area_id_num and
5811: dims.dimension_id = l_dimension_id);

Line 5818: from zpb_hierarchies hier,

5814: where user_id = l_user_id and
5815: resp_id = nvl(to_number(sys_context('ZPB_CONTEXT', 'resp_id')), FND_GLOBAL.RESP_ID) and
5816: last_update_date < l_start_time and
5817: hier_id in (select hierarchy_id
5818: from zpb_hierarchies hier,
5819: zpb_dimensions dims
5820: where hier.dimension_id = dims.dimension_id and
5821: dims.bus_area_id = bus_area_id_num and
5822: dims.dimension_id = l_dimension_id);

Line 5907: delete zpb_hierarchies_tl

5903: delete zpb_attributes
5904: where dimension_id = v_dim.dimension_id;
5905:
5906: -- delete hierarchies_tl
5907: delete zpb_hierarchies_tl
5908: where hierarchy_id in (select hierarchy_id
5909: from zpb_hierarchies
5910: where dimension_id = v_dim.dimension_id);
5911:

Line 5909: from zpb_hierarchies

5905:
5906: -- delete hierarchies_tl
5907: delete zpb_hierarchies_tl
5908: where hierarchy_id in (select hierarchy_id
5909: from zpb_hierarchies
5910: where dimension_id = v_dim.dimension_id);
5911:
5912: -- delete hier_level
5913: delete zpb_hier_level

Line 5915: from zpb_hierarchies

5911:
5912: -- delete hier_level
5913: delete zpb_hier_level
5914: where hier_id in (select hierarchy_id
5915: from zpb_hierarchies
5916: where dimension_id = v_dim.dimension_id);
5917:
5918: -- delete hier_level_scope
5919: delete zpb_hier_level_scope

Line 5921: from zpb_hierarchies

5917:
5918: -- delete hier_level_scope
5919: delete zpb_hier_level_scope
5920: where hier_id in (select hierarchy_id
5921: from zpb_hierarchies
5922: where dimension_id = v_dim.dimension_id);
5923:
5924: -- delete hier_scope
5925: delete zpb_hier_scope

Line 5927: from zpb_hierarchies

5923:
5924: -- delete hier_scope
5925: delete zpb_hier_scope
5926: where hierarchy_id in (select hierarchy_id
5927: from zpb_hierarchies
5928: where dimension_id = v_dim.dimension_id);
5929:
5930: -- Finally delete hierarchies entry
5931: delete zpb_hierarchies

Line 5931: delete zpb_hierarchies

5927: from zpb_hierarchies
5928: where dimension_id = v_dim.dimension_id);
5929:
5930: -- Finally delete hierarchies entry
5931: delete zpb_hierarchies
5932: where dimension_id = v_dim.dimension_id;
5933:
5934: -- delete levels_tl
5935: delete zpb_levels_tl