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

TABLE: PO.PO_LINE_LOC_ALL_EXT_TL_ARCHIVE

Object Details
Object Name: PO_LINE_LOC_ALL_EXT_TL_ARCHIVE
Object Type: TABLE
Owner: PO
FND Design Data: TablePO.PO_LINE_LOC_ALL_EXT_TL_ARCHIVE
Subobject Name:
Status: VALID


This is the translation table corresponding to PO_LINE_LOC_ALL_EXT_B_ARCHIVE. This stores the data for translatable user defined attributes.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
EXTENSION_ID NUMBER
Yes EXTENSION_ID
ATTR_GROUP_ID VARCHAR2 (30) Yes ATTR_GROUP_ID
LINE_LOCATION_ID NUMBER

LINE_LOCATION_ID
DATA_LEVEL_ID NUMBER

DATA_LEVEL_ID
PK1_VALUE NUMBER

PK1_VALUE
PK2_VALUE NUMBER

PK2_VALUE
PK3_VALUE NUMBER

PK3_VALUE
PK4_VALUE NUMBER

PK4_VALUE
PK5_VALUE NUMBER

PK5_VALUE
SOURCE_LANG VARCHAR2 (30) Yes SOURCE_LANG
LANGUAGE VARCHAR2 (30) Yes LANGUAGE
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 (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY NUMBER (15) Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
TL_EXT_ATTR1 VARCHAR2 (4000)
TL_EXT_ATTR1
TL_EXT_ATTR2 VARCHAR2 (4000)
TL_EXT_ATTR2
TL_EXT_ATTR3 VARCHAR2 (4000)
TL_EXT_ATTR3
TL_EXT_ATTR4 VARCHAR2 (4000)
TL_EXT_ATTR4
TL_EXT_ATTR5 VARCHAR2 (4000)
TL_EXT_ATTR5
TL_EXT_ATTR6 VARCHAR2 (4000)
TL_EXT_ATTR6
TL_EXT_ATTR7 VARCHAR2 (4000)
TL_EXT_ATTR7
TL_EXT_ATTR8 VARCHAR2 (4000)
TL_EXT_ATTR8
TL_EXT_ATTR9 VARCHAR2 (4000)
TL_EXT_ATTR9
TL_EXT_ATTR10 VARCHAR2 (4000)
TL_EXT_ATTR10
TL_EXT_ATTR11 VARCHAR2 (4000)
TL_EXT_ATTR11
TL_EXT_ATTR12 VARCHAR2 (4000)
TL_EXT_ATTR12
TL_EXT_ATTR13 VARCHAR2 (4000)
TL_EXT_ATTR13
TL_EXT_ATTR14 VARCHAR2 (4000)
TL_EXT_ATTR14
TL_EXT_ATTR15 VARCHAR2 (4000)
TL_EXT_ATTR15
TL_EXT_ATTR16 VARCHAR2 (4000)
TL_EXT_ATTR16
TL_EXT_ATTR17 VARCHAR2 (4000)
TL_EXT_ATTR17
TL_EXT_ATTR18 VARCHAR2 (4000)
TL_EXT_ATTR18
TL_EXT_ATTR19 VARCHAR2 (4000)
TL_EXT_ATTR19
TL_EXT_ATTR20 VARCHAR2 (4000)
TL_EXT_ATTR20
TL_EXT_ATTR21 VARCHAR2 (4000)
TL_EXT_ATTR21
TL_EXT_ATTR22 VARCHAR2 (4000)
TL_EXT_ATTR22
TL_EXT_ATTR23 VARCHAR2 (4000)
TL_EXT_ATTR23
TL_EXT_ATTR24 VARCHAR2 (4000)
TL_EXT_ATTR24
TL_EXT_ATTR25 VARCHAR2 (4000)
TL_EXT_ATTR25
TL_EXT_ATTR26 VARCHAR2 (4000)
TL_EXT_ATTR26
TL_EXT_ATTR27 VARCHAR2 (4000)
TL_EXT_ATTR27
TL_EXT_ATTR28 VARCHAR2 (4000)
TL_EXT_ATTR28
TL_EXT_ATTR29 VARCHAR2 (4000)
TL_EXT_ATTR29
TL_EXT_ATTR30 VARCHAR2 (4000)
TL_EXT_ATTR30
TL_EXT_ATTR31 VARCHAR2 (4000)
TL_EXT_ATTR31
TL_EXT_ATTR32 VARCHAR2 (4000)
TL_EXT_ATTR32
TL_EXT_ATTR33 VARCHAR2 (4000)
TL_EXT_ATTR33
TL_EXT_ATTR34 VARCHAR2 (4000)
TL_EXT_ATTR34
TL_EXT_ATTR35 VARCHAR2 (4000)
TL_EXT_ATTR35
TL_EXT_ATTR36 VARCHAR2 (4000)
TL_EXT_ATTR36
TL_EXT_ATTR37 VARCHAR2 (4000)
TL_EXT_ATTR37
TL_EXT_ATTR38 VARCHAR2 (4000)
TL_EXT_ATTR38
TL_EXT_ATTR39 VARCHAR2 (4000)
TL_EXT_ATTR39
TL_EXT_ATTR40 VARCHAR2 (4000)
TL_EXT_ATTR40
UDA_TEMPLATE_ID NUMBER
Yes UDA_TEMPLATE_ID
DRAFT_ID NUMBER

DRAFT_ID
REVISION_NUM NUMBER
Yes REVISION_NUM
LATEST_EXTERNAL_FLAG VARCHAR2 (1)
LATEST_EXTERNAL_FLAG
Query Text

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


SELECT EXTENSION_ID
,      ATTR_GROUP_ID
,      LINE_LOCATION_ID
,      DATA_LEVEL_ID
,      PK1_VALUE
,      PK2_VALUE
,      PK3_VALUE
,      PK4_VALUE
,      PK5_VALUE
,      SOURCE_LANG
,      LANGUAGE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      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
,      UDA_TEMPLATE_ID
,      DRAFT_ID
,      REVISION_NUM
,      LATEST_EXTERNAL_FLAG
FROM PO.PO_LINE_LOC_ALL_EXT_TL_ARCHIVE;

Dependencies

[top of page]

PO.PO_LINE_LOC_ALL_EXT_TL_ARCHIVE does not reference any database object

PO.PO_LINE_LOC_ALL_EXT_TL_ARCHIVE is referenced by following:

SchemaPO
ViewPO_LINE_LOC_ALL_EXT_TL_ARCHIV#