[Home] [Help] [Dependency Information]
Object Name: | MSD_SUPPLY_COMMIT_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 supply commits 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. | ||
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_SUPPLY_COMMIT_CS_V;
|
|
|