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_ACT_PRL_PRECEDENCE

Object Details

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

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
RES_CLASS_TYPE	VARCHAR2	(30)	Yes	This column indicates if resource classes in the planning resource list are enabled or disabled
RES_PREC_ID	NUMBER			This column indicates the resource format precedence ID
RES_CLASS_ID	NUMBER			This column indicates the resource class ID
RES_FORMAT_ID	NUMBER		Yes	This column indicates the resource format ID
RES_TOKENS	VARCHAR2	(30)	Yes	This column indicates the resource format tokens
EFF_RES_FORMAT_ID	NUMBER		Yes	This column indicates the effective resource format ID
CREATION_DATE	DATE		Yes	Standard Who column - date when this row was created
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column - user who last updated this row
CREATED_BY	NUMBER	(15)	Yes	Standard Who column - user who created this row
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	Standard Who column - operating system login of user who last updated this row

Query Text

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


SELECT RES_CLASS_TYPE
,      RES_PREC_ID
,      RES_CLASS_ID
,      RES_FORMAT_ID
,      RES_TOKENS
,      EFF_RES_FORMAT_ID
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      LAST_UPDATE_LOGIN
FROM PA.PA_ACT_PRL_PRECEDENCE;

Dependencies

[top of page]

PA.PA_ACT_PRL_PRECEDENCE does not reference any database object

PA.PA_ACT_PRL_PRECEDENCE is referenced by following:

PA: PA_ACT_PRL_PRECEDENCE#