[Home] [Help] [Dependency Information]
Object Name: | MSD_ORDER_FORECAST_CS_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 order forecast 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.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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. | ||
GEO_LEVEL_VALUE_PK | NUMBER | Geography Level Value Primary Key. | ||
GEO_LEVEL_ID | NUMBER | Geography Level Id. | ||
TIME_LEVEL_ID | NUMBER | Time Level Id. | ||
QUANTITY | NUMBER | Quantity Shipped. | ||
AMOUNT | NUMBER | Amount. | ||
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. | ||
ASL_LIABILITY_AGREEMENT_BASIS | NUMBER | Liability Agreement Basis. |
Cut, paste (and edit) the following text to query this object:
SELECT PLAN_ID
, CS_NAME
, ORG_LEVEL_VALUE_PK
, ORG_LEVEL_ID
, PRD_LEVEL_VALUE_PK
, PRD_LEVEL_ID
, GEO_LEVEL_VALUE_PK
, GEO_LEVEL_ID
, TIME_LEVEL_ID
, QUANTITY
, AMOUNT
, 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
, ASL_LIABILITY_AGREEMENT_BASIS
FROM APPS.MSD_ORDER_FORECAST_CS_V;
|
|
|