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.MSD_EOL_PLAN dependencies on MSD_DP_PARAMETERS

Line 173: from msd_dp_parameters

169: as
170:
171: cursor c1 is
172: select count(*)
173: from msd_dp_parameters
174: where demand_plan_id=p_demand_plan_id
175: and stream_type='ARCHIVED';
176:
177: cursor c2 is

Line 186: from msd_dp_parameters

182: and document_id=(select document_id from msd_dp_seeded_documents where document_name='MSD_SD_EOL_LWF' and demand_plan_id=p_demand_plan_id);
183:
184: cursor c3 is
185: select parameter_id,input_demand_plan_id, input_scenario_id
186: from msd_dp_parameters
187: where demand_plan_id=p_demand_plan_id
188: and stream_type='ARCHIVED';
189:
190: cursor c4(p_demand_plan_id number, p_scenario_id number) is

Line 198: from msd_dp_parameters

194: and scenario_id=p_scenario_id;
195:
196: cursor c5(p_parameter_type varchar2,p_parameter_name varchar2) is
197: select parameter_id
198: from msd_dp_parameters
199: where demand_plan_id=p_demand_plan_id
200: and parameter_type = p_parameter_type
201: and nvl(parameter_name,'@#$') = nvl(p_parameter_name,'@#$');
202:

Line 232: INSERT INTO msd_dp_parameters

228: close c1;
229:
230: if l_archived_count <1 then
231:
232: INSERT INTO msd_dp_parameters
233: (DEMAND_PLAN_ID,
234: PARAMETER_ID,
235: PARAMETER_TYPE,
236: PARAMETER_NAME,

Line 269: ,msd_dp_parameters_s.nextval

265: PRICE_LIST_NAME,
266: STREAM_TYPE)
267: SELECT
268: p_demand_plan_id
269: ,msd_dp_parameters_s.nextval
270: ,par.PARAMETER_TYPE
271: ,mds.supply_plan_name
272: ,msd_common_utilities.get_bucket_start_date(sysdate,-23,6,'GREGORIAN')
273: ,msd_common_utilities.get_bucket_start_date(sysdate,24,6,'GREGORIAN')

Line 303: msd_dp_parameters par,

299: ,par.SUPPLY_PLAN_FLAG
300: ,par.PRICE_LIST_NAME
301: ,par.STREAM_TYPE
302: FROM
303: msd_dp_parameters par,
304: msd_dp_parameters par1,
305: msd_dp_scenarios mds,
306: msd_dp_scenario_revisions mdsr
307: WHERE

Line 304: msd_dp_parameters par1,

300: ,par.PRICE_LIST_NAME
301: ,par.STREAM_TYPE
302: FROM
303: msd_dp_parameters par,
304: msd_dp_parameters par1,
305: msd_dp_scenarios mds,
306: msd_dp_scenario_revisions mdsr
307: WHERE
308: par.DEMAND_PLAN_ID = (select template_id from msd_demand_plans where demand_plan_id=p_demand_plan_id)

Line 320: INSERT INTO msd_dp_parameters

316: and mds.scenario_id=mdsr.scenario_id(+)
317: and nvl(mdsr.revision,-1)=(select nvl(max(revision),-1) from msd_dp_scenario_revisions where demand_plan_id=p_demand_plan_id
318: and scenario_id=mdsr.scenario_id);
319:
320: INSERT INTO msd_dp_parameters
321: (DEMAND_PLAN_ID,
322: PARAMETER_ID,
323: PARAMETER_TYPE,
324: PARAMETER_NAME,

Line 357: ,msd_dp_parameters_s.nextval

353: PRICE_LIST_NAME,
354: STREAM_TYPE)
355: SELECT
356: p_demand_plan_id
357: ,msd_dp_parameters_s.nextval
358: ,par.PARAMETER_TYPE
359: ,mds.supply_plan_name
360: ,msd_common_utilities.get_bucket_start_date(sysdate,-23,6,'GREGORIAN')
361: ,msd_common_utilities.get_bucket_start_date(sysdate,24,6,'GREGORIAN')

Line 391: msd_dp_parameters par,

387: ,par.SUPPLY_PLAN_FLAG
388: ,par.PRICE_LIST_NAME
389: ,par.STREAM_TYPE
390: FROM
391: msd_dp_parameters par,
392: msd_dp_parameters par1,
393: msd_dp_scenario_revisions mdsr,
394: msd_dp_scenarios mds
395: WHERE

