Scribd
Upload
43 views1 page

Patch Database Query Overview

The document contains several SQL queries that are selecting data from different database tables and views. The queries are retrieving data like file names, versions, languages, patches, and product names and statuses.

Uploaded by

mluhunk
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
43 views1 page

Patch Database Query Overview

The document contains several SQL queries that are selecting data from different database tables and views. The queries are retrieving data like file names, versions, languages, patches, and product names and statuses.

Uploaded by

mluhunk
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd

SELECT a.app_short_name, a.subdir, a.filename, b.

version
FROM apps.ad_files a,
apps.ad_file_versions b
WHERE a.FILENAME = nvl(:P_NAMA_FILE, a.filename)
AND a.file_id = b.file_id
AND b.creation_date = (SELECT MAX (creation_date)
FROM apps.ad_file_versions ver
WHERE ver.file_id = a.file_id)

SELECT * FROM v$version;

select * from v$database;

Select *from FND_LANGUAGES


where INSTALLED_FLAG = 'I' or INSTALLED_FLAG = 'B';

select AP.PATCH_NAME, AP.PATCH_TYPE, AD.DRIVER_FILE_NAME, AD.CREATION_DATE,


AD.PLATFORM,AL.LANGUAGE
from AD_APPLIED_PATCHES AP, AD_PATCH_DRIVERS AD, AD_PATCH_DRIVER_LANGS AL
where AP.APPLIED_PATCH_ID = AD.APPLIED_PATCH_ID
and AD.PATCH_DRIVER_ID = AL.PATCH_DRIVER_ID;

SELECT V.APPLICATION_NAME PRD, to_char(V.APPLICATION_ID) PRDID, L.MEANING


PRDSTATUS, DECODE(I.PATCH_LEVEL, NULL, '11i.' || v.APPLICATION_SHORT_NAME || '.?',
I.PATCH_LEVEL) patchset
FROM FND_APPLICATION_ALL_VIEW V, FND_PRODUCT_INSTALLATIONS I, FND_LOOKUPS L
WHERE (V.APPLICATION_ID = I.APPLICATION_ID)
AND (L.LOOKUP_TYPE = 'FND_PRODUCT_STATUS')
AND (L.LOOKUP_CODE = I.Status )
ORDER BY 1;

You might also like