APPS.MSC_DEMAND_PKG dependencies on MSC_HUB_QUERY

Line 51: (select number1, number2, number3, number4 from msc_hub_query q where q.query_id = l_item_rn_qid);

47: delete from msc_demands_f
48: where plan_id = p_plan_id
49: and plan_run_id = p_plan_run_id
50: and (p_plan_id, sr_instance_id, organization_id, inventory_item_id) in
51: (select number1, number2, number3, number4 from msc_hub_query q where q.query_id = l_item_rn_qid);
52:
53: l_rowcount1 := l_rowcount1 + sql%rowcount;
54: msc_phub_util.log('msc_demands_f, delete='||sql%rowcount||', l_rowcount1='||l_rowcount1);
55: commit;

Line 62: (select number1, number2, number3, number4 from msc_hub_query q where q.query_id = l_item_rn_qid);

58: delete from msc_demands_cum_f
59: where plan_id = p_plan_id
60: and plan_run_id = p_plan_run_id
61: and (p_plan_id, sr_instance_id, organization_id, inventory_item_id) in
62: (select number1, number2, number3, number4 from msc_hub_query q where q.query_id = l_item_rn_qid);
63:
64: l_rowcount2 := l_rowcount2 + sql%rowcount;
65: msc_phub_util.log('msc_demands_cum_f, delete='||sql%rowcount||', l_rowcount2='||l_rowcount2);
66: commit;

Line 415: (select number1, number2, number3, number4 from msc_hub_query q where q.query_id = l_item_rn_qid) ) )

411: or ( p_plan_id = -1
412: and md.sr_instance_id = l_sr_instance_id
413: and (l_refresh_mode = 1
414: or (l_refresh_mode = 2 and (p_plan_id, md.sr_instance_id, md.organization_id, md.inventory_item_id) in
415: (select number1, number2, number3, number4 from msc_hub_query q where q.query_id = l_item_rn_qid) ) )
416: and md.origination_type <> 29
417: and trunc(nvl(md.firm_date,md.using_assembly_demand_date)) between l_plan_start_date and l_plan_cutoff_date
418: )
419: )

Line 551: (select number1, number2, number3, number4 from msc_hub_query q where q.query_id = l_item_rn_qid) ) )

547: and least(nvl(md2.assembly_demand_comp_date, md2.using_assembly_demand_date), l_plan_cutoff_date)
548: and md2.sr_instance_id=l_sr_instance_id
549: and (l_refresh_mode = 1
550: or (l_refresh_mode = 2 and (p_plan_id, md2.sr_instance_id, md2.organization_id, md2.inventory_item_id) in
551: (select number1, number2, number3, number4 from msc_hub_query q where q.query_id = l_item_rn_qid) ) )
552: ) md
553: group by
554: decode(md.organization_id, -1, -23453, md.sr_instance_id),
555: decode(md.organization_id, -1, -23453, md.organization_id),

Line 640: (select number1, number2, number3, number4 from msc_hub_query q where q.query_id = l_item_rn_qid) ) )

636: where p_plan_id=-1
637: and mso.sr_instance_id = l_sr_instance_id
638: and (l_refresh_mode = 1
639: or (l_refresh_mode = 2 and (p_plan_id, mso.sr_instance_id, mso.organization_id, mso.inventory_item_id) in
640: (select number1, number2, number3, number4 from msc_hub_query q where q.query_id = l_item_rn_qid) ) )
641: and trunc(mso.requirement_date) between l_plan_start_date and l_plan_cutoff_date
642: group by
643: mso.sr_instance_id,
644: mso.organization_id,