VIEW: APPS.FEM_BI_ATTR_DIMENSIONS_V

Source

View Text - Preformatted

SELECT 0 DIMENSION_ID, LOOKUP_CODE DIMENSION_VARCHAR_LABEL, MEANING DIMENSION_NAME FROM FEM_LOOKUPS WHERE LOOKUP_TYPE = 'FEM_BI_ATTR_DIM_ALLOWED_DSC' AND LOOKUP_CODE = 'ALL' UNION ALL SELECT D.DIMENSION_ID, D.DIMENSION_VARCHAR_LABEL, D.DIMENSION_NAME FROM FEM_XDIM_DIMENSIONS X, FEM_DIMENSIONS_VL D WHERE D.DIMENSION_ID = X.DIMENSION_ID AND X.SIMPLE_DIMENSION_FLAG = 'N' AND X.ATTRIBUTE_TABLE_NAME LIKE 'FEM%' AND X.COMPOSITE_DIMENSION_FLAG = 'N' AND X.MEMBER_TL_TABLE_NAME <> X.MEMBER_VL_OBJECT_NAME

View Text - HTML Formatted

SELECT 0 DIMENSION_ID
, LOOKUP_CODE DIMENSION_VARCHAR_LABEL
, MEANING DIMENSION_NAME
FROM FEM_LOOKUPS
WHERE LOOKUP_TYPE = 'FEM_BI_ATTR_DIM_ALLOWED_DSC'
AND LOOKUP_CODE = 'ALL' UNION ALL SELECT D.DIMENSION_ID
, D.DIMENSION_VARCHAR_LABEL
, D.DIMENSION_NAME
FROM FEM_XDIM_DIMENSIONS X
, FEM_DIMENSIONS_VL D
WHERE D.DIMENSION_ID = X.DIMENSION_ID
AND X.SIMPLE_DIMENSION_FLAG = 'N'
AND X.ATTRIBUTE_TABLE_NAME LIKE 'FEM%'
AND X.COMPOSITE_DIMENSION_FLAG = 'N'
AND X.MEMBER_TL_TABLE_NAME <> X.MEMBER_VL_OBJECT_NAME