PSC_COM_GIS_SYNC_MAP_VL

Details

• Schema: FUSION

• Object owner: PSC_CC

• Object type: VIEW

Columns

Name
AGENCY_ID MAPPING_ID OFFERING_ID DESCRIPTION GIS_SERVICE_ID LAYER_ID LAYER_NAME RESOURCE_ID RESOURCE_PATH RECORD_TYPE_ID ENABLED_FLAG OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT b.AGENCY_ID, b.MAPPING_ID, b.OFFERING_ID, tl.DESCRIPTION, b.GIS_SERVICE_ID, b.LAYER_ID, b.LAYER_NAME, b.RESOURCE_ID, b.RESOURCE_PATH, b.RECORD_TYPE_ID, b.ENABLED_FLAG, b.OBJECT_VERSION_NUMBER, b.CREATED_BY, b.CREATION_DATE, b.LAST_UPDATED_BY, b.LAST_UPDATE_DATE, b.LAST_UPDATE_LOGIN FROM psc_com_gis_sync_map_b b, psc_com_gis_sync_map_tl tl WHERE b.AGENCY_ID = tl.AGENCY_ID AND b.MAPPING_ID = tl.MAPPING_ID AND tl.LANGUAGE = USERENV('LANG')