Pre Patch Analysis:
SELECT a.bug_no,
app.application_name,
a.DIRECTORY,
a.filename,
a.old_version,
a.new_version,
DECODE (a.typeid,
'not applied',
'Unchanged File',
'upgrade',
'Changed File',
'new',
'New')
change_type
FROM apps.fnd_imp_psmaster_vl a, apps.fnd_application_vl app
WHERE a.bug_no in ('35865350','36033961','36178678','36211820','36247239','36328493','36349505','36370240','36397384','36548655','36564407','36592636','36606890','36214033','36591466')
AND app.application_short_name = a.app_short_name
ORDER BY DECODE (a.typeid,
'not applied',
'Unchanged File',
'upgrade',
'Changed File',
'new',
'New') ASC;
No comments:
Post a Comment