[Home] [Help] [Dependency Information]

TABLE: AR.AR_TRX_LINES_GT

Object Details

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

Temporary Table Details

AR.AR_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$SESSION. 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_TRX_LINES_GT_U1	NORMAL	UNIQUE		TRX_LINE_ID
AR_TRX_LINES_GT_N1	NORMAL	NONUNIQUE		TRX_HEADER_ID

Columns

Query Text

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

SELECT TRX_LINE_ID
,      TRX_HEADER_ID
,      TRX_DATE
,      CUSTOMER_TRX_LINE_ID
,      LINK_TO_TRX_LINE_ID
,      LINE_NUMBER
,      LINE_TYPE
,      CURRENCY_CODE
,      CUSTOMER_TRX_ID
,      LINK_TO_CUST_TRX_LINE_ID
,      ORG_ID
,      SET_OF_BOOKS_ID
,      REASON_CODE
,      INVENTORY_ITEM_ID
,      DESCRIPTION
,      QUANTITY_ORDERED
,      QUANTITY_CREDITED
,      QUANTITY_INVOICED
,      UNIT_STANDARD_PRICE
,      UNIT_SELLING_PRICE
,      SALES_ORDER
,      SALES_ORDER_LINE
,      SALES_ORDER_DATE
,      ACCOUNTING_RULE_ID
,      ACCOUNTING_RULE_DURATION
,      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
,      REQUEST_ID
,      SALES_ORDER_SOURCE
,      EXTENDED_AMOUNT
,      REVENUE_AMOUNT
,      AUTORULE_COMPLETE_FLAG
,      TAX_PRECEDENCE
,      TAX_RATE
,      ITEM_EXCEPTION_RATE_ID
,      TAX_EXEMPTION_ID
,      MEMO_LINE_ID
,      AUTORULE_DURATION_PROCESSED
,      UOM_CODE
,      DEFAULT_USSGL_TRANSACTION_CODE
,      DEFAULT_USSGL_TRX_CODE_CONTEXT
,      VAT_TAX_ID
,      AUTOTAX
,      LAST_PERIOD_TO_CREDIT
,      ITEM_CONTEXT
,      TAX_EXEMPT_FLAG
,      TAX_EXEMPT_NUMBER
,      TAX_EXEMPT_REASON_CODE
,      TAX_VENDOR_RETURN_CODE
,      LOCATION_SEGMENT_ID
,      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
,      GROSS_UNIT_SELLING_PRICE
,      GROSS_EXTENDED_AMOUNT
,      AMOUNT_INCLUDES_TAX_FLAG
,      TAXABLE_AMOUNT
,      WAREHOUSE_ID
,      EXTENDED_ACCTD_AMOUNT
,      CONTRACT_LINE_ID
,      SOURCE_DATA_KEY1
,      SOURCE_DATA_KEY2
,      SOURCE_DATA_KEY3
,      SOURCE_DATA_KEY4
,      SOURCE_DATA_KEY5
,      INVOICED_LINE_ACCTG_LEVEL
,      SHIP_VIA
,      FOB_POINT
,      WAYBILL_NUMBER
,      SHIP_DATE_ACTUAL
,      GL_DATE
,      OVERRIDE_AUTO_ACCOUNTING_FLAG
,      PARENT_LINE_ID
,      DEFERRAL_EXCLUSION_FLAG
,      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_GT;

Dependencies

[top of page]

AR.AR_TRX_LINES_GT does not reference any database object

AR.AR_TRX_LINES_GT is referenced by following:

APPS

AR_TRX_LINES_GT