laneboy

exec USP_ReportSpendingNumberSummarySearchForTW @updateType=-1,@HasAgencyAdapted=-1,@HasGroupMAdapted=-1,@AgencyId=2,@MediaTypeId=-1,@SpendingNo=N'0040064A',@BillingMonth=N'201712',@operatorUserid=1,@InvoiceType=-1,@InvestmentCategory=-1
-----------------------

select * from ObjCampaign where ObjCampaignid=37427
select * from mediaspotplanheader where mediaspotplanheaderid=40064

select sequenceID,* from mediaspotplanrow where mediaspotplanheaderid=40064

select hasadepted,HasAgencyAdapted,HasGroupMAdapted,HasExecutingAdepted,* from mediaspotplandetail where mediaspotplanrowid in (
select mediaspotplanrowid from mediaspotplanrow where mediaspotplanheaderid=40064)

select mediaspotplandetailid as did,hasAdepted,* from dbo.MediaSpotPlanDetailChangeLog  where mediaspotplanrowid in (
select mediaspotplanrowid from mediaspotplanrow where mediaspotplanheaderid=40064) order by mediaspotplandetailid ,MediaSpotPlanDetailChangeLogID