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
----------- ------------ ------------------ - - - - --------- ------------------------------ - ---------- --------- --------------- -
3244 udkfinp07 Y Y Y Y 26-APR-17 DBOFINP1 R 5 26-APR-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 26-JUL-06 DBOFINP1 G 5 26-JUL-06 5 Y
View Snapshot
APPL_TOP_ID NAME DESCRIPTION S S S S CREATION_ APPLICATIONS_SYSTEM_NAME A CREATED_BY LAST_UPDA LAST_UPDATED_BY A
----------- ------------ ------------------ - - - - --------- ------------------------------ - ---------- --------- --------------- -
169 *PRESEEDED* Fake APPL_TOP for 29-OCT-04 *PRESEEDED*-11i S 5 29-OCT-04 5 Y
PRESEEDED 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
2241 udkfinp03 Y Y Y Y 04-APR-17 DBOFINP1 R 5 04-APR-17 5 Y
select * from ad_snapshots;
SNAPSHOT_ID RELEASE_ID APPL_TOP_ID SNAPSHOT_NAME SNAPSHOT_ SNAPSHOT_ S COMMENTS R I CREATION_ LAST_UPDA LAST_UPDATED_BY CREATED_BY
----------- ---------- ----------- ------------------------- --------- --------- - --------------- - - --------- --------- --------------- ----------
7175 2156 2233 CURRENT_VIEW 30-NOV-12 24-JAN-17 C Current View Y 26-JAN-17 26-JAN-17 5 5
6175 2156 1233 CURRENT_VIEW 16-DEC-16 20-JAN-17 P Current View Y 16-DEC-16 17-JAN-17 5 5
6176 2156 209 GLOBAL_VIEW 16-DEC-16 24-JAN-17 G Created from Cu N 16-DEC-16 20-JAN-17 5 5
rrent View Snap
shots
5173 2156 1233 CURRENT_VIEW 30-NOV-12 24-JAN-17 C Current View Y 30-NOV-12 20-JAN-17 5 5
5174 2156 209 GLOBAL_VIEW 30-NOV-12 17-JAN-17 Q Created from Cu N 30-NOV-12 17-JAN-17 5 5
rrent View Snap
shots
5175 2155 231 *PRESEEDED*12.2.0.0 08-DEC-16 16-DEC-16 B Preseeded Y 08-DEC-16 16-DEC-16 5 5