eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [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	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

Name	Datatype	Length
ROW_ID	ROWID	(10)
MULTI_SELECT	CHAR	(1)
BANK_ACCOUNT_ID	NUMBER
BANK_ACCOUNT_NAME	VARCHAR2	(80)
BANK_ACCOUNT_NUM	VARCHAR2	(30)
BANK_NAME	VARCHAR2	(60)
BANK_BRANCH_NAME	VARCHAR2	(60)
TRX_ID	NUMBER
TRX_TYPE	VARCHAR2	(30)
TYPE_MEANING	VARCHAR2	(80)
TRX_NUMBER	VARCHAR2	(240)
CHECK_NUMBER	NUMBER
CURRENCY_CODE	VARCHAR2	(15)
AMOUNT	NUMBER
BANK_ACCOUNT_AMOUNT	NUMBER
AMOUNT_CLEARED	NUMBER
GL_DATE	DATE
STATUS_DSP	VARCHAR2	(80)
STATUS	VARCHAR2	(30)
DESCRIPTION	VARCHAR2	(250)
TRX_DATE	DATE
CLEARED_DATE	DATE
MATURITY_DATE	DATE
EXCHANGE_RATE_DATE	DATE
EXCHANGE_RATE_TYPE	VARCHAR2	(30)
USER_EXCHANGE_RATE_TYPE	VARCHAR2	(30)
EXCHANGE_RATE	NUMBER
BANK_CHARGES	NUMBER
BANK_ERRORS	NUMBER
BATCH_NAME	VARCHAR2	(100)
BATCH_ID	NUMBER
AGENT_NAME	VARCHAR2	(240)
CUSTOMER_NAME	VARCHAR2	(360)
PAYMENT_METHOD	VARCHAR2	(80)
VENDOR_NAME	VARCHAR2	(240)
CUSTOMER_ID	NUMBER
SUPPLIER_ID	NUMBER
REFERENCE_TYPE_DSP	VARCHAR2	(80)
REFERENCE_TYPE	VARCHAR2	(30)
REFERENCE_ID	NUMBER
ACTUAL_AMOUNT_CLEARED	NUMBER
CREATION_DATE	DATE
CREATED_BY	NUMBER
LAST_UPDATE_DATE	DATE
LAST_UPDATED_BY	NUMBER
REMITTANCE_NUMBER	VARCHAR2	(30)
CASH_RECEIPT_ID	NUMBER
APPLICATION_ID	NUMBER
COUNT_CLEARED	NUMBER
BANK_CURRENCY_CODE	VARCHAR2	(15)
TRX_CURRENCY_TYPE	VARCHAR2	(10)
CODE_COMBINATION_ID	NUMBER
PERIOD_NAME	VARCHAR2	(15)
JOURNAL_ENTRY_NAME	VARCHAR2	(100)
DOCUMENT_NUMBER	NUMBER
JOURNAL_ENTRY_LINE_NUMBER	NUMBER
CLEARING_TRX_TYPE	VARCHAR2	(20)
JOURNAL_CATEGORY	VARCHAR2	(25)
BASE_AMOUNT	NUMBER
RECEIPT_CLASS_ID	NUMBER
RECEIPT_METHOD_ID	NUMBER
RECEIPT_CLASS_NAME	VARCHAR2	(30)
DEPOSIT_DATE	DATE
VALUE_DATE	DATE
REVERSED_RECEIPT_FLAG	VARCHAR2	(1)
LEGAL_ENTITY_ID	NUMBER	(15)
ORG_ID	NUMBER	(15)
INVOICE_TEXT	VARCHAR2	(70)
BANK_ACCOUNT_TEXT	VARCHAR2	(30)
CUSTOMER_TEXT	VARCHAR2	(80)
COUNTERPARTY	VARCHAR2	(240)
TRXN_SUBTYPE	VARCHAR2	(30)
CE_BANK_ACCT_USE_ID	NUMBER	(15)
RECONCILED_STATUS_FLAG	VARCHAR2	(1)
SEQ_ID	NUMBER	(15)

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