ZCA_ES_DATE_BUCKETS_VL

Details

• Schema: FUSION

• Object owner: ZCA

• Object type: VIEW

Columns

Name
DATE_BUCKET_UUID ENABLED_FLAG TIMEZONE MIN_INCLUSIVE_FIRST_FLAG START_OFFSET START_OFFSET_UNIT_TYPE_NAME END_OFFSET END_OFFSET_UNIT_TYPE_NAME MIN_INCLUSIVE_DATE MAX_EXCLUSIVE_DATE DELETED_FLAG CREATED_BY CREATION_DATE LAST_UPDATE_DATE LAST_UPDATE_LOGIN LAST_UPDATED_BY OBJECT_VERSION_NUMBER USER_LAST_UPDATE_DATE DATE_BUCKET_KEY_NAME LOCALIZED_NAME LOCALIZED_DESCRIPTION

Query

SQL_Statement

SELECT ZCA_ES_DATE_BUCKETS_B.DATE_BUCKET_UUID, ZCA_ES_DATE_BUCKETS_B.ENABLED_FLAG, ZCA_ES_DATE_BUCKETS_B.TIMEZONE, ZCA_ES_DATE_BUCKETS_B.MIN_INCLUSIVE_FIRST_FLAG, ZCA_ES_DATE_BUCKETS_B.START_OFFSET, ZCA_ES_DATE_BUCKETS_B.START_OFFSET_UNIT_TYPE_NAME, ZCA_ES_DATE_BUCKETS_B.END_OFFSET, ZCA_ES_DATE_BUCKETS_B.END_OFFSET_UNIT_TYPE_NAME, ZCA_ES_DATE_BUCKETS_B.MIN_INCLUSIVE_DATE, ZCA_ES_DATE_BUCKETS_B.MAX_EXCLUSIVE_DATE, ZCA_ES_DATE_BUCKETS_B.DELETED_FLAG, ZCA_ES_DATE_BUCKETS_B.CREATED_BY, ZCA_ES_DATE_BUCKETS_B.CREATION_DATE, ZCA_ES_DATE_BUCKETS_B.LAST_UPDATE_DATE, ZCA_ES_DATE_BUCKETS_B.LAST_UPDATE_LOGIN, ZCA_ES_DATE_BUCKETS_B.LAST_UPDATED_BY, ZCA_ES_DATE_BUCKETS_B.OBJECT_VERSION_NUMBER, ZCA_ES_DATE_BUCKETS_B.USER_LAST_UPDATE_DATE, ZCA_ES_DATE_BUCKETS_B.DATE_BUCKET_KEY_NAME, ZCA_ES_DATE_BUCKETS_TL.LOCALIZED_NAME, ZCA_ES_DATE_BUCKETS_TL.LOCALIZED_DESCRIPTION FROM ZCA_ES_DATE_BUCKETS_B, ZCA_ES_DATE_BUCKETS_TL WHERE ZCA_ES_DATE_BUCKETS_B.DATE_BUCKET_UUID = ZCA_ES_DATE_BUCKETS_TL.DATE_BUCKET_UUID AND ZCA_ES_DATE_BUCKETS_TL.LANGUAGE = USERENV('LANG')