APPS.MSD_FCST_PUB dependencies on MSD_LEVEL_VALUES

Line 63: v_org_id msd_level_values.sr_level_pk%TYPE;

59: loc_pk number;
60: v_level_id number;
61: v_quant varchar2(20);
62: v_item_id number;
63: v_org_id msd_level_values.sr_level_pk%TYPE;
64: org_id VARCHAR2(240);
65: org_pk number;
66: v_fcst_date date;
67: v_quantity number;

Line 98: from msd_level_values

94: WHERE demand_plan_id = p_demand_plan_id;
95:
96: CURSOR c_sr_lvl_pk(p_lvl_pk number) IS
97: select sr_level_pk
98: from msd_level_values
99: where level_pk = p_lvl_pk;
100:
101: l_sr_dcs_lvl_pk varchar2(30) := NULL;
102: l_sr_org_lvl_pk varchar2(30) := NULL;

Line 137: from msd_level_values

133: v_customer_id := NULL;
134: else
135: select sr_level_pk
136: into v_customer_id
137: from msd_level_values
138: where level_pk = p_customer_id;
139: end if;
140:
141: if p_location_id is null then

Line 146: from msd_level_values

142: v_location_id := NULL;
143: else
144: select sr_level_pk
145: into v_location_id
146: from msd_level_values
147: where level_pk = p_location_id;
148: end if;
149:
150:

Line 158: from msd_level_values lv,

154:
155: /* For SR ORG Level PKs that exist in the scenario entries */
156: /* Begin of 1 */
157: for v_org_id in (select lv.sr_level_pk
158: from msd_level_values lv,
159: (select organization_lvl_pk opk
160: from msd_dp_scenario_entries
161: where demand_plan_id = p_demand_plan_id
162: and scenario_id = p_scenario_id

Line 393: from msd_level_values

389: l_group_by := 'GROUP BY ';
390:
391: select level_pk
392: into org_pk
393: from msd_level_values
394: where instance = p_instance_id
395: and sr_level_pk = org_id
396: and level_id = 7; -- level_id=7 - organization level
397:

Line 457: 'SELECT level_pk from msd_level_values_v where parent_level_pk = ' || to_char(cus_pk) || ') ';

453: -- state 3 means that scenario_entries is on the location level while
454: -- f_desg/org_id is on the customer level
455: -- so we need to include all "child" locations on the f_desg/org_id's customer
456: l_where := l_where || ' AND sce.geography_lvl_pk IN ('||
457: 'SELECT level_pk from msd_level_values_v where parent_level_pk = ' || to_char(cus_pk) || ') ';
458: end if;
459: -- state 4 means that forecast_designator/org_id is aggregate across all customers
460: -- and therefore nothing should be added
461:

Line 506: open lpks for 'select level_pk from msd_level_values_v ' ||

502: from msd_hierarchy_levels
503: where parent_level_id = lvl2
504: and hierarchy_id = hier;
505:
506: open lpks for 'select level_pk from msd_level_values_v ' ||
507: ' where level_id = ' || to_char(lvl2) || ' ' ||
508: ' and parent_level_pk in ' || qstr;
509:
510: qstr := NULL;