MSC_CAUSAL_FACTORS_DECOMP_VL
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: MSC
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
PROFILE_ID OUTPUT_MEASURE_ID CAUSAL_DECOMP_ID CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN CAUSAL_DECOMP_NAME CAUSAL_DECOMP_DESCRIPTION |
問合せ
| SQL_Statement |
|---|
|
SELECT B.PROFILE_ID, B.OUTPUT_MEASURE_ID, B.CAUSAL_DECOMP_ID, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, T.CAUSAL_DECOMP_NAME, T.CAUSAL_DECOMP_DESCRIPTION FROM MSC_CAUSAL_FACTORS_DECOMP_B B, MSC_CAUSAL_FACTORS_DECOMP_TL T WHERE B.PROFILE_ID = T.PROFILE_ID and B.CAUSAL_DECOMP_ID = T.CAUSAL_DECOMP_ID AND T.LANGUAGE = USERENV('LANG') |