[Home] [Help] [Dependency Information]
Object Name: | ENG_ATTACHMENT_CHANGES |
---|---|
Object Type: | TABLE |
Owner: | ENG |
FND Design Data: | ENG.ENG_ATTACHMENT_CHANGES |
Subobject Name: | |
Status: | VALID |
Table that stores the attachment related changes
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
ENG_ATTACHMENT_CHANGES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | CHANGE_DOCUMENT_ID |
ENG_ATTACHMENT_CHANGES_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
CHANGE_ID
REVISED_ITEM_SEQUENCE_ID |
ENG_ATTACHMENT_CHANGES_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
REPOSITORY_ID
SOURCE_MEDIA_ID |
ENG_ATTACHMENT_CHANGES_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ATTACHMENT_ID |
ENG_ATTACHMENT_CHANGES_N4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | SOURCE_DOCUMENT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CHANGE_ID | NUMBER | Yes | Change internal identifier | |
REVISED_ITEM_SEQUENCE_ID | NUMBER | Revised item sequence id | ||
ATTACHMENT_ID | NUMBER | Attachment internal id | ||
CHANGE_DOCUMENT_ID | NUMBER | Yes | Document internal identifier | |
ACTION_TYPE | VARCHAR2 | (30) | Action performed on the attachment - add, modify or delete | |
FILE_NAME | VARCHAR2 | (2048) | Yes | Name of the file |
SOURCE_MEDIA_ID | NUMBER | Stores the media id information | ||
SOURCE_VERSION_LABEL | VARCHAR2 | (255) | The version number of the attachment that is being changed | |
SOURCE_PATH | VARCHAR2 | (1000) | Source path of the attachment | |
DEST_MEDIA_ID | NUMBER | |||
DEST_VERSION_LABEL | VARCHAR2 | (255) | The version of the new attachment | |
DEST_PATH | VARCHAR2 | (1000) | The path of the new attachment | |
CATEGORY_ID | NUMBER | Internal id of the attachment category | ||
ATTACHED_USER_ID | NUMBER | Attached user id | ||
PREVIOUS_STATUS | VARCHAR2 | (30) | Previous workflow status of the attachment | |
LAST_UPDATE_DATE | DATE | Yes | Standard WHO column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard WHO column | |
CREATION_DATE | DATE | Yes | Standard WHO column | |
CREATED_BY | NUMBER | Yes | Standard WHO column | |
LAST_UPDATE_LOGIN | NUMBER | Standard WHO column | ||
FAMILY_ID | NUMBER | Family id of the attachment | ||
REPOSITORY_ID | NUMBER | Repository id to indicate if the attachment is a webservices, webdav or a EBS attachment | ||
DM_TYPE | VARCHAR2 | (30) | Document type | |
ENTITY_NAME | VARCHAR2 | (40) | Name of the entity - item/ item revision | |
PK1_VALUE | VARCHAR2 | (100) | Primary key of the entity | |
PK2_VALUE | VARCHAR2 | (100) | Primary key of the entity | |
PK3_VALUE | VARCHAR2 | (100) | Primary key of the entity | |
PK4_VALUE | VARCHAR2 | (150) | Primary key of the entity | |
PK5_VALUE | VARCHAR2 | (150) | Primary key of the entity | |
NEW_FILE_NAME | VARCHAR2 | (2048) | New name of the file when the name is modified. Only applicable for EBS attachments | |
DESCRIPTION | VARCHAR2 | (255) | Description of the file | |
NEW_DESCRIPTION | VARCHAR2 | (255) | New description of the file when the description is modified. Only applicable for EBS attachments | |
SOURCE_DOCUMENT_ID | NUMBER | The attachment id that is being changed | ||
DEST_DOCUMENT_ID | NUMBER | The internal id of the new attachment | ||
NEW_CATEGORY_ID | NUMBER | Category id of the new attachment | ||
DATATYPE_ID | NUMBER | Datatype id |
Cut, paste (and edit) the following text to query this object:
SELECT CHANGE_ID
, REVISED_ITEM_SEQUENCE_ID
, ATTACHMENT_ID
, CHANGE_DOCUMENT_ID
, ACTION_TYPE
, FILE_NAME
, SOURCE_MEDIA_ID
, SOURCE_VERSION_LABEL
, SOURCE_PATH
, DEST_MEDIA_ID
, DEST_VERSION_LABEL
, DEST_PATH
, CATEGORY_ID
, ATTACHED_USER_ID
, PREVIOUS_STATUS
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, FAMILY_ID
, REPOSITORY_ID
, DM_TYPE
, ENTITY_NAME
, PK1_VALUE
, PK2_VALUE
, PK3_VALUE
, PK4_VALUE
, PK5_VALUE
, NEW_FILE_NAME
, DESCRIPTION
, NEW_DESCRIPTION
, SOURCE_DOCUMENT_ID
, DEST_DOCUMENT_ID
, NEW_CATEGORY_ID
, DATATYPE_ID
FROM ENG.ENG_ATTACHMENT_CHANGES;
ENG.ENG_ATTACHMENT_CHANGES does not reference any database object
ENG.ENG_ATTACHMENT_CHANGES is referenced by following:
|
|
|