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_RECONCILED_V

Object Details

Object Name:	CE_200_RECONCILED_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	CE.CE_200_RECONCILED_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
STATEMENT_LINE_ID	NUMBER	(15)	Yes	Statement line identifier
BANK_ACCOUNT_ID	NUMBER	(15)	Yes	Bank account identifier
TRX_ID	NUMBER	(15)	Yes	Transaction identifier, check identifier
TRX_TYPE	CHAR	(7)		Transaction type, PAYMENT
TYPE_MEANING	VARCHAR2	(80)		Transaction type meaning, Payment
TRX_NUMBER	VARCHAR2	(40)		Transaction number, check number
CURRENCY_CODE	VARCHAR2	(15)	Yes	Transaction currency code, check currency code
TRX_CURRENCY_TYPE	VARCHAR2	(10)		Transaction currency type, functional or entered
AMOUNT	NUMBER		Yes	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		Yes	Transaction date
CLEARED_DATE	DATE			Date this payment was cleared
MATURITY_DATE	DATE			Transaction maturity date, future pay due date
EXCHANGE_RATE_DATE	DATE			Date used in determining currency exchange rate
EXCHANGE_RATE_TYPE	VARCHAR2	(30)		Currency exchange rate type
EXCHANGE_RATE	NUMBER			Currency exchange rate
BANK_CHARGES	NUMBER			Bank charge amount
BANK_ERRORS	NUMBER			Bank error amount
BATCH_NAME	VARCHAR2	(255)		Batch name, check run name
BATCH_ID	NUMBER			Batch identifier, check run identifier
AGENT_NAME	VARCHAR2	(240)		Agent name, vendor name
CUSTOMER_NAME	VARCHAR2	(0)		Customer name, Null
VENDOR_NAME	VARCHAR2	(240)		Vendor name
CUSTOMER_ID	NUMBER			Customer identifier, Null
SUPPLIER_ID	NUMBER	(15)		Vendor identifier
REFERENCE_TYPE_DSP	VARCHAR2	(0)		Reference type description, Null
REFERENCE_TYPE	VARCHAR2	(0)		Reference type, Null
REFERENCE_ID	NUMBER			Reference 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
STATEMENT_HEADER_ID	NUMBER	(15)	Yes	Statement identifier
CASH_RECEIPT_ID	NUMBER			Cash receipt identifier, Null
BANK_BRANCH_ID	NUMBER	(15)	Yes	Bank branch identifier
RECEIPT_DATE	DATE		Yes	Receipt date, check date
POSTED_FLAG	VARCHAR2	(0)		GL posting flag, Null
POSTED_DATE	DATE			Posted date, Null
LINE_TYPE_MEANING	VARCHAR2	(80)	Yes	Statement line type meaning
STATEMENT_LINE_NUMBER	NUMBER	(15)	Yes	Statement line number
STATEMENT_LINE_DATE	DATE		Yes	Statement line date
STATEMENT_LINE_AMOUNT	NUMBER		Yes	Statement line amount
STATEMENT_LINE_STATUS_MEANING	VARCHAR2	(30)	Yes	Statement line status
STATEMENT_LINE_TYPE_MEANING	VARCHAR2	(240)		Statement line transaction code type meaning
STATEMENT_HEADER_NUMBER	VARCHAR2	(50)	Yes	Statement number
STATEMENT_HEADER_DATE	DATE		Yes	Statement date
BANK_ACCOUNT_NAME	VARCHAR2	(100)	Yes	Bank account name
BANK_ACCOUNT_NUM	VARCHAR2	(30)		Bank account number
BANK_CURRENCY_CODE	VARCHAR2	(15)		Bank currency code
STATEMENT_DOC_SEQUENCE_VALUE	NUMBER			Document sequence number
LINE_TRX_TYPE	VARCHAR2	(30)	Yes	Line transaction type
REMITTANCE_NUMBER	VARCHAR2	(40)		Remittance number, batch identifier
CONTROL_END_BALANCE	NUMBER			Statement control ending balance
APPLICATION_ID	NUMBER			Application identifier, 200
COUNT_CLEARED	NUMBER			Internal use
ACTUAL_AMOUNT_CLEARED	NUMBER			Not used
CLEARING_TRX_TYPE	CHAR	(7)		Transaction type for clearing, PAYMENT
REQUEST_ID	NUMBER	(15)		Reconciliation request identifier
INVOICE_TEXT	VARCHAR2	(30)		Invoice number
BANK_ACCOUNT_TEXT	VARCHAR2	(30)		Vendor bank account number
CUSTOMER_TEXT	VARCHAR2	(80)		Vendor name
VALUE_DATE	DATE			Value date
CE_BANK_ACCT_USE_ID	NUMBER	(15)	Yes
ORG_ID	NUMBER	(15)
LEGAL_ENTITY_ID	NUMBER

