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_GT

Object Details

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

Temporary Table Details

AR.RA_AR_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_N1	NORMAL	NONUNIQUE		GT_ID REF_CUSTOMER_TRX_ID GP_LEVEL SOURCE_DATA_KEY1 SOURCE_DATA_KEY2 SOURCE_DATA_KEY3 SOURCE_DATA_KEY4 SOURCE_DATA_KEY5 REF_CUSTOMER_TRX_LINE_ID REF_CUST_TRX_LINE_GL_DIST_ID
RA_AR_N2	NORMAL	NONUNIQUE		GT_ID REF_CUSTOMER_TRX_ID GP_LEVEL REF_CUSTOMER_TRX_LINE_ID REF_CUST_TRX_LINE_GL_DIST_ID

Columns

Name	Datatype	Length
ACCOUNT_CLASS	VARCHAR2	(30)
ACCTD_AMT	NUMBER
ACCTD_AMT_CR	NUMBER
ACCTD_AMT_DR	NUMBER
ALLOC_ACCTD_AMT	NUMBER
ALLOC_AMT	NUMBER
AMT	NUMBER
AMT_CR	NUMBER
AMT_DR	NUMBER
BASE_CHRG_PRO_ACCTD_AMT	NUMBER
BASE_CHRG_PRO_AMT	NUMBER
BASE_CURRENCY	VARCHAR2	(30)
BASE_DIST_ACCTD_AMT	NUMBER
BASE_DIST_AMT	NUMBER
BASE_DIST_CHRG_ACCTD_AMT	NUMBER
BASE_DIST_CHRG_AMT	NUMBER
BASE_DIST_FRT_ACCTD_AMT	NUMBER
BASE_DIST_FRT_AMT	NUMBER
BASE_DIST_TAX_ACCTD_AMT	NUMBER
BASE_DIST_TAX_AMT	NUMBER
BASE_ED_CHRG_PRO_ACCTD_AMT	NUMBER
BASE_ED_CHRG_PRO_AMT	NUMBER
BASE_ED_DIST_ACCTD_AMT	NUMBER
BASE_ED_DIST_AMT	NUMBER
BASE_ED_DIST_CHRG_ACCTD_AMT	NUMBER
BASE_ED_DIST_CHRG_AMT	NUMBER
BASE_ED_DIST_FRT_ACCTD_AMT	NUMBER
BASE_ED_DIST_FRT_AMT	NUMBER
BASE_ED_DIST_TAX_ACCTD_AMT	NUMBER
BASE_ED_DIST_TAX_AMT	NUMBER
BASE_ED_FRT_PRO_ACCTD_AMT	NUMBER
BASE_ED_FRT_PRO_AMT	NUMBER
BASE_ED_PRO_ACCTD_AMT	NUMBER
BASE_ED_PRO_AMT	NUMBER
BASE_ED_TAX_PRO_ACCTD_AMT	NUMBER
BASE_ED_TAX_PRO_AMT	NUMBER
BASE_FRT_PRO_ACCTD_AMT	NUMBER
BASE_FRT_PRO_AMT	NUMBER
BASE_PRO_ACCTD_AMT	NUMBER
BASE_PRO_AMT	NUMBER
BASE_TAX_PRO_ACCTD_AMT	NUMBER
BASE_TAX_PRO_AMT	NUMBER
BASE_UNED_CHRG_PRO_ACCTD_AMT	NUMBER
BASE_UNED_CHRG_PRO_AMT	NUMBER
BASE_UNED_DIST_ACCTD_AMT	NUMBER
BASE_UNED_DIST_AMT	NUMBER
BASE_UNED_DIST_CHRG_ACCTD_AMT	NUMBER
BASE_UNED_DIST_CHRG_AMT	NUMBER
BASE_UNED_DIST_FRT_ACCTD_AMT	NUMBER
BASE_UNED_DIST_FRT_AMT	NUMBER
BASE_UNED_DIST_TAX_ACCTD_AMT	NUMBER
BASE_UNED_DIST_TAX_AMT	NUMBER
BASE_UNED_FRT_PRO_ACCTD_AMT	NUMBER
BASE_UNED_FRT_PRO_AMT	NUMBER
BASE_UNED_PRO_ACCTD_AMT	NUMBER
BASE_UNED_PRO_AMT	NUMBER
BASE_UNED_TAX_PRO_ACCTD_AMT	NUMBER
BASE_UNED_TAX_PRO_AMT	NUMBER
ACTIVITY_BUCKET	VARCHAR2	(30)
BUC_ALLOC_ACCTD_AMT	NUMBER
BUC_ALLOC_AMT	NUMBER
BUC_CHRG_ALLOC_ACCTD_AMT	NUMBER
BUC_CHRG_ALLOC_AMT	NUMBER
BUC_ED_ALLOC_ACCTD_AMT	NUMBER
BUC_ED_ALLOC_AMT	NUMBER
BUC_ED_CHRG_ALLOC_ACCTD_AMT	NUMBER
BUC_ED_CHRG_ALLOC_AMT	NUMBER
BUC_ED_FRT_ALLOC_ACCTD_AMT	NUMBER
BUC_ED_FRT_ALLOC_AMT	NUMBER
BUC_ED_TAX_ALLOC_ACCTD_AMT	NUMBER
BUC_ED_TAX_ALLOC_AMT	NUMBER
BUC_FRT_ALLOC_ACCTD_AMT	NUMBER
BUC_FRT_ALLOC_AMT	NUMBER
BUC_TAX_ALLOC_ACCTD_AMT	NUMBER
BUC_TAX_ALLOC_AMT	NUMBER
BUC_UNED_ALLOC_ACCTD_AMT	NUMBER
BUC_UNED_ALLOC_AMT	NUMBER
BUC_UNED_CHRG_ALLOC_ACCTD_AMT	NUMBER
BUC_UNED_CHRG_ALLOC_AMT	NUMBER
BUC_UNED_FRT_ALLOC_ACCTD_AMT	NUMBER
BUC_UNED_FRT_ALLOC_AMT	NUMBER
BUC_UNED_TAX_ALLOC_ACCTD_AMT	NUMBER
BUC_UNED_TAX_ALLOC_AMT	NUMBER
CCID	NUMBER
CCID_SECONDARY	NUMBER
CHRG_REM_ACCTD_AMT	NUMBER
CHRG_REM_AMT	NUMBER
DET_ID	NUMBER
DIST_ACCTD_AMT	NUMBER
DIST_AMT	NUMBER
DIST_CHRG_ACCTD_AMT	NUMBER
DIST_CHRG_AMT	NUMBER
DIST_ED_ACCTD_AMT	NUMBER
DIST_ED_AMT	NUMBER
DIST_ED_CHRG_ACCTD_AMT	NUMBER
DIST_ED_CHRG_AMT	NUMBER
DIST_ED_FRT_ACCTD_AMT	NUMBER
DIST_ED_FRT_AMT	NUMBER
DIST_ED_TAX_ACCTD_AMT	NUMBER
DIST_ED_TAX_AMT	NUMBER
DIST_FRT_ACCTD_AMT	NUMBER
DIST_FRT_AMT	NUMBER
DIST_TAX_ACCTD_AMT	NUMBER
DIST_TAX_AMT	NUMBER
DIST_UNED_ACCTD_AMT	NUMBER
DIST_UNED_AMT	NUMBER
DIST_UNED_CHRG_ACCTD_AMT	NUMBER
DIST_UNED_CHRG_AMT	NUMBER
DIST_UNED_FRT_ACCTD_AMT	NUMBER
DIST_UNED_FRT_AMT	NUMBER
DIST_UNED_TAX_ACCTD_AMT	NUMBER
DIST_UNED_TAX_AMT	NUMBER
DUE_ORIG_ACCTD_AMT	NUMBER
DUE_ORIG_AMT	NUMBER
DUE_REM_ACCTD_AMT	NUMBER
DUE_REM_AMT	NUMBER
ELMT_CHRG_PRO_ACCTD_AMT	NUMBER
ELMT_CHRG_PRO_AMT	NUMBER
ELMT_ED_CHRG_PRO_ACCTD_AMT	NUMBER
ELMT_ED_CHRG_PRO_AMT	NUMBER
ELMT_ED_FRT_PRO_ACCTD_AMT	NUMBER
ELMT_ED_FRT_PRO_AMT	NUMBER
ELMT_ED_PRO_ACCTD_AMT	NUMBER
ELMT_ED_PRO_AMT	NUMBER
ELMT_ED_TAX_PRO_ACCTD_AMT	NUMBER
ELMT_ED_TAX_PRO_AMT	NUMBER
ELMT_FRT_PRO_ACCTD_AMT	NUMBER
ELMT_FRT_PRO_AMT	NUMBER
ELMT_PRO_ACCTD_AMT	NUMBER
ELMT_PRO_AMT	NUMBER
ELMT_TAX_PRO_ACCTD_AMT	NUMBER
ELMT_TAX_PRO_AMT	NUMBER
ELMT_UNED_CHRG_PRO_ACCTD_AMT	NUMBER
ELMT_UNED_CHRG_PRO_AMT	NUMBER
ELMT_UNED_FRT_PRO_ACCTD_AMT	NUMBER
ELMT_UNED_FRT_PRO_AMT	NUMBER
ELMT_UNED_PRO_ACCTD_AMT	NUMBER
ELMT_UNED_PRO_AMT	NUMBER
ELMT_UNED_TAX_PRO_ACCTD_AMT	NUMBER
ELMT_UNED_TAX_PRO_AMT	NUMBER
FROM_ACCTD_AMT_CR	NUMBER
FROM_ACCTD_AMT_DR	NUMBER
FROM_ALLOC_ACCTD_AMT	NUMBER
FROM_ALLOC_AMT	NUMBER
FROM_CURRENCY	VARCHAR2	(30)
FRT_ADJ_REM_ACCTD_AMT	NUMBER
FRT_ADJ_REM_AMT	NUMBER
FRT_ORIG_ACCTD_AMT	NUMBER
FRT_ORIG_AMT	NUMBER
FRT_REM_ACCTD_AMT	NUMBER
FRT_REM_AMT	NUMBER
GP_LEVEL	VARCHAR2	(30)
GROUP_ID	VARCHAR2	(1000)
GT_ID	VARCHAR2	(30)
LINE_ID	NUMBER
LINE_TYPE	VARCHAR2	(30)
REF_CUSTOMER_TRX_ID	NUMBER
REF_CUSTOMER_TRX_LINE_ID	NUMBER
REF_CUST_TRX_LINE_GL_DIST_ID	NUMBER
REF_DET_ID	NUMBER
REF_LINE_ID	NUMBER
SET_OF_BOOKS_ID	NUMBER
SE_GT_ID	VARCHAR2	(30)
SOB_TYPE	VARCHAR2	(2)
SOURCE_DATA_KEY1	VARCHAR2	(150)
SOURCE_DATA_KEY2	VARCHAR2	(150)
SOURCE_DATA_KEY3	VARCHAR2	(150)
SOURCE_DATA_KEY4	VARCHAR2	(150)
SOURCE_DATA_KEY5	VARCHAR2	(150)
SOURCE_ID	NUMBER
SOURCE_TABLE	VARCHAR2	(30)
SOURCE_TYPE	VARCHAR2	(30)
SUM_GP_LINE_CHRG_REM_ACCTD_AMT	NUMBER
SUM_GP_LINE_CHRG_REM_AMT	NUMBER
SUM_GP_LINE_FRT_ORIG_ACCTD_AMT	NUMBER
SUM_GP_LINE_FRT_ORIG_AMT	NUMBER
SUM_GP_LINE_FRT_REM_ACCTD_AMT	NUMBER
SUM_GP_LINE_FRT_REM_AMT	NUMBER
SUM_GP_LINE_ORIG_ACCTD_AMT	NUMBER
SUM_GP_LINE_ORIG_AMT	NUMBER
SUM_GP_LINE_REM_ACCTD_AMT	NUMBER
SUM_GP_LINE_REM_AMT	NUMBER
SUM_GP_LINE_TAX_ORIG_ACCTD_AMT	NUMBER
SUM_GP_LINE_TAX_ORIG_AMT	NUMBER
SUM_GP_LINE_TAX_REM_ACCTD_AMT	NUMBER
SUM_GP_LINE_TAX_REM_AMT	NUMBER
SUM_LINE_CHRG_REM_ACCTD_AMT	NUMBER
SUM_LINE_CHRG_REM_AMT	NUMBER
SUM_LINE_FRT_ORIG_ACCTD_AMT	NUMBER
SUM_LINE_FRT_ORIG_AMT	NUMBER
SUM_LINE_FRT_REM_ACCTD_AMT	NUMBER
SUM_LINE_FRT_REM_AMT	NUMBER
SUM_LINE_ORIG_ACCTD_AMT	NUMBER
SUM_LINE_ORIG_AMT	NUMBER
SUM_LINE_REM_ACCTD_AMT	NUMBER
SUM_LINE_REM_AMT	NUMBER
SUM_LINE_TAX_ORIG_ACCTD_AMT	NUMBER
SUM_LINE_TAX_ORIG_AMT	NUMBER
SUM_LINE_TAX_REM_ACCTD_AMT	NUMBER
SUM_LINE_TAX_REM_AMT	NUMBER
TAX_INC_FLAG	VARCHAR2	(1)
TAX_LINK_ID	NUMBER
TAX_ORIG_ACCTD_AMT	NUMBER
TAX_ORIG_AMT	NUMBER
TAX_REM_ACCTD_AMT	NUMBER
TAX_REM_AMT	NUMBER
TL_ALLOC_ACCTD_AMT	NUMBER
TL_ALLOC_AMT	NUMBER
TL_CHRG_ALLOC_ACCTD_AMT	NUMBER
TL_CHRG_ALLOC_AMT	NUMBER
TL_ED_ALLOC_ACCTD_AMT	NUMBER
TL_ED_ALLOC_AMT	NUMBER
TL_ED_CHRG_ALLOC_ACCTD_AMT	NUMBER
TL_ED_CHRG_ALLOC_AMT	NUMBER
TL_ED_FRT_ALLOC_ACCTD_AMT	NUMBER
TL_ED_FRT_ALLOC_AMT	NUMBER
TL_ED_TAX_ALLOC_ACCTD_AMT	NUMBER
TL_ED_TAX_ALLOC_AMT	NUMBER
TL_FRT_ALLOC_ACCTD_AMT	NUMBER
TL_FRT_ALLOC_AMT	NUMBER
TL_TAX_ALLOC_ACCTD_AMT	NUMBER
TL_TAX_ALLOC_AMT	NUMBER
TL_UNED_ALLOC_ACCTD_AMT	NUMBER
TL_UNED_ALLOC_AMT	NUMBER
TL_UNED_CHRG_ALLOC_ACCTD_AMT	NUMBER
TL_UNED_CHRG_ALLOC_AMT	NUMBER
TL_UNED_FRT_ALLOC_ACCTD_AMT	NUMBER
TL_UNED_FRT_ALLOC_AMT	NUMBER
TL_UNED_TAX_ALLOC_ACCTD_AMT	NUMBER
TL_UNED_TAX_ALLOC_AMT	NUMBER
TO_CURRENCY	VARCHAR2	(30)
REF_MF_DIST_FLAG	VARCHAR2	(15)
CHRG_ORIG_AMT	NUMBER
CHRG_ORIG_ACCTD_AMT	NUMBER
CHRG_ADJ_REM_AMT	NUMBER
CHRG_ADJ_REM_ACCTD_AMT	NUMBER
SUM_LINE_CHRG_ORIG_AMT	NUMBER
SUM_LINE_CHRG_ORIG_ACCTD_AMT	NUMBER
SUM_GP_LINE_CHRG_ORIG_AMT	NUMBER
SUM_GP_LINE_CHRG_ORIG_ACCTD_AM	NUMBER
INT_LINE_AMOUNT	NUMBER
INT_TAX_AMOUNT	NUMBER
INT_ED_LINE_AMOUNT	NUMBER
INT_ED_TAX_AMOUNT	NUMBER
INT_UNED_LINE_AMOUNT	NUMBER
INT_UNED_TAX_AMOUNT	NUMBER
SUM_INT_LINE_AMOUNT	NUMBER
SUM_INT_TAX_AMOUNT	NUMBER
SUM_INT_ED_LINE_AMOUNT	NUMBER
SUM_INT_ED_TAX_AMOUNT	NUMBER
SUM_INT_UNED_LINE_AMOUNT	NUMBER
SUM_INT_UNED_TAX_AMOUNT	NUMBER
TAX_CODE_ID	NUMBER	(15)
LOCATION_SEGMENT_ID	NUMBER	(15)

