VIEW: APPS.FND_IMP_PFILEINFO_VL

Source

View Text - Preformatted

SELECT a.bug_number bug_no, b.file_version_guid fileid, c.patch_id from fnd_ums_bugfixes a, fnd_ums_bugfix_file_versions b, ad_pm_patches c WHERE a.bugfix_guid = b.bugfix_guid and (a.bug_number = c.bug_number and a.baseline=c.baseline)

View Text - HTML Formatted

SELECT A.BUG_NUMBER BUG_NO
, B.FILE_VERSION_GUID FILEID
, C.PATCH_ID
FROM FND_UMS_BUGFIXES A
, FND_UMS_BUGFIX_FILE_VERSIONS B
, AD_PM_PATCHES C
WHERE A.BUGFIX_GUID = B.BUGFIX_GUID
AND (A.BUG_NUMBER = C.BUG_NUMBER
AND A.BASELINE=C.BASELINE)