Install, Upgrade, Clone, Patch - EBS (MOSC)

MOSC Banner

Query to check file Version

edited July 2019 in Install, Upgrade, Clone, Patch - EBS (MOSC) 3 commentsAnswered

SELECT

  1. fi.file_id,

filename,

version,

  1. fi.creation_date file_creation_date,
  • ve.creation_date Version_Creation_date

FROM

  1. apps.ad_files fi,
  2. 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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center