MSC_DIM_ORD_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_ORD_TREE_STRUCTURE' AS TREE_STRUCTURE_CODE, 'ORD_DEF_29_TREE' AS TREE_CODE, 'DEFAULT' AS TREE_VERSION_ID, 0 AS DISTANCE , FLV.LOOKUP_CODE AS PK1_VALUE, 76 AS PK2_VALUE, FLV.LOOKUP_CODE AS ANCESTOR_PK1_VALUE, 76 AS ANCESTOR_PK2_VALUE, NVL(SYS_CONTEXT('FND_VPD_CTX', 'ENTERPRISE_ID'), 1) AS ENTERPRISE_ID FROM FND_LOOKUP_VALUES_VL FLV WHERE FLV.LOOKUP_TYPE ='MSC_ORDER_TYPE' UNION ALL SELECT 'MSC_ORD_TREE_STRUCTURE' AS TREE_STRUCTURE_CODE, 'ORD_DEF_29_TREE' AS TREE_CODE, 'DEFAULT' AS TREE_VERSION_ID, 1 AS DISTANCE , FLV.LOOKUP_CODE AS PK1_VALUE, 76 AS PK2_VALUE, CASE WHEN FLV.LOOKUP_CODE>1000 THEN '2' ELSE '1' END AS ANCESTOR_PK1_VALUE, 75 AS ANCESTOR_PK2_VALUE, NVL(SYS_CONTEXT('FND_VPD_CTX', 'ENTERPRISE_ID'), 1) AS ENTERPRISE_ID FROM FND_LOOKUP_VALUES_VL FLV WHERE FLV.LOOKUP_TYPE ='MSC_ORDER_TYPE' UNION ALL SELECT 'MSC_ORD_TREE_STRUCTURE' AS TREE_STRUCTURE_CODE, 'ORD_DEF_29_TREE' AS TREE_CODE, 'DEFAULT' AS TREE_VERSION_ID, 0 AS DISTANCE , FLV.LOOKUP_CODE AS PK1_VALUE, 75 AS PK2_VALUE, FLV.LOOKUP_CODE AS ANCESTOR_PK1_VALUE, 75 AS ANCESTOR_PK2_VALUE, NVL(SYS_CONTEXT('FND_VPD_CTX', 'ENTERPRISE_ID'), 1) AS ENTERPRISE_ID FROM FND_LOOKUP_VALUES_VL FLV WHERE FLV.LOOKUP_TYPE ='ORA_MSC_ORDER_GROUP'