APPS.MSC_PHUB_EXCESS_PKG dependencies on MSC_HUB_QUERY

Line 61: select msc_hub_query_s.nextval into l_qid_eo from dual;

57: 'l_item_simulation_set_id='||l_item_simulation_set_id||', '||
58: 'l_sim_plan_id='||l_sim_plan_id);
59:
60: if l_item_simulation_set_id is not null then
61: select msc_hub_query_s.nextval into l_qid_eo from dual;
62: insert into msc_hub_query(
63: query_id,
64: last_update_date,
65: last_updated_by,

Line 62: insert into msc_hub_query(

58: 'l_sim_plan_id='||l_sim_plan_id);
59:
60: if l_item_simulation_set_id is not null then
61: select msc_hub_query_s.nextval into l_qid_eo from dual;
62: insert into msc_hub_query(
63: query_id,
64: last_update_date,
65: last_updated_by,
66: creation_date,

Line 112: select msc_hub_query_s.nextval into l_qid_eo from dual;

108: msc_phub_util.log('msc_phub_excess_pkg.populate_details: '||
109: 'l_item_simulation_set_id='||l_item_simulation_set_id);
110:
111: if l_item_simulation_set_id is not null then
112: select msc_hub_query_s.nextval into l_qid_eo from dual;
113: insert into msc_hub_query(
114: query_id,
115: last_update_date,
116: last_updated_by,

Line 113: insert into msc_hub_query(

109: 'l_item_simulation_set_id='||l_item_simulation_set_id);
110:
111: if l_item_simulation_set_id is not null then
112: select msc_hub_query_s.nextval into l_qid_eo from dual;
113: insert into msc_hub_query(
114: query_id,
115: last_update_date,
116: last_updated_by,
117: creation_date,

Line 273: from msc_supplies_f msf,msc_trading_partners mtp, msc_hub_query b, msc_system_items i

269: *nvl(b.number8, nvl(i.standard_cost,0))) onhand_value,
270: sum((case when msf.supply_type in (1,2,3,8,11,12,14,27,49,53,80)
271: then nvl(msf.supply_qty,0) else 0 end)
272: *nvl(b.number8, nvl(i.standard_cost,0))) onorder_value
273: from msc_supplies_f msf,msc_trading_partners mtp, msc_hub_query b, msc_system_items i
274: where msf.plan_id=p_plan_id
275: and msf.plan_run_id=p_plan_run_id
276: and msf.aggr_type=0
277: and b.query_id(+)=l_qid_eo

Line 318: from msc_demands_f mdf, msc_trading_partners mtp, msc_hub_query b, msc_system_items i

314: to_number(0) onhand_qty,
315: to_number(0) onorder_qty,
316: to_number(0) onhand_value,
317: to_number(0) onorder_value
318: from msc_demands_f mdf, msc_trading_partners mtp, msc_hub_query b, msc_system_items i
319: where mdf.plan_id=p_plan_id
320: and mdf.plan_run_id=p_plan_run_id
321: and mdf.aggr_type=0
322: and b.query_id(+)=l_qid_eo