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_AE_ALLOC_REC_GT

Object Details

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

Temporary Table Details

AR.AR_AE_ALLOC_REC_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	Column
AR_AE_ALLOC_REC_GT_N1	NORMAL	NONUNIQUE	AE_ID AE_ACCOUNT_CLASS AE_CUSTOMER_TRX_LINE_ID
AR_AE_ALLOC_REC_GT_N2	NORMAL	NONUNIQUE	AE_ID AE_ACCOUNT_CLASS AE_TAX_TYPE AE_TAX_ID AE_TAX_LINE_COUNT AE_COUNTED_FLAG
AR_AE_ALLOC_REC_GT_N3	NORMAL	NONUNIQUE	AE_ID AE_ACCOUNT_CLASS AE_LINK_TO_CUST_TRX_LINE_ID
AR_AE_ALLOC_REC_GT_N4	NORMAL	NONUNIQUE	AE_ID REF_ACCOUNT_CLASS AE_TAX_LINK_ID

Columns

Name	Datatype	Length
AE_ID	NUMBER	(15)
AE_ACCOUNT_CLASS	VARCHAR2	(20)
AE_CUSTOMER_TRX_ID	NUMBER	(15)
AE_CUSTOMER_TRX_LINE_ID	NUMBER	(15)
AE_LINK_TO_CUST_TRX_LINE_ID	NUMBER	(15)
AE_TAX_TYPE	VARCHAR2	(30)
AE_CODE_COMBINATION_ID	NUMBER	(15)
AE_COLLECTED_TAX_CCID	NUMBER	(15)
AE_LINE_AMOUNT	NUMBER
AE_AMOUNT	NUMBER
AE_ACCTD_AMOUNT	NUMBER
AE_TAX_ID	NUMBER
AE_TAXABLE_AMOUNT	NUMBER
AE_TAXABLE_ACCTD_AMOUNT	NUMBER
AE_SUM_ALLOC_AMT	NUMBER
AE_SUM_ALLOC_ACCTD_AMT	NUMBER
AE_ADJ_CCID	NUMBER	(15)
AE_EDISC_CCID	NUMBER	(15)
AE_UNEDISC_CCID	NUMBER	(15)
AE_FINCHRG_CCID	NUMBER	(15)
AE_ADJ_NON_REC_TAX_CCID	NUMBER	(15)
AE_EDISC_NON_REC_TAX_CCID	NUMBER	(15)
AE_UNEDISC_NON_REC_TAX_CCID	NUMBER	(15)
AE_FINCHRG_NON_REC_TAX_CCID	NUMBER	(15)
AE_OVERRIDE_CCID1	NUMBER	(15)
AE_OVERRIDE_CCID2	NUMBER	(15)
AE_TAX_LINK_ID	NUMBER
AE_TAX_LINK_ID_ED_ADJ	NUMBER
AE_TAX_LINK_ID_UNED	NUMBER
AE_TAX_LINK_ID_ACT	NUMBER
AE_PRO_AMT	NUMBER
AE_PRO_ACCTD_AMT	NUMBER
AE_PRO_FRT_CHRG_AMT	NUMBER
AE_PRO_FRT_CHRG_ACCTD_AMT	NUMBER
AE_PRO_TAXABLE_AMT	NUMBER
AE_PRO_TAXABLE_ACCTD_AMT	NUMBER
AE_PRO_SPLIT_TAXABLE_AMT	NUMBER
AE_PRO_SPLIT_TAXABLE_ACCTD_AMT	NUMBER
AE_PRO_RECOV_TAXABLE_AMT	NUMBER
AE_PRO_RECOV_TAXABLE_ACCTD_AMT	NUMBER
AE_PRO_DEF_TAX_AMT	NUMBER
AE_PRO_DEF_TAX_ACCTD_AMT	NUMBER
AE_COUNTED_FLAG	VARCHAR2	(1)
AE_AUTOTAX	VARCHAR2	(1)
AE_NEG_IND	NUMBER
AE_SUM_REV_AMT	NUMBER
AE_SUM_REV_ACCTD_AMT	NUMBER
AE_COUNT	NUMBER
AE_TAX_LINE_COUNT	NUMBER
AE_SUMMARIZE_FLAG	VARCHAR2	(1)
AE_LINE_TYPE	VARCHAR2	(30)
AE_LINE_TYPE_SECONDARY	VARCHAR2	(30)
AE_SOURCE_ID	NUMBER	(15)
AE_SOURCE_TABLE	VARCHAR2	(10)
AE_ACCOUNT	NUMBER	(15)
AE_ENTERED_DR	NUMBER
AE_ENTERED_CR	NUMBER
AE_ACCOUNTED_DR	NUMBER
AE_ACCOUNTED_CR	NUMBER
AE_SOURCE_ID_SECONDARY	NUMBER	(15)
AE_SOURCE_TABLE_SECONDARY	VARCHAR2	(10)
AE_CURRENCY_CODE	VARCHAR2	(15)
AE_CURRENCY_CONVERSION_RATE	NUMBER
AE_CURRENCY_CONVERSION_TYPE	VARCHAR2	(30)
AE_CURRENCY_CONVERSION_DATE	DATE
AE_THIRD_PARTY_ID	NUMBER	(15)
AE_THIRD_PARTY_SUB_ID	NUMBER	(15)
AE_TAX_GROUP_CODE_ID	NUMBER	(15)
AE_TAX_CODE_ID	NUMBER	(15)
AE_LOCATION_SEGMENT_ID	NUMBER	(15)
AE_TAXABLE_ENTERED_DR	NUMBER
AE_TAXABLE_ENTERED_CR	NUMBER
AE_TAXABLE_ACCOUNTED_DR	NUMBER
AE_TAXABLE_ACCOUNTED_CR	NUMBER
AE_REVERSED_SOURCE_ID	NUMBER	(15)
AE_INV_LINE	NUMBER	(15)
AE_AMOUNT_DUE_ORIGINAL	NUMBER
AE_ACCTD_AMOUNT_DUE_ORIGINAL	NUMBER
AE_AMOUNT_DUE_REMAINING	NUMBER
AE_ACCTD_AMOUNT_DUE_REMAINING	NUMBER
AE_CUST_TRX_LINE_GL_DIST_ID	NUMBER
AE_REF_LINE_ID	NUMBER
AE_PRO_CHRG_AMT	NUMBER
AE_PRO_CHRG_ACCTD_AMT	NUMBER
AE_SUM_ADJ_AMT	NUMBER
AE_SUM_ADJ_ACCTD_AMT	NUMBER
AE_CHRG_AMOUNT_REMAINING	NUMBER
AE_CHRG_ACCTD_AMOUNT_REMAINING	NUMBER
AE_SUM_CHRG_AMOUNT_REM	NUMBER
AE_SUM_CHRG_ACCTD_AMOUNT_REM	NUMBER
AE_CHRG_AMOUNT	NUMBER
AE_CHRG_ACCTD_AMOUNT	NUMBER
AE_SUM_ADJ_CHRG_AMT	NUMBER
AE_SUM_ADJ_CHRG_ACCTD_AMT	NUMBER
AE_ORIG_INSERT	VARCHAR2	(30)
AE_FROM_PRO_AMT	NUMBER
AE_FROM_PRO_ACCTD_AMT	NUMBER
AE_FROM_PRO_CHRG_AMT	NUMBER
AE_FROM_PRO_CHRG_ACCTD_AMT	NUMBER
AE_FROM_AMOUNT_DR	NUMBER
AE_FROM_AMOUNT_CR	NUMBER
AE_FROM_ACCTD_AMOUNT_DR	NUMBER
AE_FROM_ACCTD_AMOUNT_CR	NUMBER
REF_ACCOUNT_CLASS	VARCHAR2	(30)
ACTIVITY_BUCKET	VARCHAR2	(30)
REF_DIST_CCID	NUMBER
REF_MF_DIST_FLAG	VARCHAR2	(15)

