[Home] [Help] [Dependency Information]
Object Name: | MSD_GROSS_REQ_OBS_DATE_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.
Planning Server view for stream Gross Requriments over Obsolescence Date. This view is no longer in use
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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 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_GROSS_REQ_OBS_DATE_CS_V;
APPS.MSD_GROSS_REQ_OBS_DATE_CS_V is not referenced by any database object
|
|
|