[Home] [Help] [Dependency Information]
Object Name: | PA_PROJECTS_ERP_EXT_TL |
---|---|
Object Type: | TABLE |
Owner: | PA |
FND Design Data: | PA.PA_PROJECTS_ERP_EXT_TL |
Subobject Name: | |
Status: | VALID |
PA_PROJECTS_ERP_EXT_TL stores translated user-defined attribute data for the project and task level.
Tablespace: | |
---|---|
PCT Free: | |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PA_PROJECTS_ERP_EXT_TL_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
EXTENSION_ID
LANGUAGE |
PA_PROJECTS_ERP_EXT_TL_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
PROJECT_ID
LANGUAGE PROJ_ELEMENT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EXTENSION_ID | NUMBER | (15) | Yes | The system-generated number that uniquely identifies the extension row |
PROJECT_ID | NUMBER | (15) | Yes | The identifier of the project for which the extensible attribute values are entered |
PROJ_ELEMENT_ID | NUMBER | (15) | The identifier of the project element for which the extensible attribute values are entered | |
ATTR_GROUP_ID | NUMBER | (15) | Yes | The identifier of the attribute group |
SOURCE_LANG | VARCHAR2 | (4) | Yes | For translation |
LANGUAGE | VARCHAR2 | (4) | Yes | For translation |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
CREATION_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
TL_EXT_ATTR1 | VARCHAR2 | (1000) | Character based extensible attribute column | |
TL_EXT_ATTR2 | VARCHAR2 | (1000) | Character based extensible attribute column | |
TL_EXT_ATTR3 | VARCHAR2 | (1000) | Character based extensible attribute column | |
TL_EXT_ATTR4 | VARCHAR2 | (1000) | Character based extensible attribute column | |
TL_EXT_ATTR5 | VARCHAR2 | (1000) | Character based extensible attribute column | |
TL_EXT_ATTR6 | VARCHAR2 | (1000) | Character based extensible attribute column | |
TL_EXT_ATTR7 | VARCHAR2 | (1000) | Character based extensible attribute column | |
TL_EXT_ATTR8 | VARCHAR2 | (1000) | Character based extensible attribute column | |
TL_EXT_ATTR9 | VARCHAR2 | (1000) | Character based extensible attribute column | |
TL_EXT_ATTR10 | VARCHAR2 | (1000) | Character based extensible attribute column | |
TL_EXT_ATTR11 | VARCHAR2 | (1000) | Character based extensible attribute column | |
TL_EXT_ATTR12 | VARCHAR2 | (1000) | Character based extensible attribute column | |
TL_EXT_ATTR13 | VARCHAR2 | (1000) | Character based extensible attribute column | |
TL_EXT_ATTR14 | VARCHAR2 | (1000) | Character based extensible attribute column | |
TL_EXT_ATTR15 | VARCHAR2 | (1000) | Character based extensible attribute column | |
TL_EXT_ATTR16 | VARCHAR2 | (1000) | Character based extensible attribute column | |
TL_EXT_ATTR17 | VARCHAR2 | (1000) | Character based extensible attribute column | |
TL_EXT_ATTR18 | VARCHAR2 | (1000) | Character based extensible attribute column | |
TL_EXT_ATTR19 | VARCHAR2 | (1000) | Character based extensible attribute column | |
TL_EXT_ATTR20 | VARCHAR2 | (1000) | Character based extensible attribute column | |
TL_EXT_ATTR21 | VARCHAR2 | (1000) | Character based extensible attribute column | |
TL_EXT_ATTR22 | VARCHAR2 | (1000) | Character based extensible attribute column | |
TL_EXT_ATTR23 | VARCHAR2 | (1000) | Character based extensible attribute column | |
TL_EXT_ATTR24 | VARCHAR2 | (1000) | Character based extensible attribute column | |
TL_EXT_ATTR25 | VARCHAR2 | (1000) | Character based extensible attribute column | |
TL_EXT_ATTR26 | VARCHAR2 | (1000) | Character based extensible attribute column | |
TL_EXT_ATTR27 | VARCHAR2 | (1000) | Character based extensible attribute column | |
TL_EXT_ATTR28 | VARCHAR2 | (1000) | Character based extensible attribute column | |
TL_EXT_ATTR29 | VARCHAR2 | (1000) | Character based extensible attribute column | |
TL_EXT_ATTR30 | VARCHAR2 | (1000) | Character based extensible attribute column | |
TL_EXT_ATTR31 | VARCHAR2 | (1000) | Character based extensible attribute column | |
TL_EXT_ATTR32 | VARCHAR2 | (1000) | Character based extensible attribute column | |
TL_EXT_ATTR33 | VARCHAR2 | (1000) | Character based extensible attribute column | |
TL_EXT_ATTR34 | VARCHAR2 | (1000) | Character based extensible attribute column | |
TL_EXT_ATTR35 | VARCHAR2 | (1000) | Character based extensible attribute column | |
TL_EXT_ATTR36 | VARCHAR2 | (1000) | Character based extensible attribute column | |
TL_EXT_ATTR37 | VARCHAR2 | (1000) | Character based extensible attribute column | |
TL_EXT_ATTR38 | VARCHAR2 | (1000) | Character based extensible attribute column | |
TL_EXT_ATTR39 | VARCHAR2 | (1000) | Character based extensible attribute column | |
TL_EXT_ATTR40 | VARCHAR2 | (1000) | Character based extensible attribute column |
Cut, paste (and edit) the following text to query this object:
SELECT EXTENSION_ID
, PROJECT_ID
, PROJ_ELEMENT_ID
, ATTR_GROUP_ID
, SOURCE_LANG
, LANGUAGE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, TL_EXT_ATTR1
, TL_EXT_ATTR2
, TL_EXT_ATTR3
, TL_EXT_ATTR4
, TL_EXT_ATTR5
, TL_EXT_ATTR6
, TL_EXT_ATTR7
, TL_EXT_ATTR8
, TL_EXT_ATTR9
, TL_EXT_ATTR10
, TL_EXT_ATTR11
, TL_EXT_ATTR12
, TL_EXT_ATTR13
, TL_EXT_ATTR14
, TL_EXT_ATTR15
, TL_EXT_ATTR16
, TL_EXT_ATTR17
, TL_EXT_ATTR18
, TL_EXT_ATTR19
, TL_EXT_ATTR20
, TL_EXT_ATTR21
, TL_EXT_ATTR22
, TL_EXT_ATTR23
, TL_EXT_ATTR24
, TL_EXT_ATTR25
, TL_EXT_ATTR26
, TL_EXT_ATTR27
, TL_EXT_ATTR28
, TL_EXT_ATTR29
, TL_EXT_ATTR30
, TL_EXT_ATTR31
, TL_EXT_ATTR32
, TL_EXT_ATTR33
, TL_EXT_ATTR34
, TL_EXT_ATTR35
, TL_EXT_ATTR36
, TL_EXT_ATTR37
, TL_EXT_ATTR38
, TL_EXT_ATTR39
, TL_EXT_ATTR40
FROM PA.PA_PROJECTS_ERP_EXT_TL;
PA.PA_PROJECTS_ERP_EXT_TL does not reference any database object
PA.PA_PROJECTS_ERP_EXT_TL is referenced by following:
|
|
|