APPS.MSC_PHUB_EXCESS_PKG dependencies on MSC_TRADING_PARTNERS

Line 273: from msc_supplies_f msf,msc_trading_partners mtp, msc_hub_query b, msc_system_items i

269: *nvl(b.number8, nvl(i.standard_cost,0))) onhand_value,
270: sum((case when msf.supply_type in (1,2,3,8,11,12,14,27,49,53,80)
271: then nvl(msf.supply_qty,0) else 0 end)
272: *nvl(b.number8, nvl(i.standard_cost,0))) onorder_value
273: from msc_supplies_f msf,msc_trading_partners mtp, msc_hub_query b, msc_system_items i
274: where msf.plan_id=p_plan_id
275: and msf.plan_run_id=p_plan_run_id
276: and msf.aggr_type=0
277: and b.query_id(+)=l_qid_eo

Line 318: from msc_demands_f mdf, msc_trading_partners mtp, msc_hub_query b, msc_system_items i

314: to_number(0) onhand_qty,
315: to_number(0) onorder_qty,
316: to_number(0) onhand_value,
317: to_number(0) onorder_value
318: from msc_demands_f mdf, msc_trading_partners mtp, msc_hub_query b, msc_system_items i
319: where mdf.plan_id=p_plan_id
320: and mdf.plan_run_id=p_plan_run_id
321: and mdf.aggr_type=0
322: and b.query_id(+)=l_qid_eo

Line 378: msc_trading_partners mtp,

374: sysdate, fnd_global.user_id, fnd_global.login_id,
375: fnd_global.conc_program_id, fnd_global.conc_login_id,
376: fnd_global.prog_appl_id, fnd_global.conc_request_id
377: from
378: msc_trading_partners mtp,
379: msc_plan_organizations po,
380: msc_uom_conversions uc
381: where po.plan_id=p_plan_id
382: and po.sr_instance_id=mtp.sr_instance_id

Line 676: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp,'||

672: ' fnd_global.user_id, sysdate,'||
673: ' fnd_global.user_id, sysdate, fnd_global.login_id'||
674: ' from'||
675: ' '||l_apps_schema||'.msc_item_orders_f'||l_suffix||' f,'||
676: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp,'||
677: ' '||l_apps_schema||'.msc_items'||l_suffix||' mi'||
678: ' where f.plan_run_id=:p_plan_run_id'||
679: ' and f.aggr_type=0'||
680: ' and mtp.partner_type(+)=3'||

Line 767: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp,'||

763: ' fnd_global.user_id, sysdate,'||
764: ' fnd_global.user_id, sysdate, fnd_global.login_id'||
765: ' from'||
766: ' '||l_apps_schema||'.msc_items_f'||l_suffix||' f,'||
767: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp,'||
768: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp2,'||
769: ' '||l_apps_schema||'.msc_items'||l_suffix||' mi,'||
770: ' '||l_apps_schema||'.msc_apps_instances'||l_suffix||' mai'||
771: ' where f.plan_run_id=:p_plan_run_id'||

Line 768: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp2,'||

764: ' fnd_global.user_id, sysdate, fnd_global.login_id'||
765: ' from'||
766: ' '||l_apps_schema||'.msc_items_f'||l_suffix||' f,'||
767: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp,'||
768: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp2,'||
769: ' '||l_apps_schema||'.msc_items'||l_suffix||' mi,'||
770: ' '||l_apps_schema||'.msc_apps_instances'||l_suffix||' mai'||
771: ' where f.plan_run_id=:p_plan_run_id'||
772: ' and f.aggr_type=0'||