Query Text

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


SELECT ROW_ID
,      MULTI_SELECT
,      STATEMENT_LINE_ID
,      BANK_ACCOUNT_ID
,      TRX_ID
,      TRX_TYPE
,      TYPE_MEANING
,      TRX_NUMBER
,      CURRENCY_CODE
,      TRX_CURRENCY_TYPE
,      AMOUNT
,      BANK_ACCOUNT_AMOUNT
,      AMOUNT_CLEARED
,      GL_DATE
,      STATUS_DSP
,      STATUS
,      TRX_DATE
,      CLEARED_DATE
,      MATURITY_DATE
,      EXCHANGE_RATE_DATE
,      EXCHANGE_RATE_TYPE
,      EXCHANGE_RATE
,      BANK_CHARGES
,      BANK_ERRORS
,      BATCH_NAME
,      BATCH_ID
,      AGENT_NAME
,      CUSTOMER_NAME
,      VENDOR_NAME
,      CUSTOMER_ID
,      SUPPLIER_ID
,      REFERENCE_TYPE_DSP
,      REFERENCE_TYPE
,      REFERENCE_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      STATEMENT_HEADER_ID
,      CASH_RECEIPT_ID
,      BANK_BRANCH_ID
,      RECEIPT_DATE
,      POSTED_FLAG
,      POSTED_DATE
,      LINE_TYPE_MEANING
,      STATEMENT_LINE_NUMBER
,      STATEMENT_LINE_DATE
,      STATEMENT_LINE_AMOUNT
,      STATEMENT_LINE_STATUS_MEANING
,      STATEMENT_LINE_TYPE_MEANING
,      STATEMENT_HEADER_NUMBER
,      STATEMENT_HEADER_DATE
,      BANK_ACCOUNT_NAME
,      BANK_ACCOUNT_NUM
,      BANK_CURRENCY_CODE
,      STATEMENT_DOC_SEQUENCE_VALUE
,      LINE_TRX_TYPE
,      REMITTANCE_NUMBER
,      CONTROL_END_BALANCE
,      APPLICATION_ID
,      COUNT_CLEARED
,      ACTUAL_AMOUNT_CLEARED
,      CLEARING_TRX_TYPE
,      REQUEST_ID
,      INVOICE_TEXT
,      BANK_ACCOUNT_TEXT
,      CUSTOMER_TEXT
,      VALUE_DATE
,      CE_BANK_ACCT_USE_ID
,      ORG_ID
,      LEGAL_ENTITY_ID
FROM APPS.CE_200_RECONCILED_V;

Dependencies

[top of page]

APPS.CE_200_RECONCILED_V references the following:

APPS: AP_CHECKS_ALL; AP_INVOICE_SELECTION_CRITERIA; AP_LOOKUP_CODES; AP_PAYMENT_HISTORY; AP_PAYMENT_HISTORY_ALL; 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; CE_TRANSACTION_CODES; FND_GLOBAL - show dependent code; GL_DAILY_CONVERSION_TYPES; GL_LEDGERS

APPS.CE_200_RECONCILED_V is referenced by following:

APPS: CE_AUTO_BANK_MATCH - show dependent code; CE_RECONCILED_TRANSACTIONS_V