OSS_CHURN_PRED_ATTRIBUTES_VL

Details

• Schema: FUSION

• Object owner: OSS

• Object type: VIEW

Columns

Name
ATTRIBUTE_ID ATTRIBUTE_NAME ATTRIBUTE_MEANING REASON_TEXT PREDEFINED_FLAG SELECTED_FLAG MANDATORY_FLAG MODULE_ID OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT OSB.ATTRIBUTE_ID, OSB.ATTRIBUTE_NAME, OSTL.ATTRIBUTE_MEANING, OSTL.REASON_TEXT, OSB.PREDEFINED_FLAG, OSB.SELECTED_FLAG, OSB.MANDATORY_FLAG, OSB.MODULE_ID, OSB.OBJECT_VERSION_NUMBER, OSB.CREATED_BY, OSB.CREATION_DATE, OSB.LAST_UPDATED_BY, OSB.LAST_UPDATE_DATE, OSB.LAST_UPDATE_LOGIN FROM OSS_CHURN_PRED_ATTRIBUTES_B OSB, OSS_CHURN_PRED_ATTRIBUTES_TL OSTL WHERE OSB.ATTRIBUTE_ID = OSTL.ATTRIBUTE_ID AND OSTL.LANGUAGE = USERENV('LANG')