PSC_COM_RE_TYPE_VL

Details

• Schema: FUSION

• Object owner: PSC_CC

• Object type: VIEW

Columns

Name

AGENCY_ID RE_TYPE_CODE RE_TYPE_ID VALID_FROM_DATE VALID_TO_DATE CITIZEN_ENABLED CLASSIFICATION SUB_CLASSIFICATION STATUS EXPIRATION_GROUP_ID AUTO_NUM_RULE APPLICATION_GROUP INDUSTRY_CLASS URL FEATURE_LAYER_URL CATEGORY SUBCATEGORY DOCUMENT_GROUP RE_IDENTIFIER_GIS PERMIT_NUMBER_GIS GIS_FLAG RE_TYPE DESCRIPTION OBJECT_VERSION_NUMBER LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN CREATED_BY CREATION_DATE

Query

SQL_Statement

SELECT B.AGENCY_ID, B.RE_TYPE_CODE, B.RE_TYPE_ID, B.VALID_FROM_DATE, B.VALID_TO_DATE, B.CITIZEN_ENABLED, B.CLASSIFICATION, B.SUB_CLASSIFICATION, B.STATUS, B.EXPIRATION_GROUP_ID, B.AUTO_NUM_RULE, B.APPLICATION_GROUP, B.INDUSTRY_CLASS, B.URL, B.FEATURE_LAYER_URL, B.CATEGORY, B.SUBCATEGORY, B.DOCUMENT_GROUP, B.RE_IDENTIFIER_GIS, B.PERMIT_NUMBER_GIS, B.GIS_FLAG, TL.RE_TYPE, TL.DESCRIPTION, B.OBJECT_VERSION_NUMBER, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.CREATED_BY, B.CREATION_DATE FROM PSC_COM_RE_TYPE_B B, PSC_COM_RE_TYPE_TL TL WHERE B.RE_TYPE_ID = TL.RE_TYPE_ID AND TL.LANGUAGE = USERENV('LANG')