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_AR_AMOUNTS_GT

Object Details

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

Temporary Table Details

AR.RA_AR_AMOUNTS_GT 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$TRANSACTION. Data is removed at the end of this period.

Storage Details

Tablespace:
PCT Free:	10
PCT Used:	40

Indexes

Index	Type	Uniqueness	Tablespace	Column
RA_AR_AMOUNTS_GT_N1	NORMAL	NONUNIQUE		GT_ID BASE_REC_ROWID

Columns

Name	Datatype	Length
GT_ID	VARCHAR2	(30)
BASE_REC_ROWID	ROWID	(10)
GP_LEVEL	VARCHAR2	(30)
REF_CUSTOMER_TRX_ID	NUMBER
REF_CUSTOMER_TRX_LINE_ID	NUMBER
BASE_PRO_AMT	NUMBER
BASE_PRO_ACCTD_AMT	NUMBER
BASE_FRT_PRO_AMT	NUMBER
BASE_FRT_PRO_ACCTD_AMT	NUMBER
BASE_TAX_PRO_AMT	NUMBER
BASE_TAX_PRO_ACCTD_AMT	NUMBER
BASE_CHRG_PRO_AMT	NUMBER
BASE_CHRG_PRO_ACCTD_AMT	NUMBER
ELMT_PRO_AMT	NUMBER
ELMT_PRO_ACCTD_AMT	NUMBER
ELMT_FRT_PRO_AMT	NUMBER
ELMT_FRT_PRO_ACCTD_AMT	NUMBER
ELMT_TAX_PRO_AMT	NUMBER
ELMT_TAX_PRO_ACCTD_AMT	NUMBER
ELMT_CHRG_PRO_AMT	NUMBER
ELMT_CHRG_PRO_ACCTD_AMT	NUMBER
BUC_ALLOC_AMT	NUMBER
BUC_ALLOC_ACCTD_AMT	NUMBER
BUC_FRT_ALLOC_AMT	NUMBER
BUC_FRT_ALLOC_ACCTD_AMT	NUMBER
BUC_TAX_ALLOC_AMT	NUMBER
BUC_TAX_ALLOC_ACCTD_AMT	NUMBER
BUC_CHRG_ALLOC_AMT	NUMBER
BUC_CHRG_ALLOC_ACCTD_AMT	NUMBER
BASE_ED_PRO_AMT	NUMBER
BASE_ED_PRO_ACCTD_AMT	NUMBER
BASE_ED_FRT_PRO_AMT	NUMBER
BASE_ED_FRT_PRO_ACCTD_AMT	NUMBER
BASE_ED_TAX_PRO_AMT	NUMBER
BASE_ED_TAX_PRO_ACCTD_AMT	NUMBER
BASE_ED_CHRG_PRO_AMT	NUMBER
BASE_ED_CHRG_PRO_ACCTD_AMT	NUMBER
ELMT_ED_PRO_AMT	NUMBER
ELMT_ED_PRO_ACCTD_AMT	NUMBER
ELMT_ED_FRT_PRO_AMT	NUMBER
ELMT_ED_FRT_PRO_ACCTD_AMT	NUMBER
ELMT_ED_TAX_PRO_AMT	NUMBER
ELMT_ED_TAX_PRO_ACCTD_AMT	NUMBER
ELMT_ED_CHRG_PRO_AMT	NUMBER
ELMT_ED_CHRG_PRO_ACCTD_AMT	NUMBER
BUC_ED_ALLOC_AMT	NUMBER
BUC_ED_ALLOC_ACCTD_AMT	NUMBER
BUC_ED_FRT_ALLOC_AMT	NUMBER
BUC_ED_FRT_ALLOC_ACCTD_AMT	NUMBER
BUC_ED_TAX_ALLOC_AMT	NUMBER
BUC_ED_TAX_ALLOC_ACCTD_AMT	NUMBER
BUC_ED_CHRG_ALLOC_AMT	NUMBER
BUC_ED_CHRG_ALLOC_ACCTD_AMT	NUMBER
BASE_UNED_PRO_AMT	NUMBER
BASE_UNED_PRO_ACCTD_AMT	NUMBER
BASE_UNED_FRT_PRO_AMT	NUMBER
BASE_UNED_FRT_PRO_ACCTD_AMT	NUMBER
BASE_UNED_TAX_PRO_AMT	NUMBER
BASE_UNED_TAX_PRO_ACCTD_AMT	NUMBER
BASE_UNED_CHRG_PRO_AMT	NUMBER
BASE_UNED_CHRG_PRO_ACCTD_AMT	NUMBER
ELMT_UNED_PRO_AMT	NUMBER
ELMT_UNED_PRO_ACCTD_AMT	NUMBER
ELMT_UNED_FRT_PRO_AMT	NUMBER
ELMT_UNED_FRT_PRO_ACCTD_AMT	NUMBER
ELMT_UNED_TAX_PRO_AMT	NUMBER
ELMT_UNED_TAX_PRO_ACCTD_AMT	NUMBER
ELMT_UNED_CHRG_PRO_AMT	NUMBER
ELMT_UNED_CHRG_PRO_ACCTD_AMT	NUMBER
BUC_UNED_ALLOC_AMT	NUMBER
BUC_UNED_ALLOC_ACCTD_AMT	NUMBER
BUC_UNED_FRT_ALLOC_AMT	NUMBER
BUC_UNED_FRT_ALLOC_ACCTD_AMT	NUMBER
BUC_UNED_TAX_ALLOC_AMT	NUMBER
BUC_UNED_TAX_ALLOC_ACCTD_AMT	NUMBER
BUC_UNED_CHRG_ALLOC_AMT	NUMBER
BUC_UNED_CHRG_ALLOC_ACCTD_AMT	NUMBER