Query Text

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


SELECT AE_ID
,      AE_ACCOUNT_CLASS
,      AE_CUSTOMER_TRX_ID
,      AE_CUSTOMER_TRX_LINE_ID
,      AE_LINK_TO_CUST_TRX_LINE_ID
,      AE_TAX_TYPE
,      AE_CODE_COMBINATION_ID
,      AE_COLLECTED_TAX_CCID
,      AE_LINE_AMOUNT
,      AE_AMOUNT
,      AE_ACCTD_AMOUNT
,      AE_TAX_ID
,      AE_TAXABLE_AMOUNT
,      AE_TAXABLE_ACCTD_AMOUNT
,      AE_SUM_ALLOC_AMT
,      AE_SUM_ALLOC_ACCTD_AMT
,      AE_ADJ_CCID
,      AE_EDISC_CCID
,      AE_UNEDISC_CCID
,      AE_FINCHRG_CCID
,      AE_ADJ_NON_REC_TAX_CCID
,      AE_EDISC_NON_REC_TAX_CCID
,      AE_UNEDISC_NON_REC_TAX_CCID
,      AE_FINCHRG_NON_REC_TAX_CCID
,      AE_OVERRIDE_CCID1
,      AE_OVERRIDE_CCID2
,      AE_TAX_LINK_ID
,      AE_TAX_LINK_ID_ED_ADJ
,      AE_TAX_LINK_ID_UNED
,      AE_TAX_LINK_ID_ACT
,      AE_PRO_AMT
,      AE_PRO_ACCTD_AMT
,      AE_PRO_FRT_CHRG_AMT
,      AE_PRO_FRT_CHRG_ACCTD_AMT
,      AE_PRO_TAXABLE_AMT
,      AE_PRO_TAXABLE_ACCTD_AMT
,      AE_PRO_SPLIT_TAXABLE_AMT
,      AE_PRO_SPLIT_TAXABLE_ACCTD_AMT
,      AE_PRO_RECOV_TAXABLE_AMT
,      AE_PRO_RECOV_TAXABLE_ACCTD_AMT
,      AE_PRO_DEF_TAX_AMT
,      AE_PRO_DEF_TAX_ACCTD_AMT
,      AE_COUNTED_FLAG
,      AE_AUTOTAX
,      AE_NEG_IND
,      AE_SUM_REV_AMT
,      AE_SUM_REV_ACCTD_AMT
,      AE_COUNT
,      AE_TAX_LINE_COUNT
,      AE_SUMMARIZE_FLAG
,      AE_LINE_TYPE
,      AE_LINE_TYPE_SECONDARY
,      AE_SOURCE_ID
,      AE_SOURCE_TABLE
,      AE_ACCOUNT
,      AE_ENTERED_DR
,      AE_ENTERED_CR
,      AE_ACCOUNTED_DR
,      AE_ACCOUNTED_CR
,      AE_SOURCE_ID_SECONDARY
,      AE_SOURCE_TABLE_SECONDARY
,      AE_CURRENCY_CODE
,      AE_CURRENCY_CONVERSION_RATE
,      AE_CURRENCY_CONVERSION_TYPE
,      AE_CURRENCY_CONVERSION_DATE
,      AE_THIRD_PARTY_ID
,      AE_THIRD_PARTY_SUB_ID
,      AE_TAX_GROUP_CODE_ID
,      AE_TAX_CODE_ID
,      AE_LOCATION_SEGMENT_ID
,      AE_TAXABLE_ENTERED_DR
,      AE_TAXABLE_ENTERED_CR
,      AE_TAXABLE_ACCOUNTED_DR
,      AE_TAXABLE_ACCOUNTED_CR
,      AE_REVERSED_SOURCE_ID
,      AE_INV_LINE
,      AE_AMOUNT_DUE_ORIGINAL
,      AE_ACCTD_AMOUNT_DUE_ORIGINAL
,      AE_AMOUNT_DUE_REMAINING
,      AE_ACCTD_AMOUNT_DUE_REMAINING
,      AE_CUST_TRX_LINE_GL_DIST_ID
,      AE_REF_LINE_ID
,      AE_PRO_CHRG_AMT
,      AE_PRO_CHRG_ACCTD_AMT
,      AE_SUM_ADJ_AMT
,      AE_SUM_ADJ_ACCTD_AMT
,      AE_CHRG_AMOUNT_REMAINING
,      AE_CHRG_ACCTD_AMOUNT_REMAINING
,      AE_SUM_CHRG_AMOUNT_REM
,      AE_SUM_CHRG_ACCTD_AMOUNT_REM
,      AE_CHRG_AMOUNT
,      AE_CHRG_ACCTD_AMOUNT
,      AE_SUM_ADJ_CHRG_AMT
,      AE_SUM_ADJ_CHRG_ACCTD_AMT
,      AE_ORIG_INSERT
,      AE_FROM_PRO_AMT
,      AE_FROM_PRO_ACCTD_AMT
,      AE_FROM_PRO_CHRG_AMT
,      AE_FROM_PRO_CHRG_ACCTD_AMT
,      AE_FROM_AMOUNT_DR
,      AE_FROM_AMOUNT_CR
,      AE_FROM_ACCTD_AMOUNT_DR
,      AE_FROM_ACCTD_AMOUNT_CR
,      REF_ACCOUNT_CLASS
,      ACTIVITY_BUCKET
,      REF_DIST_CCID
,      REF_MF_DIST_FLAG
FROM AR.AR_AE_ALLOC_REC_GT;

Dependencies

[top of page]

AR.AR_AE_ALLOC_REC_GT does not reference any database object

AR.AR_AE_ALLOC_REC_GT is referenced by following:

APPS: AR_AE_ALLOC_REC_GT