[Home] [Help] [Dependency Information]
Object Name: | MSD_TOTAL_SUPPLY_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 total supplies in the planning server. 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. | ||
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 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_TOTAL_SUPPLY_CS_V;
APPS.MSD_TOTAL_SUPPLY_CS_V is not referenced by any database object
|
|
|