DBA Data[Home] [Help]

APPS.MSD_SCE_PUBLISH_FORECAST_PKG dependencies on MSD_DP_SCE_SCN_ENTRIES_V

Line 130: from msd_dp_sce_scn_entries_v fcst,

126: fcst.sr_organization_id, --Source Partner Org Id
127: fcst.sr_instance_id, --Source Partner Instance Id,
128: ts1.shipping_control, --Shipping control method
129: MSD_SCE_RECEIVE_FORECAST_PKG.get_intrasit_lead_time(t.sr_instance_id, t.sr_tp_id, tsi1.location_id)
130: from msd_dp_sce_scn_entries_v fcst,
131: msc_system_items item,
132: msc_company_sites cs,
133: msc_company_sites cs1,
134: msc_companies c,

Line 233: msd_dp_sce_scn_entries_v dp

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
237: site.sr_company_id = -1 and