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.MSC_MATL_PLAN_PKG dependencies on MSC_HP_ROW_DTLS

Line 50: delete from msc_hp_row_dtls where query_id = p_query_id;

46: msc_phub_util.log('l_org_filter_cnt='||l_org_filter_cnt||', '||
47: 'l_cat_filter_cnt='||l_cat_filter_cnt||', '||
48: 'l_item_filter_cnt='||l_item_filter_cnt);
49:
50: delete from msc_hp_row_dtls where query_id = p_query_id;
51: msc_phub_util.log('delete from msc_hp_row_dtls: '||sql%rowcount);
52: commit;
53:
54: insert into msc_hp_row_dtls(

Line 51: msc_phub_util.log('delete from msc_hp_row_dtls: '||sql%rowcount);

47: 'l_cat_filter_cnt='||l_cat_filter_cnt||', '||
48: 'l_item_filter_cnt='||l_item_filter_cnt);
49:
50: delete from msc_hp_row_dtls where query_id = p_query_id;
51: msc_phub_util.log('delete from msc_hp_row_dtls: '||sql%rowcount);
52: commit;
53:
54: insert into msc_hp_row_dtls(
55: query_id,

Line 54: insert into msc_hp_row_dtls(

50: delete from msc_hp_row_dtls where query_id = p_query_id;
51: msc_phub_util.log('delete from msc_hp_row_dtls: '||sql%rowcount);
52: commit;
53:
54: insert into msc_hp_row_dtls(
55: query_id,
56: row_index,
57: plan_id,
58: sr_instance_id,

Line 101: msc_phub_util.log('insert into msc_hp_row_dtls: '||sql%rowcount);

97: and ic.category_set_id(+) = p_category_set_id
98: and (l_org_filter_cnt = 0 or o.organization_code in (select char1 from msc_form_query where query_id = p_query_id and number1 = msc_hp_util.ft_organization))
99: and (l_cat_filter_cnt = 0 or ic.category_name in (select char1 from msc_form_query where query_id = p_query_id and number1 = msc_hp_util.ft_category))
100: and (l_item_filter_cnt = 0 or i.inventory_item_id in (select number2 from msc_form_query where query_id = p_query_id and number1 = msc_hp_util.ft_item));
101: msc_phub_util.log('insert into msc_hp_row_dtls: '||sql%rowcount);
102: commit;
103:
104: insert into msc_hp_row_dtls(
105: query_id,

Line 104: insert into msc_hp_row_dtls(

100: and (l_item_filter_cnt = 0 or i.inventory_item_id in (select number2 from msc_form_query where query_id = p_query_id and number1 = msc_hp_util.ft_item));
101: msc_phub_util.log('insert into msc_hp_row_dtls: '||sql%rowcount);
102: commit;
103:
104: insert into msc_hp_row_dtls(
105: query_id,
106: row_index,
107: plan_id,
108: data_flag,

Line 114: msc_phub_util.log('insert into msc_hp_row_dtls: '||sql%rowcount);

110: last_update_date, last_updated_by, last_update_login)
111: values (p_query_id, -1, p_plan_id, 1,
112: fnd_global.user_id, sysdate,
113: sysdate, fnd_global.user_id, fnd_global.login_id);
114: msc_phub_util.log('insert into msc_hp_row_dtls: '||sql%rowcount);
115: commit;
116:
117: g_page_size := p_page_size;
118: g_fetch_size := ceil(g_max_fetch_size/g_page_size) * g_page_size;

Line 137: from msc_hp_row_dtls h, msc_hp_col_dtls b

133:
134: begin
135: select h.plan_id, b.bkt_start_date
136: into l_plan_id, l_past_date
137: from msc_hp_row_dtls h, msc_hp_col_dtls b
138: where h.query_id = p_query_id
139: and h.data_flag = decode(p_summary, 1, h.data_flag, 3)
140: and h.plan_id = b.plan_id
141: and b.bucket_type = 0

Line 147: from msc_hp_row_dtls h, msc_hp_col_dtls b

143: msc_phub_util.log('l_plan_id='||l_plan_id||', l_past_date='||l_past_date);
144:
145: select min(b.bkt_start_date), max(b.bkt_end_date)
146: into l_pre_start_date, l_plan_cutoff_date
147: from msc_hp_row_dtls h, msc_hp_col_dtls b
148: where h.query_id = p_query_id
149: and h.plan_id = b.plan_id;
150: msc_phub_util.log('l_pre_start_date='||l_pre_start_date||
151: ', l_plan_cutoff_date='||l_plan_cutoff_date);

Line 161: from msc_hp_row_dtls h

157: where (query_id, row_index) in
158: (select
159: h.query_id,
160: decode(p_summary, 1, -1, h.row_index) row_index
161: from msc_hp_row_dtls h
162: where h.query_id = p_query_id
163: and h.data_flag = decode(p_summary, 1, h.data_flag, 3));
164: msc_phub_util.log('delete from msc_matl_plan_data: '||sql%rowcount);
165: commit;

Line 237: msc_hp_row_dtls h

233: to_number(null) safety_stock
234: from
235: msc_supplies ms,
236: msc_hp_col_dtls b,
237: msc_hp_row_dtls h
238: where h.query_id = p_query_id
239: and ms.plan_id = h.plan_id
240: and ms.sr_instance_id = h.sr_instance_id
241: and ms.organization_id = h.organization_id

Line 302: msc_hp_row_dtls h

298: to_number(null) safety_stock
299: from
300: msc_supplies ms,
301: msc_hp_col_dtls b,
302: msc_hp_row_dtls h
303: where h.query_id = p_query_id
304: and ms.plan_id = h.plan_id
305: and ms.sr_instance_id = h.sr_instance_id
306: and ms.organization_id = h.organization_id

Line 369: msc_hp_row_dtls h

365: to_number(null) safety_stock
366: from
367: msc_demands md,
368: msc_hp_col_dtls b,
369: msc_hp_row_dtls h
370: where h.query_id = p_query_id
371: and md.plan_id = h.plan_id
372: and md.sr_instance_id = h.sr_instance_id
373: and md.organization_id = h.organization_id

Line 416: msc_hp_row_dtls h

412: ss.period_start_date,
413: sum(ss.safety_stock_quantity) safety_stock_quantity
414: from
415: msc_safety_stocks ss,
416: msc_hp_row_dtls h
417: where h.query_id = p_query_id
418: and ss.plan_id = h.plan_id
419: and ss.sr_instance_id = h.sr_instance_id
420: and ss.organization_id = h.organization_id

Line 444: update msc_hp_row_dtls

440: analysis_date;
441: msc_phub_util.log('insert into msc_matl_plan_data: '||sql%rowcount);
442: commit;
443:
444: update msc_hp_row_dtls
445: set data_flag = 2
446: where query_id = p_query_id and data_flag = 3;
447: msc_phub_util.log('update msc_hp_row_dtls: '||sql%rowcount);
448: commit;

Line 447: msc_phub_util.log('update msc_hp_row_dtls: '||sql%rowcount);

443:
444: update msc_hp_row_dtls
445: set data_flag = 2
446: where query_id = p_query_id and data_flag = 3;
447: msc_phub_util.log('update msc_hp_row_dtls: '||sql%rowcount);
448: commit;
449:
450: end populate_data;
451:

Line 457: update msc_hp_row_dtls

453: is
454: begin
455: msc_phub_util.log('msc_matl_plan_pkg.summarize_data('||p_query_id||')');
456:
457: update msc_hp_row_dtls
458: set data_flag = 3
459: where query_id = p_query_id
460: and row_index = -1
461: and data_flag = 1;

Line 499: from msc_hp_row_dtls

495: begin
496: msc_phub_util.log('msc_matl_plan_pkg.fetch_data('||p_query_id||', '||p_row_index||')');
497:
498: select count(*) into l_n
499: from msc_hp_row_dtls
500: where query_id = p_query_id
501: and row_index between p_row_index and p_row_index+g_page_size-1
502: and data_flag = 1;
503: if (l_n = 0) then

Line 507: update msc_hp_row_dtls

503: if (l_n = 0) then
504: return;
505: end if;
506:
507: update msc_hp_row_dtls
508: set data_flag = 3
509: where query_id = p_query_id
510: and row_index between p_row_index and p_row_index+g_page_size-1
511: and data_flag = 1;

Line 538: msc_hp_row_dtls h,

534: u.column_name,
535: u.new_value
536: from
537: msc_hp_updates u,
538: msc_hp_row_dtls h,
539: msc_hp_col_dtls b
540: where h.query_id = p_query_id
541: and h.query_id = u.query_id
542: and h.row_index = u.row_index

Line 799: update msc_hp_row_dtls

795: commit;
796: end if;
797: end loop;
798:
799: update msc_hp_row_dtls
800: set data_flag = 3
801: where query_id = p_query_id
802: and row_index in (select row_index from msc_hp_updates where query_id = p_query_id);
803: commit;

Line 823: delete from msc_hp_row_dtls where query_id = p_query_id;

819: is
820: begin
821: msc_phub_util.log('msc_matl_plan_pkg.close_data('||p_query_id||')');
822:
823: delete from msc_hp_row_dtls where query_id = p_query_id;
824: msc_phub_util.log('delete from msc_hp_row_dtls: '||sql%rowcount);
825: commit;
826:
827: delete from msc_matl_plan_data where query_id = p_query_id;

Line 824: msc_phub_util.log('delete from msc_hp_row_dtls: '||sql%rowcount);

820: begin
821: msc_phub_util.log('msc_matl_plan_pkg.close_data('||p_query_id||')');
822:
823: delete from msc_hp_row_dtls where query_id = p_query_id;
824: msc_phub_util.log('delete from msc_hp_row_dtls: '||sql%rowcount);
825: commit;
826:
827: delete from msc_matl_plan_data where query_id = p_query_id;
828: msc_phub_util.log('delete from msc_matl_plan_data: '||sql%rowcount);