1. Tables and Views for HCM
  2. HWM_TM_REC_CHG_SUBRESOURCE_V

HWM_TM_REC_CHG_SUBRESOURCE_V

Details

  • Schema: FUSION

  • Object owner: HWM

  • Object type: VIEW

Columns

Name

TM_REC_CHANGE_ID

SUBRESOURCE_ID

Query

SQL_Statement

SELECT

HwmTmRecChangeAtrbs.TM_REC_CHANGE_ID TM_REC_CHANGE_ID,

HwmTmRecChangeAtrbs.VALUE_NUMBER SUBRESOURCE_ID

FROM HWM_TM_REC_CHANGE_ATRBS HwmTmRecChangeAtrbs,

HWM_TM_ATRB_FLDS_B HwmTmAtrbFldsB

WHERE HwmTmRecChangeAtrbs.TM_ATRB_FLD_ID = HwmTmAtrbFldsB.TM_ATRB_FLD_ID

AND HwmTmAtrbFldsB.NAME = 'SubresourceId'