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 656: FROM msc_tp_id_lid

652:
653: cursor get_src_cust_id_c1(t_tp_cust_id IN number,
654: t_src_instance_id IN number) IS
655: SELECT sr_tp_id
656: FROM msc_tp_id_lid
657: WHERE tp_id = t_tp_cust_id
658: AND sr_instance_id = t_src_instance_id
659: AND nvl(sr_company_id, -1) = -1
660: AND partner_type = 2;