VIEW: APPS.MSD_CS_DEFINITIONS_V1

Source

View Text - Preformatted

SELECT csd.CS_DEFINITION_ID, csd.NAME,csd.DESCRIPTION,csd.CS_CLASSIFICATION,csd.CS_TYPE, lok1.MEANING CS_TYPE_DESC, csd.LOWEST_LEVEL_FLAG,csd.STRICT_FLAG,csd.SYSTEM_FLAG, csd.aggregation_allowed_flag, csd.allocation_allowed_flag, csd.stream_editable_flag, csd.measurement_type, lok2.meaning, csd.PLANNING_SERVER_VIEW_NAME,csd.SOURCE_VIEW_NAME,csd.COLLECTION_PROGRAM_NAME, csd.COLLECT_ADDTL_WHERE_CLAUSE,csd.PULL_ADDTL_WHERE_CLAUSE, csd.cs_type, lok1.meaning, csd.multiple_stream_flag, csd.VALID_FLAG, csd.cs_lov_view_name, dfdim1.collect_level_id, dfdim2.collect_level_id, dfdim3.collect_level_id, dfdim4.collect_level_id, dfdim5.collect_level_id, dfdim6.collect_level_id, DFDIM7.COLLECT_LEVEL_ID, DFDIM8.COLLECT_LEVEL_ID, dfdim1.collect_flag, dfdim2.collect_flag, dfdim3.collect_flag, dfdim4.collect_flag,dfdim5.collect_flag, dfdim6.collect_flag, dfdim7.collect_flag, dfdim8.collect_flag, csd.CREATION_DATE,csd.CREATED_BY,csd.LAST_UPDATE_DATE,csd.LAST_UPDATED_BY,csd.LAST_UPDATE_LOGIN, csd.REQUEST_ID,csd.PROGRAM_APPLICATION_ID,csd.PROGRAM_ID,csd.PROGRAM_UPDATE_DATE, dcs.collect_level_id, dcs.collect_flag from msd_cs_definitions csd, fnd_lookup_values_vl lok1, fnd_lookup_values_vl lok2, msd_cs_defn_dim_dtls dcs, msd_cs_defn_dim_dtls dfdim1, msd_cs_defn_dim_dtls dfdim2, msd_cs_defn_dim_dtls dfdim3, msd_cs_defn_dim_dtls dfdim4, msd_cs_defn_dim_dtls dfdim5, msd_cs_defn_dim_dtls dfdim6, msd_cs_defn_dim_dtls dfdim7, msd_cs_defn_dim_dtls dfdim8 WHERE csd.cs_type = lok1.lookup_code (+) and lok1.lookup_type (+) = 'MSD_CS_STREAM_SOURCE_TYPE' and csd.measurement_type = lok2.lookup_code (+) and lok2.lookup_type (+) = 'MSD_CS_MEASUREMENT_TYPE' and csd.cs_definition_id = dcs.cs_definition_id (+) and dcs.dimension_code (+) = 'DCS' and csd.cs_definition_id = dfdim1.cs_definition_id (+) and dfdim1.dimension_code (+) = 'PRD' and csd.cs_definition_id = dfdim2.cs_definition_id (+) and dfdim2.dimension_code (+) = 'GEO' and csd.cs_definition_id = dfdim3.cs_definition_id (+) and dfdim3.dimension_code (+) = 'ORG' and csd.cs_definition_id = dfdim4.cs_definition_id (+) and dfdim4.dimension_code (+) = 'CHN' and csd.cs_definition_id = dfdim5.cs_definition_id (+) and dfdim5.dimension_code (+) = 'REP' and csd.cs_definition_id = dfdim6.cs_definition_id (+) and dfdim6.dimension_code (+) = 'UD1' and csd.cs_definition_id = dfdim7.cs_definition_id (+) and dfdim7.dimension_code (+) = 'UD2' and csd.cs_definition_id = dfdim8.cs_definition_id (+) and dfdim8.dimension_code (+) = 'TIM'

View Text - HTML Formatted

