eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: AR.AR_NOTES

Object Details

Object Name:	AR_NOTES
Object Type:	TABLE
Owner:	AR
FND Design Data:	AR.AR_NOTES
Subobject Name:
Status:	VALID

The AR_NOTES table stores MemoPad information for customer calls that are entered in the Customer Calls window. The AR_CALL_ACTIONS and AR_CUSTOMER_CALL_TOPICS tables both access MemoPad information from this table. Oracle Receivables creates one row for each MemoPad entry.
.
The primary key for this table is NOTE_ID.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AR_NOTES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	NOTE_ID
AR_NOTES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CUSTOMER_CALL_TOPIC_ID
AR_NOTES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CALL_ACTION_ID
AR_NOTES_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CUSTOMER_TRX_ID
AR_NOTES_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CUSTOMER_CALL_ID

Columns

Name	Datatype	Length	Mandatory	Comments
NOTE_ID	NUMBER		Yes	Identifier of the note
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
NOTE_TYPE	VARCHAR2	(30)	Yes	Type of note
TEXT	VARCHAR2	(2000)	Yes	Text of the line
CUSTOMER_CALL_TOPIC_ID	NUMBER	(15)		Topic of the customer call
CALL_ACTION_ID	NUMBER	(15)		Action of the call
CUSTOMER_TRX_ID	NUMBER	(15)		Invoice that is the subject of the call
CUSTOMER_CALL_ID	NUMBER	(15)		Call identifier

Query Text

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


SELECT NOTE_ID
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      NOTE_TYPE
,      TEXT
,      CUSTOMER_CALL_TOPIC_ID
,      CALL_ACTION_ID
,      CUSTOMER_TRX_ID
,      CUSTOMER_CALL_ID
FROM AR.AR_NOTES;

Dependencies

[top of page]

AR.AR_NOTES does not reference any database object

AR.AR_NOTES is referenced by following:

AR: AR_NOTES#