Query Text

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


SELECT ACCOUNT_CLASS
,      ACCTD_AMT
,      ACCTD_AMT_CR
,      ACCTD_AMT_DR
,      ALLOC_ACCTD_AMT
,      ALLOC_AMT
,      AMT
,      AMT_CR
,      AMT_DR
,      BASE_CHRG_PRO_ACCTD_AMT
,      BASE_CHRG_PRO_AMT
,      BASE_CURRENCY
,      BASE_DIST_ACCTD_AMT
,      BASE_DIST_AMT
,      BASE_DIST_CHRG_ACCTD_AMT
,      BASE_DIST_CHRG_AMT
,      BASE_DIST_FRT_ACCTD_AMT
,      BASE_DIST_FRT_AMT
,      BASE_DIST_TAX_ACCTD_AMT
,      BASE_DIST_TAX_AMT
,      BASE_ED_CHRG_PRO_ACCTD_AMT
,      BASE_ED_CHRG_PRO_AMT
,      BASE_ED_DIST_ACCTD_AMT
,      BASE_ED_DIST_AMT
,      BASE_ED_DIST_CHRG_ACCTD_AMT
,      BASE_ED_DIST_CHRG_AMT
,      BASE_ED_DIST_FRT_ACCTD_AMT
,      BASE_ED_DIST_FRT_AMT
,      BASE_ED_DIST_TAX_ACCTD_AMT
,      BASE_ED_DIST_TAX_AMT
,      BASE_ED_FRT_PRO_ACCTD_AMT
,      BASE_ED_FRT_PRO_AMT
,      BASE_ED_PRO_ACCTD_AMT
,      BASE_ED_PRO_AMT
,      BASE_ED_TAX_PRO_ACCTD_AMT
,      BASE_ED_TAX_PRO_AMT
,      BASE_FRT_PRO_ACCTD_AMT
,      BASE_FRT_PRO_AMT
,      BASE_PRO_ACCTD_AMT
,      BASE_PRO_AMT
,      BASE_TAX_PRO_ACCTD_AMT
,      BASE_TAX_PRO_AMT
,      BASE_UNED_CHRG_PRO_ACCTD_AMT
,      BASE_UNED_CHRG_PRO_AMT
,      BASE_UNED_DIST_ACCTD_AMT
,      BASE_UNED_DIST_AMT
,      BASE_UNED_DIST_CHRG_ACCTD_AMT
,      BASE_UNED_DIST_CHRG_AMT
,      BASE_UNED_DIST_FRT_ACCTD_AMT
,      BASE_UNED_DIST_FRT_AMT
,      BASE_UNED_DIST_TAX_ACCTD_AMT
,      BASE_UNED_DIST_TAX_AMT
,      BASE_UNED_FRT_PRO_ACCTD_AMT
,      BASE_UNED_FRT_PRO_AMT
,      BASE_UNED_PRO_ACCTD_AMT
,      BASE_UNED_PRO_AMT
,      BASE_UNED_TAX_PRO_ACCTD_AMT
,      BASE_UNED_TAX_PRO_AMT
,      ACTIVITY_BUCKET
,      BUC_ALLOC_ACCTD_AMT
,      BUC_ALLOC_AMT
,      BUC_CHRG_ALLOC_ACCTD_AMT
,      BUC_CHRG_ALLOC_AMT
,      BUC_ED_ALLOC_ACCTD_AMT
,      BUC_ED_ALLOC_AMT
,      BUC_ED_CHRG_ALLOC_ACCTD_AMT
,      BUC_ED_CHRG_ALLOC_AMT
,      BUC_ED_FRT_ALLOC_ACCTD_AMT
,      BUC_ED_FRT_ALLOC_AMT
,      BUC_ED_TAX_ALLOC_ACCTD_AMT
,      BUC_ED_TAX_ALLOC_AMT
,      BUC_FRT_ALLOC_ACCTD_AMT
,      BUC_FRT_ALLOC_AMT
,      BUC_TAX_ALLOC_ACCTD_AMT
,      BUC_TAX_ALLOC_AMT
,      BUC_UNED_ALLOC_ACCTD_AMT
,      BUC_UNED_ALLOC_AMT
,      BUC_UNED_CHRG_ALLOC_ACCTD_AMT
,      BUC_UNED_CHRG_ALLOC_AMT
,      BUC_UNED_FRT_ALLOC_ACCTD_AMT
,      BUC_UNED_FRT_ALLOC_AMT
,      BUC_UNED_TAX_ALLOC_ACCTD_AMT
,      BUC_UNED_TAX_ALLOC_AMT
,      CCID
,      CCID_SECONDARY
,      CHRG_REM_ACCTD_AMT
,      CHRG_REM_AMT
,      DET_ID
,      DIST_ACCTD_AMT
,      DIST_AMT
,      DIST_CHRG_ACCTD_AMT
,      DIST_CHRG_AMT
,      DIST_ED_ACCTD_AMT
,      DIST_ED_AMT
,      DIST_ED_CHRG_ACCTD_AMT
,      DIST_ED_CHRG_AMT
,      DIST_ED_FRT_ACCTD_AMT
,      DIST_ED_FRT_AMT
,      DIST_ED_TAX_ACCTD_AMT
,      DIST_ED_TAX_AMT
,      DIST_FRT_ACCTD_AMT
,      DIST_FRT_AMT
,      DIST_TAX_ACCTD_AMT
,      DIST_TAX_AMT
,      DIST_UNED_ACCTD_AMT
,      DIST_UNED_AMT
,      DIST_UNED_CHRG_ACCTD_AMT
,      DIST_UNED_CHRG_AMT
,      DIST_UNED_FRT_ACCTD_AMT
,      DIST_UNED_FRT_AMT
,      DIST_UNED_TAX_ACCTD_AMT
,      DIST_UNED_TAX_AMT
,      DUE_ORIG_ACCTD_AMT
,      DUE_ORIG_AMT
,      DUE_REM_ACCTD_AMT
,      DUE_REM_AMT
,      ELMT_CHRG_PRO_ACCTD_AMT
,      ELMT_CHRG_PRO_AMT
,      ELMT_ED_CHRG_PRO_ACCTD_AMT
,      ELMT_ED_CHRG_PRO_AMT
,      ELMT_ED_FRT_PRO_ACCTD_AMT
,      ELMT_ED_FRT_PRO_AMT
,      ELMT_ED_PRO_ACCTD_AMT
,      ELMT_ED_PRO_AMT
,      ELMT_ED_TAX_PRO_ACCTD_AMT
,      ELMT_ED_TAX_PRO_AMT
,      ELMT_FRT_PRO_ACCTD_AMT
,      ELMT_FRT_PRO_AMT
,      ELMT_PRO_ACCTD_AMT
,      ELMT_PRO_AMT
,      ELMT_TAX_PRO_ACCTD_AMT
,      ELMT_TAX_PRO_AMT
,      ELMT_UNED_CHRG_PRO_ACCTD_AMT
,      ELMT_UNED_CHRG_PRO_AMT
,      ELMT_UNED_FRT_PRO_ACCTD_AMT
,      ELMT_UNED_FRT_PRO_AMT
,      ELMT_UNED_PRO_ACCTD_AMT
,      ELMT_UNED_PRO_AMT
,      ELMT_UNED_TAX_PRO_ACCTD_AMT
,      ELMT_UNED_TAX_PRO_AMT
,      FROM_ACCTD_AMT_CR
,      FROM_ACCTD_AMT_DR
,      FROM_ALLOC_ACCTD_AMT
,      FROM_ALLOC_AMT
,      FROM_CURRENCY
,      FRT_ADJ_REM_ACCTD_AMT
,      FRT_ADJ_REM_AMT
,      FRT_ORIG_ACCTD_AMT
,      FRT_ORIG_AMT
,      FRT_REM_ACCTD_AMT
,      FRT_REM_AMT
,      GP_LEVEL
,      GROUP_ID
,      GT_ID
,      LINE_ID
,      LINE_TYPE
,      REF_CUSTOMER_TRX_ID
,      REF_CUSTOMER_TRX_LINE_ID
,      REF_CUST_TRX_LINE_GL_DIST_ID
,      REF_DET_ID
,      REF_LINE_ID
,      SET_OF_BOOKS_ID
,      SE_GT_ID
,      SOB_TYPE
,      SOURCE_DATA_KEY1
,      SOURCE_DATA_KEY2
,      SOURCE_DATA_KEY3
,      SOURCE_DATA_KEY4
,      SOURCE_DATA_KEY5
,      SOURCE_ID
,      SOURCE_TABLE
,      SOURCE_TYPE
,      SUM_GP_LINE_CHRG_REM_ACCTD_AMT
,      SUM_GP_LINE_CHRG_REM_AMT
,      SUM_GP_LINE_FRT_ORIG_ACCTD_AMT
,      SUM_GP_LINE_FRT_ORIG_AMT
,      SUM_GP_LINE_FRT_REM_ACCTD_AMT
,      SUM_GP_LINE_FRT_REM_AMT
,      SUM_GP_LINE_ORIG_ACCTD_AMT
,      SUM_GP_LINE_ORIG_AMT
,      SUM_GP_LINE_REM_ACCTD_AMT
,      SUM_GP_LINE_REM_AMT
,      SUM_GP_LINE_TAX_ORIG_ACCTD_AMT
,      SUM_GP_LINE_TAX_ORIG_AMT
,      SUM_GP_LINE_TAX_REM_ACCTD_AMT
,      SUM_GP_LINE_TAX_REM_AMT
,      SUM_LINE_CHRG_REM_ACCTD_AMT
,      SUM_LINE_CHRG_REM_AMT
,      SUM_LINE_FRT_ORIG_ACCTD_AMT
,      SUM_LINE_FRT_ORIG_AMT
,      SUM_LINE_FRT_REM_ACCTD_AMT
,      SUM_LINE_FRT_REM_AMT
,      SUM_LINE_ORIG_ACCTD_AMT
,      SUM_LINE_ORIG_AMT
,      SUM_LINE_REM_ACCTD_AMT
,      SUM_LINE_REM_AMT
,      SUM_LINE_TAX_ORIG_ACCTD_AMT
,      SUM_LINE_TAX_ORIG_AMT
,      SUM_LINE_TAX_REM_ACCTD_AMT
,      SUM_LINE_TAX_REM_AMT
,      TAX_INC_FLAG
,      TAX_LINK_ID
,      TAX_ORIG_ACCTD_AMT
,      TAX_ORIG_AMT
,      TAX_REM_ACCTD_AMT
,      TAX_REM_AMT
,      TL_ALLOC_ACCTD_AMT
,      TL_ALLOC_AMT
,      TL_CHRG_ALLOC_ACCTD_AMT
,      TL_CHRG_ALLOC_AMT
,      TL_ED_ALLOC_ACCTD_AMT
,      TL_ED_ALLOC_AMT
,      TL_ED_CHRG_ALLOC_ACCTD_AMT
,      TL_ED_CHRG_ALLOC_AMT
,      TL_ED_FRT_ALLOC_ACCTD_AMT
,      TL_ED_FRT_ALLOC_AMT
,      TL_ED_TAX_ALLOC_ACCTD_AMT
,      TL_ED_TAX_ALLOC_AMT
,      TL_FRT_ALLOC_ACCTD_AMT
,      TL_FRT_ALLOC_AMT
,      TL_TAX_ALLOC_ACCTD_AMT
,      TL_TAX_ALLOC_AMT
,      TL_UNED_ALLOC_ACCTD_AMT
,      TL_UNED_ALLOC_AMT
,      TL_UNED_CHRG_ALLOC_ACCTD_AMT
,      TL_UNED_CHRG_ALLOC_AMT
,      TL_UNED_FRT_ALLOC_ACCTD_AMT
,      TL_UNED_FRT_ALLOC_AMT
,      TL_UNED_TAX_ALLOC_ACCTD_AMT
,      TL_UNED_TAX_ALLOC_AMT
,      TO_CURRENCY
,      REF_MF_DIST_FLAG
,      CHRG_ORIG_AMT
,      CHRG_ORIG_ACCTD_AMT
,      CHRG_ADJ_REM_AMT
,      CHRG_ADJ_REM_ACCTD_AMT
,      SUM_LINE_CHRG_ORIG_AMT
,      SUM_LINE_CHRG_ORIG_ACCTD_AMT
,      SUM_GP_LINE_CHRG_ORIG_AMT
,      SUM_GP_LINE_CHRG_ORIG_ACCTD_AM
,      INT_LINE_AMOUNT
,      INT_TAX_AMOUNT
,      INT_ED_LINE_AMOUNT
,      INT_ED_TAX_AMOUNT
,      INT_UNED_LINE_AMOUNT
,      INT_UNED_TAX_AMOUNT
,      SUM_INT_LINE_AMOUNT
,      SUM_INT_TAX_AMOUNT
,      SUM_INT_ED_LINE_AMOUNT
,      SUM_INT_ED_TAX_AMOUNT
,      SUM_INT_UNED_LINE_AMOUNT
,      SUM_INT_UNED_TAX_AMOUNT
,      TAX_CODE_ID
,      LOCATION_SEGMENT_ID
FROM AR.RA_AR_GT;

Dependencies

[top of page]

AR.RA_AR_GT does not reference any database object

AR.RA_AR_GT is referenced by following:

APPS: RA_AR_GT