select	distinct top  100  a118.Marketing_ID  Marketing_ID,
	a122.Marketing_DESC  Marketing_DESC,
	pa11.PLAN_ID  PLAN_ID,
	a119.Plan_DESC  Plan_DESC,
	a117.ASM_ID  ASM_ID,
	a121.ASM_DESC  ASM_DESC,
	pa11.Object_ID  Object_ID,
	a120.Object_DESC  Object_DESC,
	pa12.WJXBFS1  WJXBFS1,
	pa13.WJXBFS1  WJXBFS2,
	pa14.WJXBFS1  WJXBFS3,
	pa15.WJXBFS1  WJXBFS4,
	(ISNULL(pa16.WJXBFS1,  0 ) - ISNULL(pa14.WJXBFS2,  0 ))  WJXBFS5,
	pa15.WJXBFS2  WJXBFS6,
	pa14.WJXBFS3  WJXBFS7,
	pa16.WJXBFS2  WJXBFS8,
	pa17.WJXBFS1  WJXBFS9,
	pa18.WJXBFS1  WJXBFSa,
	pa19.WJXBFS1  WJXBFSb,
	(ISNULL(pa19.WJXBFS2,  0 ) - ISNULL(pa18.WJXBFS2,  0 ))  WJXBFSc,
	pa17.WJXBFS2  WJXBFSd,
	pa18.WJXBFS3  WJXBFSe,
	pa19.WJXBFS3  WJXBFSf,
	(ISNULL(pa19.WJXBFS4,  0 ) - ISNULL(pa18.WJXBFS4,  0 ))  WJXBFS10,
	pa15.WJXBFS3  WJXBFS11,
	pa14.WJXBFS4  WJXBFS12,
	pa16.WJXBFS3  WJXBFS13,
	pa110.WJXBFS1  WJXBFS14,
	pa111.WJXBFS1  WJXBFS15,
	pa112.WJXBFS1  WJXBFS16,
	pa13.WJXBFS2  WJXBFS17,
	pa113.WJXBFS2  WJXBFS18,
	pa114.WJXBFS2  WJXBFS19,
	pa115.WJXBFS2  WJXBFS1a,
	pa110.WJXBFS1  WJXBFS1b,
	pa116.WJXBFS1  WJXBFS1c,
	pa111.WJXBFS1  WJXBFS1d,
	pa14.WJXBFS5  WJXBFS1e,
	pa16.WJXBFS5  WJXBFS1f,
	pa116.WJXBFS2  WJXBFS20,
	pa15.WJXBFS5  WJXBFS21,
	pa16.WJXBFS6  WJXBFS22,
	pa116.WJXBFS3  WJXBFS23,
	pa14.WJXBFS7  WJXBFS24,
	pa112.WJXBFS1  WJXBFS25,
	pa14.WJXBFS8  WJXBFS26,
	pa15.WJXBFS6  WJXBFS27,
	pa16.WJXBFS7  WJXBFS28,
	pa16.WJXBFS8  WJXBFS29
from	#zzTP3073ORVOD00I	pa11
	left outer join	#zzTP3073ORVMD000	pa12
	  on 	(pa11.Object_ID = pa12.Object_ID and 
	pa11.PLAN_ID = pa12.PLAN_ID)
	left outer join	#zzTP3073ORVMD001	pa13
	  on 	(pa11.Object_ID = pa13.Object_ID and 
	pa11.PLAN_ID = pa13.PLAN_ID)
	left outer join	#zzTP3073ORVMD002	pa14
	  on 	(pa11.Object_ID = pa14.Object_ID and 
	pa11.PLAN_ID = pa14.PLAN_ID)
	left outer join	#zzTP3073ORVMD003	pa15
	  on 	(pa11.Object_ID = pa15.Object_ID and 
	pa11.PLAN_ID = pa15.PLAN_ID)
	left outer join	#zzTP3073ORVMD004	pa16
	  on 	(pa11.Object_ID = pa16.Object_ID and 
	pa11.PLAN_ID = pa16.PLAN_ID)
	left outer join	#zzTP3073ORVMD005	pa17
	  on 	(pa11.Object_ID = pa17.Object_ID and 
	pa11.PLAN_ID = pa17.PLAN_ID)
	left outer join	#zzTP3073ORVMD006	pa18
	  on 	(pa11.Object_ID = pa18.Object_ID and 
	pa11.PLAN_ID = pa18.PLAN_ID)
	left outer join	#zzTP3073ORVMD007	pa19
	  on 	(pa11.Object_ID = pa19.Object_ID and 
	pa11.PLAN_ID = pa19.PLAN_ID)
	left outer join	#zzTP3073ORVMD008	pa110
	  on 	(pa11.Object_ID = pa110.Object_ID and 
	pa11.PLAN_ID = pa110.PLAN_ID)
	left outer join	#zzTP3073ORVMD009	pa111
	  on 	(pa11.Object_ID = pa111.Object_ID and 
	pa11.PLAN_ID = pa111.PLAN_ID)
	left outer join	#zzTP3073ORVMD00A	pa112
	  on 	(pa11.Object_ID = pa112.Object_ID and 
	pa11.PLAN_ID = pa112.PLAN_ID)
	left outer join	#zzTP3073ORVMD008	pa113
	  on 	(pa11.Object_ID = pa113.Object_ID and 
	pa11.PLAN_ID = pa113.PLAN_ID)
	left outer join	#zzTP3073ORVMD009	pa114
	  on 	(pa11.Object_ID = pa114.Object_ID and 
	pa11.PLAN_ID = pa114.PLAN_ID)
	left outer join	#zzTP3073ORVMD00A	pa115
	  on 	(pa11.Object_ID = pa115.Object_ID and 
	pa11.PLAN_ID = pa115.PLAN_ID)
	left outer join	#zzTP3073ORVMD00G	pa116
	  on 	(pa11.Object_ID = pa116.Object_ID)
	join	DBA.REL_1_CityASM	a117
	  on 	(pa11.Object_ID = a117.Object_ID)
	join	(select distinct Plan_ID, Marketing_ID  from DBA.REL_Plan
where Marketing_ID not in ( 7 , 16 , 18 , 19 , 20 ) and Marketing_ID in (select distinct Marketing_ID from DBA.LU_Product))	a118
	  on 	(pa11.PLAN_ID = a118.PLAN_ID)
	join	DBA.LU_Plan	a119
	  on 	(pa11.PLAN_ID = a119.PLAN_ID)
	join	DBA.LU_SHOP	a120
	  on 	(pa11.Object_ID = a120.Object_ID)
	join	DBA.LU_ASM	a121
	  on 	(a117.ASM_ID = a121.ASM_ID)
	join	DBA.LU_Marketing	a122
	  on 	(a118.Marketing_ID = a122.Marketing_ID);