APPS.MSC_PHUB_COST_PKG dependencies on MSC_TRADING_PARTNERS

Line 549: msc_trading_partners mtp

545: sum(f.ready_to_build_qty) ready_to_build_qty,
546: sum(f.total_build_qty) total_build_qty
547: from
548: msc_st_costs_f f,
549: msc_trading_partners mtp
550: where f.st_transaction_id=l_transfer_id
551: and mtp.partner_type(+)=3
552: and f.owning_inst_id=mtp.sr_instance_id(+)
553: and f.owning_org_id=mtp.sr_tp_id(+)

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

796: ' fnd_global.user_id, sysdate,'||
797: ' fnd_global.user_id, sysdate, fnd_global.login_id'||
798: ' from'||
799: ' '||l_apps_schema||'.msc_item_inventory_f'||l_suffix||' f,'||
800: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp,'||
801: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp3,'||
802: ' '||l_apps_schema||'.msc_items'||l_suffix||' mi'||
803: ' where f.plan_run_id=:p_plan_run_id'||
804: ' and f.aggr_type=0'||

Line 801: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp3,'||

797: ' fnd_global.user_id, sysdate, fnd_global.login_id'||
798: ' from'||
799: ' '||l_apps_schema||'.msc_item_inventory_f'||l_suffix||' f,'||
800: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp,'||
801: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp3,'||
802: ' '||l_apps_schema||'.msc_items'||l_suffix||' mi'||
803: ' where f.plan_run_id=:p_plan_run_id'||
804: ' and f.aggr_type=0'||
805: ' and mtp.partner_type(+)=3'||

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

923: ' fnd_global.user_id, sysdate,'||
924: ' fnd_global.user_id, sysdate, fnd_global.login_id'||
925: ' from'||
926: ' '||l_apps_schema||'.msc_costs_f'||l_suffix||' f,'||
927: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp,'||
928: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp2,'||
929: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp3,'||
930: ' '||l_apps_schema||'.msc_items'||l_suffix||' mi,'||
931: ' '||l_apps_schema||'.msc_phub_customers_mv'||l_suffix||' cmv,'||

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

924: ' fnd_global.user_id, sysdate, fnd_global.login_id'||
925: ' from'||
926: ' '||l_apps_schema||'.msc_costs_f'||l_suffix||' f,'||
927: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp,'||
928: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp2,'||
929: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp3,'||
930: ' '||l_apps_schema||'.msc_items'||l_suffix||' mi,'||
931: ' '||l_apps_schema||'.msc_phub_customers_mv'||l_suffix||' cmv,'||
932: ' '||l_apps_schema||'.msc_phub_suppliers_mv'||l_suffix||' smv'||

Line 929: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp3,'||

925: ' from'||
926: ' '||l_apps_schema||'.msc_costs_f'||l_suffix||' f,'||
927: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp,'||
928: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp2,'||
929: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp3,'||
930: ' '||l_apps_schema||'.msc_items'||l_suffix||' mi,'||
931: ' '||l_apps_schema||'.msc_phub_customers_mv'||l_suffix||' cmv,'||
932: ' '||l_apps_schema||'.msc_phub_suppliers_mv'||l_suffix||' smv'||
933: ' where f.plan_run_id=:p_plan_run_id'||