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_ACTIVITY_DETAILS

Object Details

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

The AR_ACTIVITY_DETAILS table stores receivable activities at the line level. The line-level applications feature uses this table to store its activity details.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AR_ACTIVITY_DETAILS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	LINE_ID
AR_ACTIVITY_DETAILS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CASH_RECEIPT_ID SOURCE_ID SOURCE_TABLE
AR_ACTIVITY_DETAILS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CUSTOMER_TRX_LINE_ID SOURCE_ID SOURCE_TABLE
AR_ACTIVITY_DETAILS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CASH_RECEIPT_ID CURRENT_ACTIVITY_FLAG
AR_ACTIVITY_DETAILS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CUSTOMER_TRX_LINE_ID CURRENT_ACTIVITY_FLAG

Columns

Name	Datatype	Length	Mandatory	Comments
CASH_RECEIPT_ID	NUMBER	(15)		Cash Receipt ID
CUSTOMER_TRX_LINE_ID	NUMBER	(15)	Yes	Invoice line ID
ALLOCATED_RECEIPT_AMOUNT	NUMBER			Allocated Receipt Amount
AMOUNT	NUMBER			Corresponding invoice revenue amount
TAX	NUMBER			Corresponding invoice tax amount
FREIGHT	NUMBER			Corresponding invoice freight amount
CHARGES	NUMBER			Corresponding invoice charges amount
LAST_UPDATE_DATE	DATE			Who Column
LAST_UPDATED_BY	NUMBER	(15)		Who Column
LINE_DISCOUNT	NUMBER			Discounted revenue line amount
TAX_DISCOUNT	NUMBER			Discounted revenue tax amount
FREIGHT_DISCOUNT	NUMBER			Discounted revenue freight amount
LINE_BALANCE	NUMBER			Revenue line balance
TAX_BALANCE	NUMBER			Tax line balance
CREATION_DATE	DATE			Who Column
CREATED_BY	NUMBER	(15)		Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Who Column
COMMENTS	VARCHAR2	(2000)		Comment
APPLY_TO	VARCHAR2	(150)		If application is on revenue or tax this is the trx line number
ATTRIBUTE1	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE10	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE11	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE12	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE13	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE14	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE15	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE2	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE3	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE4	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE5	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE6	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE7	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE8	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE9	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive Flexfield Flexfield structure defining column
REFERENCE4	VARCHAR2	(240)		Reference Column 4
REFERENCE5	VARCHAR2	(240)		Reference Column 5
GROUP_ID	NUMBER	(15)		Group Identifier
REFERENCE2	VARCHAR2	(240)		Reference Column 2
REFERENCE1	VARCHAR2	(240)		Reference Column 1
REFERENCE3	VARCHAR2	(240)		Reference Column 3
OBJECT_VERSION_NUMBER	NUMBER		Yes	Object Version Number
CREATED_BY_MODULE	VARCHAR2	(240)		created by module
SOURCE_ID	NUMBER	(15)		Fkey to AR distributions_all.SOURCE_ID
SOURCE_TABLE	VARCHAR2	(10)		Fkey to AR distributions_all.SOURCE_TABLE
LINE_ID	NUMBER	(15)	Yes	Fkey to AR distributions_all.LINE_ID
CURRENT_ACTIVITY_FLAG	VARCHAR2	(1)		Latest activity record
OFFSET_REC_FLAG	VARCHAR2	(1)		This will identify offset records under table ar_activity_details for value 'Y'.

Query Text

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


SELECT CASH_RECEIPT_ID
,      CUSTOMER_TRX_LINE_ID
,      ALLOCATED_RECEIPT_AMOUNT
,      AMOUNT
,      TAX
,      FREIGHT
,      CHARGES
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LINE_DISCOUNT
,      TAX_DISCOUNT
,      FREIGHT_DISCOUNT
,      LINE_BALANCE
,      TAX_BALANCE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      COMMENTS
,      APPLY_TO
,      ATTRIBUTE1
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE_CATEGORY
,      REFERENCE4
,      REFERENCE5
,      GROUP_ID
,      REFERENCE2
,      REFERENCE1
,      REFERENCE3
,      OBJECT_VERSION_NUMBER
,      CREATED_BY_MODULE
,      SOURCE_ID
,      SOURCE_TABLE
,      LINE_ID
,      CURRENT_ACTIVITY_FLAG
,      OFFSET_REC_FLAG
FROM AR.AR_ACTIVITY_DETAILS;

Dependencies

[top of page]

AR.AR_ACTIVITY_DETAILS does not reference any database object

AR.AR_ACTIVITY_DETAILS is referenced by following:

APPS: AR_ACTIVITY_DETAILS