MSC_DIM_DCS_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 'MSC_DCS_TREE_STRUCTURE' AS TREE_STRUCTURE_CODE, 'DCS_DEF_16_TREE' AS TREE_CODE, 'DEFAULT' AS TREE_VERSION_ID, 0 AS DISTANCE , MSRLV.LOOKUP_CODE AS PK1_VALUE, 50 AS PK2_VALUE, MSRLV.LOOKUP_CODE AS ANCESTOR_PK1_VALUE, 50 AS ANCESTOR_PK2_VALUE, NVL(SYS_CONTEXT('FND_VPD_CTX', 'ENTERPRISE_ID'), 1) AS ENTERPRISE_ID FROM MSC_SR_LOOKUP_VALUES_VL MSRLV WHERE MSRLV.LOOKUP_TYPE ='DEMAND_CLASS' |