[Home] [Help] [Dependency Information]

TABLE: CE.CE_AVAILABLE_TRANSACTIONS_TMP

Object Details

Object Name:	CE_AVAILABLE_TRANSACTIONS_TMP
Object Type:	TABLE
Owner:	CE
FND Design Data:	CE.CE_AVAILABLE_TRANSACTIONS_TMP
Subobject Name:
Status:	VALID

Temporary Table Details

CE.CE_AVAILABLE_TRANSACTIONS_TMP 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
CE_AVAILABLE_TRX_TMP_N1	NORMAL	NONUNIQUE		APPLICATION_ID
CE_AVAILABLE_TRX_TMP_N2	NORMAL	NONUNIQUE		TRX_NUMBER
CE_AVAILABLE_TRX_TMP_U1	NORMAL	NONUNIQUE		SEQ_ID

Columns

Query Text

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

SELECT ROW_ID
,      MULTI_SELECT
,      BANK_ACCOUNT_ID
,      BANK_ACCOUNT_NAME
,      BANK_ACCOUNT_NUM
,      BANK_NAME
,      BANK_BRANCH_NAME
,      TRX_ID
,      TRX_TYPE
,      TYPE_MEANING
,      TRX_NUMBER
,      CHECK_NUMBER
,      CURRENCY_CODE
,      AMOUNT
,      BANK_ACCOUNT_AMOUNT
,      AMOUNT_CLEARED
,      GL_DATE
,      STATUS_DSP
,      STATUS
,      DESCRIPTION
,      TRX_DATE
,      CLEARED_DATE
,      MATURITY_DATE
,      EXCHANGE_RATE_DATE
,      EXCHANGE_RATE_TYPE
,      USER_EXCHANGE_RATE_TYPE
,      EXCHANGE_RATE
,      BANK_CHARGES
,      BANK_ERRORS
,      BATCH_NAME
,      BATCH_ID
,      AGENT_NAME
,      CUSTOMER_NAME
,      PAYMENT_METHOD
,      VENDOR_NAME
,      CUSTOMER_ID
,      SUPPLIER_ID
,      REFERENCE_TYPE_DSP
,      REFERENCE_TYPE
,      REFERENCE_ID
,      ACTUAL_AMOUNT_CLEARED
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      REMITTANCE_NUMBER
,      CASH_RECEIPT_ID
,      APPLICATION_ID
,      COUNT_CLEARED
,      BANK_CURRENCY_CODE
,      TRX_CURRENCY_TYPE
,      CODE_COMBINATION_ID
,      PERIOD_NAME
,      JOURNAL_ENTRY_NAME
,      DOCUMENT_NUMBER
,      JOURNAL_ENTRY_LINE_NUMBER
,      CLEARING_TRX_TYPE
,      JOURNAL_CATEGORY
,      BASE_AMOUNT
,      RECEIPT_CLASS_ID
,      RECEIPT_METHOD_ID
,      RECEIPT_CLASS_NAME
,      DEPOSIT_DATE
,      VALUE_DATE
,      REVERSED_RECEIPT_FLAG
,      LEGAL_ENTITY_ID
,      ORG_ID
,      INVOICE_TEXT
,      BANK_ACCOUNT_TEXT
,      CUSTOMER_TEXT
,      COUNTERPARTY
,      TRXN_SUBTYPE
,      CE_BANK_ACCT_USE_ID
,      RECONCILED_STATUS_FLAG
,      SEQ_ID
FROM CE.CE_AVAILABLE_TRANSACTIONS_TMP;

Dependencies

[top of page]

CE.CE_AVAILABLE_TRANSACTIONS_TMP does not reference any database object

CE.CE_AVAILABLE_TRANSACTIONS_TMP is referenced by following:

APPS

CE_AVAILABLE_TRANSACTIONS_TMP