[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | MSD_CS_DEFINITIONS |
|---|---|
| Object Type: | TABLE |
| Owner: | MSD |
| FND Design Data: |  MSD.MSD_CS_DEFINITIONS
|
| Subobject Name: | |
| Status: | VALID |
This table stores Custom Stream Definitions.
| Tablespace: |  APPS_TS_SEED |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| MSD_CS_DEFINITIONS_U1 | NORMAL | UNIQUE |
APPS_TS_SEED
|
 CS_DEFINITION_ID
|
| MSD_CS_DEFINITIONS_U2 | NORMAL | UNIQUE |
APPS_TS_SEED
|
NAME
|
| 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) | Description of Custom Stream Definition. | |
| 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' |
| LOWEST_LEVEL_FLAG | VARCHAR2 | (30) | Reserved. | |
| STRICT_FLAG | VARCHAR2 | (30) | Yes | Reserved for internal use.. |
| SYSTEM_FLAG | VARCHAR2 | (30) | Yes | Identifies if the stream is delivered by Oracle Demand Planning Application and can not be changed by the customer. |
| LOCAL_STREAM_FLAG | VARCHAR2 | (30) | Reserved for internal use. | |
| MULTIPLE_STREAM_FLAG | VARCHAR2 | (30) | Identifies if multiple stream of this type can be collected for the same time period. | |
| AGGREGATION_ALLOWED_FLAG | VARCHAR2 | (30) | Definition allows aggregation. | |
| ALLOCATION_ALLOWED_FLAG | VARCHAR2 | (30) | Definition allows allocation. | |
| MEASUREMENT_TYPE | VARCHAR2 | (30) | Measurement supported by the definition. Lookup - FND_CS_MEASUREMENT_TYPE. | |
| STREAM_EDITABLE_FLAG | VARCHAR2 | (30) | Is stream editable. | |
| PRD_LEVEL_ID | NUMBER | (15) | Reserved for internal use. | |
| GEO_LEVEL_ID | NUMBER | (15) | Reserved for internal use. | |
| CUS_LEVEL_ID | NUMBER | (15) | Reserved for internal use. | |
| ORG_LEVEL_ID | NUMBER | (15) | Reserved for internal use. | |
| CHN_LEVEL_ID | NUMBER | (15) | Reserved for internal use. | |
| REP_LEVEL_ID | NUMBER | (15) | Reserved for internal use. | |
| UD1_LEVEL_ID | NUMBER | (15) | Reserved for internal use. | |
| UD2_LEVEL_ID | NUMBER | (15) | Reserved for internal use. | |
| PLANNING_SERVER_VIEW_NAME | VARCHAR2 | (30) | Planning Server View Name that'll expose data to Express. | |
| SOURCE_VIEW_NAME | VARCHAR2 | (30) | Source View Name, from where the data is collected. | |
| COLLECTION_PROGRAM_NAME | VARCHAR2 | (30) | Reserved for Future Use. | |
| COLLECT_ADDTL_WHERE_CLAUSE | VARCHAR2 | (2000) | Define additional filter condition to collection program. | |
| PULL_ADDTL_WHERE_CLAUSE | VARCHAR2 | (2000) | Reserved for Future Use. | |
| VALID_FLAG | VARCHAR2 | (30) | Status of the row. | |
| ENABLE_FLAG | VARCHAR2 | (30) | Is Stream Enabled for use. | |
| CREATED_BY | NUMBER | Yes | Who Columns | |
| CREATION_DATE | DATE | Yes | Who Columns | |
| LAST_UPDATED_BY | NUMBER | Yes | Who Columns | |
| LAST_UPDATE_DATE | DATE | Yes | Who Columns | |
| LAST_UPDATE_LOGIN | NUMBER | Who Columns | ||
| PROGRAM_APPLICATION_ID | NUMBER | Enhanced Who Columns. | ||
| PROGRAM_ID | NUMBER | Enhanced Who Columns. | ||
| PROGRAM_UPDATE_DATE | DATE | Enhanced Who Columns. | ||
| REQUEST_ID | NUMBER | Enhanced Who Columns. | ||
| CS_LOV_VIEW_NAME | VARCHAR2 | (100) | Name of view used for Parameter LOV on DP defn form. | |
| DEPENDENT_DATA_FLAG | VARCHAR2 | (30) | Dependent Demand Enabled Flag | |
| COMPOSITE_GROUP_CODE | NUMBER | Composite Group Identifier | ||
| DEPENDENT_DEMAND_CODE | VARCHAR2 | (30) | Dependent Demand Code | |
| STRIPE_FLAG | VARCHAR2 | (30) | Determines whether this stream can be striped with msd_cs_data_ds. | |
| PLANNING_SERVER_VIEW_NAME_DS | VARCHAR2 | (30) | Striped Planning Server View Name | |
| PLAN_TYPE | VARCHAR2 | (30) | Plan Type | |
| LIABILITY_USER_FLAG | VARCHAR2 | (240) | This Flag indicates whether the given measure is includable by user |
Cut, paste (and edit) the following text to query this object:
SELECT CS_DEFINITION_ID
, NAME
, DESCRIPTION
, CS_CLASSIFICATION
, CS_TYPE
, LOWEST_LEVEL_FLAG
, STRICT_FLAG
, SYSTEM_FLAG
, LOCAL_STREAM_FLAG
, MULTIPLE_STREAM_FLAG
, AGGREGATION_ALLOWED_FLAG
, ALLOCATION_ALLOWED_FLAG
, MEASUREMENT_TYPE
, STREAM_EDITABLE_FLAG
, PRD_LEVEL_ID
, GEO_LEVEL_ID
, CUS_LEVEL_ID
, ORG_LEVEL_ID
, CHN_LEVEL_ID
, REP_LEVEL_ID
, UD1_LEVEL_ID
, UD2_LEVEL_ID
, PLANNING_SERVER_VIEW_NAME
, SOURCE_VIEW_NAME
, COLLECTION_PROGRAM_NAME
, COLLECT_ADDTL_WHERE_CLAUSE
, PULL_ADDTL_WHERE_CLAUSE
, VALID_FLAG
, ENABLE_FLAG
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
, CS_LOV_VIEW_NAME
, DEPENDENT_DATA_FLAG
, COMPOSITE_GROUP_CODE
, DEPENDENT_DEMAND_CODE
, STRIPE_FLAG
, PLANNING_SERVER_VIEW_NAME_DS
, PLAN_TYPE
, LIABILITY_USER_FLAG
FROM MSD.MSD_CS_DEFINITIONS;
MSD.MSD_CS_DEFINITIONS does not reference any database object
MSD.MSD_CS_DEFINITIONS is referenced by following:
APPS
MSD_CS_DEFINITIONS
|
|
|
|