[Home] [Help] [Dependency Information]

TABLE: AR.AR_CREATE_RECEIPTS_GT

Object Details

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

Temporary Table Details

AR.AR_CREATE_RECEIPTS_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_CREATE_RECEIPTS_GT_N1	NORMAL	UNIQUE		RECEIPT_NUMBER RECEIPT_DATE
AR_CREATE_RECEIPTS_GT_N2	NORMAL	NONUNIQUE		REQUEST_ID GT_ID

Columns

Query Text

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

SELECT RECEIPT_NUMBER
,      CASH_RECEIPT_ID
,      RECEIPT_DATE
,      GL_DATE
,      MATURITY_DATE
,      POSTMARK_DATE
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      REQUEST_ID
,      RETURN_ERROR_STATUS
,      RETURN_ERROR_COUNT
,      RETURN_ERROR_TEXT
,      USR_CURRENCY_CODE
,      CURRENCY_CODE
,      USR_EXCHANGE_RATE_TYPE
,      EXCHANGE_RATE_TYPE
,      EXCHANGE_RATE
,      EXCHANGE_RATE_DATE
,      AMOUNT
,      FACTOR_DISCOUNT_AMOUNT
,      CUSTOMER_ID
,      CUSTOMER_NAME
,      CUSTOMER_NUMBER
,      CUSTOMER_BANK_ACCOUNT_ID
,      CUSTOMER_BANK_ACCOUNT_NUM
,      CUSTOMER_BANK_ACCOUNT_NAME
,      PAYMENT_TRXN_EXTENSION_ID
,      LOCATION
,      CUSTOMER_SITE_USE_ID
,      DEFAULT_SITE_USE
,      CUSTOMER_RECEIPT_REFERENCE
,      OVERRIDE_REMIT_ACCOUNT_FLAG
,      REMITTANCE_BANK_ACCOUNT_ID
,      REMITTANCE_BANK_ACCOUNT_NUM
,      REMITTANCE_BANK_ACCOUNT_NAME
,      DEPOSIT_DATE
,      RECEIPT_METHOD_ID
,      RECEIPT_METHOD_NAME
,      DOC_SEQUENCE_VALUE
,      USSGL_TRANSACTION_CODE
,      ANTICIPATED_CLEARING_DATE
,      CALLED_FROM
,      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
,      COMMENTS
,      ISSUER_NAME
,      ISSUE_DATE
,      ISSUER_BANK_BRANCH_ID
,      ORG_ID
,      INSTALLMENT
,      GT_ID
FROM AR.AR_CREATE_RECEIPTS_GT;

Dependencies

[top of page]

AR.AR_CREATE_RECEIPTS_GT does not reference any database object

AR.AR_CREATE_RECEIPTS_GT is referenced by following:

APPS

AR_CREATE_RECEIPTS_GT