APPS.MSC_PHUB_PKG dependencies on MSC_TRADING_PARTNERS

Line 367: from msc_trading_partners mtp, msd_dem_app_instance_orgs daio

363: msd_dp_ascp_scenarios_v das,
364: msd_dp_scenario_revisions dsr,
365: msd_dem_transfer_query tq,
366: (select mtp.sr_instance_id, mtp.sr_tp_id
367: from msc_trading_partners mtp, msd_dem_app_instance_orgs daio
368: where daio.organization_id=nvl(fnd_profile.value('MSD_DEM_MASTER_ORG'), -23453)
369: and mtp.organization_code=daio.organization_code
370: and mtp.partner_type=3
371: union all select to_number(-23453), to_number(-23453) from dual) o

Line 1935: msc_trading_partners mtp

1931: sysdate,
1932: fnd_global.user_id,
1933: fnd_global.login_id
1934: from msc_instance_orgs mio,
1935: msc_trading_partners mtp
1936: where mio.sr_instance_id = p_sr_instance_id
1937: and mio.sr_instance_id = mtp.sr_instance_id
1938: and mio.organization_id = mtp.sr_tp_id
1939: and mtp.partner_type = 3;