AR_CMGT_DATA_POINTS_VL

Details

• Schema: FUSION

• Object owner: AR

• Object type: VIEW

Columns

Name
ROW_ID DATA_POINT_ID DATA_POINT_NAME DATA_POINT_CATEGORY_CODE DATA_TYPE DATA_POINT_CODE RETURN_DATE_FORMAT SCORABLE_FLAG SYSTEM_DERIVED_FLAG DATA_POINT_SOURCE_CODE ENABLED_FLAG DESCRIPTION LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN CREATION_DATE CREATED_BY OBJECT_VERSION_NUMBER

Query

SQL_Statement

SELECT b.ROWID row_id, b.data_point_id, t.data_point_name, b.data_point_category_code, b.data_type, b.data_point_code, b.return_date_format, b.scorable_flag, b.system_derived_flag, b.data_point_source_code, NVL(b.enabled_flag,'N') enabled_flag, t.description, t.last_updated_by, t.last_update_date, t.last_update_login, t.creation_date, t.created_by, t.object_version_number FROM ar_cmgt_data_points_b b, ar_cmgt_data_points_tl t WHERE b.data_point_id = t.data_point_id AND t.language = userenv('LANG')