SELECT
hddsb.data_file_name,
hdds.ucm_content_id,
hdds.creation_date,
hdds.data_set_name,
hdds.imported_status,
hdds.loaded_status,
hdds.import_lines_success_count,
hdds.import_lines_error_count,
hdds.import_lines_total_count,
hdds.import_success_count,
hdds.import_error_count,
hdds.loaded_count,
hdds.error_count,
hdpl.pval018 assignment_number,
hdpl.pval008 element_name,
hdpl.pval010 ldg,
hdpl.imported_status import_status,
hdll.validated_loaded_status validation_status,
CASE
WHEN hdll.validated_loaded_status = ‘UNPROCESSED’ THEN
‘UNPROCESSED’
ELSE
(
SELECT
msg_text
FROM
hrc_dl_message_lines hdml
WHERE
1 = 1
AND hdpl.data_set_bus_obj_id = hdml.data_set_bus_obj_id
AND hdml.message_source_line_id = hdll.logical_line_id
and rownum = 1
)
END error_message_1,
CASE
WHEN hdll.validated_loaded_status = ‘UNPROCESSED’ THEN
‘UNPROCESSED’
ELSE
(
SELECT
untokenized_message
FROM
hrc_dl_message_lines hdml
WHERE
1 = 1
AND hdpl.data_set_bus_obj_id = hdml.data_set_bus_obj_id
AND hdml.message_source_line_id = hdll.logical_line_id
and rownum = 1
)
END error_message_2
FROM
hrc_dl_data_sets hdds,
hrc_dl_data_set_bus_objs hddsb,
hrc_dl_physical_lines hdpl,
hrc_dl_logical_lines hdll
WHERE
1 = 1
AND hddsb.data_set_id = hdds.data_set_id
AND hdpl.data_set_bus_obj_id = hddsb.data_set_bus_obj_id
AND hdpl.pval013 IS NULL
AND hdds.ucm_content_id IN ( :p_contentid )
AND hdpl.logical_line_id = hdll.logical_line_id

Share this post
Recent Posts

Leave a Comment

Start typing and press Enter to search