[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | MSD_SHIPMENT_DATA_CS_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  MSD.MSD_SHIPMENT_DATA_CS_V
|
| Subobject Name: | |
| Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This view provides the shipment Data in the planning server and is not restricted by a demand plan. If the Planning Server is used for only one demand plan then we can go directly out of the fact table or this view. However if the planning server t is used for supporting multiple demand plans, then the user needs to write views on top of the fact table or this table, and these views would be attached to the view_name attribute of them demand plan parameters.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PRD_LEVEL_ID | NUMBER | Product Level Id | ||
| PRD_LEVEL_VALUE_PK | NUMBER | Yes | Product Level Value Primary Key | |
| GEO_LEVEL_ID | NUMBER | Geography Level Id | ||
| GEO_LEVEL_VALUE_PK | NUMBER | Yes | Geography Level Value Primary Key | |
| ORG_LEVEL_ID | NUMBER | Org Level Id | ||
| ORG_LEVEL_VALUE_PK | NUMBER | Yes | Org Level Value Primary Key | |
| REP_LEVEL_ID | NUMBER | Sales Rep Level Id | ||
| REP_LEVEL_VALUE_PK | NUMBER | Yes | Sales Rep Level Value Primary Key | |
| CHN_LEVEL_ID | NUMBER | Sales Chennal Level Id | ||
| CHN_LEVEL_VALUE_PK | NUMBER | Yes | Sales Chennal Level Value Primary Key | |
| UD1_LEVEL_ID | VARCHAR2 | (0) | User Defined Level Id | |
| UD1_LEVEL_VALUE_PK | VARCHAR2 | (0) | User Defined Level Value Primary Key | |
| UD2_LEVEL_ID | VARCHAR2 | (0) | User Defined Level Id | |
| UD2_LEVEL_VALUE_PK | VARCHAR2 | (0) | User Defined Level Value Primary Key | |
| PRD_PARENT_LEVEL_ID | VARCHAR2 | (1) | Product Parent Level Id | |
| PRD_PARENT_LEVEL_VALUE_PK | NUMBER | Product Parent Level value Pk | ||
| TIME_LEVEL_ID | NUMBER | Time Level Id | ||
| BOOKED_DATE | DATE | Booked Date | ||
| REQUESTED_DATE | DATE | Requested Date | ||
| PROMISED_DATE | DATE | Promised Date | ||
| SHIPPED_DATE | DATE | Yes | Shipped Date | |
| AMOUNT | NUMBER | Amount | ||
| QUANTITY | NUMBER | Quantity Shipped | ||
| CREATION_DATE | DATE | Yes | Who columns | |
| CREATED_BY | NUMBER | Yes | Who columns | |
| LAST_UPDATE_DATE | DATE | Yes | Who columns | |
| LAST_UPDATED_BY | NUMBER | Yes | Who columns | |
| LAST_UPDATE_LOGIN | NUMBER | Yes | Who columns | |
| LAST_REFRESH_NUM | NUMBER | last refresh number | ||
| CREATED_BY_REFRESH_NUM | NUMBER | created by refresh number | ||
| ACTION_CODE | VARCHAR2 | (30) | DML action code | |
| SCHEDULED_DATE | DATE | Scheduled Ship Date | ||
| SCHEDULED_ARRIVAL_DATE | DATE | Scheduled Arrival Date | ||
| DCS_LEVEL_ID | NUMBER | Product Level Id | ||
| DCS_LEVEL_VALUE_PK | NUMBER | Prd Level Value |
Cut, paste (and edit) the following text to query this object:
SELECT PRD_LEVEL_ID
, PRD_LEVEL_VALUE_PK
, GEO_LEVEL_ID
, GEO_LEVEL_VALUE_PK
, ORG_LEVEL_ID
, ORG_LEVEL_VALUE_PK
, REP_LEVEL_ID
, REP_LEVEL_VALUE_PK
, CHN_LEVEL_ID
, CHN_LEVEL_VALUE_PK
, UD1_LEVEL_ID
, UD1_LEVEL_VALUE_PK
, UD2_LEVEL_ID
, UD2_LEVEL_VALUE_PK
, PRD_PARENT_LEVEL_ID
, PRD_PARENT_LEVEL_VALUE_PK
, TIME_LEVEL_ID
, BOOKED_DATE
, REQUESTED_DATE
, PROMISED_DATE
, SHIPPED_DATE
, AMOUNT
, QUANTITY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, LAST_REFRESH_NUM
, CREATED_BY_REFRESH_NUM
, ACTION_CODE
, SCHEDULED_DATE
, SCHEDULED_ARRIVAL_DATE
, DCS_LEVEL_ID
, DCS_LEVEL_VALUE_PK
FROM APPS.MSD_SHIPMENT_DATA_CS_V;
APPS
MSD_LEVEL_VALUES
MSD_SHIPMENT_DATA
APPS.MSD_SHIPMENT_DATA_CS_V is not referenced by any database object
|
|
|
|