DBA Data[Home] [Help]

APPS.MSD_SCE_PUBLISH_FORECAST_PKG dependencies on MSC_TP_SITE_ID_LID

Line 139: msc_tp_site_id_lid tsi1,

135: msc_companies c1,
136: msc_trading_partner_maps m,
137: msc_trading_partner_maps m2,
138: msc_trading_partners t,
139: msc_tp_site_id_lid tsi1,
140: msc_trading_partner_sites ts1
141: -- msc_tp_id_lid ti1
142: where fcst.sr_instance_id = item.sr_instance_id and
143: fcst.sr_organization_id = item.organization_id and

Line 232: from msc_tp_site_id_lid site,

228: ship_to_site_id,
229: source_locations)
230: select distinct site.tp_site_id,
231: 2
232: from msc_tp_site_id_lid site,
233: msd_dp_sce_scn_entries_v dp
234: where site.sr_tp_site_id = dp.sr_geography_id and
235: site.sr_instance_id = dp.sr_instance_id and
236: site.partner_type = 2 and