CMP_RANGE_DIFFS_F_VL

Details

• Schema: FUSION

• Object owner: CMP

• Object type: VIEW

Columns

Name
NAME DESCRIPTION LANGUAGE SOURCE_LANG RANGE_DIFF_ID CODE LEGISLATIVE_DATA_GROUP_ID STATUS CRITERIA EFFECTIVE_START_DATE EFFECTIVE_END_DATE BUSINESS_GROUP_ID OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN ACTION_OCCURRENCE_ID ACTION_ID ACTION_REASON_ID RANGE_DIFF_TYPE GEOGRAPHY_TYPE_ID PROCESS_WFH_FLAG ADDRESS_TYPE1 ADDRESS_TYPE2 ADDRESS_TYPE3

Query

SQL_Statement

SELECT T.NAME, T.DESCRIPTION, T.LANGUAGE, T.SOURCE_LANG, B.RANGE_DIFF_ID, B.CODE, B.LEGISLATIVE_DATA_GROUP_ID, B.STATUS, B.CRITERIA, B.EFFECTIVE_START_DATE, B.EFFECTIVE_END_DATE, B.BUSINESS_GROUP_ID, B.OBJECT_VERSION_NUMBER, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.ACTION_OCCURRENCE_ID, B.ACTION_ID, B.ACTION_REASON_ID, B.RANGE_DIFF_TYPE, B.GEOGRAPHY_TYPE_ID, B.PROCESS_WFH_FLAG, B.ADDRESS_TYPE1, B.ADDRESS_TYPE2, B.ADDRESS_TYPE3 FROM CMP_RANGE_DIFFS_F_TL T, CMP_RANGE_DIFFS_F B WHERE B.RANGE_DIFF_ID=T.RANGE_DIFF_ID AND T.LANGUAGE=USERENV('LANG') AND T.BUSINESS_GROUP_ID=B.BUSINESS_GROUP_ID AND T.EFFECTIVE_START_DATE=B.EFFECTIVE_START_DATE AND T.EFFECTIVE_END_DATE=B.EFFECTIVE_END_DATE