APPS.MSD_SCE_PUBLISH_FORECAST_PKG dependencies on MSC_TP_ID_LID

Line 141: -- msc_tp_id_lid ti1

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
144: fcst.sr_inventory_item_id = item.sr_inventory_item_id and
145: item.plan_id = -1 and

Line 690: FROM msc_tp_id_lid

686:
687: cursor get_src_cust_id_c1(t_tp_cust_id IN number,
688: t_src_instance_id IN number) IS
689: SELECT sr_tp_id
690: FROM msc_tp_id_lid
691: WHERE tp_id = t_tp_cust_id
692: AND sr_instance_id = t_src_instance_id
693: AND nvl(sr_company_id, -1) = -1
694: AND partner_type = 2;