1. Tables and Views for SCM
  2. MSC_DIM_DCS_TREE_NODE_RF_V

MSC_DIM_DCS_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 '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'