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_200_REVERSAL_V

Object Details

Object Name:	CE_200_REVERSAL_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	CE.CE_200_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	Comments
ROW_ID	ROWID	(10)	Database row identifier
MULTI_SELECT	CHAR	(1)	Column used internally
BANK_ACCOUNT_ID	NUMBER	(15)	Bank account identifier
TRX_ID	NUMBER	(15)	Transaction identifier, check identifier
TRX_TYPE	VARCHAR2	(7)	Transaction type, PAYMENT
TYPE_MEANING	VARCHAR2	(80)	Transaction type meaning, Payment
TRX_NUMBER	VARCHAR2	(40)	Transaction 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	(25)	Transaction status
TRX_DATE	DATE		Transaction date
CLEARED_DATE	DATE		Cleared Date, Null
MATURITY_DATE	DATE		Maturity date, future pay due date
BATCH_NAME	VARCHAR2	(255)	Batch name, check run name
AGENT_NAME	VARCHAR2	(240)	Agent name, vendor name
CUSTOMER_ID	NUMBER		Customer identifier, Null
SUPPLIER_ID	NUMBER	(15)	Vendor identifier
CREATION_DATE	DATE		Standard WHO column
CREATED_BY	NUMBER	(15)	Standard WHO column
LAST_UPDATE_DATE	DATE		Standard WHO column
LAST_UPDATED_BY	NUMBER	(15)	Standard WHO column
PAYMENT_METHOD	VARCHAR2	(25)	Payment method
BANK_ACCOUNT_NUM	VARCHAR2	(30)	Bank account number
BANK_ACCOUNT_NAME	VARCHAR2	(100)	Bank account name
BANK_CURRENCY_CODE	VARCHAR2	(15)	Bank currency code
BANK_NAME	VARCHAR2	(360)	Bank name
REVERSAL_CATEGORY	VARCHAR2	(0)	Reversal category, Null
REVERSAL_CATEGORY_ID	VARCHAR2	(0)	Reversal category identifier, Null
REVERSAL_REASON	VARCHAR2	(0)	Reason for reversal, Null
REVERSAL_REASON_ID	VARCHAR2	(0)	Reversal reason identifier, Null
REVERSAL_COMMENTS	VARCHAR2	(0)	Comments for reversal, Null
PAYMENT_METHOD_ID	VARCHAR2	(25)	Payment method identifier
BATCH_ID	VARCHAR2	(40)	Batch identifier, check run identifier
CASH_RECEIPT_ID	NUMBER		Cash receipt identifier, Null
APPLICATION_ID	NUMBER		Application identifier, 100
REMITTANCE_NUMBER	VARCHAR2	(40)	Remittance number, batch identifier
AGENT_NUMBER	VARCHAR2	(30)	Agent number
TRX_RECONCILED_FLAG	CHAR	(1)	Flag to indicate whether the statement line is reconciled or not, Y or N
STATEMENT_LINE_ID	NUMBER		Statement line identifier
STATEMENT_NUMBER	VARCHAR2	(0)	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)
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_200_REVERSAL_V;

Dependencies

[top of page]

APPS.CE_200_REVERSAL_V references the following:

APPS: AP_CHECKS_ALL; AP_INV_SELECTION_CRITERIA_ALL; AP_LOOKUP_CODES; AP_PAYMENT_HISTORY_ALL; AP_SYSTEM_PARAMETERS_ALL; CE_BANK_ACCOUNTS; CE_BANK_ACCT_USES_OU_V; CE_BANK_BRANCHES_V; CE_LOOKUPS; CE_SYSTEM_PARAMETERS; FND_GLOBAL - show dependent code; GL_SETS_OF_BOOKS; PO_VENDORS

APPS.CE_200_REVERSAL_V is referenced by following:

APPS: CE_REVERSAL_TRANSACTIONS_V