APPS.MSC_ITEM_PKG dependencies on MSC_TRADING_PARTNERS

Line 776: msc_trading_partners mtp

772: sum(f.onhand_value) onhand_value,
773: sum(f.scheduled_rept_value) scheduled_rept_value
774: from
775: msc_st_item_orders_f f,
776: msc_trading_partners mtp
777: where f.st_transaction_id=l_transfer_id
778: and mtp.partner_type(+)=3
779: and f.owning_inst_id=mtp.sr_instance_id(+)
780: and f.owning_org_id=mtp.sr_tp_id(+)

Line 1014: msc_trading_partners mtp

1010: and d.query_id=l_qid_last_date1
1011: and f.period_start_date <= d.date2
1012: ) t,
1013: msc_apcc_item_d i,
1014: msc_trading_partners mtp
1015: where t.rn=1
1016: and t.plan_id=i.plan_id
1017: and t.sr_instance_id=i.sr_instance_id
1018: and t.organization_id=i.organization_id

Line 1119: msc_trading_partners mtp

1115: and d.query_id=l_qid_last_date1
1116: and f.inventory_date <= d.date2
1117: ) t,
1118: msc_apcc_item_d i,
1119: msc_trading_partners mtp
1120: where t.rn=1
1121: and t.plan_id=i.plan_id
1122: and t.sr_instance_id=i.sr_instance_id
1123: and t.organization_id=i.organization_id

Line 1494: msc_trading_partners mtp,

1490: sum(f.avg_daily_demand) avg_daily_demand,
1491: sum(f.avg_daily_demand_volume) avg_daily_demand_volume
1492: from
1493: msc_st_item_inventory_f f,
1494: msc_trading_partners mtp,
1495: msc_apcc_item_d i
1496: where f.st_transaction_id=l_transfer_id
1497: and mtp.partner_type(+)=3
1498: and f.owning_inst_id=mtp.sr_instance_id(+)

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

1978: ' fnd_global.user_id, sysdate,'||
1979: ' fnd_global.user_id, sysdate, fnd_global.login_id'||
1980: ' from'||
1981: ' '||l_apps_schema||'.msc_item_inventory_f'||l_suffix||' f,'||
1982: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp,'||
1983: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp2,'||
1984: ' '||l_apps_schema||'.msc_items'||l_suffix||' mi'||
1985: ' where f.plan_run_id=:p_plan_run_id'||
1986: ' and f.aggr_type=0'||

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

1979: ' fnd_global.user_id, sysdate, fnd_global.login_id'||
1980: ' from'||
1981: ' '||l_apps_schema||'.msc_item_inventory_f'||l_suffix||' f,'||
1982: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp,'||
1983: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp2,'||
1984: ' '||l_apps_schema||'.msc_items'||l_suffix||' mi'||
1985: ' where f.plan_run_id=:p_plan_run_id'||
1986: ' and f.aggr_type=0'||
1987: ' and mtp.partner_type(+)=3'||

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

2169: ' fnd_global.user_id, sysdate,'||
2170: ' fnd_global.user_id, sysdate, fnd_global.login_id'||
2171: ' from'||
2172: ' '||l_apps_schema||'.msc_item_orders_f'||l_suffix||' f,'||
2173: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp,'||
2174: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp2,'||
2175: ' '||l_apps_schema||'.msc_items'||l_suffix||' mi'||
2176: ' where f.plan_run_id=:p_plan_run_id'||
2177: ' and f.aggr_type=0'||

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

2170: ' fnd_global.user_id, sysdate, fnd_global.login_id'||
2171: ' from'||
2172: ' '||l_apps_schema||'.msc_item_orders_f'||l_suffix||' f,'||
2173: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp,'||
2174: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp2,'||
2175: ' '||l_apps_schema||'.msc_items'||l_suffix||' mi'||
2176: ' where f.plan_run_id=:p_plan_run_id'||
2177: ' and f.aggr_type=0'||
2178: ' and mtp.partner_type(+)=3'||