Line 392: msd_dp_parameters par1,

388: ,par.PRICE_LIST_NAME
389: ,par.STREAM_TYPE
390: FROM
391: msd_dp_parameters par,
392: msd_dp_parameters par1,
393: msd_dp_scenario_revisions mdsr,
394: msd_dp_scenarios mds
395: WHERE
396: par.DEMAND_PLAN_ID = (select template_id from msd_demand_plans where demand_plan_id=p_demand_plan_id)

Line 406: from msd_dp_parameters mdp

402: and par1.parameter_id=to_number(mds.associate_parameter)
403: and mds.sc_type= 'ARCHIVED'
404: and mds.scenario_id=mdsr.scenario_id(+)
405: and nvl(mdsr.revision,0)>(select nvl(max(revision),-1)
406: from msd_dp_parameters mdp
407: where mdp.demand_plan_id=p_demand_plan_id
408: and mdp.parameter_type=par.parameter_type);
409:
410: select mp.compile_designator into l_supply_plan_name

Line 425: update msd_dp_parameters

421: open c4(c3_rec.input_demand_plan_id,c3_rec.input_scenario_id);
422: fetch c4 into l_revision;
423: close c4;
424:
425: update msd_dp_parameters
426: set revision = nvl(l_revision,-1)
427: where demand_plan_id=p_demand_plan_id
428: and parameter_id=c3_rec.parameter_id;
429:

Line 434: INSERT INTO msd_dp_parameters

430: end loop;
431:
432:
433:
434: INSERT INTO msd_dp_parameters
435: (DEMAND_PLAN_ID,
436: PARAMETER_ID,
437: PARAMETER_TYPE,
438: PARAMETER_NAME,

Line 471: ,msd_dp_parameters_s.nextval

467: PRICE_LIST_NAME,
468: STREAM_TYPE)
469: SELECT
470: p_demand_plan_id
471: ,msd_dp_parameters_s.nextval
472: ,par.PARAMETER_TYPE
473: ,mds.supply_plan_name
474: ,msd_common_utilities.get_bucket_start_date(sysdate,-23,6,'GREGORIAN')
475: ,msd_common_utilities.get_bucket_start_date(sysdate,24,6,'GREGORIAN')

Line 505: msd_dp_parameters par,

501: ,par.SUPPLY_PLAN_FLAG
502: ,par.PRICE_LIST_NAME
503: ,par.STREAM_TYPE
504: FROM
505: msd_dp_parameters par,
506: msd_dp_parameters par1,
507: (select mds1.demand_plan_id,mds1.scenario_id,nvl(max(mdsr1.revision),-1) revision
508: from msd_dp_scenario_revisions mdsr1, msd_dp_scenarios mds1
509: where mdsr1.scenario_id(+)=mds1.scenario_id

Line 506: msd_dp_parameters par1,

502: ,par.PRICE_LIST_NAME
503: ,par.STREAM_TYPE
504: FROM
505: msd_dp_parameters par,
506: msd_dp_parameters par1,
507: (select mds1.demand_plan_id,mds1.scenario_id,nvl(max(mdsr1.revision),-1) revision
508: from msd_dp_scenario_revisions mdsr1, msd_dp_scenarios mds1
509: where mdsr1.scenario_id(+)=mds1.scenario_id
510: and mdsr1.demand_plan_id(+)=mds1.demand_plan_id

Line 513: (select demand_plan_id,parameter_type,nvl(max(revision),-1) revision from msd_dp_parameters group by

509: where mdsr1.scenario_id(+)=mds1.scenario_id
510: and mdsr1.demand_plan_id(+)=mds1.demand_plan_id
511: group by mds1.demand_plan_id,mds1.scenario_id) mdsr,
512: msd_dp_scenarios mds,
513: (select demand_plan_id,parameter_type,nvl(max(revision),-1) revision from msd_dp_parameters group by
514: demand_plan_id,parameter_type) mdp2
515: WHERE
516: par.DEMAND_PLAN_ID = (select template_id from msd_demand_plans where demand_plan_id=p_demand_plan_id)
517: and par.stream_type in ('ARCHIVED_TIM')