MSC_SOP_PLAN_CYCLE_VL
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: MSC
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
PLAN_CYCLE_ID START_DATE END_DATE OWNER OBJECT_VERSION_NUMBER LAST_UPDATED_BY LAST_UPDATE_DATE CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN USAGE_STATUS PLAN_CYCLE_NAME PLAN_CYCLE_DESC |
問合せ
| SQL_Statement |
|---|
|
SELECT B.PLAN_CYCLE_ID, B.START_DATE, B.END_DATE, B.OWNER, B.OBJECT_VERSION_NUMBER , B.LAST_UPDATED_BY , B.LAST_UPDATE_DATE , B.CREATION_DATE , B.CREATED_BY , B.LAST_UPDATE_LOGIN , B.USAGE_STATUS, T.PLAN_CYCLE_NAME , T.PLAN_CYCLE_DESC FROM MSC_SOP_PLAN_CYCLE_B B, MSC_SOP_PLAN_CYCLE_TL T WHERE B.PLAN_CYCLE_ID = T.PLAN_CYCLE_ID AND T.language = USERENV('LANG') |