SELECT CSD.CS_DEFINITION_ID
, CSD.NAME
, CSD.DESCRIPTION
, CSD.CS_CLASSIFICATION
, CSD.CS_TYPE
, LOK1.MEANING CS_TYPE_DESC
, CSD.LOWEST_LEVEL_FLAG
, CSD.STRICT_FLAG
, CSD.SYSTEM_FLAG
, CSD.AGGREGATION_ALLOWED_FLAG
, CSD.ALLOCATION_ALLOWED_FLAG
, CSD.STREAM_EDITABLE_FLAG
, CSD.MEASUREMENT_TYPE
, LOK2.MEANING
, CSD.PLANNING_SERVER_VIEW_NAME
, CSD.SOURCE_VIEW_NAME
, CSD.COLLECTION_PROGRAM_NAME
, CSD.COLLECT_ADDTL_WHERE_CLAUSE
, CSD.PULL_ADDTL_WHERE_CLAUSE
, CSD.CS_TYPE
, LOK1.MEANING
, CSD.MULTIPLE_STREAM_FLAG
, CSD.VALID_FLAG
, CSD.CS_LOV_VIEW_NAME
, DFDIM1.COLLECT_LEVEL_ID
, DFDIM2.COLLECT_LEVEL_ID
, DFDIM3.COLLECT_LEVEL_ID
, DFDIM4.COLLECT_LEVEL_ID
, DFDIM5.COLLECT_LEVEL_ID
, DFDIM6.COLLECT_LEVEL_ID
, DFDIM7.COLLECT_LEVEL_ID
, DFDIM8.COLLECT_LEVEL_ID
, DFDIM1.COLLECT_FLAG
, DFDIM2.COLLECT_FLAG
, DFDIM3.COLLECT_FLAG
, DFDIM4.COLLECT_FLAG
, DFDIM5.COLLECT_FLAG
, DFDIM6.COLLECT_FLAG
, DFDIM7.COLLECT_FLAG
, DFDIM8.COLLECT_FLAG
, CSD.CREATION_DATE
, CSD.CREATED_BY
, CSD.LAST_UPDATE_DATE
, CSD.LAST_UPDATED_BY
, CSD.LAST_UPDATE_LOGIN
, CSD.REQUEST_ID
, CSD.PROGRAM_APPLICATION_ID
, CSD.PROGRAM_ID
, CSD.PROGRAM_UPDATE_DATE
, DCS.COLLECT_LEVEL_ID
, DCS.COLLECT_FLAG
FROM MSD_CS_DEFINITIONS CSD
, FND_LOOKUP_VALUES_VL LOK1
, FND_LOOKUP_VALUES_VL LOK2
, MSD_CS_DEFN_DIM_DTLS DCS
, MSD_CS_DEFN_DIM_DTLS DFDIM1
, MSD_CS_DEFN_DIM_DTLS DFDIM2
, MSD_CS_DEFN_DIM_DTLS DFDIM3
, MSD_CS_DEFN_DIM_DTLS DFDIM4
, MSD_CS_DEFN_DIM_DTLS DFDIM5
, MSD_CS_DEFN_DIM_DTLS DFDIM6
, MSD_CS_DEFN_DIM_DTLS DFDIM7
, MSD_CS_DEFN_DIM_DTLS DFDIM8
WHERE CSD.CS_TYPE = LOK1.LOOKUP_CODE (+)
AND LOK1.LOOKUP_TYPE (+) = 'MSD_CS_STREAM_SOURCE_TYPE'
AND CSD.MEASUREMENT_TYPE = LOK2.LOOKUP_CODE (+)
AND LOK2.LOOKUP_TYPE (+) = 'MSD_CS_MEASUREMENT_TYPE'
AND CSD.CS_DEFINITION_ID = DCS.CS_DEFINITION_ID (+)
AND DCS.DIMENSION_CODE (+) = 'DCS'
AND CSD.CS_DEFINITION_ID = DFDIM1.CS_DEFINITION_ID (+)
AND DFDIM1.DIMENSION_CODE (+) = 'PRD'
AND CSD.CS_DEFINITION_ID = DFDIM2.CS_DEFINITION_ID (+)
AND DFDIM2.DIMENSION_CODE (+) = 'GEO'
AND CSD.CS_DEFINITION_ID = DFDIM3.CS_DEFINITION_ID (+)
AND DFDIM3.DIMENSION_CODE (+) = 'ORG'
AND CSD.CS_DEFINITION_ID = DFDIM4.CS_DEFINITION_ID (+)
AND DFDIM4.DIMENSION_CODE (+) = 'CHN'
AND CSD.CS_DEFINITION_ID = DFDIM5.CS_DEFINITION_ID (+)
AND DFDIM5.DIMENSION_CODE (+) = 'REP'
AND CSD.CS_DEFINITION_ID = DFDIM6.CS_DEFINITION_ID (+)
AND DFDIM6.DIMENSION_CODE (+) = 'UD1'
AND CSD.CS_DEFINITION_ID = DFDIM7.CS_DEFINITION_ID (+)
AND DFDIM7.DIMENSION_CODE (+) = 'UD2'
AND CSD.CS_DEFINITION_ID = DFDIM8.CS_DEFINITION_ID (+)
AND DFDIM8.DIMENSION_CODE (+) = 'TIM'