How To Find History of Package Modification

depend on your need of history : ad_files, ad_file_version, all_objects

exemple:

select f.FILE_ID,

       f.APP_SHORT_NAME "TOP",

       f.SUBDIR,

       f.FILENAME,

       v.file_version_id,

       v.VERSION,

       v.creation_date,

       v.last_update_date,

       fu.USER_NAME "Updated By"

  from ad_files f, ad_file_versions v, fnd_user fu

where f.FILE_ID = v.FILE_ID

and f.FILENAME like 'AppsLocalLogin.jsp'

   and fu.user_id = v.LAST_UPDATED_BY

order by v.last_update_date desc ;

select o.OWNER, o.OWNER, o.CREATED,o.LAST_DDL_TIME,o.TIMESTAMP, o.status, v.TEXT_LENGTH, v.text

from all_views v, all_objects o

where v.view_NAME in ('PA_PROJ_REQ_DISTRIBUTIONS','PA_PROJ_REQ_DISTRIBUTIONS_V','PA_PROJ_REQ_DISTRIBUTIONS_V1')

and o.OWNER = v.OWNER

and o.OBJECT_NAME = v.VIEW_NAME;

Hi Ramaraju

You may also check the column LAST_DDL_TIME in the table dba_objects.

LAST_DDL_TIME Not Changing (Doc ID 1448241.1)

Why LAST_DDL_TIME is not updated after running "CREATE OR REPLACE VIEW"? (Doc ID 862422.1)

Thanks!

N Kandasamy