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_222_TXN_FOR_BATCH_V

Object Details

Object Name:	CE_222_TXN_FOR_BATCH_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	CE.CE_222_TXN_FOR_BATCH_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
TRX_ID	NUMBER	(15)	Transaction Identifier, Cash Receipt History Identifier
TRX_TYPE	VARCHAR2	(20)	Transaction Type -- either Cash or Miscellaneous
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
STATUS	VARCHAR2	(30)	Transaction Status
TRX_DATE	DATE		Transaction Date
CASH_RECEIPT_ID	NUMBER	(15)	Cash Receipt Identifier
BASE_AMOUNT	NUMBER		Transaction Amount in Functional Currency
BATCH_ID	NUMBER	(15)	Batch Identifier
BANK_CHARGES	NUMBER		Bank Charge Amount
RECEIPT_GL_DATE	DATE		Receipt GL Date
EXCHANGE_RATE	NUMBER		Exchange Rate
EXCHANGE_RATE_DATE	DATE		Exchange Rate Date
EXCHANGE_RATE_TYPE	VARCHAR2	(30)	Exchange Rate Type
CE_BANK_ACCT_USE_ID	NUMBER	(15)
ORG_ID	NUMBER	(15)

Query Text

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


SELECT TRX_ID
,      TRX_TYPE
,      CURRENCY_CODE
,      AMOUNT
,      BANK_ACCOUNT_AMOUNT
,      AMOUNT_CLEARED
,      STATUS
,      TRX_DATE
,      CASH_RECEIPT_ID
,      BASE_AMOUNT
,      BATCH_ID
,      BANK_CHARGES
,      RECEIPT_GL_DATE
,      EXCHANGE_RATE
,      EXCHANGE_RATE_DATE
,      EXCHANGE_RATE_TYPE
,      CE_BANK_ACCT_USE_ID
,      ORG_ID
FROM APPS.CE_222_TXN_FOR_BATCH_V;

Dependencies

[top of page]

APPS.CE_222_TXN_FOR_BATCH_V references the following:

APPS: AR_BATCHES_ALL; AR_CASH_RECEIPTS_ALL; AR_CASH_RECEIPT_HISTORY_ALL; AR_LOOKUPS; AR_PAYMENT_SCHEDULES_ALL; AR_RECEIPT_CLASSES; AR_RECEIPT_METHODS; CE_AUTO_BANK_CLEAR - show dependent code; CE_BANK_ACCOUNTS; CE_BANK_ACCT_USES_ALL; CE_BANK_ACCT_USES_OU_V; CE_LOOKUPS; CE_SECURITY_PROFILES_GT; CE_STATEMENT_RECONCILS_ALL; CE_SYSTEM_PARAMETERS; GL_DAILY_CONVERSION_TYPES; GL_SETS_OF_BOOKS

APPS.CE_222_TXN_FOR_BATCH_V is referenced by following:

APPS: CE_AUTO_BANK_CLEAR1 - show dependent code; CE_AUTO_BANK_MATCH - show dependent code