这是sql语句
"SELECT A.GROUP_NO,\n" + 
"       A.QTY_DATE,\n" + 
"       A.SEQ_ID,\n" + 
"       A.INNER_NO,\n" + 
"       A.SINGLE_BATTERY_NUM,\n" + 
"       A.MADE_DATE,\n" + 
"       A.LOT_NO,\n" + 
"       A.ASSET_NO,\n" + 
"       A.PRODUCT_NO,\n" + 
"       A.MADE_NO,\n" + 
"       A.PR_ORG,\n" + 
"       A.FIRST_RUN_DATE,\n" + 
"       A.LAST_RUN_DATE,\n" + 
"       A.LAST_REPAIR_DATE,\n" + 
"       A.CHIP_FACTORY,\n" + 
"       A.BATTERY_SHAPE,\n" + 
"       A.CHIP_GROUP_TYPE,\n" + 
"       (SELECT ORG_NAME FROM O_ORG WHERE ORG_NO = A.PR_ORG) PR_ORG_NAME,\n" + 
"       A.BELONG_DEPT,\n" + 
"       A.EQIP_PRC,\n" + 
"       N + A.PR_CODE,\n" + 
"       A.CUR_STATUS_CODE,\n" + 
"       A.DOC_CREATOR_NO,\n" + 
"       SUBS_ID,\n" + 
"       (SELECT SUBS_NO FROM C_SUBS WHERE SUBS_ID = A.SUBS_ID) SUBS_NO,\n" + 
"       + (SELECT USER_NAME N +\n" + 
"           FROM P_SYS_USER N +\n" + 
"          WHERE SYS_USER_NAME = A.DOC_CREATOR_NO) DOC_CREATOR_NAME,\n" + 
"       A.DOC_CREATE_DATE,\n" + 
"       N + A.REMARK,\n" + 
"       A.BATTERY_ID,\n" + 
"       A.GROUP_TYPE,\n" + 
"       A.BATTERY_TYPE,\n" + 
"       A.BATTERY_MODEL,\n" + 
"       A.BATTERY_CAPA,\n" + 
"       N + A.BATTERY_SPEC,\n" + 
"       A.RUN_DATE,\n" + 
"       A.MANUFACTURER,\n" + 
"       A.MOBILE,\n" + 
"       A.VALIDATE_CODE,\n" + 
"       A.BAR_CODE,\n" + 
"       A.WH_ID,\n" + 
"       EQUIP_CODE_ID,\n" + 
"       N +\n" + 
"       ((SELECT B.NAME FROM D_WH B WHERE B.WH_ID = A.WH_ID) || N +\n" + 
"       DECODE((SELECT B.NAME FROM D_WH_AREA B WHERE B.ID = A.WH_AREA_ID),\n" + 
"               '',\n" + 
"               '',\n" + 
"               ('>>' ||\n" + 
"               (SELECT B.NAME FROM D_WH_AREA B WHERE B.ID = A.WH_AREA_ID))) || N +\n" + 
"       DECODE((SELECT B.STORE_AREA_NAME\n" + 
"                 FROM D_STORAGE_AREA B\n" + 
"                WHERE B.ID = A.STORE_AREA_ID),\n" + 
"               '',\n" + 
"               '',\n" + 
"               ('>>' || (SELECT B.STORE_AREA_NAME\n" + 
"                           FROM D_STORAGE_AREA B\n" + 
"                          WHERE B.ID = A.STORE_AREA_ID))) || N +\n" + 
"       DECODE((SELECT B.NAME\n" + 
"                 FROM D_STOCK_POS B\n" + 
"                WHERE B.STORE_LOC_ID = A.STORE_LOC_ID),\n" + 
"               '',\n" + 
"               '',\n" + 
"               ('>>' || (SELECT B.NAME\n" + 
"                           FROM D_STOCK_POS B\n" + 
"                          WHERE B.STORE_LOC_ID = A.STORE_LOC_ID)))) LOCATION_INFO +\n" + 
"  FROM D_BATTERY A N +\n" + 
" WHERE A.ASSET_NO = ?;";