APPS.MSC_ANALYSIS_PKG dependencies on MSC_BIS_INV_DETAIL

Line 27: from msc_bis_inv_detail

23:
24: cursor c_next_pr (p_plan in number, p_curr_pr_date in date,
25: p_period_type in number, p_detail_level in number ) is
26: select min(detail_date)-1
27: from msc_bis_inv_detail
28: where plan_id = p_plan
29: and nvl(period_type,0) = p_period_type
30: and nvl(detail_level,0) = p_detail_level
31: and detail_date > p_curr_pr_date;

Line 38: from msc_bis_inv_detail

34: p_instance in number, p_org in number, p_item in number,
35: p_curr_pr_date in date,
36: p_period_type in number, p_detail_level in number ) is
37: select max(detail_date)+1
38: from msc_bis_inv_detail
39: where plan_id = p_plan
40: and sr_instance_id = p_instance
41: and organization_id = p_org
42: and inventory_item_id = p_item

Line 611: ' from msc_bis_inv_detail '||

607: l_mfq_query_id := get_form_seq_id;
608: l_cur_plan_id := -1;
609:
610: l_sql_stmt := ' SELECT distinct plan_id, period_type, detail_level, detail_date '||
611: ' from msc_bis_inv_detail '||
612: ' where plan_id in ('|| arg_plan_list ||')';
613:
614: if ( arg_detail_level = 'NULL'
615: or arg_detail_level is null or arg_detail_level = '5' ) then

Line 985: from msc_bis_inv_detail

981:
982: cursor c_next_pr_local (p_plan in number, p_curr_pr_date in date,
983: p_period_type in number, p_detail_level in number ) is
984: select min(detail_date)-1
985: from msc_bis_inv_detail
986: where plan_id = p_plan
987: and sr_instance_id = arg_instance
988: and organization_id = arg_org
989: and nvl(period_type,0) = p_period_type