1. Tables and Views for HCM
  2. CMP_SCTN_REGION_ITEMS_VL

CMP_SCTN_REGION_ITEMS_VL

Details

  • Schema: FUSION

  • Object owner: CMP

  • Object type: VIEW

Columns

Name

SECTION_ID

SECTION_TYPE

SECTION_KEY

REGION_NAME

ITEM_NAME

ENABLED_FLAG

ORDER_NUM

SECTION_CODE

TILE_CODE

COLLAPSE_FLAG

DISPLAY_NAME

DESCRIPTION

OBJECT_VERSION_NUMBER

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

BUSINESS_GROUP_ID

Query

SQL_Statement

SELECT

B.SECTION_ID,

B.SECTION_TYPE,

B.SECTION_KEY,

B.REGION_NAME,

B.ITEM_NAME,

B.ENABLED_FLAG,

B.ORDER_NUM,

B.SECTION_CODE,

B.TILE_CODE,

B.COLLAPSE_FLAG,

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

FROM

CMP_SCTN_REGION_ITEMS_B B,

CMP_SCTN_REGION_ITEMS_TL T

WHERE

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