VIEW: APPS.FEM_DIS_LDGR_DIM_VS_MAP_V

Source

View Text - Preformatted

SELECT LEDGER_ID, COMPANY_COST_CENTER_ORG_VS_ID, CHANNEL_VS_ID, COMPANY_VS_ID, COST_CENTER_VS_ID, CUSTOMER_VS_ID, ENTITY_VS_ID, FINANCIAL_ELEM_VS_ID, GEOGRAPHY_VS_ID, INTERCOMPANY_VS_ID, LINE_ITEM_VS_ID, NATURAL_ACCOUNT_VS_ID, PRODUCT_VS_ID, PROJECT_VS_ID, TASK_VS_ID, USER_DIM1_VS_ID, USER_DIM2_VS_ID, USER_DIM3_VS_ID, USER_DIM4_VS_ID, USER_DIM5_VS_ID, USER_DIM6_VS_ID, USER_DIM7_VS_ID, USER_DIM8_VS_ID, USER_DIM9_VS_ID, USER_DIM10_VS_ID FROM ( WITH P AS ( SELECT LA.LEDGER_ID, LA.DIM_ATTRIBUTE_NUMERIC_MEMBER GLOBAL_VS_COMBO_ID FROM FEM_DIMENSIONS_B D, FEM_DIM_ATTRIBUTES_B A, FEM_DIM_ATTR_VERSIONS_B V, FEM_LEDGERS_ATTR LA WHERE D.DIMENSION_VARCHAR_LABEL = 'LEDGER' AND A.DIMENSION_ID = D.DIMENSION_ID AND A.ATTRIBUTE_VARCHAR_LABEL = 'GLOBAL_VS_COMBO' AND V.ATTRIBUTE_ID = A.ATTRIBUTE_ID AND V.DEFAULT_VERSION_FLAG = 'Y' AND LA.ATTRIBUTE_ID = V.ATTRIBUTE_ID AND LA.VERSION_ID = V.VERSION_ID ) SELECT P.LEDGER_ID, ( SELECT G.VALUE_SET_ID FROM FEM_DIMENSIONS_B D, FEM_GLOBAL_VS_COMBO_DEFS G WHERE D.DIMENSION_VARCHAR_LABEL = 'COMPANY_COST_CENTER_ORG' AND G.DIMENSION_ID = D.DIMENSION_ID AND G.GLOBAL_VS_COMBO_ID = P.GLOBAL_VS_COMBO_ID ) COMPANY_COST_CENTER_ORG_VS_ID, ( SELECT G.VALUE_SET_ID FROM FEM_DIMENSIONS_B D, FEM_GLOBAL_VS_COMBO_DEFS G WHERE D.DIMENSION_VARCHAR_LABEL = 'CHANNEL' AND G.DIMENSION_ID = D.DIMENSION_ID AND G.GLOBAL_VS_COMBO_ID = P.GLOBAL_VS_COMBO_ID ) CHANNEL_VS_ID, ( SELECT G.VALUE_SET_ID FROM FEM_DIMENSIONS_B D, FEM_GLOBAL_VS_COMBO_DEFS G WHERE D.DIMENSION_VARCHAR_LABEL = 'COMPANY' AND G.DIMENSION_ID = D.DIMENSION_ID AND G.GLOBAL_VS_COMBO_ID = P.GLOBAL_VS_COMBO_ID ) COMPANY_VS_ID, ( SELECT G.VALUE_SET_ID FROM FEM_DIMENSIONS_B D, FEM_GLOBAL_VS_COMBO_DEFS G WHERE D.DIMENSION_VARCHAR_LABEL = 'COST_CENTER' AND G.DIMENSION_ID = D.DIMENSION_ID AND G.GLOBAL_VS_COMBO_ID = P.GLOBAL_VS_COMBO_ID ) COST_CENTER_VS_ID, ( SELECT G.VALUE_SET_ID FROM FEM_DIMENSIONS_B D, FEM_GLOBAL_VS_COMBO_DEFS G WHERE D.DIMENSION_VARCHAR_LABEL = 'CUSTOMER' AND G.DIMENSION_ID = D.DIMENSION_ID AND G.GLOBAL_VS_COMBO_ID = P.GLOBAL_VS_COMBO_ID ) CUSTOMER_VS_ID, ( SELECT G.VALUE_SET_ID FROM FEM_DIMENSIONS_B D, FEM_GLOBAL_VS_COMBO_DEFS G WHERE D.DIMENSION_VARCHAR_LABEL = 'ENTITY' AND G.DIMENSION_ID = D.DIMENSION_ID AND G.GLOBAL_VS_COMBO_ID = P.GLOBAL_VS_COMBO_ID ) ENTITY_VS_ID, ( SELECT G.VALUE_SET_ID FROM FEM_DIMENSIONS_B D, FEM_GLOBAL_VS_COMBO_DEFS G WHERE D.DIMENSION_VARCHAR_LABEL = 'FINANCIAL_ELEMENT' AND G.DIMENSION_ID = D.DIMENSION_ID AND G.GLOBAL_VS_COMBO_ID = P.GLOBAL_VS_COMBO_ID ) FINANCIAL_ELEM_VS_ID, ( SELECT G.VALUE_SET_ID FROM FEM_DIMENSIONS_B D, FEM_GLOBAL_VS_COMBO_DEFS G WHERE D.DIMENSION_VARCHAR_LABEL = 'GEOGRAPHY' AND G.DIMENSION_ID = D.DIMENSION_ID AND G.GLOBAL_VS_COMBO_ID = P.GLOBAL_VS_COMBO_ID ) GEOGRAPHY_VS_ID, ( SELECT G.VALUE_SET_ID FROM FEM_DIMENSIONS_B D, FEM_GLOBAL_VS_COMBO_DEFS G WHERE D.DIMENSION_VARCHAR_LABEL = 'COMPANY_COST_CENTER_ORG' AND G.DIMENSION_ID = D.DIMENSION_ID AND G.GLOBAL_VS_COMBO_ID = P.GLOBAL_VS_COMBO_ID ) INTERCOMPANY_VS_ID, ( SELECT G.VALUE_SET_ID FROM FEM_DIMENSIONS_B D, FEM_GLOBAL_VS_COMBO_DEFS G WHERE D.DIMENSION_VARCHAR_LABEL = 'LINE_ITEM' AND G.DIMENSION_ID = D.DIMENSION_ID AND G.GLOBAL_VS_COMBO_ID = P.GLOBAL_VS_COMBO_ID ) LINE_ITEM_VS_ID, ( SELECT G.VALUE_SET_ID FROM FEM_DIMENSIONS_B D, FEM_GLOBAL_VS_COMBO_DEFS G WHERE D.DIMENSION_VARCHAR_LABEL = 'NATURAL_ACCOUNT' AND G.DIMENSION_ID = D.DIMENSION_ID AND G.GLOBAL_VS_COMBO_ID = P.GLOBAL_VS_COMBO_ID ) NATURAL_ACCOUNT_VS_ID, ( SELECT G.VALUE_SET_ID FROM FEM_DIMENSIONS_B D, FEM_GLOBAL_VS_COMBO_DEFS G WHERE D.DIMENSION_VARCHAR_LABEL = 'PRODUCT' AND G.DIMENSION_ID = D.DIMENSION_ID AND G.GLOBAL_VS_COMBO_ID = P.GLOBAL_VS_COMBO_ID ) PRODUCT_VS_ID, ( SELECT G.VALUE_SET_ID FROM FEM_DIMENSIONS_B D, FEM_GLOBAL_VS_COMBO_DEFS G WHERE D.DIMENSION_VARCHAR_LABEL = 'PROJECT' AND G.DIMENSION_ID = D.DIMENSION_ID AND G.GLOBAL_VS_COMBO_ID = P.GLOBAL_VS_COMBO_ID ) PROJECT_VS_ID, ( SELECT G.VALUE_SET_ID FROM FEM_DIMENSIONS_B D, FEM_GLOBAL_VS_COMBO_DEFS G WHERE D.DIMENSION_VARCHAR_LABEL = 'TASK' AND G.DIMENSION_ID = D.DIMENSION_ID AND G.GLOBAL_VS_COMBO_ID = P.GLOBAL_VS_COMBO_ID ) TASK_VS_ID, ( SELECT G.VALUE_SET_ID FROM FEM_DIMENSIONS_B D, FEM_GLOBAL_VS_COMBO_DEFS G WHERE D.DIMENSION_VARCHAR_LABEL = 'USER_DIM1' AND G.DIMENSION_ID = D.DIMENSION_ID AND G.GLOBAL_VS_COMBO_ID = P.GLOBAL_VS_COMBO_ID ) USER_DIM1_VS_ID, ( SELECT G.VALUE_SET_ID FROM FEM_DIMENSIONS_B D, FEM_GLOBAL_VS_COMBO_DEFS G WHERE D.DIMENSION_VARCHAR_LABEL = 'USER_DIM2' AND G.DIMENSION_ID = D.DIMENSION_ID AND G.GLOBAL_VS_COMBO_ID = P.GLOBAL_VS_COMBO_ID ) USER_DIM2_VS_ID, ( SELECT G.VALUE_SET_ID FROM FEM_DIMENSIONS_B D, FEM_GLOBAL_VS_COMBO_DEFS G WHERE D.DIMENSION_VARCHAR_LABEL = 'USER_DIM3' AND G.DIMENSION_ID = D.DIMENSION_ID AND G.GLOBAL_VS_COMBO_ID = P.GLOBAL_VS_COMBO_ID ) USER_DIM3_VS_ID, ( SELECT G.VALUE_SET_ID FROM FEM_DIMENSIONS_B D, FEM_GLOBAL_VS_COMBO_DEFS G WHERE D.DIMENSION_VARCHAR_LABEL = 'USER_DIM4' AND G.DIMENSION_ID = D.DIMENSION_ID AND G.GLOBAL_VS_COMBO_ID = P.GLOBAL_VS_COMBO_ID ) USER_DIM4_VS_ID, ( SELECT G.VALUE_SET_ID FROM FEM_DIMENSIONS_B D, FEM_GLOBAL_VS_COMBO_DEFS G WHERE D.DIMENSION_VARCHAR_LABEL = 'USER_DIM5' AND G.DIMENSION_ID = D.DIMENSION_ID AND G.GLOBAL_VS_COMBO_ID = P.GLOBAL_VS_COMBO_ID ) USER_DIM5_VS_ID, ( SELECT G.VALUE_SET_ID FROM FEM_DIMENSIONS_B D, FEM_GLOBAL_VS_COMBO_DEFS G WHERE D.DIMENSION_VARCHAR_LABEL = 'USER_DIM6' AND G.DIMENSION_ID = D.DIMENSION_ID AND G.GLOBAL_VS_COMBO_ID = P.GLOBAL_VS_COMBO_ID ) USER_DIM6_VS_ID, ( SELECT G.VALUE_SET_ID FROM FEM_DIMENSIONS_B D, FEM_GLOBAL_VS_COMBO_DEFS G WHERE D.DIMENSION_VARCHAR_LABEL = 'USER_DIM7' AND G.DIMENSION_ID = D.DIMENSION_ID AND G.GLOBAL_VS_COMBO_ID = P.GLOBAL_VS_COMBO_ID ) USER_DIM7_VS_ID, ( SELECT G.VALUE_SET_ID FROM FEM_DIMENSIONS_B D, FEM_GLOBAL_VS_COMBO_DEFS G WHERE D.DIMENSION_VARCHAR_LABEL = 'USER_DIM8' AND G.DIMENSION_ID = D.DIMENSION_ID AND G.GLOBAL_VS_COMBO_ID = P.GLOBAL_VS_COMBO_ID ) USER_DIM8_VS_ID, ( SELECT G.VALUE_SET_ID FROM FEM_DIMENSIONS_B D, FEM_GLOBAL_VS_COMBO_DEFS G WHERE D.DIMENSION_VARCHAR_LABEL = 'USER_DIM9' AND G.DIMENSION_ID = D.DIMENSION_ID AND G.GLOBAL_VS_COMBO_ID = P.GLOBAL_VS_COMBO_ID ) USER_DIM9_VS_ID, ( SELECT G.VALUE_SET_ID FROM FEM_DIMENSIONS_B D, FEM_GLOBAL_VS_COMBO_DEFS G WHERE D.DIMENSION_VARCHAR_LABEL = 'USER_DIM10' AND G.DIMENSION_ID = D.DIMENSION_ID AND G.GLOBAL_VS_COMBO_ID = P.GLOBAL_VS_COMBO_ID ) USER_DIM10_VS_ID FROM P )

