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: PA.PA_PLAN_RES_DEFAULTS

Object Details

Object Name:	PA_PLAN_RES_DEFAULTS
Object Type:	TABLE
Owner:	PA
FND Design Data:	PA.PA_PLAN_RES_DEFAULTS
Subobject Name:
Status:	VALID

This table stores default values for certain entities (like spread curve and expenditure type) by resource class.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_PLAN_RES_DEFAULTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PLAN_RES_DEFAULT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PLAN_RES_DEFAULT_ID	NUMBER	(15)	Yes	The primary key for the table - from a sequence.
RESOURCE_CLASS_ID	NUMBER	(15)	Yes	Indicates the resource class.
OBJECT_TYPE	VARCHAR2	(30)	Yes	Indicates the level. Valid values are CLASS, ORGANIZATION or PROJECT.
OBJECT_ID	NUMBER	(15)		Indicates the resource class, organization or project to which the defaulting is applicable.
SPREAD_CURVE_ID	NUMBER	(15)		Indicates the spread curve.
ETC_METHOD_CODE	VARCHAR2	(30)		Indicates the ETC method.
EXPENDITURE_TYPE	VARCHAR2	(30)		Indicates the expenditure type.
ITEM_CATEGORY_SET_ID	NUMBER	(15)		Indicates the item category.
ITEM_MASTER_ID	NUMBER	(15)		Indicates the organization of the item master.
MFC_COST_TYPE_ID	NUMBER	(15)		Indicates the manufacturing cost type.
ENABLED_FLAG	VARCHAR2	(1)		Indicates if the resource class object type combination is enabled.
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Column.
CREATION_DATE	DATE		Yes	Standard Who Column.
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column.
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	Standard Who Column.
RECORD_VERSION_NUMBER	NUMBER	(15)		Apps standard - used for locking.

Query Text

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


SELECT PLAN_RES_DEFAULT_ID
,      RESOURCE_CLASS_ID
,      OBJECT_TYPE
,      OBJECT_ID
,      SPREAD_CURVE_ID
,      ETC_METHOD_CODE
,      EXPENDITURE_TYPE
,      ITEM_CATEGORY_SET_ID
,      ITEM_MASTER_ID
,      MFC_COST_TYPE_ID
,      ENABLED_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      RECORD_VERSION_NUMBER
FROM PA.PA_PLAN_RES_DEFAULTS;

Dependencies

[top of page]

PA.PA_PLAN_RES_DEFAULTS does not reference any database object

PA.PA_PLAN_RES_DEFAULTS is referenced by following:

APPS: PA_PLAN_RES_DEFAULTS