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

TABLE: AK.AK_LOOKUP_CODES

Object Details
Object Name: AK_LOOKUP_CODES
Object Type: TABLE
Owner: AK
FND Design Data: TableAK.AK_LOOKUP_CODES
Subobject Name:
Status: VALID


AK_LOOKUP_CODES contains lookup code, lookup type and description of
each lookup codes. It also contains translation information for the
description of lookup code. You need one row for each lookup code/type
that you want.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AK_LOOKUP_CODES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnLOOKUP_TYPE
ColumnLOOKUP_CODE
ColumnLANGUAGE
Columns
Name Datatype Length Mandatory Comments
LOOKUP_CODE VARCHAR2 (25) Yes Name of the lookup code
LOOKUP_TYPE VARCHAR2 (30) Yes Defines the type of lookup code
DESCRIPTION VARCHAR2 (80)
A user friendly description of the lookup type
LANGUAGE VARCHAR2 (4)
The language code of the language which the translatable fields are translated to
SOURCE_LANG VARCHAR2 (4)
Language code of the language which the values of the translatable columns were originally entered
LAST_UPDATE_DATE DATE
Yes Standard Who Column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15) Yes Standard Who Column
CREATION_DATE DATE
Yes Standard Who Column
CREATED_BY NUMBER (15) Yes Standard Who Column
Query Text

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


SELECT LOOKUP_CODE
,      LOOKUP_TYPE
,      DESCRIPTION
,      LANGUAGE
,      SOURCE_LANG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
FROM AK.AK_LOOKUP_CODES;

Dependencies

[top of page]

AK.AK_LOOKUP_CODES does not reference any database object

AK.AK_LOOKUP_CODES is referenced by following:

SchemaAPPS
SynonymAK_LOOKUP_CODES