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


TABLE: PA.PA_WORK_TYPES_TL

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


This table stores translated information about the Work Types. Each row includes the language the row is translated to. You need one row for each application in each of the installed languages.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PA_WORK_TYPES_TL_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnWORK_TYPE_ID
ColumnLANGUAGE
PA_WORK_TYPES_TL_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnNAME
ColumnLANGUAGE
Columns
Name Datatype Length Mandatory Comments
WORK_TYPE_ID NUMBER
Yes The system generated number that uniquely identifies the work type
LANGUAGE VARCHAR2 (4) Yes The defined language code for the row's translated columns
SOURCE_LANG VARCHAR2 (4) Yes Indicates the actual language of the row's translated columns.
NAME VARCHAR2 (80) Yes User-defined name that uniquely identifies the work type
DESCRIPTION VARCHAR2 (240)
Free text description of the work type
CREATION_DATE DATE
Yes Standard Who Column
CREATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_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 WORK_TYPE_ID
,      LANGUAGE
,      SOURCE_LANG
,      NAME
,      DESCRIPTION
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM PA.PA_WORK_TYPES_TL;

Dependencies

[top of page]

PA.PA_WORK_TYPES_TL does not reference any database object

PA.PA_WORK_TYPES_TL is referenced by following:

SchemaAPPS
SynonymPA_WORK_TYPES_TL