[Home] [Help]
View: MSD_CS_DATA_V
| Product: | MSD - Demand Planning |
|---|
| Description: | This view is used by express to download custom data stream |
|---|
| Implementation/DBA Data: |
 APPS.MSD_CS_DATA_V
|
|---|
View Text
SELECT CS_DEFINITION_ID
, CS_NAME
, ATTRIBUTE_1
, ATTRIBUTE_2
, ATTRIBUTE_3
, ATTRIBUTE_4
, ATTRIBUTE_5
, ATTRIBUTE_6
, ATTRIBUTE_7
, ATTRIBUTE_8
, ATTRIBUTE_9
, ATTRIBUTE_10
, ATTRIBUTE_11
, ATTRIBUTE_12
, ATTRIBUTE_13
, ATTRIBUTE_14
, ATTRIBUTE_15
, ATTRIBUTE_16
, ATTRIBUTE_17
, ATTRIBUTE_18
, ATTRIBUTE_19
, ATTRIBUTE_20
, ATTRIBUTE_21
, ATTRIBUTE_22
, ATTRIBUTE_23
, ATTRIBUTE_24
, ATTRIBUTE_25
, ATTRIBUTE_26
, ATTRIBUTE_27
, ATTRIBUTE_28
, ATTRIBUTE_29
, ATTRIBUTE_30
, ATTRIBUTE_31
, ATTRIBUTE_32
, ATTRIBUTE_33
, ATTRIBUTE_34
, TO_NUMBER(ATTRIBUTE_41)
, TO_NUMBER(ATTRIBUTE_42)
, TO_DATE(ATTRIBUTE_43
, 'YYYY/MM/DD')
, TO_NUMBER(ATTRIBUTE_44)
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, LAST_REFRESH_NUM
, CREATED_BY_REFRESH_NUM
, ACTION_CODE
FROM MSD_CS_DATA
Columns
| Name |
| CS_DEFINITION_ID |
| CS_NAME |
| INSTANCE |
| PRD_LEVEL_ID |
| PRD_SR_LEVEL_VALUE_PK |
| PRD_LEVEL_VALUE |
| PRD_LEVEL_VALUE_PK |
| GEO_LEVEL_ID |
| GEO_SR_LEVEL_VALUE_PK |
| GEO_LEVEL_VALUE |
| GEO_LEVEL_VALUE_PK |
| ORG_LEVEL_ID |
| ORG_SR_LEVEL_VALUE_PK |
| ORG_LEVEL_VALUE |
| ORG_LEVEL_VALUE_PK |
| PRD_PARENT_LEVEL_ID |
| PRD_PARENT_SR_LEVEL_VALUE_PK |
| PRD_PARENT_LEVEL_VALUE |
| PRD_PARENT_LEVEL_VALUE_PK |
| REP_LEVEL_ID |
| REP_SR_LEVEL_VALUE_PK |
| REP_LEVEL_VALUE |
| REP_LEVEL_VALUE_PK |
| CHN_LEVEL_ID |
| CHN_SR_LEVEL_VALUE_PK |
| CHN_LEVEL_VALUE |
| CHN_LEVEL_VALUE_PK |
| UD1_LEVEL_ID |
| UD1_SR_LEVEL_VALUE_PK |
| UD1_LEVEL_VALUE |
| UD1_LEVEL_VALUE_PK |
| UD2_LEVEL_ID |
| UD2_SR_LEVEL_VALUE_PK |
| UD2_LEVEL_VALUE |
| UD2_LEVEL_VALUE_PK |
| TIME_LEVEL_ID |
| QUANTITY |
| AMOUNT |
| END_DATE |
| PRICE |
| CREATION_DATE |
| CREATED_BY |
| LAST_UPDATE_DATE |
| LAST_UPDATED_BY |
| LAST_UPDATE_LOGIN |
| LAST_REFRESH_NUM |
| CREATED_BY_REFRESH_NUM |
| ACTION_CODE |