DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.MSD_FORECAST_BASIS_LIAB_DS_V

Object Details
Object Name: MSD_FORECAST_BASIS_LIAB_DS_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


Planning Server view for stream Forecast Liability when plan is striped. This view is no longer in use


[View Source]

Columns
Name Datatype Length Mandatory Comments
DEMAND_PLAN_ID NUMBER

Demand Plan Id
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
GEO_LEVEL_VALUE_PK NUMBER

Geo Level Value Primary Key
GEO_LEVEL_ID NUMBER

Geo Level Id
TIME_LEVEL_ID NUMBER

Time Level Id
QUANTITY NUMBER

Quantity
AMOUNT NUMBER

Amount
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
Query Text

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
,      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
FROM APPS.MSD_FORECAST_BASIS_LIAB_DS_V;

Dependencies

[top of page]

APPS.MSD_FORECAST_BASIS_LIAB_DS_V references the following:

SchemaAPPS
ViewMSD_ORDER_FORECAST_DS_V
ViewMSD_SUPPLY_COMMIT_DS_V

APPS.MSD_FORECAST_BASIS_LIAB_DS_V is not referenced by any database object