APPS.MSC_ANALYSIS_PKG dependencies on MSC_BIS_INV_DETAIL

Line 29: from msc_bis_inv_detail

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

Line 40: from msc_bis_inv_detail

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

Line 612: ' from msc_bis_inv_detail '||

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

Line 986: from msc_bis_inv_detail

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

Line 1342: FROM msc_bis_inv_detail mbid

1338: CURSOR c_tp_cost (p_plan_id in number, p_inst_id in number, p_org_id in number) IS
1339: select sum(nvl(MSC_ANALYSIS_PKG.get_tp_cost(mbid.period_type,
1340: mbid.detail_level, mbid.plan_id, mbid.sr_instance_id,
1341: mbid.organization_id, mbid.inventory_item_id, mbid.detail_date),0))
1342: FROM msc_bis_inv_detail mbid
1343: WHERE mbid.plan_id = p_plan_id
1344: and mbid.sr_instance_id = p_inst_id
1345: and mbid.organization_id = p_org_id
1346: and nvl(mbid.detail_level, 0) = 0