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 1092: msc_company_sites cs

1088: BEGIN
1089: select cs.company_site_id
1090: into l_customer_site_id
1091: from msc_trading_partner_maps m,
1092: msc_company_sites cs
1093: where m.tp_key = p_customer_site_id and
1094: m.map_type = 3 and
1095: cs.company_site_id = m.company_key;
1096: EXCEPTION

Line 1110: from msc_company_sites cs,

1106: if p_org_id is not null and p_sr_instance_id is not null then
1107: BEGIN
1108: select distinct cs.company_site_id
1109: into l_supplier_site_id
1110: from msc_company_sites cs,
1111: msc_trading_partner_maps m,
1112: msc_trading_partners t
1113: where t.sr_tp_id = p_org_id and
1114: t.sr_instance_id = p_sr_instance_id and