APPS.MSC_GET_BIS_VALUES dependencies on MSC_EXCEPTION_DETAILS

Line 824: ' FROM msc_exception_details mbis' ||

820: ' FROM msc_late_order_mv_tab mbis' ||
821: ' WHERE mbis.plan_id = :1 ';
822: else
823: sql_statement := ' SELECT count(distinct mbis.number1) ' ||
824: ' FROM msc_exception_details mbis' ||
825: ' WHERE mbis.plan_id = :1 '||
826: ' AND mbis.exception_type in (13,14,24,26) '||
827: ' AND mbis.number1 is not null ';
828: end if;

Line 3127: from msc_exception_details

3123: plan_id,
3124: organization_id,
3125: sr_instance_id,
3126: count(distinct number1)
3127: from msc_exception_details
3128: where exception_type in (13,14,24,26)
3129: and plan_id = p_plan_id
3130: group by plan_id,
3131: organization_id,