eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_SUPPLY_PKG dependencies on MSC_TRADING_PARTNERS

Line 394: msc_trading_partners mtp

390: mfp2.inventory_item_id,
391: nvl(decode(l_pegging_granularity, 1, md.parent_model_item_id, md.top_model_item_id), -23453)
392: ) pg,
393: msc_apcc_item_d msi,
394: msc_trading_partners mtp
395: where ms.plan_id = msi.plan_id
396: and decode(sign(ms.sr_instance_id), -1, l_sr_instance_id, ms.sr_instance_id) = msi.sr_instance_id
397: and decode(sign(ms.organization_id), -1, msc_hub_calendar.get_item_org(p_plan_id, ms.inventory_item_id,
398: decode(sign(ms.sr_instance_id), -1, l_sr_instance_id, ms.sr_instance_id)),

Line 1206: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp,';

1202: ' fnd_global.user_id, sysdate,'||
1203: ' fnd_global.user_id, sysdate, fnd_global.login_id'||
1204: ' from'||
1205: ' '||l_apps_schema||'.msc_supplies_f'||l_suffix||' f,'||
1206: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp,';
1207: if (p_source_version >= '12.1.3') then l_sql := l_sql||
1208: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp2,'||
1209: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp3,'||
1210: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp4,'||

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

1204: ' from'||
1205: ' '||l_apps_schema||'.msc_supplies_f'||l_suffix||' f,'||
1206: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp,';
1207: if (p_source_version >= '12.1.3') then l_sql := l_sql||
1208: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp2,'||
1209: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp3,'||
1210: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp4,'||
1211: ' '||l_apps_schema||'.msc_phub_customers_mv'||l_suffix||' cmv,'||
1212: ' '||l_apps_schema||'.msc_items'||l_suffix||' mi2,'||

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

1205: ' '||l_apps_schema||'.msc_supplies_f'||l_suffix||' f,'||
1206: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp,';
1207: if (p_source_version >= '12.1.3') then l_sql := l_sql||
1208: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp2,'||
1209: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp3,'||
1210: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp4,'||
1211: ' '||l_apps_schema||'.msc_phub_customers_mv'||l_suffix||' cmv,'||
1212: ' '||l_apps_schema||'.msc_items'||l_suffix||' mi2,'||
1213: ' '||l_apps_schema||'.msc_items'||l_suffix||' mi3,';

Line 1210: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp4,'||

1206: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp,';
1207: if (p_source_version >= '12.1.3') then l_sql := l_sql||
1208: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp2,'||
1209: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp3,'||
1210: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp4,'||
1211: ' '||l_apps_schema||'.msc_phub_customers_mv'||l_suffix||' cmv,'||
1212: ' '||l_apps_schema||'.msc_items'||l_suffix||' mi2,'||
1213: ' '||l_apps_schema||'.msc_items'||l_suffix||' mi3,';
1214: end if;

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

1315: ' fnd_global.user_id, sysdate,'||
1316: ' fnd_global.user_id, sysdate, fnd_global.login_id'||
1317: ' from'||
1318: ' '||l_apps_schema||'.msc_item_wips_f'||l_suffix||' f,'||
1319: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp,'||
1320: ' '||l_apps_schema||'.msc_items'||l_suffix||' mi'||
1321: ' where f.plan_run_id=:p_plan_run_id'||
1322: ' and f.aggr_type=0'||
1323: ' and mtp.partner_type(+)=3'||