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_CUSTOMER_TRX_LINES_GT

Object Details

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

Temporary Table Details

AR.RA_CUSTOMER_TRX_LINES_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_CUSTOMER_TRX_LINES_GT_N1	NORMAL	NONUNIQUE		CUSTOMER_TRX_ID CUSTOMER_TRX_LINE_ID

Columns

Name	Datatype	Length
ACCTD_AMOUNT_DUE_ORIGINAL	NUMBER
ACCTD_AMOUNT_DUE_REMAINING	NUMBER
AMOUNT_DUE_ORIGINAL	NUMBER
AMOUNT_DUE_REMAINING	NUMBER
CHRG_ACCTD_AMOUNT_REMAINING	NUMBER
CHRG_AMOUNT_REMAINING	NUMBER
CUSTOMER_TRX_ID	NUMBER
CUSTOMER_TRX_LINE_ID	NUMBER
DESCRIPTION	VARCHAR2	(240)
FRT_ADJ_ACCTD_REMAINING	NUMBER
FRT_ADJ_REMAINING	NUMBER
FRT_ED_ACCTD_AMOUNT	NUMBER
FRT_ED_AMOUNT	NUMBER
FRT_UNED_ACCTD_AMOUNT	NUMBER
FRT_UNED_AMOUNT	NUMBER
GROUP_ID	VARCHAR2	(1000)
INVENTORY_ITEM_ID	NUMBER
LINE_TYPE	VARCHAR2	(20)
LINK_TO_CUST_TRX_LINE_ID	NUMBER
REASON_CODE	VARCHAR2	(30)
SET_OF_BOOKS_ID	NUMBER
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)
BR_LINE_ORIG_AMT	NUMBER
BR_TAX_ORIG_AMT	NUMBER
BR_FRT_ORIG_AMT	NUMBER
BR_CHRG_ORIG_AMT	NUMBER
BR_LINE_REM_AMT	NUMBER
BR_TAX_REM_AMT	NUMBER
BR_FRT_REM_AMT	NUMBER
BR_CHRG_REM_AMT	NUMBER
BR_LINE_ORIG_ACCTD_AMT	NUMBER
BR_TAX_ORIG_ACCTD_AMT	NUMBER
BR_FRT_ORIG_ACCTD_AMT	NUMBER
BR_CHRG_ORIG_ACCTD_AMT	NUMBER
BR_LINE_REM_ACCTD_AMT	NUMBER
BR_TAX_REM_ACCTD_AMT	NUMBER
BR_FRT_REM_ACCTD_AMT	NUMBER
BR_CHRG_REM_ACCTD_AMT	NUMBER
BR_REF_CUSTOMER_TRX_ID	NUMBER
BR_ADJUSTMENT_ID	NUMBER
LINE_ORIGIN	VARCHAR2	(30)
CM_AMT_DUE_ORIG	NUMBER
CM_AMT_DUE_REM	NUMBER
CM_ACCTD_AMT_DUE_ORIG	NUMBER
CM_ACCTD_AMT_DUE_REM	NUMBER

Query Text

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


SELECT ACCTD_AMOUNT_DUE_ORIGINAL
,      ACCTD_AMOUNT_DUE_REMAINING
,      AMOUNT_DUE_ORIGINAL
,      AMOUNT_DUE_REMAINING
,      CHRG_ACCTD_AMOUNT_REMAINING
,      CHRG_AMOUNT_REMAINING
,      CUSTOMER_TRX_ID
,      CUSTOMER_TRX_LINE_ID
,      DESCRIPTION
,      FRT_ADJ_ACCTD_REMAINING
,      FRT_ADJ_REMAINING
,      FRT_ED_ACCTD_AMOUNT
,      FRT_ED_AMOUNT
,      FRT_UNED_ACCTD_AMOUNT
,      FRT_UNED_AMOUNT
,      GROUP_ID
,      INVENTORY_ITEM_ID
,      LINE_TYPE
,      LINK_TO_CUST_TRX_LINE_ID
,      REASON_CODE
,      SET_OF_BOOKS_ID
,      SOURCE_DATA_KEY1
,      SOURCE_DATA_KEY2
,      SOURCE_DATA_KEY3
,      SOURCE_DATA_KEY4
,      SOURCE_DATA_KEY5
,      BR_LINE_ORIG_AMT
,      BR_TAX_ORIG_AMT
,      BR_FRT_ORIG_AMT
,      BR_CHRG_ORIG_AMT
,      BR_LINE_REM_AMT
,      BR_TAX_REM_AMT
,      BR_FRT_REM_AMT
,      BR_CHRG_REM_AMT
,      BR_LINE_ORIG_ACCTD_AMT
,      BR_TAX_ORIG_ACCTD_AMT
,      BR_FRT_ORIG_ACCTD_AMT
,      BR_CHRG_ORIG_ACCTD_AMT
,      BR_LINE_REM_ACCTD_AMT
,      BR_TAX_REM_ACCTD_AMT
,      BR_FRT_REM_ACCTD_AMT
,      BR_CHRG_REM_ACCTD_AMT
,      BR_REF_CUSTOMER_TRX_ID
,      BR_ADJUSTMENT_ID
,      LINE_ORIGIN
,      CM_AMT_DUE_ORIG
,      CM_AMT_DUE_REM
,      CM_ACCTD_AMT_DUE_ORIG
,      CM_ACCTD_AMT_DUE_REM
FROM AR.RA_CUSTOMER_TRX_LINES_GT;

Dependencies

[top of page]

AR.RA_CUSTOMER_TRX_LINES_GT does not reference any database object

AR.RA_CUSTOMER_TRX_LINES_GT is referenced by following:

APPS: RA_CUSTOMER_TRX_LINES_GT