[Home] [Help] [Dependency Information]
Object Name: | FND_MIME_TYPES_TL |
---|---|
Object Type: | TABLE |
Owner: | APPLSYS |
FND Design Data: | FND.FND_MIME_TYPES_TL |
Subobject Name: | |
Status: | VALID |
FND_MIME_TYPES_TL stores information about mime types.
Each row contains the file format code, the mime content type,
and a description of the mime type.
The mime type has a type and subtype separated by a slash;
for example, text/html and image/gif. Major types include
application, audio, image, text and video. Application refers
to a variety of formats; for example, application/x-pdf refers
to Adobe Acrobat documents and application/ps refers
to Postscript documents. Since this table also stores translations,
you will need one row for each mime type for each
language installed at your site.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FND_MIME_TYPES_TL_U1 | NORMAL | UNIQUE | APPS_TS_SEED |
FILE_FORMAT_CODE
MIME_TYPE LANGUAGE ZD_EDITION_NAME |
FND_MIME_TYPES_TL_N1 | NORMAL | NONUNIQUE | APPS_TS_SEED |
FILE_FORMAT_CODE
LANGUAGE |
FND_MIME_TYPES_TL_N2 | NORMAL | NONUNIQUE | APPS_TS_SEED |
FILE_FORMAT_CODE
DESCRIPTION LANGUAGE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FILE_FORMAT_CODE | VARCHAR2 | (30) | Yes | File format code for mime type |
MIME_TYPE | VARCHAR2 | (80) | Yes | Mime type |
LANGUAGE | VARCHAR2 | (4) | Yes | Language |
SOURCE_LANG | VARCHAR2 | (4) | Yes | The Language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well. |
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 |
DESCRIPTION | VARCHAR2 | (240) | Description | |
ALLOW_CLIENT_ENCODING | VARCHAR2 | (1) | Allow native client encoding for this MIME type | |
ZD_EDITION_NAME | VARCHAR2 | (30) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT FILE_FORMAT_CODE
, MIME_TYPE
, LANGUAGE
, SOURCE_LANG
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, DESCRIPTION
, ALLOW_CLIENT_ENCODING
, ZD_EDITION_NAME
FROM APPLSYS.FND_MIME_TYPES_TL;
APPLSYS.FND_MIME_TYPES_TL does not reference any database object
APPLSYS.FND_MIME_TYPES_TL is referenced by following:
|
|
|