[Home] [Help] [Dependency Information]

TABLE: AR.AR_TRX_HEADER_TMP_GT

Object Details

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

Temporary Table Details

AR.AR_TRX_HEADER_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_NUMBER
,      TRX_DATE
,      TRX_CURRENCY
,      REFERENCE_NUMBER
,      TRX_CLASS
,      CUST_TRX_TYPE_ID
,      GL_DATE
,      BILL_TO_CUSTOMER_ID
,      BILL_TO_ACCOUNT_NUMBER
,      BILL_TO_CUSTOMER_NAME
,      BILL_TO_CONTACT_ID
,      BILL_TO_ADDRESS_ID
,      BILL_TO_SITE_USE_ID
,      SHIP_TO_CUSTOMER_ID
,      SHIP_TO_ACCOUNT_NUMBER
,      SHIP_TO_CUSTOMER_NAME
,      SHIP_TO_CONTACT_ID
,      SHIP_TO_ADDRESS_ID
,      SHIP_TO_SITE_USE_ID
,      SOLD_TO_CUSTOMER_ID
,      TERM_ID
,      PRIMARY_SALESREP_ID
,      PRIMARY_SALESREP_NAME
,      EXCHANGE_RATE_TYPE
,      EXCHANGE_DATE
,      EXCHANGE_RATE
,      TERRITORY_ID
,      REMIT_TO_ADDRESS_ID
,      INVOICING_RULE_ID
,      PRINTING_OPTION
,      PURCHASE_ORDER
,      PURCHASE_ORDER_REVISION
,      PURCHASE_ORDER_DATE
,      COMMENTS
,      INTERNAL_NOTES
,      FINANCE_CHARGES
,      RECEIPT_METHOD_ID
,      RELATED_CUSTOMER_TRX_ID
,      AGREEMENT_ID
,      SHIP_VIA
,      SHIP_DATE_ACTUAL
,      WAYBILL_NUMBER
,      FOB_POINT
,      CUSTOMER_BANK_ACCOUNT_ID
,      DEFAULT_USSGL_TRANSACTION_CODE
,      STATUS_TRX
,      PAYING_CUSTOMER_ID
,      PAYING_SITE_USE_ID
,      DEFAULT_TAX_EXEMPT_FLAG
,      DOC_SEQUENCE_VALUE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      GLOBAL_ATTRIBUTE_CATEGORY
,      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_ATTRIBUTE21
,      GLOBAL_ATTRIBUTE22
,      GLOBAL_ATTRIBUTE23
,      GLOBAL_ATTRIBUTE24
,      GLOBAL_ATTRIBUTE25
,      GLOBAL_ATTRIBUTE26
,      GLOBAL_ATTRIBUTE27
,      GLOBAL_ATTRIBUTE28
,      GLOBAL_ATTRIBUTE29
,      GLOBAL_ATTRIBUTE30
,      INTERFACE_HEADER_CONTEXT
,      INTERFACE_HEADER_ATTRIBUTE1
,      INTERFACE_HEADER_ATTRIBUTE2
,      INTERFACE_HEADER_ATTRIBUTE3
,      INTERFACE_HEADER_ATTRIBUTE4
,      INTERFACE_HEADER_ATTRIBUTE5
,      INTERFACE_HEADER_ATTRIBUTE6
,      INTERFACE_HEADER_ATTRIBUTE7
,      INTERFACE_HEADER_ATTRIBUTE8
,      INTERFACE_HEADER_ATTRIBUTE9
,      INTERFACE_HEADER_ATTRIBUTE10
,      INTERFACE_HEADER_ATTRIBUTE11
,      INTERFACE_HEADER_ATTRIBUTE12
,      INTERFACE_HEADER_ATTRIBUTE13
,      INTERFACE_HEADER_ATTRIBUTE14
,      INTERFACE_HEADER_ATTRIBUTE15
,      ORG_ID
,      LEGAL_ENTITY_ID
,      PAYMENT_TRXN_EXTENSION_ID
,      BILLING_DATE
,      INTEREST_HEADER_ID
,      LATE_CHARGES_ASSESSED
,      DOCUMENT_SUB_TYPE
,      DEFAULT_TAXATION_COUNTRY
,      TAXED_UPSTREAM_FLAG
FROM AR.AR_TRX_HEADER_TMP_GT;

Dependencies

[top of page]

AR.AR_TRX_HEADER_TMP_GT does not reference any database object

AR.AR_TRX_HEADER_TMP_GT is referenced by following:

APPS

AR_TRX_HEADER_TMP_GT