[Home] [Help] [Dependency Information]
Object Name: | MSD_ON_HAND_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.
This view is obsolete. This view provides the current onhand and in-receiving supplies 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 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.This view is implemeted with Custom Data Stream Module and is used by express upload process. This view is ASCP plan specific and is stripe by a demand plan.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DEMAND_PLAN_ID | NUMBER | Demand Plan Id. | ||
PLAN_ID | NUMBER | ASCP Plan Id. | ||
CS_NAME | VARCHAR2 | (255) | CS Name. | |
ORG_LEVEL_VALUE_PK | NUMBER | Org Level Value 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 Shipped. | ||
SCHEDULE_DATE | DATE | Scheduled Ship Date. | ||
CREATION_DATE | DATE | Who columns. | ||
CREATED_BY | NUMBER | Who columns. | ||
LAST_UPDATE_DATE | DATE | Who columns. | ||
LAST_UPDATED_BY | NUMBER | Who columns. | ||
LAST_UPDATE_LOGIN | NUMBER | 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. | |
PRD_PARENT_LEVEL_ID | NUMBER | Product Parent Level Id. | ||
PRD_PARENT_LEVEL_VALUE_PK | NUMBER | Product Parent Level value Primary key. |
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_ON_HAND_DS_V;
APPS.MSD_ON_HAND_DS_V is not referenced by any database object
|
|
|