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_FORM_QUERY

Line 23: delete from msc_form_query where query_id = p_query_id;

19: begin
20: msc_phub_util.log('msc_matl_plan_pkg.prepare_row_dtls('||p_query_id||', '||p_plan_id||
21: ','||p_category_set_id||','||p_page_size||')');
22:
23: delete from msc_form_query where query_id = p_query_id;
24: msc_phub_util.log('delete from msc_form_query: '||sql%rowcount);
25: commit;
26:
27: msc_hp_util.prepare_filters(p_query_id, msc_hp_util.ft_organization, p_organization_filters);

Line 24: msc_phub_util.log('delete from msc_form_query: '||sql%rowcount);

20: msc_phub_util.log('msc_matl_plan_pkg.prepare_row_dtls('||p_query_id||', '||p_plan_id||
21: ','||p_category_set_id||','||p_page_size||')');
22:
23: delete from msc_form_query where query_id = p_query_id;
24: msc_phub_util.log('delete from msc_form_query: '||sql%rowcount);
25: commit;
26:
27: msc_hp_util.prepare_filters(p_query_id, msc_hp_util.ft_organization, p_organization_filters);
28: msc_hp_util.prepare_filters(p_query_id, msc_hp_util.ft_category, p_category_filters);

Line 33: from msc_form_query

29: msc_hp_util.prepare_filters(p_query_id, msc_hp_util.ft_item, p_item_filters);
30:
31: select count(*)
32: into l_org_filter_cnt
33: from msc_form_query
34: where query_id = p_query_id and number1 = msc_hp_util.ft_organization;
35:
36: select count(*)
37: into l_cat_filter_cnt

Line 38: from msc_form_query

34: where query_id = p_query_id and number1 = msc_hp_util.ft_organization;
35:
36: select count(*)
37: into l_cat_filter_cnt
38: from msc_form_query
39: where query_id = p_query_id and number1 = msc_hp_util.ft_category;
40:
41: select count(*)
42: into l_item_filter_cnt

Line 43: from msc_form_query

39: where query_id = p_query_id and number1 = msc_hp_util.ft_category;
40:
41: select count(*)
42: into l_item_filter_cnt
43: from msc_form_query
44: where query_id = p_query_id and number1 = msc_hp_util.ft_item;
45:
46: msc_phub_util.log('l_org_filter_cnt='||l_org_filter_cnt||', '||
47: 'l_cat_filter_cnt='||l_cat_filter_cnt||', '||

Line 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))

94: and i.sr_instance_id = ic.sr_instance_id(+)
95: and i.organization_id = ic.organization_id(+)
96: and i.inventory_item_id = ic.inventory_item_id(+)
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;

Line 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))

95: and i.organization_id = ic.organization_id(+)
96: and i.inventory_item_id = ic.inventory_item_id(+)
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:

Line 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));

96: and i.inventory_item_id = ic.inventory_item_id(+)
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(