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_RES_PLAN_PKG dependencies on MSC_FORM_QUERY

Line 26: delete from msc_form_query where query_id = p_query_id;

22: begin
23: msc_phub_util.log('msc_res_plan_pkg.prepare_row_dtls('||p_query_id||', '||p_plan_id||
24: ','||p_page_size||')');
25:
26: delete from msc_form_query where query_id = p_query_id;
27: msc_phub_util.log('delete from msc_form_query: '||sql%rowcount);
28: commit;
29:
30: msc_hp_util.prepare_filters(p_query_id, msc_hp_util.ft_organization, p_organization_filters);

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

23: msc_phub_util.log('msc_res_plan_pkg.prepare_row_dtls('||p_query_id||', '||p_plan_id||
24: ','||p_page_size||')');
25:
26: delete from msc_form_query where query_id = p_query_id;
27: msc_phub_util.log('delete from msc_form_query: '||sql%rowcount);
28: commit;
29:
30: msc_hp_util.prepare_filters(p_query_id, msc_hp_util.ft_organization, p_organization_filters);
31: msc_hp_util.prepare_filters(p_query_id, msc_hp_util.ft_department, p_department_filters);

Line 38: from msc_form_query

34: msc_hp_util.prepare_filters(p_query_id, msc_hp_util.ft_item, p_item_filters);
35:
36: select count(*)
37: into l_org_filter_cnt
38: from msc_form_query
39: where query_id = p_query_id and number1 = msc_hp_util.ft_organization;
40:
41: select count(*)
42: into l_dept_filter_cnt

Line 43: from msc_form_query

39: where query_id = p_query_id and number1 = msc_hp_util.ft_organization;
40:
41: select count(*)
42: into l_dept_filter_cnt
43: from msc_form_query
44: where query_id = p_query_id and number1 = msc_hp_util.ft_department;
45:
46: select count(*)
47: into l_res_filter_cnt

Line 48: from msc_form_query

44: where query_id = p_query_id and number1 = msc_hp_util.ft_department;
45:
46: select count(*)
47: into l_res_filter_cnt
48: from msc_form_query
49: where query_id = p_query_id and number1 = msc_hp_util.ft_resource;
50:
51: select count(*)
52: into l_exception_filter_cnt

Line 53: from msc_form_query

49: where query_id = p_query_id and number1 = msc_hp_util.ft_resource;
50:
51: select count(*)
52: into l_exception_filter_cnt
53: from msc_form_query
54: where query_id = p_query_id and number1 = msc_hp_util.ft_exception and number2 in (24,26);
55:
56: select count(*)
57: into l_item_filter_cnt

Line 58: from msc_form_query

