CN_EXPRESSIONS_ALL_VL

Details

• Schema: FUSION

• Object owner: CN

• Object type: VIEW

Columns

Name

ORG_ID EXPRESSION_ID EXPRESSION_NAME DESCRIPTION STATUS_CODE EXPRESSION_TYPE RENDERED_EXPRESSION_DISP SQL_SELECT SQL_FROM PIPED_SQL_SELECT PIPED_SQL_FROM USES_RATETBL_RSLT_FLAG ENABLED_FLAG ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 CREATED_BY CREATION_DATE LAST_UPDATE_LOGIN LAST_UPDATE_DATE LAST_UPDATED_BY OBJECT_VERSION_NUMBER

Query

SQL_Statement

SELECT b.ORG_ID, b.EXPRESSION_ID, EXPRESSION_NAME, DESCRIPTION,STATUS_CODE, EXPRESSION_TYPE, RENDERED_EXPRESSION_DISP, SQL_SELECT, SQL_FROM, PIPED_SQL_SELECT, PIPED_SQL_FROM, USES_RATETBL_RSLT_FLAG,ENABLED_FLAG, ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15, b.CREATED_BY, b.CREATION_DATE, b.LAST_UPDATE_LOGIN, b.LAST_UPDATE_DATE, b.LAST_UPDATED_BY, b.OBJECT_VERSION_NUMBER from CN_EXPRESSIONS_ALL_B b, CN_EXPRESSIONS_ALL_TL t where b.EXPRESSION_ID = t.EXPRESSION_ID and b.ORG_ID = t.ORG_ID and t.LANGUAGE = userenv('LANG')