SELECT *, stock_quantity - isnull(,0) - isnull(,0) - isnull(,0) - isnull(,0) - isnull(,0) - isnull(,0) - isnull(,0) - isnull(,0) - isnull(,0) - isnull(,0) - isnull(,0) - isnull(over5y_QUANTITY,0) as '9999_quantity', stock_value - isnull(,0) - isnull(,0) - isnull(,0) - isnull(,0) - isnull(,0) - isnull(,0) - isnull(,0) - isnull(,0) - isnull(,0) - isnull(,0) - isnull(,0) - isnull(over5y_value,0) as '9999_value' FROM (SELECT FMONTH, replace(ltrim(replace(PRODUCT_NUM, '0', ' ')), ' ', '0') as PRODUCT_NUM, PRODUCT_NAME, specification, STOCK_UNITS, MATERIAL_GROUP, MATERIAL_GROUP_description, Evaluation_class, business_division_code, business_division_name, stock_class, actual_cost, stock_quantity, stock_value, turnover_quantity, , , , , , , , , , , , , , , , , , , , , , , over5y_QUANTITY, over5y_VALUE, ETL_DATE, E9999_QUANTITY, E9999_VALUE, CONSUME_QUANTITY, TURNOVER_RATE, TURNOVER_DAYFROM DM_T01_STOCK_TOTAL) TAAAA where 1=1${if(len(pPRODUCT_NUM) == 0,"","and PRODUCT_NUM = '" + pPRODUCT_NUM + "'")}${if(len(DATE) == 0,"","and FMONTH = '" + DATE + "'")}${if(len(pSTOCK_CLASS) == 0,"","and STOCK_CLASS = '" + pSTOCK_CLASS + "'")}${if(len(pbusiness_division_name) == 0,"","and business_division_name = '" + pbusiness_division_name + "'")} ${if(len(pEvaluation_class) == 0,"","and Evaluation_class = '" + pEvaluation_class + "'")} ${if(JOINARRAY(GETUSERDEPARTMENTS(),"") = "IDC事业部","and Evaluation_class in('半成品','成品')","")}${if(JOINARRAY(GETUSERDEPARTMENTS(),"") = "电力事业部","and Evaluation_class in('半成品','成品')","")}${if(JOINARRAY(GETUSERDEPARTMENTS(),"") = "站点能源事业部","and Evaluation_class in('半成品','成品')","")}ORDER BY PRODUCT_NUM
