[Home] [Help] [Dependency Information]
Object Name: | MSD_INTRANSIT_DS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
Planning Server view for stream Intransit when plan is striped. This view is no longer in use
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DEMAND_PLAN_ID | NUMBER | Demand Plan Id | ||
PLAN_ID | NUMBER | Plan Id | ||
CS_NAME | VARCHAR2 | (255) | Plan Name | |
ORG_LEVEL_VALUE_PK | NUMBER | Org Level Primary Key | ||
ORG_LEVEL_ID | NUMBER | Org Level Id | ||
PRD_LEVEL_VALUE_PK | NUMBER | Product Level Value Primary Key | ||
PRD_LEVEL_ID | NUMBER | Product Level Id | ||
TIME_LEVEL_ID | NUMBER | Time Level Id | ||
QUANTITY | NUMBER | Quantity | ||
SCHEDULE_DATE | DATE | Schedule date | ||
CREATION_DATE | DATE | Standard who column | ||
CREATED_BY | NUMBER | Standard who column | ||
LAST_UPDATE_DATE | DATE | Standard who column | ||
LAST_UPDATED_BY | NUMBER | Standard who column | ||
LAST_UPDATE_LOGIN | NUMBER | Standard who column | ||
LAST_REFRESH_NUM | NUMBER | last refresh number | ||
CREATED_BY_REFRESH_NUM | NUMBER | created by refresh number | ||
ACTION_CODE | VARCHAR2 | (30) | DML action code | |
PRD_PARENT_LEVEL_ID | NUMBER | Product Parent Level Id | ||
PRD_PARENT_LEVEL_VALUE_PK | NUMBER | Product Parent Level value Pk |
Cut, paste (and edit) the following text to query this object:
SELECT DEMAND_PLAN_ID
, PLAN_ID
, CS_NAME
, ORG_LEVEL_VALUE_PK
, ORG_LEVEL_ID
, PRD_LEVEL_VALUE_PK
, PRD_LEVEL_ID
, TIME_LEVEL_ID
, QUANTITY
, SCHEDULE_DATE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, LAST_REFRESH_NUM
, CREATED_BY_REFRESH_NUM
, ACTION_CODE
, PRD_PARENT_LEVEL_ID
, PRD_PARENT_LEVEL_VALUE_PK
FROM APPS.MSD_INTRANSIT_DS_V;
APPS.MSD_INTRANSIT_DS_V is not referenced by any database object
|
|
|