SELECT * FROM SYS_PREFIX WHERE ID IN ('CM_DOCUMENT'
,'CM_WAREHOUSE'
,'CM_WAREHOUSE_DT'
,'BOX_DOCUMENT'
,'BOX_DOCUMENT_DT'
,'BOX_DOCUMENT_HIST'
,'REQ_BOR_DOCUMENT'
,'REQ_BOR_DOCUMENT_DT'
,'REQ_OUT_DOCUMENT'
,'REQ_OUT_DOCUMENT_DT'
,'REQ_COL_DOCUMENT'
,'REQ_COL_DOCUMENT_DT'
,'REQ_IN_DOCUMENT_GATHER'
,'REQ_IN_DOCUMENT_GATHER_DT'
,'REQ_BOR_DOCUMENT_GATHER'
,'REQ_BOR_DOCUMENT_GATHER_DT'
,'REQ_OUT_DOCUMENT_GATHER'
,'REQ_OUT_DOCUMENT_GATHER_DT'
,'REQ_COL_DOCUMENT_GATHER'
,'REQ_COL_DOCUMENT_GATHER_DT'
,'REQ_DES_DOCUMENT_GATHER'
,'REQ_DES_DOCUMENT_GATHER_DT')

DELETE FROM CM_DOCUMENT
DELETE FROM CM_WAREHOUSE
DELETE FROM CM_WAREHOUSE_DT
DELETE FROM BOX_DOCUMENT
DELETE FROM BOX_DOCUMENT_DT
DELETE FROM BOX_DOCUMENT_HIST
DELETE FROM REQ_BOR_DOCUMENT
DELETE FROM REQ_BOR_DOCUMENT_DT
DELETE FROM REQ_OUT_DOCUMENT
DELETE FROM REQ_OUT_DOCUMENT_DT
DELETE FROM REQ_COL_DOCUMENT
DELETE FROM REQ_COL_DOCUMENT_DT
DELETE FROM REQ_IN_DOCUMENT_GATHER
DELETE FROM REQ_IN_DOCUMENT_GATHER_DT
DELETE FROM REQ_BOR_DOCUMENT_GATHER
DELETE FROM REQ_BOR_DOCUMENT_GATHER_DT
DELETE FROM REQ_OUT_DOCUMENT_GATHER
DELETE FROM REQ_OUT_DOCUMENT_GATHER_DT
DELETE FROM REQ_COL_DOCUMENT_GATHER
DELETE FROM REQ_COL_DOCUMENT_GATHER_DT
DELETE FROM REQ_DES_DOCUMENT_GATHER
DELETE FROM REQ_DES_DOCUMENT_GATHER_DT