APPS.MSC_DEMAND_PKG dependencies on MSC_TRADING_PARTNERS

Line 90: from msc_trading_partners o, msc_plans p

86: -- save owning organization's functional currency
87: begin
88: select o.currency_code
89: into l_owning_currency_code
90: from msc_trading_partners o, msc_plans p
91: where o.sr_instance_id=p.sr_instance_id
92: and o.sr_tp_id=p.organization_id
93: and o.partner_type=3
94: and p.plan_id=p_plan_id;

Line 693: from msc_demands md, msc_trading_partners mtp, msc_plans mp,

689: 30,nvl(md.service_level, 50),
690: 81,nvl(md.service_level, 50),
691: null)) service_level
692:
693: from msc_demands md, msc_trading_partners mtp, msc_plans mp,
694: (select msi_1.plan_id,
695: msi_1.sr_instance_id,
696: msi_1.organization_id,
697: msi_1.inventory_item_id,

Line 862: from msc_demands md1,msc_trading_partners mtp1,

858: ) late_order_value,
859: min(nvl(md1.service_level, 50))
860:
861:
862: from msc_demands md1,msc_trading_partners mtp1,
863: msc_exception_details med1,
864: msc_plans mp1,
865: (select msi_2.plan_id,
866: msi_2.sr_instance_id,