APPS.MSC_SUPPLY_PKG dependencies on MSC_EXCEPTION_DETAILS

Line 462: msc_exception_details med,

458: sum(MED.DATE2 - MED.DATE1) stockout_days --- should be to_date - from_date
459: -- may get from msc_exception_f if this has performance issue
460: -- table from_date - to_date
461: from
462: msc_exception_details med,
463: msc_hub_query f_2
464: where f_2.query_id(+) = l_qid_vmi
465: and f_2.number1(+) = med.plan_id
466: and f_2.number3(+) = med.sr_instance_id