VIEW: APPS.AMS_LIST_SRC_FIELDS_VL

Source

View Text - Preformatted

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, fields.column_type 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')

View Text - HTML Formatted

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
, FIELDS.COLUMN_TYPE
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')