54: where query_id = p_query_id and number1 = msc_hp_util.ft_exception and number2 in (24,26);
55:
56: select count(*)
57: into l_item_filter_cnt
58: from msc_form_query
59: where query_id = p_query_id and number1 = msc_hp_util.ft_item;
60:
61: msc_phub_util.log('l_org_filter_cnt = '||l_org_filter_cnt||', '||
62: 'l_dept_filter_cnt = '||l_dept_filter_cnt||', '||

Line 72: insert into msc_form_query(query_id, number1, number2, number3,

68: msc_phub_util.log('delete from msc_hp_row_dtls: '||sql%rowcount);
69: commit;
70:
71: if (l_exception_filter_cnt > 0) then
72: insert into msc_form_query(query_id, number1, number2, number3,
73: created_by, creation_date, last_update_date, last_updated_by, last_update_login)
74: select /*+ ordered */
75: p_query_id,
76: msc_hp_util.ft_end_pegging,

Line 84: msc_form_query q,

80: sysdate, fnd_global.user_id, fnd_global.login_id
81: from
82: msc_full_pegging mfp1,
83: msc_exception_details med1,
84: msc_form_query q,
85: msc_trading_partners mtp1
86: where mfp1.plan_id = p_plan_id
87: and mfp1.plan_id = med1.plan_id
88: and mfp1.prev_pegging_id is null

Line 98: and (l_org_filter_cnt = 0 or mtp1.organization_code in (select char1 from msc_form_query where query_id = p_query_id and number1 = msc_hp_util.ft_organization))

94: and q.number2 in (24,26)
95: and mfp1.sr_instance_id = mtp1.sr_instance_id
96: and mfp1.organization_id = mtp1.sr_tp_id
97: and mtp1.partner_type = 3
98: and (l_org_filter_cnt = 0 or mtp1.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_item_filter_cnt = 0 or mfp1.inventory_item_id in (select number2 from msc_form_query where query_id = p_query_id and number1 = msc_hp_util.ft_item));
100: msc_phub_util.log('insert into msc_form_query: '||sql%rowcount);
101: commit;
102:

Line 99: and (l_item_filter_cnt = 0 or mfp1.inventory_item_id in (select number2 from msc_form_query where query_id = p_query_id and number1 = msc_hp_util.ft_item));

95: and mfp1.sr_instance_id = mtp1.sr_instance_id
96: and mfp1.organization_id = mtp1.sr_tp_id
97: and mtp1.partner_type = 3
98: and (l_org_filter_cnt = 0 or mtp1.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_item_filter_cnt = 0 or mfp1.inventory_item_id in (select number2 from msc_form_query where query_id = p_query_id and number1 = msc_hp_util.ft_item));
100: msc_phub_util.log('insert into msc_form_query: '||sql%rowcount);
101: commit;
102:
103: insert into msc_hp_row_dtls(

Line 100: msc_phub_util.log('insert into msc_form_query: '||sql%rowcount);

96: and mfp1.organization_id = mtp1.sr_tp_id
97: and mtp1.partner_type = 3
98: and (l_org_filter_cnt = 0 or mtp1.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_item_filter_cnt = 0 or mfp1.inventory_item_id in (select number2 from msc_form_query where query_id = p_query_id and number1 = msc_hp_util.ft_item));
100: msc_phub_util.log('insert into msc_form_query: '||sql%rowcount);
101: commit;
102:
103: insert into msc_hp_row_dtls(
104: query_id,

Line 161: msc_form_query q,

157: and mfp2.transaction_id = mrr.supply_id
158: and mrr.resource_id > 0
159: ) r,
160: msc_exception_details med2,
161: msc_form_query q,
162: msc_trading_partners mtp2,
163: msc_department_resources mdp
164: where q.query_id = p_query_id
165: and q.number1 = msc_hp_util.ft_end_pegging

Line 180: and (l_dept_filter_cnt = 0 or mdp.department_code in (select char1 from msc_form_query where query_id = p_query_id and number1 = msc_hp_util.ft_department))

176: and r.sr_instance_id = mdp.sr_instance_id
177: and r.organization_id = mdp.organization_id
178: and r.department_id = mdp.department_id
179: and r.resource_id = mdp.resource_id
180: and (l_dept_filter_cnt = 0 or mdp.department_code in (select char1 from msc_form_query where query_id = p_query_id and number1 = msc_hp_util.ft_department))
181: and (l_res_filter_cnt = 0 or mdp.resource_code in (select char1 from msc_form_query where query_id = p_query_id and number1 = msc_hp_util.ft_resource))
182: ) t;
183: msc_phub_util.log('insert into msc_hp_row_dtls: '||sql%rowcount);
184: commit;

Line 181: and (l_res_filter_cnt = 0 or mdp.resource_code in (select char1 from msc_form_query where query_id = p_query_id and number1 = msc_hp_util.ft_resource))

177: and r.organization_id = mdp.organization_id
178: and r.department_id = mdp.department_id
179: and r.resource_id = mdp.resource_id
180: and (l_dept_filter_cnt = 0 or mdp.department_code in (select char1 from msc_form_query where query_id = p_query_id and number1 = msc_hp_util.ft_department))
181: and (l_res_filter_cnt = 0 or mdp.resource_code in (select char1 from msc_form_query where query_id = p_query_id and number1 = msc_hp_util.ft_resource))
182: ) t;
183: msc_phub_util.log('insert into msc_hp_row_dtls: '||sql%rowcount);
184: commit;
185: else

Line 222: and (l_org_filter_cnt = 0 or mtp.organization_code in (select char1 from msc_form_query where query_id = p_query_id and number1 = msc_hp_util.ft_organization))

218: and mdp.sr_instance_id = mtp.sr_instance_id
219: and mdp.organization_id = mtp.sr_tp_id
220: and mtp.partner_type = 3
221: and mdp.resource_id > 0
222: and (l_org_filter_cnt = 0 or mtp.organization_code in (select char1 from msc_form_query where query_id = p_query_id and number1 = msc_hp_util.ft_organization))
223: and (l_dept_filter_cnt = 0 or mdp.department_code in (select char1 from msc_form_query where query_id = p_query_id and number1 = msc_hp_util.ft_department))
224: and (l_res_filter_cnt = 0 or mdp.resource_code in (select char1 from msc_form_query where query_id = p_query_id and number1 = msc_hp_util.ft_resource));
225: msc_phub_util.log('insert into msc_hp_row_dtls: '||sql%rowcount);
226: commit;

Line 223: and (l_dept_filter_cnt = 0 or mdp.department_code in (select char1 from msc_form_query where query_id = p_query_id and number1 = msc_hp_util.ft_department))

219: and mdp.organization_id = mtp.sr_tp_id
220: and mtp.partner_type = 3
221: and mdp.resource_id > 0
222: and (l_org_filter_cnt = 0 or mtp.organization_code in (select char1 from msc_form_query where query_id = p_query_id and number1 = msc_hp_util.ft_organization))
223: and (l_dept_filter_cnt = 0 or mdp.department_code in (select char1 from msc_form_query where query_id = p_query_id and number1 = msc_hp_util.ft_department))
224: and (l_res_filter_cnt = 0 or mdp.resource_code in (select char1 from msc_form_query where query_id = p_query_id and number1 = msc_hp_util.ft_resource));
225: msc_phub_util.log('insert into msc_hp_row_dtls: '||sql%rowcount);
226: commit;
227: end if;

Line 224: and (l_res_filter_cnt = 0 or mdp.resource_code in (select char1 from msc_form_query where query_id = p_query_id and number1 = msc_hp_util.ft_resource));

220: and mtp.partner_type = 3
221: and mdp.resource_id > 0
222: and (l_org_filter_cnt = 0 or mtp.organization_code in (select char1 from msc_form_query where query_id = p_query_id and number1 = msc_hp_util.ft_organization))
223: and (l_dept_filter_cnt = 0 or mdp.department_code in (select char1 from msc_form_query where query_id = p_query_id and number1 = msc_hp_util.ft_department))
224: and (l_res_filter_cnt = 0 or mdp.resource_code in (select char1 from msc_form_query where query_id = p_query_id and number1 = msc_hp_util.ft_resource));
225: msc_phub_util.log('insert into msc_hp_row_dtls: '||sql%rowcount);
226: commit;
227: end if;
228: