APPS.MSC_SUPPLIER_PKG dependencies on MSC_TRADING_PARTNERS

Line 153: msc_trading_partners mtp

149: to_number(null) po_cancel_count,
150: to_number(null) buy_order_value,
151: to_number(null) buy_order_count
152: from msc_supplier_requirements msr,
153: msc_trading_partners mtp
154: where msr.plan_id = p_plan_id
155: and l_plan_constrained = SYS_YES
156: and msr.sr_instance_id = mtp.sr_instance_id
157: and msr.organization_id = mtp.sr_tp_id

Line 205: msc_trading_partners mtp

201: from
202: MSC_SUPPLIES ms,
203: MSC_SYSTEM_ITEMS msi,
204: msc_plans mp,
205: msc_trading_partners mtp
206: where
207: mp.plan_id = p_plan_id
208: and l_plan_constrained = SYS_NO -- are we double counting constrained plan with previous?
209: and mp.plan_id = ms.plan_id

Line 250: msc_trading_partners mtp

246: to_number(null) buy_order_value,
247: to_number(null) buy_order_count
248: from
249: msc_bis_inv_detail mbid,
250: msc_trading_partners mtp
251: where mbid.plan_id = p_plan_id
252: and mbid.supplier_id is not null
253: and mbid.organization_id = mtp.sr_tp_id
254: and mbid.sr_instance_id = mtp.sr_instance_id

Line 328: msc_trading_partners mtp,

324: nvl(mscp.capacity, 1e20) avail_qty
325: from
326: msc_supplier_capacities mscp,
327: msc_calendar_dates mcd,
328: msc_trading_partners mtp,
329: msc_item_suppliers mis,
330: msc_plans mp
331: where mp.plan_id = mscp.plan_id
332: and mscp.capacity > 0

Line 367: msc_trading_partners mtp

363: to_number(null) required_qty,
364: mbid.supplier_capacity avail_qty
365: from
366: msc_bis_inv_detail mbid,
367: msc_trading_partners mtp
368: where mbid.plan_id = p_plan_id
369: and mbid.supplier_id is not null
370: and mbid.organization_id = mtp.sr_tp_id
371: and mbid.sr_instance_id = mtp.sr_instance_id