DBA Data[Home] [Help]

APPS.MSC_EXP_WF dependencies on MSC_FORM_QUERY

Line 346: FROM msc_form_query

342: WHERE exp.exception_type in
343: (1,2,3,6,7,8,9,10,12,13,14,15,16,17,18,19,20,24,25,26,27,28,37,49,70)
344: AND exp.plan_id = p_plan_id
345: AND exp.exception_detail_id in (SELECT number1
346: FROM msc_form_query
347: WHERE query_id = p_query_id)
348: AND sup.plan_id (+) = exp.plan_id
349: AND sup.transaction_id (+) = exp.number1
350: and sup.sr_instance_id(+) = exp.sr_instance_id