MSC_DIM_EXP_TREE_NODE_RF_V

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
TREE_STRUCTURE_CODE TREE_CODE TREE_VERSION_ID DISTANCE PK1_VALUE PK2_VALUE ANCESTOR_PK1_VALUE ANCESTOR_PK2_VALUE ENTERPRISE_ID

Query

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