FFS_CML_MAP_LAYER_VL

Details

• Schema: FUSION

• Object owner: FFS

• Object type: VIEW

Columns

Name
LAYER_ID LAYER_LABEL LAYER_TYPE LAYER_SOURCE_NAME LAYER_THEME LAYER_URL LAYER_STATUS LAYER_JOB_ID LAYER_CREATED LAYER_UPDATED LAYER_SOURCE_URL LAYER_SRID LAYER_ASSIGNMENT LAYER_SHAPE_IDENTIFIER ACTION_LINK_ID FORM_ID PLUGIN_FORM_FIELD_LOB NAME CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT b.LAYER_ID LAYER_ID, b.LAYER_LABEL LAYER_LABEL, b.LAYER_TYPE LAYER_TYPE, b.LAYER_SOURCE_NAME LAYER_SOURCE_NAME, b.LAYER_THEME LAYER_THEME, b.LAYER_URL LAYER_URL, b.LAYER_STATUS LAYER_STATUS, b.LAYER_JOB_ID LAYER_JOB_ID, b.LAYER_CREATED LAYER_CREATED, b.LAYER_UPDATED LAYER_UPDATED, b.LAYER_SOURCE_URL LAYER_SOURCE_URL, b.LAYER_SRID LAYER_SRID, b.LAYER_ASSIGNMENT LAYER_ASSIGNMENT, b.LAYER_SHAPE_IDENTIFIER LAYER_SHAPE_IDENTIFIER, b.ACTION_LINK_ID ACTION_LINK_ID, b.FORM_ID FORM_ID, b.PLUGIN_FORM_FIELD_LOB PLUGIN_FORM_FIELD_LOB, nvl (tl.NAME, b.LAYER_LABEL) NAME, b.CREATION_DATE CREATION_DATE, b.CREATED_BY CREATED_BY, b.LAST_UPDATE_DATE LAST_UPDATE_DATE, b.LAST_UPDATED_BY LAST_UPDATED_BY, b.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN from ffs_cml_map_layer b left join ffs_cml_map_layer_tl tl on b.LAYER_ID = tl.LAYER_ID and tl.LANGUAGE = USERENV('LANG')