DBA Data[Home] [Help] [Dependency Information]

TABLE: PA.PA_RESOURCE_CLASSES_TL

Object Details
Object Name: PA_RESOURCE_CLASSES_TL
Object Type: TABLE
Owner: PA
FND Design Data: TablePA.PA_RESOURCE_CLASSES_TL
Subobject Name:
Status: VALID


This table provides multi-lingual support (MLS) for resource classes supported in Oracle Projects. MLS enables you to store and print data in multiple languages. The primary key for this table is RESOURCE_CLASS_ID and LANGUAGE. The non-translated information is in the table PA_RESOURCE_CLASSES_B.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PA_RESOURCE_CLASSES_TL_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnRESOURCE_CLASS_ID
ColumnLANGUAGE
ColumnZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
RESOURCE_CLASS_ID NUMBER (15) Yes Unique identifier of the resource class.
NAME VARCHAR2 (240) Yes Name of the resource class.
DESCRIPTION VARCHAR2 (2000)
Description of the resource class.
LANGUAGE VARCHAR2 (4) Yes Language of display.
SOURCE_LANG VARCHAR2 (4) Yes Language of source.
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
Yes Standard Who Column.
LAST_UPDATE_LOGIN NUMBER (15) Yes Standard Who Column.
ZD_EDITION_NAME VARCHAR2 (30) Yes
Query Text

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


SELECT RESOURCE_CLASS_ID
,      NAME
,      DESCRIPTION
,      LANGUAGE
,      SOURCE_LANG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ZD_EDITION_NAME
FROM PA.PA_RESOURCE_CLASSES_TL;

Dependencies

[top of page]

PA.PA_RESOURCE_CLASSES_TL does not reference any database object

PA.PA_RESOURCE_CLASSES_TL is referenced by following:

SchemaPA
ViewPA_RESOURCE_CLASSES_TL#