DBA Data[Home] [Help]

APPS.MSC_SNO_PKG dependencies on MSC_EXCEPTION_DETAILS

Line 175: msc_exception_details med,

171: med.number2,
172: decode(med.organization_id, -1, mp.organization_id, med.organization_id) eff_organization_id,
173: decode(med.organization_id, -1, mp.sr_instance_id, med.sr_instance_id) eff_sr_instance_id -- wei: sync sr_instance_id with organization_id
174: from
175: msc_exception_details med,
176: msc_plans mp
177: where mp.plan_id = med.plan_id
178: and mp.plan_type = 6
179: and mp.plan_id = p_plan_id) t,