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

VIEW: APPS.MSD_FORECAST_BASIS_LIAB_CS_V

Object Details
Object Name: MSD_FORECAST_BASIS_LIAB_CS_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. This view is no longer in use


[View Source]

Columns
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
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 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_CS_V;

Dependencies

[top of page]

APPS.MSD_FORECAST_BASIS_LIAB_CS_V references the following:

SchemaAPPS
ViewMSD_ORDER_FORECAST_CS_V
ViewMSD_SUPPLY_COMMIT_CS_V

APPS.MSD_FORECAST_BASIS_LIAB_CS_V is not referenced by any database object