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]

TABLE: MSD.MSD_DP_PLANNING_PERCENTAGES

Object Details

Object Name:	MSD_DP_PLANNING_PERCENTAGES
Object Type:	TABLE
Owner:	MSD
FND Design Data:	MSD.MSD_DP_PLANNING_PERCENTAGES
Subobject Name:
Status:	VALID

Planning Percentages Data Published by DPE

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MSD_DP_PLANNING_PCTGS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DEMAND_PLAN_ID DP_SCENARIO_ID REVISION

Columns

Name	Datatype	Length	Mandatory	Comments
DEMAND_PLAN_ID	NUMBER		Yes	Demand Plan id
DP_SCENARIO_ID	NUMBER		Yes	Demand Plan Scenario Id
REVISION	NUMBER		Yes	Revision
INSTANCE	VARCHAR2	(40)	Yes	Instance
SR_ORGANIZATION_PK	VARCHAR2	(240)		Source Organization Primary Key
ORGANIZATION_LEVEL_PK	NUMBER			Organization level Pk
COMPONENT_SEQUENCE_ID	NUMBER		Yes	Component Sequence Id
SR_ASSEMBLY_ITEM_PK	VARCHAR2	(240)		Source Assembly Item Pk
ASSEMBLY_ITEM_LEVEL_PK	NUMBER			Assembly Item Level Pk
SR_COMPONENT_ITEM_PK	VARCHAR2	(240)		Source Component Item Pk
COMPONENT_ITEM_LEVEL_PK	NUMBER			Component Item Level Pk
PLANNING_FACTOR	NUMBER			Planning Factor
DATE_FROM	DATE			Date From
DATE_TO	DATE			Date to
PLAN_PERCENT_TYPE	VARCHAR2	(30)		Plan Percent Type
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER		Yes	Standard who column
CREATION_DATE	DATE		Yes	Standard who column
CREATED_BY	NUMBER		Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER			Standard who column
REQUEST_ID	NUMBER			Enhanced who column
PROGRAM_APPLICATION_ID	NUMBER			Enhanced who column
PROGRAM_ID	NUMBER			Enhanced who column
PROGRAM_UPDATE_DATE	DATE			Enhanced who column

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT DEMAND_PLAN_ID
,      DP_SCENARIO_ID
,      REVISION
,      INSTANCE
,      SR_ORGANIZATION_PK
,      ORGANIZATION_LEVEL_PK
,      COMPONENT_SEQUENCE_ID
,      SR_ASSEMBLY_ITEM_PK
,      ASSEMBLY_ITEM_LEVEL_PK
,      SR_COMPONENT_ITEM_PK
,      COMPONENT_ITEM_LEVEL_PK
,      PLANNING_FACTOR
,      DATE_FROM
,      DATE_TO
,      PLAN_PERCENT_TYPE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM MSD.MSD_DP_PLANNING_PERCENTAGES;

Dependencies

[top of page]

MSD.MSD_DP_PLANNING_PERCENTAGES does not reference any database object

MSD.MSD_DP_PLANNING_PERCENTAGES is referenced by following:

APPS: MSD_DP_PLANNING_PERCENTAGES