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

TABLE: CZ.CZ_INTL_TEXTS

Object Details
Object Name: CZ_INTL_TEXTS
Object Type: TABLE
Owner: CZ
FND Design Data: TableCZ.CZ_INTL_TEXTS
Subobject Name:
Status: VALID


OBSOLETE


Storage Details
Tablespace: TablespaceAPPS_TS_ARCHIVE
PCT Free: 10
PCT Used:
Primary Key: CZ_INTL_TEXTS_PK
  1. ColumnINTL_TEXT_ID
Indexes
Index Type Uniqueness Tablespace Column
CZ_INTL_TEXTS_PK NORMAL UNIQUE TablespaceAPPS_TS_ARCHIVE ColumnINTL_TEXT_ID
Columns
Name Datatype Length Mandatory Comments
INTL_TEXT_ID NUMBER (15) Yes Unique identifier of the translated text string
TEXT_STR VARCHAR2 (255)
Text string
CREATION_DATE DATE
Yes Standard Who Column
LAST_UPDATE_DATE DATE
Yes Standard Who Column
DELETED_FLAG VARCHAR2 (1) Yes Flag indicating if record was deleted by the user. If deleted_flag=1 the record will be purged
EFF_FROM DATE

Not currently used
EFF_TO DATE

Not currently used
CREATED_BY NUMBER (15) Yes Standard Who Column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who Column
SECURITY_MASK VARCHAR2 (40)
Not currently used
EFF_MASK VARCHAR2 (40)
Not currently used
CHECKOUT_USER VARCHAR2 (40)
Not currently used
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
ORIG_SYS_REF VARCHAR2 (255)
Holds the key information by which an imported record can be identified in its source database
Query Text

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


SELECT INTL_TEXT_ID
,      TEXT_STR
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      DELETED_FLAG
,      EFF_FROM
,      EFF_TO
,      CREATED_BY
,      LAST_UPDATED_BY
,      SECURITY_MASK
,      EFF_MASK
,      CHECKOUT_USER
,      LAST_UPDATE_LOGIN
,      ORIG_SYS_REF
FROM CZ.CZ_INTL_TEXTS;

Dependencies

[top of page]

CZ.CZ_INTL_TEXTS does not reference any database object

CZ.CZ_INTL_TEXTS is not referenced by any database object