APPS.MSC_SNO_PKG dependencies on MSC_TRADING_PARTNERS

Line 181: msc_trading_partners mtp

177: where mp.plan_id = med.plan_id
178: and mp.plan_type = 6
179: and mp.plan_id = p_plan_id) t,
180: msc_system_items msi,
181: msc_trading_partners mtp
182: where msi.plan_id(+) = t.plan_id
183: and msi.inventory_item_id(+) = t.inventory_item_id
184: and msi.organization_id(+) = t.eff_organization_id
185: and msi.sr_instance_id(+) = t.eff_sr_instance_id

Line 307: msc_trading_partners mtp

303: mdrs.resource_cost
304: from
305: msc_bis_res_summary mdrs,
306: msc_department_resources mdr,
307: msc_trading_partners mtp
308: where mdrs.plan_id = p_plan_id
309: and nvl(mdrs.detail_level, 0) = 1
310: and nvl(mdrs.period_type, 0) = 1
311: and mdrs.sr_instance_id = mtp.sr_instance_id(+)

Line 414: msc_trading_partners mtp

410: to_number(null) buy_order_value2,
411: to_number(null) buy_order_count
412: from
413: msc_bis_inv_detail mbid,
414: msc_trading_partners mtp
415: where mbid.plan_id = p_plan_id
416: and mbid.supplier_id is not null
417: and mbid.organization_id = mtp.sr_tp_id
418: and mbid.sr_instance_id = mtp.sr_instance_id

Line 457: msc_trading_partners mtp

453: from
454: msc_supplies ms,
455: msc_system_items msi,
456: msc_plans mp,
457: msc_trading_partners mtp
458: where mp.plan_id = p_plan_id
459: and mp.plan_type = 6
460: and ms.plan_id = p_plan_id
461: and ms.supplier_id is not null -- wei: make/move orders don't go to supplier and are filtered out

Line 568: msc_trading_partners mtp

564: sum(using_requirement_quantity) demand_qty,
565: sum(quantity_by_due_date) qty_by_due_date
566: from
567: msc_demands md,
568: msc_trading_partners mtp
569: where md.plan_id = p_plan_id
570: and md.origination_type = 81 -- wei: SNO
571: and md.sr_instance_id = mtp.sr_instance_id(+)
572: and md.organization_id = mtp.sr_tp_id(+)

Line 860: msc_trading_partners bis_mtp

856: mbid.organization_id, mbid.inventory_item_id, mbid.ship_method
857: order by mbid.detail_date) inv_build_target
858: -- wei: SNO meassure, to add include partition by vmi.number6 order by map.date2
859: from msc_bis_inv_detail mbid,
860: msc_trading_partners bis_mtp
861: where nvl(mbid.detail_level,0)=1
862: and nvl(mbid.period_type,0)=1
863: and mbid.plan_id=p_plan_id
864: and mbid.sr_instance_id = bis_mtp.sr_instance_id