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.RA_CM_REQUESTS_ALL

Object Details

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

The RA_CM_REQUESTS_ALL table stores information about credit memo requests that a customer made with the Dispute A Bill feature of iReceivables, known as AR Online in Release 11. Receivables creates one row in this table for each request that a customer makes using the Dispute A Bill feature. This table contains all parameters that are required to initiate the Credit Memo Request Workflow.
.
Each row in this table includes general information about the request such as amount, reason, comments, and if the request concerns specific invoice lines or just a credit to the total line, tax, or freight on the transaction. A value of Y in the LINES_CREDITS_FLAG column indicates that the customer made the credit request for specific lines.
.
The CUSTOMER_TRX_ID column is the transaction identifier and the CM_CUSTOMER_TRX_ID column is the credit memo identifier, once Receivables approves and creates the credit memo.
.
The primary keys for this table are REQUEST_ID and CUSTOMER_TRX_ID.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
RA_CM_REQUESTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	REQUEST_ID

Columns

Name	Datatype	Length	Mandatory	Comments
REQUEST_ID	NUMBER	(15)	Yes	Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
CUSTOMER_TRX_ID	NUMBER	(15)	Yes	Transaction Identifier
CM_CUSTOMER_TRX_ID	NUMBER	(15)		Credit Memo Identifier
URL	VARCHAR2	(2000)		URL for the request page
LINE_CREDITS_FLAG	VARCHAR2	(1)		Indicates if line credits are at the line level. Y for a credit request to specific lines. N for a request for header level credit.
LINE_AMOUNT	NUMBER			Amount of header line credit requested
TAX_AMOUNT	NUMBER			Amount of header tax credit requested
FREIGHT_AMOUNT	NUMBER			Amount of header freight credit requested
CM_REASON_CODE	VARCHAR2	(30)		Reason code identifier for the credit memo
COMMENTS	VARCHAR2	(1760)		Comments to appear on the credit memo request
STATUS	VARCHAR2	(20)		Credit memo approval and creation status
APPROVAL_DATE	VARCHAR2	(20)		Date the request was approved
ORG_ID	NUMBER	(15)	Yes	Organization identifier
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
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).
TOTAL_AMOUNT	NUMBER			Total amount of credit request
TERMS_SEQUENCE_NUMBER	NUMBER			The sequence number given to each installment for multiple payment terms.
TRANSACTION_URL	VARCHAR2	(2000)		Stores the URL to display the transaction
ACTIVITIES_URL	VARCHAR2	(2000)		Stores the URL to display the activities information
ORIG_TRX_NUMBER	VARCHAR2	(30)		Stores the original transaction number when the user is disputing an invoice with the duplicate billing reason code
TAX_EX_CERT_NUM	VARCHAR2	(30)		Stores the tax exemption certificate when user is entering a dispute
INTERFACE_HEADER_CONTEXT	VARCHAR2	(30)		Interface header context
INTERFACE_HEADER_ATTRIBUTE1	VARCHAR2	(150)		Interface header attribute value
INTERFACE_HEADER_ATTRIBUTE2	VARCHAR2	(150)		Interface Header Attribute
INTERFACE_HEADER_ATTRIBUTE3	VARCHAR2	(150)		Interface Header Attribute
INTERFACE_HEADER_ATTRIBUTE4	VARCHAR2	(150)		Interface Header Attribute
INTERFACE_HEADER_ATTRIBUTE5	VARCHAR2	(150)		Interface Header Attribute
INTERFACE_HEADER_ATTRIBUTE6	VARCHAR2	(150)		Interface Header Attribute
INTERFACE_HEADER_ATTRIBUTE7	VARCHAR2	(150)		Interface Header Attribute
INTERFACE_HEADER_ATTRIBUTE8	VARCHAR2	(150)		Interface Header Attribute
INTERFACE_HEADER_ATTRIBUTE9	VARCHAR2	(150)		Interface Header Attribute
INTERFACE_HEADER_ATTRIBUTE10	VARCHAR2	(150)		Interface Header Attribute
INTERFACE_HEADER_ATTRIBUTE11	VARCHAR2	(150)		Interface Header Attribute
INTERFACE_HEADER_ATTRIBUTE12	VARCHAR2	(150)		Interface Header Attribute
INTERFACE_HEADER_ATTRIBUTE13	VARCHAR2	(150)		Interface Header Attribute
INTERFACE_HEADER_ATTRIBUTE14	VARCHAR2	(150)		Interface Header Attribute
INTERFACE_HEADER_ATTRIBUTE15	VARCHAR2	(150)		Interface Header Attribute
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive Flexfield structure defining column
ATTRIBUTE1	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
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
GLOBAL_ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE1	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE2	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE3	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE4	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE5	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE6	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE7	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE8	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE9	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE10	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE11	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE12	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE13	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE14	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE15	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE16	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE17	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE18	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE19	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE20	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE21	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE22	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE23	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE24	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE25	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE26	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE27	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE28	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE29	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE30	VARCHAR2	(150)		Reserved for country-specific functionality
DISPUTE_DATE	DATE			Dispute date
INTERNAL_COMMENT	VARCHAR2	(1760)		Internal Comment
RESPONSIBILITY_ID	NUMBER			Responsibility Identifier

