[Home] [Help] [Dependency Information]
Object Name: | CZ_LOCALIZED_TEXTS_VL |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | CZ.CZ_LOCALIZED_TEXTS_VL |
Subobject Name: | |
Status: | VALID |
MultiLingual view (a language resolved view of the data.)
This table implements an Oracle Applications case III multi-language view of the CZ_LOCALIZED_TEXTS table. It provides user-interface texts in the current language of the database session.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LAST_UPDATE_LOGIN | NUMBER | (15) | ID of the user who last updated this record | |
INTL_TEXT_ID | NUMBER | (15) | Yes | Locale-independent identity of this text, per CZ_INTL_TEXTS table |
TEXT_STR | VARCHAR2 | (2000) | Contains a version of an CZ_INTL_TEXTS string localized for the locale specified in LOCALE_ID | |
DELETED_FLAG | VARCHAR2 | (1) | Yes | Standard flag; '0' indicates the record is active, '1' means deleted. Other values are reserved |
ORIG_SYS_REF | VARCHAR2 | (255) | Contains the source identity of this text when imported | |
LANGUAGE | VARCHAR2 | (4) | Yes | Identifies the language for which this text entry is to be used. ALWAYS EQUALS CURRENT LANGUAGE OF SESSION. |
SOURCE_LANG | VARCHAR2 | (4) | Yes | Indicates the actual language in which this text is stored. |
CREATION_DATE | DATE | Yes | Standard field recording the date this record was created | |
LAST_UPDATE_DATE | DATE | Yes | Standard field recording the date/time this record was last updated | |
CREATED_BY | NUMBER | (15) | Yes | Standard field recording the ID of the user that created this record |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard field recording the ID of the user that last updated this record |
EFF_FROM | DATE | UNUSED | ||
EFF_TO | DATE | UNUSED | ||
EFF_MASK | VARCHAR2 | (40) | UNUSED | |
SECURITY_MASK | VARCHAR2 | (40) | UNUSED | |
CHECKOUT_USER | VARCHAR2 | (40) | UNUSED | |
UI_DEF_ID | NUMBER | |||
MODEL_ID | NUMBER | |||
PERSISTENT_INTL_TEXT_ID | NUMBER | |||
SEEDED_FLAG | VARCHAR2 | (1) | ||
UI_PAGE_ID | NUMBER | |||
UI_PAGE_ELEMENT_ID | VARCHAR2 | (255) |
Cut, paste (and edit) the following text to query this object:
SELECT LAST_UPDATE_LOGIN
, INTL_TEXT_ID
, TEXT_STR
, DELETED_FLAG
, ORIG_SYS_REF
, LANGUAGE
, SOURCE_LANG
, CREATION_DATE
, LAST_UPDATE_DATE
, CREATED_BY
, LAST_UPDATED_BY
, EFF_FROM
, EFF_TO
, EFF_MASK
, SECURITY_MASK
, CHECKOUT_USER
, UI_DEF_ID
, MODEL_ID
, PERSISTENT_INTL_TEXT_ID
, SEEDED_FLAG
, UI_PAGE_ID
, UI_PAGE_ELEMENT_ID
FROM APPS.CZ_LOCALIZED_TEXTS_VL;
|
|
|