SELECT * FROM SYS_CODEMASTERS WHERE Prefix IN (SELECT Prefix 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'))