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_MRC_CASH_LINES

Object Details

Object Name:	AR_MRC_CASH_LINES
Object Type:	TABLE
Owner:	AR
Subobject Name:
Status:	VALID

Temporary Table Details

AR.AR_MRC_CASH_LINES is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$SESSION. Data is removed at the end of this period.

Storage Details

Tablespace:
PCT Free:	10
PCT Used:	40

Columns

Name	Datatype	Length
CASH_RECEIPT_ID	NUMBER
RECEIVABLE_APPLICATION_ID	NUMBER
STATUS	VARCHAR2	(30)
APPLIED_CUSTOMER_TRX_ID	NUMBER
TRX_NUMBER	VARCHAR2	(30)
INVOICE_CURRENCY_CODE	VARCHAR2	(15)
AMOUNT_APPLIED	NUMBER
AMOUNT_APPLIED_FROM	NUMBER
CURR1	VARCHAR2	(15)
CURR2	VARCHAR2	(15)
CURR3	VARCHAR2	(15)
CURR4	VARCHAR2	(15)
CURR5	VARCHAR2	(15)
CURR6	VARCHAR2	(15)
CURR7	VARCHAR2	(15)
CURR8	VARCHAR2	(15)
CURR9	VARCHAR2	(15)
PRI_ACCTD_AMOUNT_APPIED_FROM	NUMBER
PRI_ACCTD_AMOUNT_APPLIED_TO	NUMBER
REP1_ACCTD_AMOUNT_APPLIED_FROM	NUMBER
REP1_ACCTD_AMOUNT_APPLIED_TO	NUMBER
REP2_ACCTD_AMOUNT_APPLIED_FROM	NUMBER
REP2_ACCTD_AMOUNT_APPLIED_TO	NUMBER
REP3_ACCTD_AMOUNT_APPLIED_FROM	NUMBER
REP3_ACCTD_AMOUNT_APPLIED_TO	NUMBER
REP4_ACCTD_AMOUNT_APPLIED_FROM	NUMBER
REP4_ACCTD_AMOUNT_APPLIED_TO	NUMBER
REP5_ACCTD_AMOUNT_APPLIED_FROM	NUMBER
REP5_ACCTD_AMOUNT_APPLIED_TO	NUMBER
REP6_ACCTD_AMOUNT_APPLIED_FROM	NUMBER
REP6_ACCTD_AMOUNT_APPLIED_TO	NUMBER
REP7_ACCTD_AMOUNT_APPLIED_FROM	NUMBER
REP7_ACCTD_AMOUNT_APPLIED_TO	NUMBER
REP8_ACCTD_AMOUNT_APPLIED_FROM	NUMBER
REP8_ACCTD_AMOUNT_APPLIED_TO	NUMBER

Query Text

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


SELECT CASH_RECEIPT_ID
,      RECEIVABLE_APPLICATION_ID
,      STATUS
,      APPLIED_CUSTOMER_TRX_ID
,      TRX_NUMBER
,      INVOICE_CURRENCY_CODE
,      AMOUNT_APPLIED
,      AMOUNT_APPLIED_FROM
,      CURR1
,      CURR2
,      CURR3
,      CURR4
,      CURR5
,      CURR6
,      CURR7
,      CURR8
,      CURR9
,      PRI_ACCTD_AMOUNT_APPIED_FROM
,      PRI_ACCTD_AMOUNT_APPLIED_TO
,      REP1_ACCTD_AMOUNT_APPLIED_FROM
,      REP1_ACCTD_AMOUNT_APPLIED_TO
,      REP2_ACCTD_AMOUNT_APPLIED_FROM
,      REP2_ACCTD_AMOUNT_APPLIED_TO
,      REP3_ACCTD_AMOUNT_APPLIED_FROM
,      REP3_ACCTD_AMOUNT_APPLIED_TO
,      REP4_ACCTD_AMOUNT_APPLIED_FROM
,      REP4_ACCTD_AMOUNT_APPLIED_TO
,      REP5_ACCTD_AMOUNT_APPLIED_FROM
,      REP5_ACCTD_AMOUNT_APPLIED_TO
,      REP6_ACCTD_AMOUNT_APPLIED_FROM
,      REP6_ACCTD_AMOUNT_APPLIED_TO
,      REP7_ACCTD_AMOUNT_APPLIED_FROM
,      REP7_ACCTD_AMOUNT_APPLIED_TO
,      REP8_ACCTD_AMOUNT_APPLIED_FROM
,      REP8_ACCTD_AMOUNT_APPLIED_TO
FROM AR.AR_MRC_CASH_LINES;

Dependencies

[top of page]

AR.AR_MRC_CASH_LINES does not reference any database object

AR.AR_MRC_CASH_LINES is referenced by following:

APPS: AR_MRC_CASH_LINES