Get LEDGERJOURNALTRANS against Financial dimension of Project , Purpose and Main account

 Get LEDGERJOURNALTRANS against  Financial dimension of Project , Purpose and Main account 

select DIMENSIONATTRIBUTE.NAME, DimensionAttributeLevelValueAllView.DISPLAYVALUE,  DIMENSIONATTRIBUTE2.NAME, DimensionAttributeLevelValueAllView2.DISPLAYVALUE,

 DIMENSIONATTRIBUTE3.NAME, DimensionAttributeLevelValueAllView3.DISPLAYVALUE, AMOUNTCURCREDIT, AMOUNTCURDEBIT from LEDGERJOURNALTRANS

join DimensionAttributeLevelValueAllView on DimensionAttributeLevelValueAllView.VALUECOMBINATIONRECID = LEDGERJOURNALTRANS.LEDGERDIMENSION

join DIMENSIONATTRIBUTE on DIMENSIONATTRIBUTE.RECID =DimensionAttributeLevelValueAllView.DIMENSIONATTRIBUTE

join DimensionAttributeLevelValueAllView as DimensionAttributeLevelValueAllView2 on DimensionAttributeLevelValueAllView2.VALUECOMBINATIONRECID = LEDGERJOURNALTRANS.LEDGERDIMENSION

join DIMENSIONATTRIBUTE as DIMENSIONATTRIBUTE2 on DIMENSIONATTRIBUTE2.RECID = DimensionAttributeLevelValueAllView2.DIMENSIONATTRIBUTE

join DimensionAttributeLevelValueAllView as DimensionAttributeLevelValueAllView3 on DimensionAttributeLevelValueAllView3.VALUECOMBINATIONRECID = LEDGERJOURNALTRANS.LEDGERDIMENSION

join DIMENSIONATTRIBUTE as DIMENSIONATTRIBUTE3 on DIMENSIONATTRIBUTE3.RECID = DimensionAttributeLevelValueAllView3.DIMENSIONATTRIBUTE

where DIMENSIONATTRIBUTE2.Name = 'PROJECTS'

and  DIMENSIONATTRIBUTE.Name = 'PURPOSE'

and  DIMENSIONATTRIBUTE3.Name = 'MainAccount'

and DimensionAttributeLevelValueAllView2.DisplayValue = 'PCB-000051'