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

TABLE: EC.ECE_ATTACHMENT_DETAILS

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


ECE_ATTACHMENT_DETAILS contains temporary detail data for
extracting attachments. It contains the body of the attachment
as well as data necessary in order to link an attachment body
to its header document which is stored in
ECE_ATTACHMENT_HEADERS.


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

Run ID
ATT_SEQ_NUM NUMBER

Attachment Sequence Number
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
SEGMENT_NUMBER NUMBER

Segment Number
CONTINUE_FLAG VARCHAR2 (1)
Continue Flag
ATTACHMENT_SEGMENT VARCHAR2 (2000)
Attachment Segment
TRANSACTION_RECORD_ID NUMBER

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
,      ATT_SEQ_NUM
,      ENTITY_NAME
,      NAME
,      PK1_VALUE
,      PK2_VALUE
,      PK3_VALUE
,      PK4_VALUE
,      PK5_VALUE
,      SEGMENT_NUMBER
,      CONTINUE_FLAG
,      ATTACHMENT_SEGMENT
,      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_DETAILS;

Dependencies

[top of page]

EC.ECE_ATTACHMENT_DETAILS does not reference any database object

EC.ECE_ATTACHMENT_DETAILS is referenced by following:

SchemaAPPS
SynonymECE_ATTACHMENT_DETAILS