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_CUSTOMER_CALLS_ALL

Object Details

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

The AR_CUSTOMER_CALLS_ALL table stores information about customer calls, including the bill-to site, promise date, and reason for the call. Each row includes customer and response information, as well as follow-up details for the customer call. You can review customer calls in the Customer Calls window.
.
The primary key for this table is CUSTOMER_CALL_ID.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AR_CUSTOMER_CALLS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CUSTOMER_CALL_ID
AR_CUSTOMER_CALLS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	COMPLETE_FLAG FOLLOW_UP_DATE
AR_CUSTOMER_CALLS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	COLLECTOR_ID
AR_CUSTOMER_CALLS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CUSTOMER_ID

Columns

Name	Datatype	Length	Mandatory	Comments
CUSTOMER_CALL_ID	NUMBER	(15)	Yes	Call identifier
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.
CUSTOMER_ID	NUMBER	(15)	Yes	Customer identifier
COLLECTOR_ID	NUMBER	(15)	Yes	Collector identifier
CALL_DATE	DATE		Yes	Date on which the call was registered
SITE_USE_ID	NUMBER	(15)		Customer location identifier
STATUS	VARCHAR2	(30)		Customer status, lookup code for CODE_STATUS
PROMISE_DATE	DATE			Date on which customer promises to pay
PROMISE_AMOUNT	NUMBER			Amount promised by customer
CALL_OUTCOME	VARCHAR2	(30)		Outcome of the customer call
FORECAST_DATE	DATE			Date that collector based forecast amount on
COLLECTION_FORECAST	NUMBER	(3)		Amount of receivable forecasted by collector, expressed as percentage
CONTACT_ID	NUMBER	(15)		Contact identifier for both customer and customer location
PHONE_ID	NUMBER	(15)		Telephone identifier
FAX_ID	NUMBER	(15)		Fax identifier
REASON_CODE	VARCHAR2	(30)		Reason for customer call
CURRENCY_CODE	VARCHAR2	(15)		Code of the currency entered
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure definition column.
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
FOLLOW_UP_DATE	DATE			Date set to follow up call with customer
COMPLETE_FLAG	VARCHAR2	(1)		Y or N indicates whether the follow-up action is complete for this customer call or not.
FOLLOW_UP_ACTION	VARCHAR2	(30)		Follow-up action for this customer call
ORG_ID	NUMBER	(15)		Organization identifier

Query Text

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


SELECT CUSTOMER_CALL_ID
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      CUSTOMER_ID
,      COLLECTOR_ID
,      CALL_DATE
,      SITE_USE_ID
,      STATUS
,      PROMISE_DATE
,      PROMISE_AMOUNT
,      CALL_OUTCOME
,      FORECAST_DATE
,      COLLECTION_FORECAST
,      CONTACT_ID
,      PHONE_ID
,      FAX_ID
,      REASON_CODE
,      CURRENCY_CODE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      FOLLOW_UP_DATE
,      COMPLETE_FLAG
,      FOLLOW_UP_ACTION
,      ORG_ID
FROM AR.AR_CUSTOMER_CALLS_ALL;

Dependencies

[top of page]

AR.AR_CUSTOMER_CALLS_ALL does not reference any database object

AR.AR_CUSTOMER_CALLS_ALL is referenced by following:

APPS: AR_CUSTOMER_CALLS; AR_CUSTOMER_CALLS_ALL