HWM_TM_A_TR_ERR_STATUS_V

Details

• Schema: FUSION

• Object owner: HWM

• Object type: VIEW

Columns

Name
STATUS_ID TM_BLDG_BLK_ID TM_BLDG_BLK_VERSION STATUS_VALUE TM_STATUS_DEF_ID

Query

SQL_Statement

SELECT statuses.status_id, statuses.tm_bldg_blk_id, statuses.tm_bldg_blk_version, statuses.status_value, statuses.tm_status_def_id FROM hwm_tm_active_status_v statuses WHERE statuses.status_def_cd = 'A_TR_ERR_STATUS' /** FROM hwm_tm_statuses statuses WHERE statuses.date_from <= sysdate AND statuses.date_to >= sysdate AND EXISTS (SELECT 1 FROM fusion.hwm_tm_status_def_b WHERE statuses.tm_status_def_id = tm_status_def_id AND status_def_cd = 'A_TR_ERR_STATUS') **/