eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.MSD_PREVIOUS_LIAB_DS_V

Object Details

Object Name:	MSD_PREVIOUS_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.

This view is obsolete. This view provides the previous total liability for item i at location l to supplier s. This view is striped by a demand plan.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
DEMAND_PLAN_ID	NUMBER			Demand Plan Id.
PLAN_ID	NUMBER		Yes	ASCP Plan Id.
CS_NAME	VARCHAR2	(80)		CS Name.
ORG_LEVEL_VALUE_PK	NUMBER		Yes	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		Yes	Geography Level Value Primary Key.
GEO_LEVEL_ID	NUMBER			Geography Level Id.
TIME_LEVEL_ID	NUMBER			Time Level Id.
SCHEDULE_DATE	DATE		Yes	Scheduled Ship Date.
QUANTITY	NUMBER			Quantity Shipped.
AMOUNT	NUMBER			Amount.
CREATION_DATE	DATE		Yes	Who columns.
CREATED_BY	NUMBER		Yes	Who columns.
LAST_UPDATE_DATE	DATE		Yes	Who columns.
LAST_UPDATED_BY	NUMBER		Yes	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	CHAR	(1)		DML action code.
PRD_PARENT_LEVEL_ID	NUMBER			Product Parent Level Id.
PRD_PARENT_LEVEL_VALUE_PK	NUMBER			Product Parent Level value Primary key.

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
,      SCHEDULE_DATE
,      QUANTITY
,      AMOUNT
,      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_PREVIOUS_LIAB_DS_V;

Dependencies

[top of page]

APPS.MSD_PREVIOUS_LIAB_DS_V references the following:

APPS: MSD_DEMAND_PLANS; MSD_DP_PARAMETERS; MSD_DP_SCENARIOS; MSD_DP_SCENARIO_ENTRIES; MSD_DP_SCENARIO_REVISIONS; MSD_DP_SESSION; MSD_LEVEL_VALUES_DS

APPS.MSD_PREVIOUS_LIAB_DS_V is not referenced by any database object