HWM_TM_A_XFR_STATUS_PYR_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_XFR_STATUS_PYR' /** FROM hwm_tm_statuses statuses WHERE statuses.date_from <= sysdate AND statuses.date_to >= sysdate AND EXISTS (SELECT 1 FROM hwm_tm_status_def_b WHERE statuses.tm_status_def_id = tm_status_def_id AND status_def_cd = 'A_XFR_STATUS_PYR' ) **/