DBA Data[Home] [Help]

APPS.MSC_RES_PLAN_PKG dependencies on MSC_EXCEPTION_DETAILS

Line 83: msc_exception_details med1,

79: fnd_global.user_id, sysdate,
80: sysdate, fnd_global.user_id, fnd_global.login_id
81: from
82: msc_full_pegging mfp1,
83: msc_exception_details med1,
84: msc_form_query q,
85: msc_trading_partners mtp1
86: where mfp1.plan_id = p_plan_id
87: and mfp1.plan_id = med1.plan_id

Line 160: msc_exception_details med2,

156: --and mfp2.organization_id = mrr.organization_id
157: and mfp2.transaction_id = mrr.supply_id
158: and mrr.resource_id > 0
159: ) r,
160: msc_exception_details med2,
161: msc_form_query q,
162: msc_trading_partners mtp2,
163: msc_department_resources mdp
164: where q.query_id = p_query_id