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

TABLE: ICX.ICX_POR_CATALOG_ATTACHMENTS

Object Details
Object Name: ICX_POR_CATALOG_ATTACHMENTS
Object Type: TABLE
Owner: ICX
FND Design Data: TableICX.ICX_POR_CATALOG_ATTACHMENTS
Subobject Name:
Status: VALID


Table for storing Catalog Attachments. It holds the data associated with an attachment. For images, the image itself is contained in the CONTENT column and the mime type is stored in the MIME_TYPE column. For administrative and control purposes the size of each file/attachment is also stored.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
ICX_POR_CATALOG_ATTACHMENTS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSUPPLIER_ID
ColumnFILE_NAME
SYS_IL0000149206C00004$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
Columns
Name Datatype Length Mandatory Comments
FILE_ID NUMBER
Yes Unique Identifier for the File/Attachment
FILE_NAME VARCHAR2 (500) Yes File Name
SUPPLIER_ID NUMBER
Yes Supplier ID owning the file/attachment
CONTENT BLOB (4000)
Content of the attachment
MIME_TYPE VARCHAR2 (30)
Mime Type
FILE_SIZE NUMBER

File size
CREATED_BY NUMBER
Yes Standard Who Column
CREATION_DATE DATE
Yes Standard Who Column
LAST_UPDATED_BY NUMBER
Yes Standard Who Column
LAST_UPDATE_DATE DATE
Yes Standard Who Column
LAST_UPDATE_LOGIN NUMBER

Standard Who Column
Query Text

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


SELECT FILE_ID
,      FILE_NAME
,      SUPPLIER_ID
,      CONTENT
,      MIME_TYPE
,      FILE_SIZE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM ICX.ICX_POR_CATALOG_ATTACHMENTS;

Dependencies

[top of page]

ICX.ICX_POR_CATALOG_ATTACHMENTS does not reference any database object

ICX.ICX_POR_CATALOG_ATTACHMENTS is referenced by following:

SchemaAPPS
SynonymICX_POR_CATALOG_ATTACHMENTS