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

TABLE: EC.ECE_ATTACHMENT_HEADERS

Object Details
Object Name: ECE_ATTACHMENT_HEADERS
Object Type: TABLE
Owner: EC
FND Design Data: TableEC.ECE_ATTACHMENT_HEADERS
Subobject Name:
Status: VALID


ECE_ATTACHMENT_HEADERS contains temporary header data
for extracting attachments. It contains information necessary
in order to link an attachment to its parent document such as
a purchase order line. The body of the attachment is stored in
the table ECE_ATTACHMENT_DETAILS.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
ECE_ATTACHMENT_HEADERS_U1 NORMAL UNIQUE TablespaceAPPS_TS_INTERFACE ColumnTRANSACTION_RECORD_ID
ECE_ATTACHMENT_HEADERS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnRUN_ID
Columns
Name Datatype Length Mandatory Comments
RUN_ID NUMBER

Run ID
DOCUMENT_ID NUMBER

Document ID
ENTITY_NAME VARCHAR2 (40)
Entity Name
NAME VARCHAR2 (30)
Attachment Category Name
PK1_VALUE VARCHAR2 (100)
Primary Key 1
PK2_VALUE VARCHAR2 (100)
Primary Key 2
PK3_VALUE VARCHAR2 (100)
Primary Key 3
PK4_VALUE VARCHAR2 (150)
Primary Key 4
PK5_VALUE VARCHAR2 (150)
Primary Key 5
ATT_SEQ_NUM NUMBER

Attachment Sequence Number
USAGE_TYPE VARCHAR2 (1)
Attachment Usage Type
DESCRIPTION VARCHAR2 (255)
Attachment Description
DATATYPE_ID NUMBER

Data Type
LANGUAGE VARCHAR2 (4)
Attachment Language
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Attachment Attribute Category
ATTRIBUTE1 VARCHAR2 (150)
Attachment Attribute 1
ATTRIBUTE2 VARCHAR2 (150)
Attachment Attribute 2
ATTRIBUTE3 VARCHAR2 (150)
Attachment Attribute 3
ATTRIBUTE4 VARCHAR2 (150)
Attachment Attribute 4
ATTRIBUTE5 VARCHAR2 (150)
Attachment Attribute 5
ATTRIBUTE6 VARCHAR2 (150)
Attachment Attribute 6
ATTRIBUTE7 VARCHAR2 (150)
Attachment Attribute 7
ATTRIBUTE8 VARCHAR2 (150)
Attachment Attribute 8
ATTRIBUTE9 VARCHAR2 (150)
Attachment Attribute 9
ATTRIBUTE10 VARCHAR2 (150)
Attachment Attribute 10
ATTRIBUTE11 VARCHAR2 (150)
Attachment Attribute 11
ATTRIBUTE12 VARCHAR2 (150)
Attachment Attribute 12
ATTRIBUTE13 VARCHAR2 (150)
Attachment Attribute 13
ATTRIBUTE14 VARCHAR2 (150)
Attachment Attribute 14
ATTRIBUTE15 VARCHAR2 (150)
Attachment Attribute 15
TRANSACTION_RECORD_ID NUMBER
Yes Unique identifier which links the transaction base table to its associated extension table.
CREATION_DATE DATE

Standard Who column
CREATED_BY NUMBER (15)
Standard Who column
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER (15)
Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
REQUEST_ID NUMBER

Standard Who column
PROGRAM_APPLICATION_ID NUMBER

Standard Who column
PROGRAM_ID NUMBER

Standard Who column
PROGRAM_UPDATE_DATE DATE

Standard Who column
ATTACHED_DOCUMENT_ID NUMBER

Attached Document ID
Query Text

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


SELECT RUN_ID
,      DOCUMENT_ID
,      ENTITY_NAME
,      NAME
,      PK1_VALUE
,      PK2_VALUE
,      PK3_VALUE
,      PK4_VALUE
,      PK5_VALUE
,      ATT_SEQ_NUM
,      USAGE_TYPE
,      DESCRIPTION
,      DATATYPE_ID
,      LANGUAGE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      TRANSACTION_RECORD_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ATTACHED_DOCUMENT_ID
FROM EC.ECE_ATTACHMENT_HEADERS;

Dependencies

[top of page]

EC.ECE_ATTACHMENT_HEADERS does not reference any database object

EC.ECE_ATTACHMENT_HEADERS is referenced by following:

SchemaAPPS
SynonymECE_ATTACHMENT_HEADERS