Product: | AMS - Marketing |
---|---|
Description: | Muti Lingual view based for list source fields |
Implementation/DBA Data: | APPS.AMS_LIST_SRC_FIELDS_VL |
SELECT FIELDS.LIST_SOURCE_FIELD_ID
, FIELDS.LAST_UPDATE_DATE
, FIELDS.LAST_UPDATED_BY
, FIELDS.CREATION_DATE
, FIELDS.CREATED_BY
, FIELDS.LAST_UPDATE_LOGIN
, FIELDS.OBJECT_VERSION_NUMBER
, FIELDS.DE_LIST_SOURCE_TYPE_CODE
, FIELDS.LIST_SOURCE_TYPE_ID
, FIELDS.FIELD_TABLE_NAME
, FIELDS.FIELD_COLUMN_NAME
, FIELDS.SOURCE_COLUMN_NAME
, TL.SOURCE_COLUMN_MEANING
, FIELDS.ENABLED_FLAG
, FIELDS.START_POSITION
, FIELDS.END_POSITION
, FIELDS.FIELD_DATA_TYPE
, FIELDS.FIELD_DATA_SIZE
, FIELDS.DEFAULT_UI_CONTROL
, FIELDS.FIELD_LOOKUP_TYPE
, FIELDS.FIELD_LOOKUP_TYPE_VIEW_NAME
, FIELDS.ALLOW_LABEL_OVERRIDE
, FIELDS.FIELD_USAGE_TYPE
, FIELDS.DIALOG_ENABLED
, FIELDS. ANALYTICS_FLAG
, FIELDS.AUTO_BINNING_FLAG
, FIELDS. NO_OF_BUCKETS
, FIELDS.ATTB_LOV_ID
, FIELDS. TCA_COLUMN_ID
, FIELDS.USED_IN_LIST_ENTRIES
, FIELDS.CHART_ENABLED_FLAG
, FIELDS.DEFAULT_CHART_TYPE
, FIELDS.LOV_DEFINED_FLAG
, FIELDS.USE_FOR_SPLITTING_FLAG
, FIELDS.ROWID
, FIELDS.SECURITY_GROUP_ID
FROM AMS_LIST_SRC_FIELDS FIELDS
, AMS_LIST_SRC_FIELDS_TL TL
WHERE FIELDS.LIST_SOURCE_FIELD_ID = TL.LIST_SOURCE_FIELD_ID
AND TL.LANGUAGE = USERENV('LANG')