VIEW: APPS.MSD_CS_DEFN_DIM_DTLS_V

Source

View Text - Preformatted

SELECT dfdim.cs_defn_dim_dtls_id, dfdim.cs_definition_id, dfdim.dimension_code, dfdim.collect_level_id, dim.meaning, dfdim.collect_flag, msd_cs_dfn_utl.get_level_desc(dfdim.dimension_code, dfdim.collect_level_id) level_desc, dfdim.allocation_type, allo.meaning, dfdim.aggregation_type, agg.meaning, dfdim.creation_date, dfdim.created_by, dfdim.last_update_date, dfdim.last_updated_by, dfdim.last_update_login, dfdim.request_id, dfdim.program_application_id, dfdim.program_id, dfdim.program_update_date from msd_cs_defn_dim_dtls DFDIM, fnd_lookup_values_vl DIM, fnd_lookup_values_vl agg, fnd_lookup_values_vl allo WHERE DFDIM.dimension_code = dim.lookup_code and DIM.lookup_type = 'MSD_DIMENSIONS' and dfdim.aggregation_type = agg.lookup_code (+) and agg.lookup_type (+) = 'MSD_CS_AGGREGATION_TYPE' and dfdim.allocation_type = allo.lookup_code (+) and allo.lookup_type (+) = 'MSD_CS_ALLOCATION_TYPE'

View Text - HTML Formatted

SELECT DFDIM.CS_DEFN_DIM_DTLS_ID
, DFDIM.CS_DEFINITION_ID
, DFDIM.DIMENSION_CODE
, DFDIM.COLLECT_LEVEL_ID
, DIM.MEANING
, DFDIM.COLLECT_FLAG
, MSD_CS_DFN_UTL.GET_LEVEL_DESC(DFDIM.DIMENSION_CODE
, DFDIM.COLLECT_LEVEL_ID) LEVEL_DESC
, DFDIM.ALLOCATION_TYPE
, ALLO.MEANING
, DFDIM.AGGREGATION_TYPE
, AGG.MEANING
, DFDIM.CREATION_DATE
, DFDIM.CREATED_BY
, DFDIM.LAST_UPDATE_DATE
, DFDIM.LAST_UPDATED_BY
, DFDIM.LAST_UPDATE_LOGIN
, DFDIM.REQUEST_ID
, DFDIM.PROGRAM_APPLICATION_ID
, DFDIM.PROGRAM_ID
, DFDIM.PROGRAM_UPDATE_DATE
FROM MSD_CS_DEFN_DIM_DTLS DFDIM
, FND_LOOKUP_VALUES_VL DIM
, FND_LOOKUP_VALUES_VL AGG
, FND_LOOKUP_VALUES_VL ALLO
WHERE DFDIM.DIMENSION_CODE = DIM.LOOKUP_CODE
AND DIM.LOOKUP_TYPE = 'MSD_DIMENSIONS'
AND DFDIM.AGGREGATION_TYPE = AGG.LOOKUP_CODE (+)
AND AGG.LOOKUP_TYPE (+) = 'MSD_CS_AGGREGATION_TYPE'
AND DFDIM.ALLOCATION_TYPE = ALLO.LOOKUP_CODE (+)
AND ALLO.LOOKUP_TYPE (+) = 'MSD_CS_ALLOCATION_TYPE'