Oracle Apps Content Module SQL Query to check files mis match
SELECT CV.citem_id, CV.attach_file_name, fl.file_name, CV.created_by,
CV.last_updated_by, creation_date, last_update_date, CV.citem_ver_id,
CV.live_citem_ver_id, VERSION, version_status
FROM ibc_citems_v CV, fnd_lobs fl
WHERE fl.file_id = CV.attach_fid AND CV.attach_file_name <> fl.file_name
ORDER BY 1;
SELECT CV.citem_id, CV.attach_file_name, fl.file_name, CV.created_by,
CV.last_updated_by, creation_date, last_update_date, CV.citem_ver_id,
CV.live_citem_ver_id, VERSION, version_status
FROM ibc_citems_v CV, fnd_lobs fl
WHERE fl.file_id = CV.attach_fid AND CV.attach_file_name <> fl.file_name
ORDER BY 1;
No comments:
Post a Comment