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_RESTYPE_MAP_TO_RESFORMAT

Object Details

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

This table stores mapping information for upgrading resource types to Oracle Projects Family Pack M. This information is used to upgrade a resource list to a planning resource list.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
GROUP_RES_TYPE_CODE	VARCHAR2	(30)		This column has combination of all Ungrouped/Grouped Parent Resources.
RES_TYPE_CODE	VARCHAR2	(30)		This column has Grouped Child Resource Names.
RES_FORMAT_ID	NUMBER			The Resource Format Id.
RESOURCE_CLASS_ID	NUMBER			The Resource Class Id.
LABOR_FLAG	VARCHAR2	(1)		The Labor Flag.
CREATION_DATE	DATE		Yes	Standard Who Column.
CREATED_BY	NUMBER		Yes	Standard Who Column.
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	Standard Who Column.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Column.
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column.

Query Text

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


SELECT GROUP_RES_TYPE_CODE
,      RES_TYPE_CODE
,      RES_FORMAT_ID
,      RESOURCE_CLASS_ID
,      LABOR_FLAG
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM PA.PA_RESTYPE_MAP_TO_RESFORMAT;

Dependencies

[top of page]

PA.PA_RESTYPE_MAP_TO_RESFORMAT does not reference any database object

PA.PA_RESTYPE_MAP_TO_RESFORMAT is referenced by following:

APPS: PA_RESTYPE_MAP_TO_RESFORMAT