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_REVERSAL_V

Object Details

Object Name:	CE_222_REVERSAL_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	CE.CE_222_REVERSAL_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	Mandatory	Comments
ROW_ID	ROWID	(10)		Database row identifier
MULTI_SELECT	CHAR	(1)		Column used internally
BANK_ACCOUNT_ID	NUMBER	(15)	Yes	Bank account identifier
TRX_ID	NUMBER	(15)	Yes	Transaction identifier, cash receipt history identifier
TRX_TYPE	VARCHAR2	(20)		Transaction type, RECEIPT
TYPE_MEANING	VARCHAR2	(80)		Transaction type meaning, Receipt
TRX_NUMBER	VARCHAR2	(30)		Transaction number, receipt number
CURRENCY_CODE	VARCHAR2	(15)	Yes	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		Yes	GL date
STATUS_DSP	VARCHAR2	(80)	Yes	Transaction status description
STATUS	VARCHAR2	(30)	Yes	Transaction status
TRX_DATE	DATE		Yes	Transaction date
CLEARED_DATE	DATE			Cleared Date, Null
MATURITY_DATE	DATE			Maturity date, due date
BATCH_NAME	VARCHAR2	(20)		Batch name
AGENT_NAME	VARCHAR2	(360)		Agent name, customer name
CUSTOMER_ID	NUMBER	(15)		Customer identifier
SUPPLIER_ID	NUMBER			Supplier identifier, Null
CREATION_DATE	DATE		Yes	Standard WHO column
CREATED_BY	NUMBER	(15)	Yes	Standard WHO column
LAST_UPDATE_DATE	DATE		Yes	Standard WHO column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO column
PAYMENT_METHOD	VARCHAR2	(30)	Yes	Payment method
BANK_ACCOUNT_NUM	VARCHAR2	(30)		Bank account number
BANK_ACCOUNT_NAME	VARCHAR2	(100)	Yes	Bank account name
BANK_CURRENCY_CODE	VARCHAR2	(15)		Bank currency code
BANK_NAME	VARCHAR2	(360)	Yes	Bank name
REVERSAL_CATEGORY	VARCHAR2	(80)		Reversal category
REVERSAL_CATEGORY_ID	VARCHAR2	(20)		Reversal category identifier
REVERSAL_REASON	VARCHAR2	(80)		Reason for reversal
REVERSAL_REASON_ID	VARCHAR2	(30)		Reversal reason identifier
REVERSAL_COMMENTS	VARCHAR2	(240)		Reversal comments
PAYMENT_METHOD_ID	VARCHAR2	(40)		Payment method identifier
BATCH_ID	VARCHAR2	(40)		Batch identifier
CASH_RECEIPT_ID	NUMBER	(15)	Yes	Cash receipt identifier
APPLICATION_ID	NUMBER			Application identifier, 222
REMITTANCE_NUMBER	VARCHAR2	(30)		Remittance number, bank deposit number
AGENT_NUMBER	VARCHAR2	(30)		Agent number, customer number
TRX_RECONCILED_FLAG	VARCHAR2	(1)		Flag to indicate whether the receipt is reconciled or not, Y or N
STATEMENT_LINE_ID	NUMBER	(15)		Statement line identifier
STATEMENT_NUMBER	VARCHAR2	(50)		Statement number
STATEMENT_LINE_AMOUNT	NUMBER			Statement line amount
TRX_CURRENCY_TYPE	VARCHAR2	(10)		Transaction currency type
BASE_AMOUNT	NUMBER			Transaction amount in functional currency
VALUE_DATE	DATE			Value date
CE_BANK_ACCT_USE_ID	NUMBER	(15)	Yes
ORG_ID	NUMBER	(15)

Query Text

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


SELECT ROW_ID
,      MULTI_SELECT
,      BANK_ACCOUNT_ID
,      TRX_ID
,      TRX_TYPE
,      TYPE_MEANING
,      TRX_NUMBER
,      CURRENCY_CODE
,      AMOUNT
,      BANK_ACCOUNT_AMOUNT
,      AMOUNT_CLEARED
,      GL_DATE
,      STATUS_DSP
,      STATUS
,      TRX_DATE
,      CLEARED_DATE
,      MATURITY_DATE
,      BATCH_NAME
,      AGENT_NAME
,      CUSTOMER_ID
,      SUPPLIER_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      PAYMENT_METHOD
,      BANK_ACCOUNT_NUM
,      BANK_ACCOUNT_NAME
,      BANK_CURRENCY_CODE
,      BANK_NAME
,      REVERSAL_CATEGORY
,      REVERSAL_CATEGORY_ID
,      REVERSAL_REASON
,      REVERSAL_REASON_ID
,      REVERSAL_COMMENTS
,      PAYMENT_METHOD_ID
,      BATCH_ID
,      CASH_RECEIPT_ID
,      APPLICATION_ID
,      REMITTANCE_NUMBER
,      AGENT_NUMBER
,      TRX_RECONCILED_FLAG
,      STATEMENT_LINE_ID
,      STATEMENT_NUMBER
,      STATEMENT_LINE_AMOUNT
,      TRX_CURRENCY_TYPE
,      BASE_AMOUNT
,      VALUE_DATE
,      CE_BANK_ACCT_USE_ID
,      ORG_ID
FROM APPS.CE_222_REVERSAL_V;

Dependencies

[top of page]

APPS.CE_222_REVERSAL_V references the following:

APPS: ARP_CASHBOOK - show dependent code; AR_BATCHES_ALL; AR_CASH_RECEIPTS_ALL; AR_CASH_RECEIPT_HISTORY_ALL; AR_LOOKUPS; AR_PAYMENT_SCHEDULES_ALL; AR_RECEIPT_METHODS; CE_AUTO_BANK_CLEAR - show dependent code; CE_BANK_ACCOUNTS; CE_BANK_ACCT_USES_ALL; CE_LOOKUPS; CE_SECURITY_PROFILES_GT; CE_STATEMENT_HEADERS; CE_STATEMENT_LINES; CE_STATEMENT_RECONCILS_ALL; CE_SYSTEM_PARAMETERS; GL_LEDGERS; HZ_CUST_ACCOUNTS; HZ_PARTIES

APPS.CE_222_REVERSAL_V is referenced by following:

APPS: CE_AUTO_BANK_MATCH - show dependent code; CE_REVERSAL_TRANSACTIONS_V