[Home] [Help] [Dependency Information]

TABLE: AR.AR_TRX_LINES_TMP_GT

Object Details

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

Temporary Table Details

AR.AR_TRX_LINES_TMP_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$SESSION. Data is removed at the end of this period.

Storage Details

Tablespace:
PCT Free:	10
PCT Used:	40

Columns

Query Text

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

SELECT TRX_HEADER_ID
,      TRX_LINE_ID
,      LINK_TO_TRX_LINE_ID
,      LINE_NUMBER
,      REASON_CODE
,      INVENTORY_ITEM_ID
,      DESCRIPTION
,      QUANTITY_ORDERED
,      QUANTITY_INVOICED
,      UNIT_STANDARD_PRICE
,      UNIT_SELLING_PRICE
,      SALES_ORDER
,      SALES_ORDER_LINE
,      SALES_ORDER_DATE
,      ACCOUNTING_RULE_ID
,      LINE_TYPE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      RULE_START_DATE
,      INTERFACE_LINE_CONTEXT
,      INTERFACE_LINE_ATTRIBUTE1
,      INTERFACE_LINE_ATTRIBUTE2
,      INTERFACE_LINE_ATTRIBUTE3
,      INTERFACE_LINE_ATTRIBUTE4
,      INTERFACE_LINE_ATTRIBUTE5
,      INTERFACE_LINE_ATTRIBUTE6
,      INTERFACE_LINE_ATTRIBUTE7
,      INTERFACE_LINE_ATTRIBUTE8
,      INTERFACE_LINE_ATTRIBUTE9
,      INTERFACE_LINE_ATTRIBUTE10
,      INTERFACE_LINE_ATTRIBUTE11
,      INTERFACE_LINE_ATTRIBUTE12
,      INTERFACE_LINE_ATTRIBUTE13
,      INTERFACE_LINE_ATTRIBUTE14
,      INTERFACE_LINE_ATTRIBUTE15
,      SALES_ORDER_SOURCE
,      AMOUNT
,      TAX_PRECEDENCE
,      TAX_RATE
,      TAX_EXEMPTION_ID
,      MEMO_LINE_ID
,      UOM_CODE
,      DEFAULT_USSGL_TRANSACTION_CODE
,      DEFAULT_USSGL_TRX_CODE_CONTEXT
,      VAT_TAX_ID
,      TAX_EXEMPT_FLAG
,      TAX_EXEMPT_NUMBER
,      TAX_EXEMPT_REASON_CODE
,      TAX_VENDOR_RETURN_CODE
,      MOVEMENT_ID
,      GLOBAL_ATTRIBUTE1
,      GLOBAL_ATTRIBUTE2
,      GLOBAL_ATTRIBUTE3
,      GLOBAL_ATTRIBUTE4
,      GLOBAL_ATTRIBUTE5
,      GLOBAL_ATTRIBUTE6
,      GLOBAL_ATTRIBUTE7
,      GLOBAL_ATTRIBUTE8
,      GLOBAL_ATTRIBUTE9
,      GLOBAL_ATTRIBUTE10
,      GLOBAL_ATTRIBUTE11
,      GLOBAL_ATTRIBUTE12
,      GLOBAL_ATTRIBUTE13
,      GLOBAL_ATTRIBUTE14
,      GLOBAL_ATTRIBUTE15
,      GLOBAL_ATTRIBUTE16
,      GLOBAL_ATTRIBUTE17
,      GLOBAL_ATTRIBUTE18
,      GLOBAL_ATTRIBUTE19
,      GLOBAL_ATTRIBUTE20
,      GLOBAL_ATTRIBUTE_CATEGORY
,      AMOUNT_INCLUDES_TAX_FLAG
,      WAREHOUSE_ID
,      CONTRACT_LINE_ID
,      SOURCE_DATA_KEY1
,      SOURCE_DATA_KEY2
,      SOURCE_DATA_KEY3
,      SOURCE_DATA_KEY4
,      SOURCE_DATA_KEY5
,      INVOICED_LINE_ACCTG_LEVEL
,      SHIP_DATE_ACTUAL
,      SOURCE_APPLICATION_ID
,      SOURCE_EVENT_CLASS_CODE
,      SOURCE_ENTITY_CODE
,      SOURCE_TRX_ID
,      SOURCE_TRX_LINE_ID
,      SOURCE_TRX_LINE_TYPE
,      SOURCE_TRX_DETAIL_TAX_LINE_ID
,      HISTORICAL_FLAG
,      TAXABLE_FLAG
,      TAX_REGIME_CODE
,      TAX
,      TAX_STATUS_CODE
,      TAX_RATE_CODE
,      TAX_JURISDICTION_CODE
,      TAX_CLASSIFICATION_CODE
,      RULE_END_DATE
,      INTEREST_LINE_ID
,      TRX_BUSINESS_CATEGORY
,      PRODUCT_FISC_CLASSIFICATION
,      PRODUCT_CATEGORY
,      PRODUCT_TYPE
,      LINE_INTENDED_USE
,      ASSESSABLE_VALUE
,      USER_DEFINED_FISC_CLASS
FROM AR.AR_TRX_LINES_TMP_GT;

Dependencies

[top of page]

AR.AR_TRX_LINES_TMP_GT does not reference any database object

AR.AR_TRX_LINES_TMP_GT is referenced by following:

APPS

AR_TRX_LINES_TMP_GT