SELECT TO_CHAR(GROUP_ID) , GROUP_DESCRIPTION , 1 FROM CST_ITEM_CST_DTLS_INTERFACE WHERE GROUP_ID IS NOT NULL AND PROCESS_FLAG = 1 AND ERROR_FLAG IS NULL UNION SELECT TO_CHAR(GROUP_ID) , GROUP_DESCRIPTION , 2 FROM CST_RESOURCE_COSTS_INTERFACE CRCI WHERE GROUP_ID IS NOT NULL AND PROCESS_FLAG = 1 AND ERROR_FLAG IS NULL UNION SELECT TO_CHAR(GROUP_ID) , GROUP_DESCRIPTION , 3 FROM CST_DEPT_OVERHEADS_INTERFACE CDOI WHERE GROUP_ID IS NOT NULL AND PROCESS_FLAG = 1 AND ERROR_FLAG IS NULL UNION SELECT TO_CHAR(GROUP_ID) , GROUP_DESCRIPTION , 3 FROM CST_RES_OVERHEADS_INTERFACE CROI WHERE GROUP_ID IS NOT NULL AND PROCESS_FLAG = 1 AND ERROR_FLAG IS NULL