Product: | AMS - Marketing |
---|---|
Description: | Muti Lingual view based for list source types |
Implementation/DBA Data: | APPS.AMS_LIST_SRC_TYPES_VL |
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')