APPS.MSC_SDA_UTILS dependencies on MSC_SYSTEM_ITEMS

Line 845: from msc_system_items_sc_v msiv,

841: repair_cost,
842: repair_lead_time, repair_program_text, repair_yield, std_dmd_over_horizon,
843: repetitive_planning_flag_text,
844: mfq.number3
845: from msc_system_items_sc_v msiv,
846: msc_form_query mfq, --items
847: msc_form_query mfq1 --orgs
848: where plan_id = p_plan_id
849: and category_set_id = l_category_set_id

Line 996: msc_system_items msi,

992: msc_get_name.lookup_meaning('MSC_EXCEPTION_GROUP', 10) exception_type_text,
993: count(*) excp_all_count,
994: 0 excp_no_count
995: from msc_supplies ms,
996: msc_system_items msi,
997: msc_form_query mfq, --items
998: msc_form_query mfq1 --orgs
999: where ms.plan_id = p_plan_id
1000: and ms.inventory_item_id = mfq.number2