APPS.MSD_SCE_PUBLISH_FORECAST_PKG dependencies on MSC_COMPANY_SITES

Line 132: msc_company_sites cs,

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,
135: msc_companies c1,
136: msc_trading_partner_maps m,

Line 133: msc_company_sites cs1,

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,
135: msc_companies c1,
136: msc_trading_partner_maps m,
137: msc_trading_partner_maps m2,

Line 1058: msc_company_sites cs

1054: BEGIN
1055: select cs.company_site_id
1056: into l_customer_site_id
1057: from msc_trading_partner_maps m,
1058: msc_company_sites cs
1059: where m.tp_key = p_customer_site_id and
1060: m.map_type = 3 and
1061: cs.company_site_id = m.company_key;
1062: EXCEPTION

Line 1076: from msc_company_sites cs,

1072: if p_org_id is not null and p_sr_instance_id is not null then
1073: BEGIN
1074: select distinct cs.company_site_id
1075: into l_supplier_site_id
1076: from msc_company_sites cs,
1077: msc_trading_partner_maps m,
1078: msc_trading_partners t
1079: where t.sr_tp_id = p_org_id and
1080: t.sr_instance_id = p_sr_instance_id and