select HRC_DL_DATA_SET_BUS_OBJS.DATA_SET_ID as DATA_SET_ID, HRC_DL_DATA_SET_BUS_OBJS.DATA_FILE_NAME as DATA_FILE_NAME, HRC_DL_DATA_SET_BUS_OBJS.PROCESSING_ORDER as PROCESSING_ORDER, HRC_DL_DATA_SET_BUS_OBJS.IMPORTED_STATUS as IMPORTED_STATUS, HRC_DL_DATA_SET_BUS_OBJS.LOADED_STATUS as LOADED_STATUS, HRC_DL_DATA_SET_BUS_OBJS.IMPORT_LINES_SUCCESS_COUNT IMPORT_LINES_SUCCESS_COUNT, HRC_DL_DATA_SET_BUS_OBJS.IMPORT_LINES_ERROR_COUNT IMPORT_LINES_ERROR_COUNT, HRC_DL_DATA_SET_BUS_OBJS.IMPORT_LINES_TOTAL_COUNT as IMPORT_LINES_TOTAL_COUNT, HRC_DL_DATA_SET_BUS_OBJS.IMPORT_SUCCESS_COUNT as IMPORT_SUCCESS_COUNT, HRC_DL_DATA_SET_BUS_OBJS.IMPORT_ERROR_COUNT as IMPORT_ERROR_COUNT, HRC_DL_DATA_SET_BUS_OBJS.LOADED_COUNT as LOADED_COUNT, HRC_DL_DATA_SET_BUS_OBJS.ERROR_COUNT as ERROR_COUNT, HRC_DL_DATA_SET_BUS_OBJS.CORRECTED_COUNT as CORRECTED_COUNT, HRC_DL_DATA_SET_BUS_OBJS.REQUEST_ID as REQUEST_ID, HRC_DL_DATA_SET_BUS_OBJS.CREATED_BY as CREATED_BY, HRC_DL_DATA_SET_BUS_OBJS.CREATION_DATE as CREATION_DATE, HRC_DL_DATA_SET_BUS_OBJS.LAST_UPDATED_BY as LAST_UPDATED_BY, HRC_DL_DATA_SET_BUS_OBJS.LAST_UPDATE_DATE as LAST_UPDATE_DATE
from HRC_DL_DATA_SET_BUS_OBJS HRC_DL_DATA_SET_BUS_OBJS, HRC_DL_DATA_SETS HRC_DL_DATA_SETS
where HRC_DL_DATA_SET_BUS_OBJS.DATA_SET_ID =HRC_DL_DATA_SETS.DATA_SET_ID AND HRC_DL_DATA_SET_BUS_OBJS.REQUEST_ID=HRC_DL_DATA_SETS.REQUEST_ID AND (HRC_DL_DATA_SET_BUS_OBJS.LOADED_STATUS='ERROR' OR HRC_DL_DATA_SET_BUS_OBJS.IMPORTED_STATUS='ERROR') AND HRC_DL_DATA_SETS.UCM_CONTENT_ID IN NVL(:P_CONTENTID,HRC_DL_DATA_SETS.UCM_CONTENT_ID)
order by HRC_DL_DATA_SET_BUS_OBJS.PROCESSING_ORDER ASC
