VIEW: APPS.AMS_LIST_SRC_TYPES_VL

Source

View Text - Preformatted

SELECT types.LIST_SOURCE_TYPE_ID , types.LAST_UPDATE_DATE , types.LAST_UPDATED_BY , types.CREATION_DATE , types.CREATED_BY , types.LAST_UPDATE_LOGIN , types.OBJECT_VERSION_NUMBER , types.LIST_SOURCE_TYPE , types.SOURCE_TYPE_CODE , types.SOURCE_OBJECT_NAME , types.MASTER_SOURCE_TYPE_FLAG , types.SOURCE_OBJECT_PK_FIELD , types.ENABLED_FLAG , tl.DESCRIPTION , types.view_application_id , tl.list_source_name , types.java_class_name , types.ARC_ACT_SRC_USED_BY, types.SOURCE_CATEGORY, types.import_type, types.remote_flag, types.database_link, types.seeded_flag, types.rowid, types.security_group_id, types.based_on_tca_flag from ams_list_src_types types, ams_list_src_types_tl tl WHERE types.list_source_type_id = tl.list_source_type_id and tl.language = userenv('LANG')

View Text - HTML Formatted

SELECT TYPES.LIST_SOURCE_TYPE_ID
, TYPES.LAST_UPDATE_DATE
, TYPES.LAST_UPDATED_BY
, TYPES.CREATION_DATE
, TYPES.CREATED_BY
, TYPES.LAST_UPDATE_LOGIN
, TYPES.OBJECT_VERSION_NUMBER
, TYPES.LIST_SOURCE_TYPE
, TYPES.SOURCE_TYPE_CODE
, TYPES.SOURCE_OBJECT_NAME
, TYPES.MASTER_SOURCE_TYPE_FLAG
, TYPES.SOURCE_OBJECT_PK_FIELD
, TYPES.ENABLED_FLAG
, TL.DESCRIPTION
, TYPES.VIEW_APPLICATION_ID
, TL.LIST_SOURCE_NAME
, TYPES.JAVA_CLASS_NAME
, TYPES.ARC_ACT_SRC_USED_BY
, TYPES.SOURCE_CATEGORY
, TYPES.IMPORT_TYPE
, TYPES.REMOTE_FLAG
, TYPES.DATABASE_LINK
, TYPES.SEEDED_FLAG
, TYPES.ROWID
, TYPES.SECURITY_GROUP_ID
, TYPES.BASED_ON_TCA_FLAG
FROM AMS_LIST_SRC_TYPES TYPES
, AMS_LIST_SRC_TYPES_TL TL
WHERE TYPES.LIST_SOURCE_TYPE_ID = TL.LIST_SOURCE_TYPE_ID
AND TL.LANGUAGE = USERENV('LANG')