HWM_TM_REP_RECORD_ATRBS_V

Details

• Schema: FUSION

• Object owner: HWM

• Object type: VIEW

Columns

Name
ATTRIBUTE_ID ATTRIBUTE_NAME ATTRIBUTE_TYPE ATTRIBUTE_VALUE TM_REC_ID TM_REC_VERSION

Query

SQL_Statement
SELECT FUNC.ATTRIBUTE_ID, FUNC.ATTRIBUTE_NAME, FUNC.ATTRIBUTE_TYPE, FUNC.ATTRIBUTE_VALUE, TR.TM_REC_ID TM_REC_ID, TR.TM_REC_VERSION TM_REC_VERSION FROM HWM_TM_REC TR, TABLE (HWM_TIME_REPOS_REST.GET_TM_ATRB_VALS(TR.TM_REC_ID , TR.TM_REC_VERSION)) FUNC WHERE TR.LATEST_VERSION = 'Y' AND NVL(TR.DELETE_FLAG, 'N') = 'N'