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

TABLE: IBC.IBC_FILE_EXTN_MAPPINGS_TL

Object Details
Object Name: IBC_FILE_EXTN_MAPPINGS_TL
Object Type: TABLE
Owner: IBC
Subobject Name:
Status: VALID


IBC_ATTRIBUTE_TYPES_TL stores translated information about attribute types defined in IBC_ATTRIBUTE_TYPES_B.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IBC_FILE_EXTN_MAPPINGS_TL_U1 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnMAPPING_ID
ColumnLANGUAGE
Columns
Name Datatype Length Mandatory Comments
MAPPING_ID NUMBER
Yes File extension unique identifier
EXTENSION VARCHAR2 (240) Yes File Extension Name
DESCRIPTION VARCHAR2 (2000)
Description of the Extension
LANGUAGE VARCHAR2 (4) Yes Language this row is storing data for
SOURCE_LANG VARCHAR2 (4) Yes Language data in this row is currently of
CREATED_BY NUMBER
Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
Query Text

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


SELECT MAPPING_ID
,      EXTENSION
,      DESCRIPTION
,      LANGUAGE
,      SOURCE_LANG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM IBC.IBC_FILE_EXTN_MAPPINGS_TL;

Dependencies

[top of page]

IBC.IBC_FILE_EXTN_MAPPINGS_TL does not reference any database object

IBC.IBC_FILE_EXTN_MAPPINGS_TL is referenced by following:

SchemaAPPS
SynonymIBC_FILE_EXTN_MAPPINGS_TL