SQL> select * from ad_appl_tops ; APPL_TOP_ID NAME DESCRIPTION S S S S CREATION_ APPLICATIONS_SYSTEM_NAME A CREATED_BY LAST_UPDA LAST_UPDATED_BY A ----------- ---------- ------------------------- - - - - --------- ------------------------------ - ---------- --------- --------------- - 4245 udkfinp08 Y Y Y Y 12-MAY-17 DBOFINP1 R 5 12-MAY-17 5 Y 210 appsun01 Y Y Y Y 02-JAN-07 PRODXB19-11i R 5 02-JAN-07 5 Y 230 appsun13 R12 Related Y Y Y Y 02-JAN-07 DBOFINP1 R 1 02-JAN-07 1 Y 231 *PRESEEDED R12 PRESEEDED 02-JAN-07 *PRESEEDED* S 1 02-JAN-07 1 Y * 232 appsun02 Y Y Y Y 23-JAN-08 DBOFINP1 R 5 23-JAN-08 5 Y 2242 udkfinp04 Y Y Y Y 10-APR-17 DBOFINP1 R 5 10-APR-17 5 Y 3243 udkfinp06 Y Y Y Y 25-APR-17 DBOFINP1 R 5 25-APR-17 5 Y 1232 appsun03 Y Y Y Y 02-APR-09 DBOFINP1 R 5 02-APR-09 5 Y 209 GLOBAL Created for Global View S 26-JUL-06 DBOFINP1 G 5 26-JUL-06 5 Y napshot 169 *PRESEEDED Fake APPL_TOP for PRESEED 29-OCT-04 *PRESEEDED*-11i S 5 29-OCT-04 5 Y * ED Baseline 189 ap981sun Y Y Y Y 15-JUL-06 DBOFINP1 R 5 15-JUL-06 5 Y 2244 udkfinp05 Y Y Y Y 11-APR-17 DBOFINP1 R 5 11-APR-17 5 Y 3245 udkfinp07 Y Y Y Y 27-APR-17 DBOFINP1 R 5 27-APR-17 5 Y 2241 udkfinp03 Y Y Y Y 04-APR-17 DBOFINP1 R 5 04-APR-17 5 Y 14 rows selected. SQL> select * from ad_timestamps ; TYPE ATTRIBUTE TIMESTAMP ATTRIBUTE1 ATTRIBUTE2 ATTRI ATTRI ATTRI ATTRI ATTRI ATTRI ATTRI ATTRI -------------------------------------------------- ------------------ --------------- --------------- --------------- ----- ----- ----- ----- ----- ----- ----- ----- AD-R12 1 02-JAN-07 INSTANTIATED_GLOBAL_VIEW_SNAPSHOT PRODXB19 02-JAN-07 INSTANTIATED_GLOBAL_VIEW_SNAPSHOT RUP4BLP 22-OCT-07 ADR12-NEWPRODS 1 02-JAN-07 INSTANTIATED_GLOBAL_VIEW_SNAPSHOT PRODPACK 23-JAN-08 BACKFILLED_BUGS_IN_CURRENT_VIEW_SNAPSHOT2 RIPRD34*ap981sun 27-OCT-04 AD_TASK_TIMING_DATA_MODEL_CHANGE 2 02-JAN-07 APPS_NE Creation 1 29-NOV-12 HANGING_FLAG 45883 12-JAN-17 Invoker Maintenance Last Run 20-JAN-17 Pre-seeded checkfile tables 11.5.5 30-MAY-02 COUNTS_FOR_ANALYZE TASK_TIMING 24-JAN-17 585175 587315 COUNTS_FOR_ANALYZE SNAPSHOT 24-JAN-17 3651936 3652014 INSTANTIATED_GLOBAL_VIEW_SNAPSHOT PRODR12 26-JUL-06 COUNTS_FOR_ANALYZE PATCH_HIST 24-JAN-17 1349007 1354250 INSERTED_SNAPSHOT_BUG_DELTAS 11.5.9 27-OCT-04 Purge arguments column in ad_task_timing tables 27-OCT-04 Purge restart_time column in ad_task_timing tables 27-OCT-04 INITIALIZED IREP_GATHERED_FLAG DATA RIPRD34*ap981sun 27-OCT-04 Pre-seeded snapshot tables 11.5.10 29-OCT-04 HANGING_FLAG 32875 16-DEC-16