Wednesday, July 6, 2011

How to check file version in Oracle Apps

Unix Command:
adident Header

ex: adident Header iemsa_outbound.jsp
Output:


SQL:

SELECT a.app_short_name, a.subdir, a.filename, b.version
FROM APPS.AD_FILES A,
APPS.AD_FILE_VERSIONS B
WHERE a.FILENAME IN ('iemsa_outbound.jsp','Agent.class')
AND A.FILE_ID = B.FILE_ID
AND A.APP_SHORT_NAME = 'IEM'
AND b.file_version_id = (SELECT MAX (file_version_id)
FROM APPS.AD_FILE_VERSIONS VER
WHERE VER.FILE_ID = A.FILE_ID
)

No comments:

Post a Comment