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

TABLE: AP.AP_NOTES_ARC

Object Details
Object Name: AP_NOTES_ARC
Object Type: TABLE
Owner: AP
FND Design Data: TableSQLAP.AP_NOTES_ARC
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
SYS_IL0000509779C00007$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
Columns
Name Datatype Length Mandatory Comments
ARC_REQ_ID NUMBER

Archive Request Identifier
ARCHIVE_DATE DATE

Archive Date - Date when this row was created
NOTE_ID NUMBER
Yes Unique note identifier
SOURCE_OBJECT_CODE VARCHAR2 (240) Yes Identifies the source entity that this note is related to
SOURCE_OBJECT_ID NUMBER
Yes The primary key of the source entity
NOTE_TYPE VARCHAR2 (30) Yes The type of the note
NOTES_DETAIL CLOB (4000)
The actual note text
ENTERED_BY NUMBER (15) Yes The user who entered the note
ENTERED_DATE DATE
Yes The date on which the note was entered
SOURCE_LANG VARCHAR2 (4) Yes The language code of the note text
CREATION_DATE DATE
Yes Standard WHO column
CREATED_BY NUMBER (15) Yes Standard WHO column
LAST_UPDATE_DATE DATE
Yes Standard WHO column
LAST_UPDATED_BY NUMBER (15) Yes Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column
Query Text

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


SELECT ARC_REQ_ID
,      ARCHIVE_DATE
,      NOTE_ID
,      SOURCE_OBJECT_CODE
,      SOURCE_OBJECT_ID
,      NOTE_TYPE
,      NOTES_DETAIL
,      ENTERED_BY
,      ENTERED_DATE
,      SOURCE_LANG
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM AP.AP_NOTES_ARC;

Dependencies

[top of page]

AP.AP_NOTES_ARC does not reference any database object

AP.AP_NOTES_ARC is referenced by following:

SchemaAP
ViewAP_NOTES_ARC#