eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.MSD_CS_DEFINITIONS_VL

Object Details

Object Name:	MSD_CS_DEFINITIONS_VL
Object Type:	VIEW
Owner:	APPS
FND Design Data:	MSD.MSD_CS_DEFINITIONS_VL
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

This view provides Data Stream Definition. It is used in "Define Data Stream UI".

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
CS_DEFINITION_ID	NUMBER	(15)	Yes	Primary Key. Generated using MSD_CS_DEFINITIONS_S sequence.
NAME	VARCHAR2	(30)	Yes	Unique Short Name of the Custom Stream Definition.
DESCRIPTION	VARCHAR2	(240)	Yes	Stream Description.
CS_CLASSIFICATION	VARCHAR2	(30)	Yes	Classification of Stream Definition. DATA or OTHER.
CS_TYPE	VARCHAR2	(30)	Yes	Stream Source - Based on FND_LOOKUP 'MSD_CS_STREAM_SOURCE_TYPE'
CS_TYPE_DESC	VARCHAR2	(80)		CS_TYPE description.
STRICT_FLAG	VARCHAR2	(30)	Yes	Data collected at Fixed Level Flag.
SYSTEM_FLAG	VARCHAR2	(30)	Yes	System Flag. Determines if the stream is defined by user or Oracle Delivered.
AGGREGATION_ALLOWED_FLAG	VARCHAR2	(30)		Aggregation Allowed Flag.
ALLOCATION_ALLOWED_FLAG	VARCHAR2	(30)		Allocation Allowed Flag.
STREAM_EDITABLE_FLAG	VARCHAR2	(30)		Stream Editable in Express Flag.
ENABLE_FLAG	VARCHAR2	(30)		Is Stream Enabled for use Flag.
CS_LOV_VIEW_NAME	VARCHAR2	(100)		Custom Stream LOV view name
MEASUREMENT_TYPE	VARCHAR2	(30)		Measurement Type. Lookup based on FND_LOOKUP - MSD_CS_MEASUREMENT_TYPE.
MEASUREMENT_TYPE_DESC	VARCHAR2	(80)		Measurement Type Description.
PLANNING_SERVER_VIEW_NAME	VARCHAR2	(30)		Planning Server View that will be used to look at the data.
PLANNING_SERVER_VIEW_NAME_DS	VARCHAR2	(30)		Planning Server View that will be used to look at the data.
SOURCE_VIEW_NAME	VARCHAR2	(30)		Source View Name which will be used to collect data.
STRIPE_FLAG	VARCHAR2	(30)		Stripe Flag
COLLECTION_PROGRAM_NAME	VARCHAR2	(30)		Reserved for future use.
COLLECT_ADDTL_WHERE_CLAUSE	VARCHAR2	(2000)		Collection Filter Condition.
PULL_ADDTL_WHERE_CLAUSE	VARCHAR2	(2000)		Reserved for future use.
MULTIPLE_STREAM_FLAG	VARCHAR2	(30)		Multiple Stream Flag.
VALID_FLAG	VARCHAR2	(30)		Valid Flag.
CREATION_DATE	DATE		Yes	Standard Who Columns.
CREATED_BY	NUMBER		Yes	Standard Who Columns.
LAST_UPDATE_DATE	DATE		Yes	Standard Who Columns.
LAST_UPDATED_BY	NUMBER		Yes	Standard Who Columns.
LAST_UPDATE_LOGIN	NUMBER			Standard Who Columns.
REQUEST_ID	NUMBER			Extended Who Column.
PROGRAM_APPLICATION_ID	NUMBER			Extended Who Column.
PROGRAM_ID	NUMBER			Extended Who Column.
PROGRAM_UPDATE_DATE	DATE			Extended Who Column.
LOWEST_LEVEL_FLAG	VARCHAR2	(30)		Lowest Level Flag.
COMPOSITE_GROUP_CODE	NUMBER			Composite Group Identifier
DEPENDENT_DATA_FLAG	VARCHAR2	(30)		Dependent Data Flag
DEPENDENT_DEMAND_CODE	VARCHAR2	(30)		Dependent Demand Code
PLAN_TYPE	VARCHAR2	(30)		Plan type
LIABILITY_USER_FLAG	VARCHAR2	(240)		This Flag indicates whether the given measure is includable by user

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT CS_DEFINITION_ID
,      NAME
,      DESCRIPTION
,      CS_CLASSIFICATION
,      CS_TYPE
,      CS_TYPE_DESC
,      STRICT_FLAG
,      SYSTEM_FLAG
,      AGGREGATION_ALLOWED_FLAG
,      ALLOCATION_ALLOWED_FLAG
,      STREAM_EDITABLE_FLAG
,      ENABLE_FLAG
,      CS_LOV_VIEW_NAME
,      MEASUREMENT_TYPE
,      MEASUREMENT_TYPE_DESC
,      PLANNING_SERVER_VIEW_NAME
,      PLANNING_SERVER_VIEW_NAME_DS
,      SOURCE_VIEW_NAME
,      STRIPE_FLAG
,      COLLECTION_PROGRAM_NAME
,      COLLECT_ADDTL_WHERE_CLAUSE
,      PULL_ADDTL_WHERE_CLAUSE
,      MULTIPLE_STREAM_FLAG
,      VALID_FLAG
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      LOWEST_LEVEL_FLAG
,      COMPOSITE_GROUP_CODE
,      DEPENDENT_DATA_FLAG
,      DEPENDENT_DEMAND_CODE
,      PLAN_TYPE
,      LIABILITY_USER_FLAG
FROM APPS.MSD_CS_DEFINITIONS_VL;

Dependencies

[top of page]

APPS.MSD_CS_DEFINITIONS_VL references the following:

APPS: FND_LOOKUP_VALUES_VL; MSD_CS_DEFINITIONS; MSD_CS_DEFINITIONS_TL

APPS.MSD_CS_DEFINITIONS_VL is referenced by following:

APPS: MSD_CS_DATA_HEADERS_V; MSD_DP_PARAMETERS_CS_V; MSD_DP_SCENARIOS_VL; MSD_VALIDATE_DEMAND_PLAN - show dependent code