[Home] [Help] [Dependency Information]

TABLE: AR.AR_LINE_APP_DETAIL_GT

Object Details

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

Temporary Table Details

AR.AR_LINE_APP_DETAIL_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
AR_LINE_APP_DETAIL_GT_N1	NORMAL	NONUNIQUE		GT_ID REF_CUSTOMER_TRX_ID REF_CUSTOMER_TRX_LINE_ID REF_CUST_TRX_LINE_GL_DIST_ID

Columns

Query Text

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

SELECT ACCTD_AMOUNT
,      REF_ACCOUNT_CLASS
,      AMOUNT
,      APP_LEVEL
,      BASE_CURRENCY
,      ACTIVITY_BUCKET
,      CCID
,      CCID_SECONDARY
,      CREATED_BY
,      CREATION_DATE
,      DET_ID
,      FROM_ACCTD_AMOUNT
,      FROM_AMOUNT
,      FROM_CURRENCY
,      GROUP_ID
,      GT_ID
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      LEDGER_ID
,      LINE_ID
,      ORG_ID
,      REF_CUSTOMER_TRX_ID
,      REF_CUSTOMER_TRX_LINE_ID
,      REF_CUST_TRX_LINE_GL_DIST_ID
,      REF_DET_ID
,      REF_LINE_ID
,      SE_GT_ID
,      SOURCE_DATA_KEY1
,      SOURCE_DATA_KEY2
,      SOURCE_DATA_KEY3
,      SOURCE_DATA_KEY4
,      SOURCE_DATA_KEY5
,      SOURCE_ID
,      SOURCE_TABLE
,      SOURCE_TYPE
,      TAXABLE_ACCTD_AMOUNT
,      TAXABLE_AMOUNT
,      TAX_INC_FLAG
,      TAX_LINK_ID
,      TO_CURRENCY
,      REF_MF_DIST_FLAG
,      TAX_CODE_ID
,      LOCATION_SEGMENT_ID
FROM AR.AR_LINE_APP_DETAIL_GT;

Dependencies

[top of page]

AR.AR_LINE_APP_DETAIL_GT does not reference any database object

AR.AR_LINE_APP_DETAIL_GT is referenced by following:

APPS

AR_LINE_APP_DETAIL_GT