SELECT [00150_BASIS_PLANNED_BUYS_ALL].BuyPlanID AS Expr1, [00150_BASIS_PLANNED_BUYS_ALL].TYCOM AS Expr2, [00150_BASIS_PLANNED_BUYS_ALL].Community AS Expr3, [00150_BASIS_PLANNED_BUYS_ALL].OBLOC AS Expr4, [00150_BASIS_PLANNED_BUYS_ALL].TOA AS Expr5, [00150_BASIS_PLANNED_BUYS_ALL].TOA_SECTION AS Expr6, [00150_BASIS_PLANNED_BUYS_ALL].FACILITY AS Expr7, [00150_BASIS_PLANNED_BUYS_ALL].ASSEMBLY_EC [00150_BASIS_PLANNED_BUYS_ALL].ASSEMBLY_EC_DESC, [00150_BASIS_PLANNED_BUYS_ALL].BuyType AS Expr10, [00150_BASIS_PLANNED_BUYS_ALL].FundingLine AS Expr11, [00150_BASIS_PLANNED_BUYS_ALL].Control_Type, [00150_BASIS_PLANNED_BUYS_ALL].FundCtrlID, [00150_BASIS_PLANNED_BUYS_ALL].[Exists_Control_$] AS Expr14, [00150_BASIS_PLANNED_BUYS_ALL].ILS_Factor AS Expr15, [00150_BASIS_PLANNED_BUYS_ALL].BuyListID AS Expr16, [00150_BASIS_PLANNED_BUYS_ALL].[AssyEC/NSN/Item] AS Expr17, [00150_BASIS_PLANNED_BUYS_ALL].ItemDescr AS Expr18, [00150_BASIS_PLANNED_BUYS_ALL].[UNIT_COST$] AS Expr19, [00150_BASIS_PLANNED_BUYS_ALL].AAO AS Expr20, [00150_BASIS_PLANNED_BUYS_ALL].[On-Hand(Prime)] AS Expr21, [00150_BASIS_PLANNED_BUYS_ALL].[On-Hand(Sub)] AS Expr22, [00150_BASIS_PLANNED_BUYS_ALL].OA_FY13 AS Expr23, [00150_BASIS_PLANNED_BUYS_ALL].OA_FY14 AS Expr24, [00150_BASIS_PLANNED_BUYS_ALL].OA_FY15 AS Expr25, [00150_BASIS_PLANNED_BUYS_ALL].OA_FY16 AS Expr26, [00150_BASIS_PLANNED_BUYS_ALL].OA_FY17 AS Expr27, [00150_BASIS_PLANNED_BUYS_ALL].OA_FY18 AS Expr28, [00150_BASIS_PLANNED_BUYS_ALL].FundedNotOnOrder AS Expr29, [00150_BASIS_PLANNED_BUYS_ALL].DueIn AS Expr30, [00150_BASIS_PLANNED_BUYS_ALL].Deferred AS Expr31, [00150_BASIS_PLANNED_BUYS_ALL].[IOShorts(TOAARS)] AS Expr32, [00150_BASIS_PLANNED_BUYS_ALL].FY13_Buys_Shorts AS Expr33, [00150_BASIS_PLANNED_BUYS_ALL].FY13_Buys_OA AS Expr34, [00150_BASIS_PLANNED_BUYS_ALL].FY14_Buys_Shorts AS Expr35, [00150_BASIS_PLANNED_BUYS_ALL].FY14_Buys_OA AS Expr36, [00150_BASIS_PLANNED_BUYS_ALL].FY15_Buys_Shorts AS Expr37, [00150_BASIS_PLANNED_BUYS_ALL].FY15_Buys_OA AS Expr38, [00150_BASIS_PLANNED_BUYS_ALL].FY16_Buys_Shorts AS Expr39, [00150_BASIS_PLANNED_BUYS_ALL].FY16_Buys_OA AS Expr40, [00150_BASIS_PLANNED_BUYS_ALL].FY17_Buys_Shorts AS Expr41, [00150_BASIS_PLANNED_BUYS_ALL].FY17_Buys_OA AS Expr42, [00150_BASIS_PLANNED_BUYS_ALL].FY18_Buys_Shorts AS Expr43, [00150_BASIS_PLANNED_BUYS_ALL].FY18_Buys_OA AS Expr44, [00150_BASIS_PLANNED_BUYS_ALL].Remarks AS Expr45, [00150_BASIS_PLANNED_BUYS_ALL].TOTAL_Buys_Shorts AS Expr46, [00150_BASIS_PLANNED_BUYS_ALL].TOTAL_Buys_OA AS Expr47, [00150_BASIS_PLANNED_BUYS_ALL].TOTAL_BUYS AS Expr48, ([FY13_Buys_Shorts]*[UNIT_COST$]*ToThePowerOf(GetSYSVar("INFLT"),1)) AS [FY13_Buy$_Shorts], ([FY13_Buys_OA]*[UNIT_COST$]*ToThePowerOf(GetSYSVar("INFLT"),1)) AS [FY13_Buy$_OA], CCur([ILS_Factor]*(nz([FY13_Buy$_Shorts],0)+nz([FY13_Buy$_OA],0))) AS [FY13_ILS_$], ([FY14_Buys_Shorts]*[UNIT_COST$]*ToThePowerOf(GetSYSVar("INFLT"),2)) AS [FY14_Buy$_Shorts], ([FY14_Buys_OA]*[UNIT_COST$]*ToThePowerOf(GetSYSVar("INFLT"),2)) AS [FY14_Buy$_OA], CCur([ILS_Factor]*(nz([FY14_Buy$_Shorts],0)+nz([FY14_Buy$_OA],0))) AS [FY14_ILS_$], ([FY15_Buys_Shorts]*[UNIT_COST$]*ToThePowerOf(GetSYSVar("INFLT"),3)) AS [FY15_Buy$_Shorts], ([FY15_Buys_OA]*[UNIT_COST$]*ToThePowerOf(GetSYSVar("INFLT"),3)) AS [FY15_Buy$_OA], CCur([ILS_Factor]*(nz([FY15_Buy$_Shorts],0)+nz([FY15_Buy$_OA],0))) AS [FY15_ILS_$], ([FY16_Buys_Shorts]*[UNIT_COST$]*ToThePowerOf(GetSYSVar("INFLT"),4)) AS [FY16_Buy$_Shorts], ([FY16_Buys_OA]*[UNIT_COST$]*ToThePowerOf(GetSYSVar("INFLT"),4)) AS [FY16_Buy$_OA], CCur([ILS_Factor]*(nz([FY16_Buy$_Shorts],0)+nz([FY16_Buy$_OA],0))) AS [FY16_ILS_$], ([FY17_Buys_Shorts]*[UNIT_COST$]*ToThePowerOf(GetSYSVar("INFLT"),5)) AS [FY17_Buy$_Shorts], ([FY17_Buys_OA]*[UNIT_COST$]*ToThePowerOf(GetSYSVar("INFLT"),5)) AS [FY17_Buy$_OA], CCur([ILS_Factor]*(nz([FY17_Buy$_Shorts],0)+nz([FY17_Buy$_OA],0))) AS [FY17_ILS_$], ([FY18_Buys_Shorts]*[UNIT_COST$]) AS [FY18_Buy$_Shorts], ([FY18_Buys_OA]*[UNIT_COST$]) AS [FY18_Buy$_OA], CCur([ILS_Factor]*(nz([FY18_Buy$_Shorts],0)+nz([FY18_Buy$_OA],0))) AS [FY18_ILS_$], [FY18_Buy$_Shorts]+[FY13_Buy$_Shorts]+[FY14_Buy$_Shorts]+[FY15_Buy$_Shorts]+[FY16_Buy$_Shorts]+[FY17_Buy$_Shorts] AS [Total_Buy$_Shorts], [FY18_Buy$_OA]+[FY13_Buy$_OA]+[FY14_Buy$_OA]+[FY15_Buy$_OA]+[FY16_Buy$_OA]+[FY17_Buy$_OA] AS [Total_Buy$_OA], [FY18_ILS_$]+[FY13_ILS_$]+[FY14_ILS_$]+[FY15_ILS_$]+[FY16_ILS_$]+[FY17_ILS_$] AS [Total_Buy$_ILS], [Total_Buy$_Shorts]+[Total_Buy$_OA]+[Total_Buy$_ILS] AS [TOTAL_BUY$]
FROM 00150_BASIS_PLANNED_BUYS_ALL;