View Text - HTML Formatted

SELECT LEDGER_ID
, COMPANY_COST_CENTER_ORG_VS_ID
, CHANNEL_VS_ID
, COMPANY_VS_ID
, COST_CENTER_VS_ID
, CUSTOMER_VS_ID
, ENTITY_VS_ID
, FINANCIAL_ELEM_VS_ID
, GEOGRAPHY_VS_ID
, INTERCOMPANY_VS_ID
, LINE_ITEM_VS_ID
, NATURAL_ACCOUNT_VS_ID
, PRODUCT_VS_ID
, PROJECT_VS_ID
, TASK_VS_ID
, USER_DIM1_VS_ID
, USER_DIM2_VS_ID
, USER_DIM3_VS_ID
, USER_DIM4_VS_ID
, USER_DIM5_VS_ID
, USER_DIM6_VS_ID
, USER_DIM7_VS_ID
, USER_DIM8_VS_ID
, USER_DIM9_VS_ID
, USER_DIM10_VS_ID
FROM ( WITH P AS ( SELECT LA.LEDGER_ID
, LA.DIM_ATTRIBUTE_NUMERIC_MEMBER GLOBAL_VS_COMBO_ID
FROM FEM_DIMENSIONS_B D
, FEM_DIM_ATTRIBUTES_B A
, FEM_DIM_ATTR_VERSIONS_B V
, FEM_LEDGERS_ATTR LA
WHERE D.DIMENSION_VARCHAR_LABEL = 'LEDGER'
AND A.DIMENSION_ID = D.DIMENSION_ID
AND A.ATTRIBUTE_VARCHAR_LABEL = 'GLOBAL_VS_COMBO'
AND V.ATTRIBUTE_ID = A.ATTRIBUTE_ID
AND V.DEFAULT_VERSION_FLAG = 'Y'
AND LA.ATTRIBUTE_ID = V.ATTRIBUTE_ID
AND LA.VERSION_ID = V.VERSION_ID ) SELECT P.LEDGER_ID
, ( SELECT G.VALUE_SET_ID
FROM FEM_DIMENSIONS_B D
, FEM_GLOBAL_VS_COMBO_DEFS G
WHERE D.DIMENSION_VARCHAR_LABEL = 'COMPANY_COST_CENTER_ORG'
AND G.DIMENSION_ID = D.DIMENSION_ID
AND G.GLOBAL_VS_COMBO_ID = P.GLOBAL_VS_COMBO_ID ) COMPANY_COST_CENTER_ORG_VS_ID
, ( SELECT G.VALUE_SET_ID
FROM FEM_DIMENSIONS_B D
, FEM_GLOBAL_VS_COMBO_DEFS G
WHERE D.DIMENSION_VARCHAR_LABEL = 'CHANNEL'
AND G.DIMENSION_ID = D.DIMENSION_ID
AND G.GLOBAL_VS_COMBO_ID = P.GLOBAL_VS_COMBO_ID ) CHANNEL_VS_ID
, ( SELECT G.VALUE_SET_ID
FROM FEM_DIMENSIONS_B D
, FEM_GLOBAL_VS_COMBO_DEFS G
WHERE D.DIMENSION_VARCHAR_LABEL = 'COMPANY'
AND G.DIMENSION_ID = D.DIMENSION_ID
AND G.GLOBAL_VS_COMBO_ID = P.GLOBAL_VS_COMBO_ID ) COMPANY_VS_ID
, ( SELECT G.VALUE_SET_ID
FROM FEM_DIMENSIONS_B D
, FEM_GLOBAL_VS_COMBO_DEFS G
WHERE D.DIMENSION_VARCHAR_LABEL = 'COST_CENTER'
AND G.DIMENSION_ID = D.DIMENSION_ID
AND G.GLOBAL_VS_COMBO_ID = P.GLOBAL_VS_COMBO_ID ) COST_CENTER_VS_ID
, ( SELECT G.VALUE_SET_ID
FROM FEM_DIMENSIONS_B D
, FEM_GLOBAL_VS_COMBO_DEFS G
WHERE D.DIMENSION_VARCHAR_LABEL = 'CUSTOMER'
AND G.DIMENSION_ID = D.DIMENSION_ID
AND G.GLOBAL_VS_COMBO_ID = P.GLOBAL_VS_COMBO_ID ) CUSTOMER_VS_ID
, ( SELECT G.VALUE_SET_ID
FROM FEM_DIMENSIONS_B D
, FEM_GLOBAL_VS_COMBO_DEFS G
WHERE D.DIMENSION_VARCHAR_LABEL = 'ENTITY'
AND G.DIMENSION_ID = D.DIMENSION_ID
AND G.GLOBAL_VS_COMBO_ID = P.GLOBAL_VS_COMBO_ID ) ENTITY_VS_ID
, ( SELECT G.VALUE_SET_ID
FROM FEM_DIMENSIONS_B D
, FEM_GLOBAL_VS_COMBO_DEFS G
WHERE D.DIMENSION_VARCHAR_LABEL = 'FINANCIAL_ELEMENT'
AND G.DIMENSION_ID = D.DIMENSION_ID
AND G.GLOBAL_VS_COMBO_ID = P.GLOBAL_VS_COMBO_ID ) FINANCIAL_ELEM_VS_ID
, ( SELECT G.VALUE_SET_ID
FROM FEM_DIMENSIONS_B D
, FEM_GLOBAL_VS_COMBO_DEFS G
WHERE D.DIMENSION_VARCHAR_LABEL = 'GEOGRAPHY'
AND G.DIMENSION_ID = D.DIMENSION_ID
AND G.GLOBAL_VS_COMBO_ID = P.GLOBAL_VS_COMBO_ID ) GEOGRAPHY_VS_ID
, ( SELECT G.VALUE_SET_ID
FROM FEM_DIMENSIONS_B D
, FEM_GLOBAL_VS_COMBO_DEFS G
WHERE D.DIMENSION_VARCHAR_LABEL = 'COMPANY_COST_CENTER_ORG'
AND G.DIMENSION_ID = D.DIMENSION_ID
AND G.GLOBAL_VS_COMBO_ID = P.GLOBAL_VS_COMBO_ID ) INTERCOMPANY_VS_ID
, ( SELECT G.VALUE_SET_ID
FROM FEM_DIMENSIONS_B D
, FEM_GLOBAL_VS_COMBO_DEFS G
WHERE D.DIMENSION_VARCHAR_LABEL = 'LINE_ITEM'
AND G.DIMENSION_ID = D.DIMENSION_ID
AND G.GLOBAL_VS_COMBO_ID = P.GLOBAL_VS_COMBO_ID ) LINE_ITEM_VS_ID
, ( SELECT G.VALUE_SET_ID
FROM FEM_DIMENSIONS_B D
, FEM_GLOBAL_VS_COMBO_DEFS G
WHERE D.DIMENSION_VARCHAR_LABEL = 'NATURAL_ACCOUNT'
AND G.DIMENSION_ID = D.DIMENSION_ID
AND G.GLOBAL_VS_COMBO_ID = P.GLOBAL_VS_COMBO_ID ) NATURAL_ACCOUNT_VS_ID
, ( SELECT G.VALUE_SET_ID
FROM FEM_DIMENSIONS_B D
, FEM_GLOBAL_VS_COMBO_DEFS G
WHERE D.DIMENSION_VARCHAR_LABEL = 'PRODUCT'
AND G.DIMENSION_ID = D.DIMENSION_ID
AND G.GLOBAL_VS_COMBO_ID = P.GLOBAL_VS_COMBO_ID ) PRODUCT_VS_ID
, ( SELECT G.VALUE_SET_ID
FROM FEM_DIMENSIONS_B D
, FEM_GLOBAL_VS_COMBO_DEFS G
WHERE D.DIMENSION_VARCHAR_LABEL = 'PROJECT'
AND G.DIMENSION_ID = D.DIMENSION_ID
AND G.GLOBAL_VS_COMBO_ID = P.GLOBAL_VS_COMBO_ID ) PROJECT_VS_ID
, ( SELECT G.VALUE_SET_ID
FROM FEM_DIMENSIONS_B D
, FEM_GLOBAL_VS_COMBO_DEFS G
WHERE D.DIMENSION_VARCHAR_LABEL = 'TASK'
AND G.DIMENSION_ID = D.DIMENSION_ID
AND G.GLOBAL_VS_COMBO_ID = P.GLOBAL_VS_COMBO_ID ) TASK_VS_ID
, ( SELECT G.VALUE_SET_ID
FROM FEM_DIMENSIONS_B D
, FEM_GLOBAL_VS_COMBO_DEFS G
WHERE D.DIMENSION_VARCHAR_LABEL = 'USER_DIM1'
AND G.DIMENSION_ID = D.DIMENSION_ID
AND G.GLOBAL_VS_COMBO_ID = P.GLOBAL_VS_COMBO_ID ) USER_DIM1_VS_ID
, ( SELECT G.VALUE_SET_ID
FROM FEM_DIMENSIONS_B D
, FEM_GLOBAL_VS_COMBO_DEFS G
WHERE D.DIMENSION_VARCHAR_LABEL = 'USER_DIM2'
AND G.DIMENSION_ID = D.DIMENSION_ID
AND G.GLOBAL_VS_COMBO_ID = P.GLOBAL_VS_COMBO_ID ) USER_DIM2_VS_ID
, ( SELECT G.VALUE_SET_ID
FROM FEM_DIMENSIONS_B D
, FEM_GLOBAL_VS_COMBO_DEFS G
WHERE D.DIMENSION_VARCHAR_LABEL = 'USER_DIM3'
AND G.DIMENSION_ID = D.DIMENSION_ID
AND G.GLOBAL_VS_COMBO_ID = P.GLOBAL_VS_COMBO_ID ) USER_DIM3_VS_ID
, ( SELECT G.VALUE_SET_ID
FROM FEM_DIMENSIONS_B D
, FEM_GLOBAL_VS_COMBO_DEFS G
WHERE D.DIMENSION_VARCHAR_LABEL = 'USER_DIM4'
AND G.DIMENSION_ID = D.DIMENSION_ID
AND G.GLOBAL_VS_COMBO_ID = P.GLOBAL_VS_COMBO_ID ) USER_DIM4_VS_ID
, ( SELECT G.VALUE_SET_ID
FROM FEM_DIMENSIONS_B D
, FEM_GLOBAL_VS_COMBO_DEFS G
WHERE D.DIMENSION_VARCHAR_LABEL = 'USER_DIM5'
AND G.DIMENSION_ID = D.DIMENSION_ID
AND G.GLOBAL_VS_COMBO_ID = P.GLOBAL_VS_COMBO_ID ) USER_DIM5_VS_ID
, ( SELECT G.VALUE_SET_ID
FROM FEM_DIMENSIONS_B D
, FEM_GLOBAL_VS_COMBO_DEFS G
WHERE D.DIMENSION_VARCHAR_LABEL = 'USER_DIM6'
AND G.DIMENSION_ID = D.DIMENSION_ID
AND G.GLOBAL_VS_COMBO_ID = P.GLOBAL_VS_COMBO_ID ) USER_DIM6_VS_ID
, ( SELECT G.VALUE_SET_ID
FROM FEM_DIMENSIONS_B D
, FEM_GLOBAL_VS_COMBO_DEFS G
WHERE D.DIMENSION_VARCHAR_LABEL = 'USER_DIM7'
AND G.DIMENSION_ID = D.DIMENSION_ID
AND G.GLOBAL_VS_COMBO_ID = P.GLOBAL_VS_COMBO_ID ) USER_DIM7_VS_ID
, ( SELECT G.VALUE_SET_ID
FROM FEM_DIMENSIONS_B D
, FEM_GLOBAL_VS_COMBO_DEFS G
WHERE D.DIMENSION_VARCHAR_LABEL = 'USER_DIM8'
AND G.DIMENSION_ID = D.DIMENSION_ID
AND G.GLOBAL_VS_COMBO_ID = P.GLOBAL_VS_COMBO_ID ) USER_DIM8_VS_ID
, ( SELECT G.VALUE_SET_ID
FROM FEM_DIMENSIONS_B D
, FEM_GLOBAL_VS_COMBO_DEFS G
WHERE D.DIMENSION_VARCHAR_LABEL = 'USER_DIM9'
AND G.DIMENSION_ID = D.DIMENSION_ID
AND G.GLOBAL_VS_COMBO_ID = P.GLOBAL_VS_COMBO_ID ) USER_DIM9_VS_ID
, ( SELECT G.VALUE_SET_ID
FROM FEM_DIMENSIONS_B D
, FEM_GLOBAL_VS_COMBO_DEFS G
WHERE D.DIMENSION_VARCHAR_LABEL = 'USER_DIM10'
AND G.DIMENSION_ID = D.DIMENSION_ID
AND G.GLOBAL_VS_COMBO_ID = P.GLOBAL_VS_COMBO_ID ) USER_DIM10_VS_ID
FROM P )