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