[Home] [Help] [Dependency Information]
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 |
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.
Tablespace: | |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Index | Type | Uniqueness | Tablespace | 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 |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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) |
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;
AR.AR_AE_ALLOC_REC_GT does not reference any database object
AR.AR_AE_ALLOC_REC_GT is referenced by following:
|
|
|