Saturday, 20 May 2017

How to find an invalid objects count in Oracle Apps ?

select  COUNT(*),owner, object_type
from    all_objects
where STATUS = 'INVALID'
GROUP BY owner, object_type
ORDER BY owner, object_type;

No comments:

Post a Comment

Query to find request set and its responsibility

  SELECT FA.application_name,        fr.responsibility_name program_attached_to,        frg.request_group_name,        fcp.request_set_name,...