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_CALL_TOPICS_ALL

Object Details

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

The AR_CUSTOMER_CALL_TOPICS_ALL table stores information about the topic of customer calls, such as the outcome of the call, the customer's response, and the follow-up date. Each row includes specific collection information regarding your call topic. Oracle Receivables uses this information to display customer calls in the Record A Call, Call History, and Collection reports.
.
The primary key for this table is CUSTOMER_CALL_TOPIC_ID.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AR_CUSTOMER_CALL_TOPICS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CUSTOMER_CALL_TOPIC_ID
AR_CUSTOMER_CALL_TOPICS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CUSTOMER_CALL_ID
AR_CUSTOMER_CALL_TOPICS_N10	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REASON_CODE
AR_CUSTOMER_CALL_TOPICS_N11	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CALL_OUTCOME
AR_CUSTOMER_CALL_TOPICS_N12	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	COMPLETE_FLAG FOLLOW_UP_DATE
AR_CUSTOMER_CALL_TOPICS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CONTACT_ID PHONE_ID
AR_CUSTOMER_CALL_TOPICS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	COLLECTOR_ID
AR_CUSTOMER_CALL_TOPICS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CUSTOMER_ID
AR_CUSTOMER_CALL_TOPICS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SITE_USE_ID
AR_CUSTOMER_CALL_TOPICS_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PAYMENT_SCHEDULE_ID
AR_CUSTOMER_CALL_TOPICS_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CUSTOMER_TRX_ID
AR_CUSTOMER_CALL_TOPICS_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	FOLLOW_UP_COMPANY_REP_ID
AR_CUSTOMER_CALL_TOPICS_N9	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CALL_DATE

Columns

Name	Datatype	Length	Mandatory	Comments
CUSTOMER_CALL_TOPIC_ID	NUMBER	(15)	Yes	Identifier of the call topic
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_CALL_ID	NUMBER	(15)	Yes	Identifier of the call associated with this call topic
CUSTOMER_ID	NUMBER	(15)	Yes	Identifier of the customer associated with this call topic
COLLECTOR_ID	NUMBER	(15)	Yes	Identifier of the collector associated with this call topic
CALL_DATE	DATE		Yes	Date of the call associated with this call topic
PAYMENT_SCHEDULE_ID	NUMBER	(15)		Identifier of the payment schedule associated with this call topic
CUSTOMER_TRX_ID	NUMBER	(15)		Identifier of the customer transaction associated with this call topic
CUSTOMER_TRX_LINE_ID	NUMBER	(15)		Identifier of the customer transaction line item associated with this call topic
PROMISE_DATE	DATE			Date the customer promises to pay
PROMISE_AMOUNT	NUMBER			Amount the customer promises to pay
FOLLOW_UP_DATE	DATE			Date set for follow-up call
FOLLOW_UP_ACTION	VARCHAR2	(30)		Follow-up action as result of call
FOLLOW_UP_COMPANY_REP_ID	NUMBER	(15)		Not currently used
CALL_OUTCOME	VARCHAR2	(30)		Outcome of the call
FORECAST_DATE	DATE			Date payment is expected
COLLECTION_FORECAST	NUMBER	(3)		Percentage of total amount expected to be collected
REASON_CODE	VARCHAR2	(30)		User-defined reason code for customer explanation on failure to pay
SITE_USE_ID	NUMBER	(15)		Identifier of the associated site use record
CONTACT_ID	NUMBER	(15)		Identifier of contact associated with this call
PHONE_ID	NUMBER	(15)		Phone number of the contact
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
COMPLETE_FLAG	VARCHAR2	(1)		Y or N indicates whether the follow-up action is complete for this topic or not.
CASH_RECEIPT_ID	NUMBER	(15)		Receipt identifier
ORG_ID	NUMBER	(15)		Organization identifier

Query Text

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


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

Dependencies

[top of page]

AR.AR_CUSTOMER_CALL_TOPICS_ALL does not reference any database object

AR.AR_CUSTOMER_CALL_TOPICS_ALL is referenced by following:

AR: AR_CUSTOMER_CALL_TOPICS_ALL#