APPS.MSC_SDA_UTILS dependencies on MSC_EXCEPTION_DETAILS

Line 1436: from msc_exception_details med,

1432: select med.exception_type,
1433: msc_get_name.lookup_meaning('MRP_EXCEPTION_CODE_TYPE', med.exception_type) exception_type_text,
1434: count(*) excp_all_count,
1435: sum(decode(nvl(action_taken,2),2,1,0)) excp_no_count
1436: from msc_exception_details med,
1437: msc_form_query mfq, --items
1438: msc_form_query mfq1 --orgs
1439: where med.plan_id = p_plan_id
1440: and med.inventory_item_id = mfq.number2