1. Tables and Views for HCM
  2. CMP_COMPONENTS_VL

CMP_COMPONENTS_VL

Details

  • Schema: FUSION

  • Object owner: CMP

  • Object type: VIEW

Columns

Name

COMPONENT_ID

PLAN_ID

PERIOD_ID

CURRENCY_DETERMINATION_CODE

SYSTEM_ORDER_NUM

ORDER_NUM

POOL_ID_TO_CONSUME

POST_AS_SALARY_FLAG

SALARY_COMPONENT

RULE_ID

GRANT_TYPE

TRADING_SYMBOL

NON_MONETARY_UOM

COMP_TYPE

COMPONENT_NAME

PLAN_ID2

OBJECT_VERSION_NUMBER

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

BUSINESS_GROUP_ID

SALARY_RATES_USED_FLAG

USE_FOR_ASG_SEG_FLAG

ASG_SEG_AUTO_PUBLISH_FLAG

ASG_SEG_WS_COLUMN_CODE

MANAGER_ENTER_RATES_CODE

SALARY_SMPL_COMP_USED_FLAG

DOCUMENT_TYPE_ID

DOR_REQUIRED_FLAG

Query

SQL_Statement

SELECT

B.COMPONENT_ID,

B.PLAN_ID,

B.PERIOD_ID,

B.CURRENCY_DETERMINATION_CODE,

B.SYSTEM_ORDER_NUM,

B.ORDER_NUM,

B.POOL_ID_TO_CONSUME,

B.POST_AS_SALARY_FLAG,

B.SALARY_COMPONENT,

B.RULE_ID,

B.GRANT_TYPE,

B.TRADING_SYMBOL,

B.NON_MONETARY_UOM,

B.COMP_TYPE,

T.COMPONENT_NAME,

T.PLAN_ID PLAN_ID2,

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.SALARY_RATES_USED_FLAG,

B.USE_FOR_ASG_SEG_FLAG,

B.ASG_SEG_AUTO_PUBLISH_FLAG,

B.ASG_SEG_WS_COLUMN_CODE,

B.MANAGER_ENTER_RATES_CODE,

B.SALARY_SMPL_COMP_USED_FLAG,

B.DOCUMENT_TYPE_ID,

B.DOR_REQUIRED_FLAG

FROM

CMP_COMPONENTS_B B,

CMP_COMPONENTS_TL T

WHERE

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