Wednesday, August 24, 2016

Oracle Apps Content Module SQL Query

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;