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: MSC.MSC_PDR_PARAMETERS

Object Details

Object Name:	MSC_PDR_PARAMETERS
Object Type:	TABLE
Owner:	MSC
FND Design Data:	MSC.MSC_PDR_PARAMETERS
Subobject Name:
Status:	VALID

Store the parameters user entered in the Planning Detailed Reports.
This table is replaced by MSC_PDR_PARAMETERS_NEW table after patchset G.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
USER_ID	NUMBER			user identifier
PLAN_ID	NUMBER			plan identifier
ORGANIZATION_ID	NUMBER			org identifier
SR_INSTANCE_ID	NUMBER			source application instance identifier
CATEGORY_SET_ID	NUMBER			category set identifier
PRODUCT_CATEGORY_ID	NUMBER			category identifier
ABC_CLASS_ID	NUMBER			ABC class identifier
INVENTORY_ITEM_ID	NUMBER			itemidentifier
PLANNER_CODE_ID	VARCHAR2	(30)		planner identifier
BUYER_NAME_ID	VARCHAR2	(240)		buyer identifier
SUPPLIER_ID	NUMBER			supplier identifier
PLANNING_GROUP_ID	VARCHAR2	(30)		planning group
PROJECT_ID	NUMBER			project identifier
RESOURCE_GROUP_ID	VARCHAR2	(50)		resource group
DEPT_LINE_ID	NUMBER			department identifer
RESOURCE_ID	NUMBER			resource identifier
REPORT_PERIOD_FROM	DATE			The start date of the planning detail report period
REPORT_PERIOD_TO	DATE			The end date of the planning detail report period
REPORT_DATE_REC	NUMBER			parameter type
PLAN_NAME	VARCHAR2	(30)		plan name
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

Query Text

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


SELECT USER_ID
,      PLAN_ID
,      ORGANIZATION_ID
,      SR_INSTANCE_ID
,      CATEGORY_SET_ID
,      PRODUCT_CATEGORY_ID
,      ABC_CLASS_ID
,      INVENTORY_ITEM_ID
,      PLANNER_CODE_ID
,      BUYER_NAME_ID
,      SUPPLIER_ID
,      PLANNING_GROUP_ID
,      PROJECT_ID
,      RESOURCE_GROUP_ID
,      DEPT_LINE_ID
,      RESOURCE_ID
,      REPORT_PERIOD_FROM
,      REPORT_PERIOD_TO
,      REPORT_DATE_REC
,      PLAN_NAME
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
FROM MSC.MSC_PDR_PARAMETERS;

Dependencies

[top of page]

MSC.MSC_PDR_PARAMETERS does not reference any database object

MSC.MSC_PDR_PARAMETERS is referenced by following:

APPS: MSC_PDR_PARAMETERS