1. Tables and Views for HCM
  2. CMP_CSTM_REGION_ITEMS_VL

CMP_CSTM_REGION_ITEMS_VL

Details

  • Schema: FUSION

  • Object owner: CMP

  • Object type: VIEW

Columns

Name

CUSTOM_ID

CUSTOM_TYPE

CUSTOM_KEY

REGION_NAME

ITEM_NAME

DISPLAY_FLAG

UPDATE_ALLOWED_FLAG

ORDER_NUM

SYSTEM_ORDER_NUM

COLUMN_BANDING

INITIALLY_HIDDEN_FLAG

OVERRIDE_CODE

CONDITION_TYPE_CODE

WRAP_TEXT_FLAG

COLUMN_WIDTH

COLUMN_SHADE_CODE

DISPLAY_NAME

DESCRIPTION

OBJECT_VERSION_NUMBER

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

BUSINESS_GROUP_ID

UPDATE_IN_WORKBOOK_FLAG

UPDATE_COND_CODE

HIDE_VIEW_PRINT_ICON_FLAG

Query

SQL_Statement

SELECT

B.CUSTOM_ID,

B.CUSTOM_TYPE,

B.CUSTOM_KEY,

B.REGION_NAME,

B.ITEM_NAME,

B.DISPLAY_FLAG,

B.UPDATE_ALLOWED_FLAG,

B.ORDER_NUM,

B.SYSTEM_ORDER_NUM,

B.COLUMN_BANDING,

B.INITIALLY_HIDDEN_FLAG,

B.OVERRIDE_CODE,

B.CONDITION_TYPE_CODE,

B.WRAP_TEXT_FLAG,

B.COLUMN_WIDTH,

B.COLUMN_SHADE_CODE,

T.DISPLAY_NAME,

T.DESCRIPTION,

B.OBJECT_VERSION_NUMBER,

B.CREATED_BY,

B.CREATION_DATE,

B.LAST_UPDATED_BY,

B.LAST_UPDATE_DATE,

B.LAST_UPDATE_LOGIN,

B.BUSINESS_GROUP_ID,

B.UPDATE_IN_WORKBOOK_FLAG,

B.UPDATE_COND_CODE,

B.HIDE_VIEW_PRINT_ICON_FLAG

FROM

CMP_CSTM_REGION_ITEMS_B B,

CMP_CSTM_REGION_ITEMS_TL T

WHERE

B.CUSTOM_ID = T.CUSTOM_ID AND T.LANGUAGE = USERENV('LANG') AND B.BUSINESS_GROUP_ID = T.BUSINESS_GROUP_ID