EOFFICE - GD4

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