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]

VIEW: APPS.CE_AVAILABLE_TRANSACTIONS_V

Object Details

Object Name:	CE_AVAILABLE_TRANSACTIONS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	CE.CE_AVAILABLE_TRANSACTIONS_V
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Comments
ROW_ID	ROWID	(10)	Database row identifier
MULTI_SELECT	CHAR	(1)	Column used internally
BANK_ACCOUNT_ID	NUMBER	(15)	Bank account identifier
BANK_ACCOUNT_NAME	VARCHAR2	(100)	Bank account name
BANK_ACCOUNT_NUM	VARCHAR2	(30)	Bank account number
BANK_NAME	VARCHAR2	(360)	Bank name
BANK_BRANCH_NAME	VARCHAR2	(360)	Bank branch name
TRX_ID	NUMBER		Transaction identifier
TRX_TYPE	VARCHAR2	(30)	Transaction type
TYPE_MEANING	VARCHAR2	(80)	Transaction type meaning
TRX_NUMBER	VARCHAR2	(240)	Transaction number
CHECK_NUMBER	NUMBER		Check Number
CURRENCY_CODE	VARCHAR2	(15)	Transaction currency code
AMOUNT	NUMBER		Transaction amount
BANK_ACCOUNT_AMOUNT	NUMBER		Transaction amount in bank currency
AMOUNT_CLEARED	NUMBER		Cleared amount in bank currency including bank charges and errors
GL_DATE	DATE		GL date
STATUS_DSP	VARCHAR2	(80)	Transaction status description
STATUS	VARCHAR2	(30)	Transaction status
DESCRIPTION	VARCHAR2	(240)	Transaction description
TRX_DATE	DATE		Transaction date
CLEARED_DATE	DATE		Cleared date of this transaction
MATURITY_DATE	DATE		Transaction maturity date
EXCHANGE_RATE_DATE	DATE		Date used in determining currency exchange rate
EXCHANGE_RATE_TYPE	VARCHAR2	(30)	Exchange rate type
USER_EXCHANGE_RATE_TYPE	VARCHAR2	(30)	Currency exchange rate type description
EXCHANGE_RATE	NUMBER		Currency exchange rate
BANK_CHARGES	NUMBER		Bank charge amount
BANK_ERRORS	NUMBER		Bank error amount
BATCH_NAME	VARCHAR2	(4000)	Batch name
BATCH_ID	NUMBER		Batch identifier
AGENT_NAME	VARCHAR2	(360)	Agent name
CUSTOMER_NAME	VARCHAR2	(360)	Customer name
PAYMENT_METHOD	VARCHAR2	(30)	Payment method
VENDOR_NAME	VARCHAR2	(240)	Vendor name
CUSTOMER_ID	NUMBER		Customer identifier
SUPPLIER_ID	NUMBER		Vendor identifier
REFERENCE_TYPE_DSP	VARCHAR2	(80)	Reference type description
REFERENCE_TYPE	VARCHAR2	(30)	Reference type
REFERENCE_ID	NUMBER		Reference identifier
ACTUAL_AMOUNT_CLEARED	NUMBER		Not used
CREATION_DATE	DATE		Standard WHO column
CREATED_BY	NUMBER		Standard WHO column
LAST_UPDATE_DATE	DATE		Standard WHO column
LAST_UPDATED_BY	NUMBER		Standard WHO column
REMITTANCE_NUMBER	VARCHAR2	(40)	Remittance number
CASH_RECEIPT_ID	NUMBER		Cash receipt identifier
APPLICATION_ID	NUMBER		Application identifier
COUNT_CLEARED	NUMBER		Internal use
BANK_CURRENCY_CODE	VARCHAR2	(15)	Bank currency code
TRX_CURRENCY_TYPE	VARCHAR2	(10)	Transaction currency type
CODE_COMBINATION_ID	NUMBER		GL account code
PERIOD_NAME	VARCHAR2	(15)	Accounting period name
JOURNAL_ENTRY_NAME	VARCHAR2	(100)	Journal entry name
DOCUMENT_NUMBER	NUMBER		Document number
JOURNAL_ENTRY_LINE_NUMBER	NUMBER		Journal entry line number
CLEARING_TRX_TYPE	VARCHAR2	(20)	Transaction type for clearing
EXCHANGE_RATE_DSP	NUMBER		Exchange rate description
JOURNAL_CATEGORY	VARCHAR2	(25)	Journal category
BASE_AMOUNT	NUMBER		Transaction amount in functional currency
RECEIPT_CLASS_ID	NUMBER		Receipt class identifier
RECEIPT_METHOD_ID	NUMBER		Receipt method identifier
RECEIPT_CLASS_NAME	VARCHAR2	(30)	Receipt class name
DEPOSIT_DATE	DATE		Deposit date
REVERSED_RECEIPT_FLAG	VARCHAR2	(1)	Flag to specify if the record is related to a reversed receipt.
VALUE_DATE	DATE		Value Date
CE_BANK_ACCT_USE_ID	NUMBER
LEGAL_ENTITY_ID	NUMBER
ORG_ID	NUMBER
COUNTERPARTY	VARCHAR2	(240)
TRXN_SUBTYPE	VARCHAR2	(30)

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
,      EXCHANGE_RATE_DSP
,      JOURNAL_CATEGORY
,      BASE_AMOUNT
,      RECEIPT_CLASS_ID
,      RECEIPT_METHOD_ID
,      RECEIPT_CLASS_NAME
,      DEPOSIT_DATE
,      REVERSED_RECEIPT_FLAG
,      VALUE_DATE
,      CE_BANK_ACCT_USE_ID
,      LEGAL_ENTITY_ID
,      ORG_ID
,      COUNTERPARTY
,      TRXN_SUBTYPE
FROM APPS.CE_AVAILABLE_TRANSACTIONS_V;

Dependencies

[top of page]

APPS.CE_AVAILABLE_TRANSACTIONS_V references the following:

APPS: CE_101_TRANSACTIONS_V; CE_200_TRANSACTIONS_V; CE_222_TRANSACTIONS_V; CE_260_CF_TRANSACTIONS_V; CE_260_TRANSACTIONS_V; CE_801_EFT_TRANSACTIONS_V; CE_801_TRANSACTIONS_V; CE_999_TRANSACTIONS_V; CE_AUTO_BANK_CLEAR - show dependent code; CE_AUTO_BANK_MATCH - show dependent code; FND_ACCESS_CONTROL_UTIL - show dependent code; FND_GLOBAL - show dependent code; FND_PROFILE - show dependent code; IBY_FD_EXTRACT_GEN_PVT - show dependent code; MO_GLOBAL - show dependent code; PAY_CE_RECONCILIATION_PKG - show dependent code; XTR_USER_ACCESS - show dependent code

APPS.CE_AVAILABLE_TRANSACTIONS_V is not referenced by any database object