APPS.MSD_COLLECT_LEVEL_VALUES dependencies on MSD_HIERARCHY_LEVELS_V

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;