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


TABLE: AK.AK_FLOW_PAGES_TL

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


AK_FLOW_PAGES_TL stores translated information about the flow pages in
AK_FLOW_PAGES. Each row includes the language the row is translated
to, the translated attributes of the flow page, and the flow page
identifier which uniquely identifies the flow page. You need one row
for each flow page in each of the installed languages. Each row
includes a language and SOURCE_LANG column which can be used to
determine if a value has been translated or defaulted.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AK_FLOW_PAGES_TL_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnFLOW_CODE
ColumnFLOW_APPLICATION_ID
ColumnPAGE_CODE
ColumnPAGE_APPLICATION_ID
ColumnLANGUAGE
Columns
Name Datatype Length Mandatory Comments
FLOW_CODE VARCHAR2 (30) Yes Flow unique identifier
FLOW_APPLICATION_ID NUMBER (15) Yes Product team's application ID which the flow belong to
PAGE_CODE VARCHAR2 (30) Yes Flow page identifier
PAGE_APPLICATION_ID NUMBER (15) Yes Product team's application ID which the flow page belong to
LANGUAGE VARCHAR2 (4) Yes The language code of the language which the translatable fields are translated to
NAME VARCHAR2 (80) Yes Name of flow page
DESCRIPTION VARCHAR2 (2000)
Description of flow page
SOURCE_LANG VARCHAR2 (4) Yes Language code of the language which the values of the translatable columns were originally entered
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) Yes Standard Who Column
Query Text

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


SELECT FLOW_CODE
,      FLOW_APPLICATION_ID
,      PAGE_CODE
,      PAGE_APPLICATION_ID
,      LANGUAGE
,      NAME
,      DESCRIPTION
,      SOURCE_LANG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM AK.AK_FLOW_PAGES_TL;

Dependencies

[top of page]

AK.AK_FLOW_PAGES_TL does not reference any database object

AK.AK_FLOW_PAGES_TL is referenced by following:

SchemaAPPS
SynonymAK_FLOW_PAGES_TL