Query Text

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


SELECT GT_ID
,      BASE_REC_ROWID
,      GP_LEVEL
,      REF_CUSTOMER_TRX_ID
,      REF_CUSTOMER_TRX_LINE_ID
,      BASE_PRO_AMT
,      BASE_PRO_ACCTD_AMT
,      BASE_FRT_PRO_AMT
,      BASE_FRT_PRO_ACCTD_AMT
,      BASE_TAX_PRO_AMT
,      BASE_TAX_PRO_ACCTD_AMT
,      BASE_CHRG_PRO_AMT
,      BASE_CHRG_PRO_ACCTD_AMT
,      ELMT_PRO_AMT
,      ELMT_PRO_ACCTD_AMT
,      ELMT_FRT_PRO_AMT
,      ELMT_FRT_PRO_ACCTD_AMT
,      ELMT_TAX_PRO_AMT
,      ELMT_TAX_PRO_ACCTD_AMT
,      ELMT_CHRG_PRO_AMT
,      ELMT_CHRG_PRO_ACCTD_AMT
,      BUC_ALLOC_AMT
,      BUC_ALLOC_ACCTD_AMT
,      BUC_FRT_ALLOC_AMT
,      BUC_FRT_ALLOC_ACCTD_AMT
,      BUC_TAX_ALLOC_AMT
,      BUC_TAX_ALLOC_ACCTD_AMT
,      BUC_CHRG_ALLOC_AMT
,      BUC_CHRG_ALLOC_ACCTD_AMT
,      BASE_ED_PRO_AMT
,      BASE_ED_PRO_ACCTD_AMT
,      BASE_ED_FRT_PRO_AMT
,      BASE_ED_FRT_PRO_ACCTD_AMT
,      BASE_ED_TAX_PRO_AMT
,      BASE_ED_TAX_PRO_ACCTD_AMT
,      BASE_ED_CHRG_PRO_AMT
,      BASE_ED_CHRG_PRO_ACCTD_AMT
,      ELMT_ED_PRO_AMT
,      ELMT_ED_PRO_ACCTD_AMT
,      ELMT_ED_FRT_PRO_AMT
,      ELMT_ED_FRT_PRO_ACCTD_AMT
,      ELMT_ED_TAX_PRO_AMT
,      ELMT_ED_TAX_PRO_ACCTD_AMT
,      ELMT_ED_CHRG_PRO_AMT
,      ELMT_ED_CHRG_PRO_ACCTD_AMT
,      BUC_ED_ALLOC_AMT
,      BUC_ED_ALLOC_ACCTD_AMT
,      BUC_ED_FRT_ALLOC_AMT
,      BUC_ED_FRT_ALLOC_ACCTD_AMT
,      BUC_ED_TAX_ALLOC_AMT
,      BUC_ED_TAX_ALLOC_ACCTD_AMT
,      BUC_ED_CHRG_ALLOC_AMT
,      BUC_ED_CHRG_ALLOC_ACCTD_AMT
,      BASE_UNED_PRO_AMT
,      BASE_UNED_PRO_ACCTD_AMT
,      BASE_UNED_FRT_PRO_AMT
,      BASE_UNED_FRT_PRO_ACCTD_AMT
,      BASE_UNED_TAX_PRO_AMT
,      BASE_UNED_TAX_PRO_ACCTD_AMT
,      BASE_UNED_CHRG_PRO_AMT
,      BASE_UNED_CHRG_PRO_ACCTD_AMT
,      ELMT_UNED_PRO_AMT
,      ELMT_UNED_PRO_ACCTD_AMT
,      ELMT_UNED_FRT_PRO_AMT
,      ELMT_UNED_FRT_PRO_ACCTD_AMT
,      ELMT_UNED_TAX_PRO_AMT
,      ELMT_UNED_TAX_PRO_ACCTD_AMT
,      ELMT_UNED_CHRG_PRO_AMT
,      ELMT_UNED_CHRG_PRO_ACCTD_AMT
,      BUC_UNED_ALLOC_AMT
,      BUC_UNED_ALLOC_ACCTD_AMT
,      BUC_UNED_FRT_ALLOC_AMT
,      BUC_UNED_FRT_ALLOC_ACCTD_AMT
,      BUC_UNED_TAX_ALLOC_AMT
,      BUC_UNED_TAX_ALLOC_ACCTD_AMT
,      BUC_UNED_CHRG_ALLOC_AMT
,      BUC_UNED_CHRG_ALLOC_ACCTD_AMT
FROM AR.RA_AR_AMOUNTS_GT;

Dependencies

[top of page]

AR.RA_AR_AMOUNTS_GT does not reference any database object

AR.RA_AR_AMOUNTS_GT is referenced by following:

APPS: RA_AR_AMOUNTS_GT