09:22 sfx_gsu4>select
    ->     gt.TARGET_NAME,
    ->     gs.SERVICE_TYPE
    -> from
    ->     sfxglb41.KB_TARGETS         as gt,
    ->     sfxglb41.KB_TARGET_SERVICES as gs,
    ->     LCL_TARGET_INVENTORY        as lt,
    ->     LCL_SERVICE_LINKING_INFO    as ls
    -> where
    ->     ls.AUTO_UPDATE='Y'
    ->     and lt.ACTIVATION_STATUS='ACTIVE'
    ->     and gt.TARGET_ID=lt.TARGET_ID
    ->     and gt.TARGET_ID=gs.TARGET_ID
    ->     and gs.TARGET_SERVICE_ID=ls.TARGET_SERVICE_ID
    -> order by
    ->     gt.TARGET_NAME;
+-------------------------------------------------------------+--------------------+
| TARGET_NAME                                                 | SERVICE_TYPE       |
+-------------------------------------------------------------+--------------------+
| ACM_DIGITAL_LIBRARY                                         | getFullTxt         |
| AMERICAN_CHEMICAL_SOCIETY_LEGACY_ARCHIVE                    | getFullTxt         |
| AMERICAN_PHYSICAL_SOCIETY_PROLA                             | getFullTxt         |
| ANTHROSOURCE                                                | getFullTxt         |
| BIOMED_CENTRAL_OPEN_ACCESS_FREE                             | getFullTxt         |
| BIOMED_CENTRAL_SELECTED_FREE                                | getFullTxt         |
| CHADWYCK_INTERNATIONAL_INDEX_TO_MUSIC_PERIODICALS           | getFullTxt         |
| COLUMBIA_INTERNATIONAL_AFFAIRS_ONLINE_CI                    | getFullTxt         |
| EBSCOHOST_ATLA_SERIALS                                      | getFullTxt         |
| EBSCOHOST_COMM_MASS_MEDIA_COMPLETE                          | getFullTxt         |
| EBSCOHOST_PSYCARTICLES                                      | getFullTxt         |
| ELSEVIER_SD_BACKFILE_ECONOMICS                              | getFullTxt         |
| ELSEVIER_SD_BACKFILE_NURSING_AND_HEALTH                     | getFullTxt         |
| ELSEVIER_SD_BACKFILE_SOCIAL_SCI                             | getFullTxt         |
| EMIS_FREE                                                   | getFullTxt         |
| FACTIVA                                                     | getAbstract        |
| FACTIVA                                                     | getFullTxt         |
| FACTIVA                                                     | getSelectedFullTxt |
| GALEGROUP_GN_BUSINESS_COMPANY_RESOURCE_                     | getFullTxt         |
| GALEGROUP_GN_BUSINESS_COMPANY_RESOURCE_                     | getAbstract        |
| HEIN_ONLINE_LAW_JOURNAL_LIBRARY                             | getFullTxt         |
| HIGHWIRE_PRESS_DUKE_UNIVERSITY_PRESS                        | getFullTxt         |
| HIGHWIRE_PRESS_FREE                                         | getFullTxt         |
| HINDAWI_PUBLISHING_OPEN_ACCESS_JOURNALS_FREE                | getFullTxt         |
| IEEE_XPLORE_JOURNALS                                        | getFullTxt         |
| INSTITUTE_OF_PHYSICS_HISTORICAL_ARCHIVE                     | getFullTxt         |
| INTERNET_SCIENTIFIC_PUBLICATIONS_FREE                       | getFullTxt         |
| JSTOR_ARTS_AND_SCIENCES_1                                   | getFullTxt         |
| JSTOR_ARTS_AND_SCIENCES_2                                   | getFullTxt         |
| JSTOR_ARTS_AND_SCIENCES_3                                   | getFullTxt         |
| JSTOR_ARTS_AND_SCIENCES_4                                   | getFullTxt         |
| JSTOR_ARTS_AND_SCIENCES_5                                   | getFullTxt         |
| JSTOR_ARTS_AND_SCIENCES_7                                   | getFullTxt         |
| JSTOR_HEALTH_AND_GENERAL_SCIENCES                           | getFullTxt         |
| MISCELLANEOUS_FREE_EJOURNALS                                | getFullTxt         |
| PORTICO_ARCHIVE                                             | getFullTxt         |
| PROJECT_MUSE_STANDARD_COLLECTION                            | getFullTxt         |
| PROQUEST_CRIMINAL_JUSTICE_PERIODICAL_INDEX                  | getFullTxt         |
| PROQUEST_ETHNIC_NEWS_WATCH                                  | getFullTxt         |
| PROQUEST_GENDER_WATCH                                       | getFullTxt         |
| PUBMED_CENTRAL_JOURNALS_FREE                                | getFullTxt         |
| SCIELO_FREE                                                 | getFullTxt         |
| SIAM_SOCIETY_FOR_INDUSTRIAL_AND_APPLIED_MATHEMATICS_CURRENT | getFullTxt         |
| SOURCE_OECD_PERIODICALS                                     | getFullTxt         |
| SPRINGER_LINK_HISTORICAL_ARCHIVES_BEHAVI                    | getFullTxt         |
+-------------------------------------------------------------+--------------------+
45 rows in set (0.02 sec)