View: MSD_CS_DEFINITIONS_V1

Product:	MSD - Demand Planning
Description:	This view provides Data Stream Definition and it's dimension properties.
Implementation/DBA Data:	APPS.MSD_CS_DEFINITIONS_V1

View Text

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
FROM MSD_CS_DEFINITIONS CSD
, FND_LOOKUP_VALUES_VL LOK1
, FND_LOOKUP_VALUES_VL LOK2
, 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 = 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'

Columns