[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | MSD_SHIPMENT_DATA_ORIG_CS_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  MSD.MSD_SHIPMENT_DATA_ORIG_CS_V
|
| Subobject Name: | |
| Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This view to support product substitution in shipment data
| 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 | (0) | Product Parent Level Id | |
| PRD_PARENT_LEVEL_VALUE_PK | VARCHAR2 | (0) | 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_ORIG_CS_V;
APPS
MSD_LEVEL_VALUES
MSD_SHIPMENT_DATA
APPS.MSD_SHIPMENT_DATA_ORIG_CS_V is not referenced by any database object
|
|
|
|