1. Tables and Views for SCM
  2. CSE_FAILURE_SETS_VL

CSE_FAILURE_SETS_VL

Details

  • Schema: FUSION

  • Object owner: CSE

  • Object type: VIEW

Columns

Name

FAILURE_SET_ID

OBJECT_VERSION_NUMBER

FAILURE_SET_CODE

FAILURE_SET_NAME

FAILURE_SET_DESC

FAILURE_CHAINS_ENFORCED_FLAG

ACTIVE_END_DATE

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT

FSB.FAILURE_SET_ID FAILURE_SET_ID,

FSB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

FSB.FAILURE_SET_CODE FAILURE_SET_CODE,

FSTL.FAILURE_SET_NAME FAILURE_SET_NAME,

FSTL.FAILURE_SET_DESC FAILURE_SET_DESC,

FSB.FAILURE_CHAINS_ENFORCED_FLAG,

FSB.ACTIVE_END_DATE ACTIVE_END_DATE,

FSB.CREATED_BY CREATED_BY,

FSB.CREATION_DATE CREATION_DATE,

FSB.LAST_UPDATED_BY LAST_UPDATED_BY,

FSB.LAST_UPDATE_DATE LAST_UPDATE_DATE,

FSB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN

FROM

cse_failure_sets_b FSB,

cse_failure_sets_tl FSTL

WHERE

FSTL.FAILURE_SET_ID = FSB.FAILURE_SET_ID AND FSTL.LANGUAGE = USERENV('LANG')