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_101_RECONCILED_V

Object Details

Object Name:	CE_101_RECONCILED_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	CE.CE_101_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, journal line number
TRX_TYPE	VARCHAR2	(7)		Transaction type, PAYMENT or CASH
TYPE_MEANING	VARCHAR2	(80)	Yes	Meaning of the transaction type, Receipt or Payment
TRX_NUMBER	VARCHAR2	(240)		Transaction number, journal line description
CURRENCY_CODE	VARCHAR2	(15)	Yes	Transaction currency code
TRX_CURRENCY_TYPE	VARCHAR2	(10)		Transaction currency type
AMOUNT	NUMBER			Transaction amount, journal line amount
BANK_ACCOUNT_AMOUNT	NUMBER			Transaction amount in bank currency, journal line amount in bank currency
AMOUNT_CLEARED	NUMBER			Amount cleared in bank currency including bank charges and errors
GL_DATE	DATE		Yes	GL date
STATUS_DSP	VARCHAR2	(80)	Yes	Transaction status description, journal line status description
STATUS	VARCHAR2	(1)	Yes	Transaction status, journal line status
TRX_DATE	DATE		Yes	Transaction date, journal line effective date
CLEARED_DATE	DATE		Yes	Reconciled date for journals
MATURITY_DATE	DATE			Transaction maturity date, Null
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, Null
BANK_ERRORS	NUMBER			Bank error amount, Null
BATCH_NAME	VARCHAR2	(100)	Yes	Batch name, journal batch name
BATCH_ID	NUMBER	(15)	Yes	Batch identifier, journal batch identifier
AGENT_NAME	VARCHAR2	(0)		Agent name, Null
CUSTOMER_NAME	VARCHAR2	(0)		Customer name, Null
VENDOR_NAME	VARCHAR2	(0)		Vendor name, Null
CUSTOMER_ID	NUMBER			Customer identifier, Null
SUPPLIER_ID	NUMBER			Supplier identifier, Null
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	(15)	Yes	Cash receipt identifier, Null
BANK_BRANCH_ID	NUMBER	(15)	Yes	Bank branch identifier
RECEIPT_DATE	DATE			Cash receipt date, Null
POSTED_FLAG	VARCHAR2	(0)		Posted 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 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	Statement line transaction type
REMITTANCE_NUMBER	VARCHAR2	(0)		Remittance number, Null
CONTROL_END_BALANCE	NUMBER			Statement control ending balance
APPLICATION_ID	NUMBER			Application identifier, 101
COUNT_CLEARED	NUMBER			Internal use
ACTUAL_AMOUNT_CLEARED	NUMBER			Not used
CLEARING_TRX_TYPE	CHAR	(7)		Transaction type for clearing, JE_LINE
REQUEST_ID	NUMBER	(15)		Reconciliation request identifier
CE_BANK_ACCT_USE_ID	NUMBER
ORG_ID	NUMBER	(15)
LEGAL_ENTITY_ID	NUMBER	(15)

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
,      CE_BANK_ACCT_USE_ID
,      ORG_ID
,      LEGAL_ENTITY_ID
FROM APPS.CE_101_RECONCILED_V;

Dependencies

[top of page]

APPS.CE_101_RECONCILED_V references the following:

APPS: CE_BANK_ACCTS_GT_V; CE_LOOKUPS; CE_STATEMENT_HEADERS; CE_STATEMENT_LINES; CE_STATEMENT_RECONCILS_ALL; CE_SYSTEM_PARAMETERS; CE_TRANSACTION_CODES; GL_DAILY_CONVERSION_TYPES; GL_JE_BATCHES; GL_JE_HEADERS; GL_JE_LINES; GL_LOOKUPS; GL_SETS_OF_BOOKS

APPS.CE_101_RECONCILED_V is referenced by following:

APPS: CE_RECONCILED_TRANSACTIONS_V