Query to check file Version
SELECT
- fi.file_id,
filename,
version,
- fi.creation_date file_creation_date,
- ve.creation_date Version_Creation_date
FROM
- apps.ad_files fi,
- apps.ad_file_versions ve
WHERE filename LIKE '%pav0212.odf%'
AND ve.file_id = fi.file_id
order by ve.creation_date desc;
Is this a valid query to verify the file versions?.
When i run this query it shows two versions
Thanks
Lalitha