View: MSD_CS_DEFINITIONS_VL

Product:	MSD - Demand Planning
Description:	This view provides Data Stream Definition. It is used in "Define Data Stream UI".
Implementation/DBA Data:	APPS.MSD_CS_DEFINITIONS_VL

View Text

SELECT CSD.CS_DEFINITION_ID
, CSD.NAME
, CSD_TL.DESCRIPTION
, CSD.CS_CLASSIFICATION
, CSD.CS_TYPE
, LOK1.MEANING
, CSD.STRICT_FLAG
, CSD.SYSTEM_FLAG
, CSD.AGGREGATION_ALLOWED_FLAG
, CSD.ALLOCATION_ALLOWED_FLAG
, CSD.STREAM_EDITABLE_FLAG
, CSD.ENABLE_FLAG
, CSD.CS_LOV_VIEW_NAME
, 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.MULTIPLE_STREAM_FLAG
, CSD.VALID_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
, CSD.LOWEST_LEVEL_FLAG
, CSD.COMPOSITE_GROUP_CODE
, CSD.DEPENDENT_DATA_FLAG
FROM MSD_CS_DEFINITIONS CSD
, MSD_CS_DEFINITIONS_TL CSD_TL
, FND_LOOKUP_VALUES_VL LOK1
, FND_LOOKUP_VALUES_VL LOK2
WHERE CSD.CS_DEFINITION_ID = CSD_TL.CS_DEFINITION_ID
AND CSD_TL.LANGUAGE = USERENV('LANG')
AND 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'

Columns