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