Query Text

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


SELECT REQUEST_ID
,      CUSTOMER_TRX_ID
,      CM_CUSTOMER_TRX_ID
,      URL
,      LINE_CREDITS_FLAG
,      LINE_AMOUNT
,      TAX_AMOUNT
,      FREIGHT_AMOUNT
,      CM_REASON_CODE
,      COMMENTS
,      STATUS
,      APPROVAL_DATE
,      ORG_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      TOTAL_AMOUNT
,      TERMS_SEQUENCE_NUMBER
,      TRANSACTION_URL
,      ACTIVITIES_URL
,      ORIG_TRX_NUMBER
,      TAX_EX_CERT_NUM
,      INTERFACE_HEADER_CONTEXT
,      INTERFACE_HEADER_ATTRIBUTE1
,      INTERFACE_HEADER_ATTRIBUTE2
,      INTERFACE_HEADER_ATTRIBUTE3
,      INTERFACE_HEADER_ATTRIBUTE4
,      INTERFACE_HEADER_ATTRIBUTE5
,      INTERFACE_HEADER_ATTRIBUTE6
,      INTERFACE_HEADER_ATTRIBUTE7
,      INTERFACE_HEADER_ATTRIBUTE8
,      INTERFACE_HEADER_ATTRIBUTE9
,      INTERFACE_HEADER_ATTRIBUTE10
,      INTERFACE_HEADER_ATTRIBUTE11
,      INTERFACE_HEADER_ATTRIBUTE12
,      INTERFACE_HEADER_ATTRIBUTE13
,      INTERFACE_HEADER_ATTRIBUTE14
,      INTERFACE_HEADER_ATTRIBUTE15
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      GLOBAL_ATTRIBUTE_CATEGORY
,      GLOBAL_ATTRIBUTE1
,      GLOBAL_ATTRIBUTE2
,      GLOBAL_ATTRIBUTE3
,      GLOBAL_ATTRIBUTE4
,      GLOBAL_ATTRIBUTE5
,      GLOBAL_ATTRIBUTE6
,      GLOBAL_ATTRIBUTE7
,      GLOBAL_ATTRIBUTE8
,      GLOBAL_ATTRIBUTE9
,      GLOBAL_ATTRIBUTE10
,      GLOBAL_ATTRIBUTE11
,      GLOBAL_ATTRIBUTE12
,      GLOBAL_ATTRIBUTE13
,      GLOBAL_ATTRIBUTE14
,      GLOBAL_ATTRIBUTE15
,      GLOBAL_ATTRIBUTE16
,      GLOBAL_ATTRIBUTE17
,      GLOBAL_ATTRIBUTE18
,      GLOBAL_ATTRIBUTE19
,      GLOBAL_ATTRIBUTE20
,      GLOBAL_ATTRIBUTE21
,      GLOBAL_ATTRIBUTE22
,      GLOBAL_ATTRIBUTE23
,      GLOBAL_ATTRIBUTE24
,      GLOBAL_ATTRIBUTE25
,      GLOBAL_ATTRIBUTE26
,      GLOBAL_ATTRIBUTE27
,      GLOBAL_ATTRIBUTE28
,      GLOBAL_ATTRIBUTE29
,      GLOBAL_ATTRIBUTE30
,      DISPUTE_DATE
,      INTERNAL_COMMENT
,      RESPONSIBILITY_ID
FROM AR.RA_CM_REQUESTS_ALL;

Dependencies

[top of page]

AR.RA_CM_REQUESTS_ALL does not reference any database object

AR.RA_CM_REQUESTS_ALL is referenced by following:

AR: RA_CM_REQUESTS_ALL#