DBA Data[Home] [Help]

APPS.MSC_RES_PLAN_PKG dependencies on MSC_TRADING_PARTNERS

Line 85: msc_trading_partners mtp1

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
88: and mfp1.prev_pegging_id is null
89: and mfp1.plan_id = med1.plan_id

Line 162: msc_trading_partners mtp2,

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
165: and q.number1 = msc_hp_util.ft_end_pegging
166: and r.sr_instance_id = q.number2

Line 216: msc_trading_partners mtp

212: fnd_global.user_id, sysdate,
213: sysdate, fnd_global.user_id, fnd_global.login_id
214: from
215: msc_department_resources mdp,
216: msc_trading_partners mtp
217: where mdp.plan_id = p_plan_id
218: and mdp.sr_instance_id = mtp.sr_instance_id
219: and mdp.organization_id = mtp.sr_tp_id
220: and mtp.partner_type = 3