APPS.MSC_DEMAND_PKG dependencies on MSC_TRADING_PARTNERS

Line 778: from msc_demands md1,msc_trading_partners mtp1,

774: fnd_global.user_id, sysdate,
775: sysdate, fnd_global.user_id, fnd_global.login_id,
776: fnd_global.conc_program_id, fnd_global.conc_login_id,
777: fnd_global.prog_appl_id, fnd_global.conc_request_id
778: from msc_demands md1,msc_trading_partners mtp1,
779: msc_exception_details med1
780: where md1.plan_id=med1.plan_id
781: and md1.plan_id=p_plan_id
782: and md1.origination_type in (5,6,7,8,9,10,11,12,15,22,27,29,30) --- only for indep demand

Line 962: msc_trading_partners mtp1

958: and md.plan_id=p_plan_id
959: and p_plan_id <> -1
960: and l_plan_type in (1,101,102,103,105)
961: and md.dmd_satisfied_date is not null) t,
962: msc_trading_partners mtp1
963: where t.sr_instance_id=mtp1.sr_instance_id(+)
964: and t.organization_id=mtp1.sr_tp_id(+)
965: and mtp1.partner_type(+)=3
966: group by

Line 1419: msc_trading_partners mtp,

1415: sum(f.sales_order_pd) sales_order_pd,
1416: sum(f.sales_order_pd * nvl(msi.list_price,0)*(1-nvl(msi.average_discount,0)/100)) sales_order_pd_value
1417: from
1418: msc_st_demands_f f,
1419: msc_trading_partners mtp,
1420: msc_apcc_item_d msi
1421: where f.st_transaction_id=l_transfer_id
1422: and mtp.partner_type(+)=3
1423: and f.owning_inst_id=mtp.sr_instance_id(+)

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

2185: ' fnd_global.user_id, sysdate,'||
2186: ' fnd_global.user_id, sysdate, fnd_global.login_id'||
2187: ' from'||
2188: ' '||l_apps_schema||'.msc_demands_f'||l_suffix||' f,'||
2189: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp,'||
2190: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp2,'||
2191: ' '||l_apps_schema||'.msc_items'||l_suffix||' mi,'||
2192: ' '||l_apps_schema||'.msc_phub_customers_mv'||l_suffix||' cmv,';
2193: if (p_source_version >= '12.1.3') then l_sql := l_sql||

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

2186: ' fnd_global.user_id, sysdate, fnd_global.login_id'||
2187: ' from'||
2188: ' '||l_apps_schema||'.msc_demands_f'||l_suffix||' f,'||
2189: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp,'||
2190: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp2,'||
2191: ' '||l_apps_schema||'.msc_items'||l_suffix||' mi,'||
2192: ' '||l_apps_schema||'.msc_phub_customers_mv'||l_suffix||' cmv,';
2193: if (p_source_version >= '12.1.3') then l_sql := l_sql||
2194: ' '||l_apps_schema||'.msc_phub_projects_mv'||l_suffix||' proj';

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

2313: ' fnd_global.user_id, sysdate,'||
2314: ' fnd_global.user_id, sysdate, fnd_global.login_id'||
2315: ' from'||
2316: ' '||l_apps_schema||'.msc_demands_cum_f'||l_suffix||' f,'||
2317: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp,'||
2318: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp2,'||
2319: ' '||l_apps_schema||'.msc_items'||l_suffix||' mi,'||
2320: ' '||l_apps_schema||'.msc_phub_customers_mv'||l_suffix||' cmv'||
2321: ' where f.plan_run_id=:p_plan_run_id'||

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

2314: ' fnd_global.user_id, sysdate, fnd_global.login_id'||
2315: ' from'||
2316: ' '||l_apps_schema||'.msc_demands_cum_f'||l_suffix||' f,'||
2317: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp,'||
2318: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp2,'||
2319: ' '||l_apps_schema||'.msc_items'||l_suffix||' mi,'||
2320: ' '||l_apps_schema||'.msc_phub_customers_mv'||l_suffix||' cmv'||
2321: ' where f.plan_run_id=:p_plan_run_id'||
2322: ' and f.aggr_type=0'||