APPS.MSD_COLLECT_LEVEL_VALUES dependencies on MSD_HIERARCHY_LEVELS

Line 243: from msd_hierarchy_levels

239: nvl(level_value_desc_column,level_value_column) level_value_desc_column,
240: parent_value_column,
241: parent_value_pk_column,
242: nvl(parent_value_desc_column, parent_value_column) parent_value_desc_column
243: from msd_hierarchy_levels
244: where level_id = p_level_id
245: and parent_level_id = p_parent_level_id
246: and plan_type is null --vinekuma
247: and relationship_view is not null;

Line 252: from msd_hierarchy_levels

248:
249: Cursor Null_relationship_view (p_level_id in number, p_parent_level_id in number) is
250: select distinct
251: hierarchy_id
252: from msd_hierarchy_levels
253: where level_id = p_level_id
254: and parent_level_id = p_parent_level_id
255: and relationship_view is null;
256:

Line 445: from msd_hierarchy_levels_v

441: Cursor to get distinct Level, Parent Combinations
442: ******************************************************/
443: Cursor Level_Parent(p_level_id IN NUMBER) is
444: select distinct level_id, parent_level_id, level_type_code
445: from msd_hierarchy_levels_v
446: where level_id = p_level_id
447: order by level_type_code, level_id;
448: Begin
449:

Line 523: from msd_hierarchy_levels_v

519: a hierarchy
520: ******************************************************/
521: Cursor Hierarchy_Levels(p_hierarchy_id IN NUMBER) is
522: select level_id, parent_level_id, level_type_code
523: from msd_hierarchy_levels_v
524: where hierarchy_id = p_hierarchy_id
525: order by level_type_code, level_id;
526:
527: /* Cursor to get distinct levels in the hierarchy */

Line 530: from msd_hierarchy_levels_v

526:
527: /* Cursor to get distinct levels in the hierarchy */
528: Cursor Level_Cursor(p_hierarchy_id IN NUMBER) is
529: select distinct level_id, level_type_code
530: from msd_hierarchy_levels_v
531: where hierarchy_id = p_hierarchy_id
532: order by level_type_code, level_id;
533:
534: Cursor hierarcy_dimension(p_hierarchy_id IN NUMBER) is

Line 536: from msd_hierarchy_levels_v

532: order by level_type_code, level_id;
533:
534: Cursor hierarcy_dimension(p_hierarchy_id IN NUMBER) is
535: select distinct OWNING_DIMENSION_CODE
536: from msd_hierarchy_levels_v
537: where hierarchy_id = p_hierarchy_id;
538:
539: l_dim_code varchar(5) := null;
540: g_retcode varchar2(5) := '0';

Line 624: from msd_hierarchy_levels_v

620: in a dimension
621: ******************************************************/
622: Cursor Dim_Level_Parent(p_dimension_code IN VARCHAR2) is
623: select distinct level_id, parent_level_id, level_type_code
624: from msd_hierarchy_levels_v
625: where owning_dimension_code = p_dimension_code
626: order by level_type_code, level_id;
627:
628: /* Cursor to get levels alone */

Line 631: from msd_hierarchy_levels_v

627:
628: /* Cursor to get levels alone */
629: Cursor Level_Cursor(p_dimension_code IN VARCHAR2) is
630: select distinct level_id, level_type_code
631: from msd_hierarchy_levels_v
632: where owning_dimension_code = p_dimension_code
633: order by level_type_code, level_id;
634:
635: Cursor Pop_Item_List_Price(p_dimension_code IN VARCHAR2, p_level_id in number) is

Line 641: FROM msd_hierarchy_levels_v

637: SELECT COUNT(*)
638: FROM
639: (SELECT DISTINCT level_id,
640: parent_level_id
641: FROM msd_hierarchy_levels_v
642: WHERE owning_dimension_code = p_dimension_code
643: AND level_id = p_level_id);
644:
645: pop_lev number := -1;

Line 878: from msd_hierarchy_levels

874: p_hierarchy_id in number) IS
875:
876: Cursor Parent_Levels(p_lvl_id IN NUMBER) is
877: select distinct parent_level_id
878: from msd_hierarchy_levels
879: where level_id = p_lvl_id
880: and hierarchy_id = nvl(p_hierarchy_id, hierarchy_id);
881:
882: v_sql_stmt varchar2(4000);