MSC_DIM_EXP_TREE_NODE_RF_V
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: MSC
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
TREE_STRUCTURE_CODE TREE_CODE TREE_VERSION_ID DISTANCE PK1_VALUE PK2_VALUE ANCESTOR_PK1_VALUE ANCESTOR_PK2_VALUE ENTERPRISE_ID |
問合せ
| SQL_Statement |
|---|
|
SELECT DISTINCT 'MSC_EXP_TREE_STRUCTURE' AS TREE_STRUCTURE_CODE, 'EXP_DEF_30_TREE' AS TREE_CODE, 'DEFAULT' AS TREE_VERSION_ID, 0 AS DISTANCE , MEXB.EXCEPTION_ID AS PK1_VALUE, 78 AS PK2_VALUE, MEXB.EXCEPTION_ID AS ANCESTOR_PK1_VALUE, 78 AS ANCESTOR_PK2_VALUE, NVL(SYS_CONTEXT('FND_VPD_CTX', 'ENTERPRISE_ID'), 1) AS ENTERPRISE_ID FROM MSC_EXCEPTION_B MEXB |