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_CS_V

Object Details

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

This view is obsolete. This view provides the previous total liability for item i at location l to supplier s.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PLAN_ID	NUMBER		Yes	Demand Plan Unique ID.
CS_NAME	VARCHAR2	(80)		Name of The Supply Plan
ORG_LEVEL_VALUE_PK	NUMBER		Yes	Organization Level Primary Key.
ORG_LEVEL_ID	NUMBER			Organization Level ID.
PRD_LEVEL_VALUE_PK	NUMBER			Product Level Primary Key.
PRD_LEVEL_ID	NUMBER			Product Level ID.
GEO_LEVEL_VALUE_PK	NUMBER		Yes	Geography Level Primary Key.
GEO_LEVEL_ID	NUMBER			Geography Level ID.
TIME_LEVEL_ID	NUMBER			Time Level ID.
SCHEDULE_DATE	DATE		Yes	Time Level To.
QUANTITY	NUMBER			Quantity.
AMOUNT	NUMBER			Amount.
CREATION_DATE	DATE		Yes	Standard who column
CREATED_BY	NUMBER		Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER		Yes	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	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 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_CS_V;

Dependencies

[top of page]

APPS.MSD_PREVIOUS_LIAB_CS_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

APPS.MSD_PREVIOUS_LIAB_CS_V is not referenced by any database object