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_185_RECONCILED_V

Object Details

Object Name:	CE_185_RECONCILED_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	CE.CE_185_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		Yes	Transaction identifier
TRX_TYPE	VARCHAR2	(7)		Transaction type
TYPE_MEANING	VARCHAR2	(7)		Transaction type meaning
TRX_NUMBER	VARCHAR2	(40)		Transaction number
CURRENCY_CODE	VARCHAR2	(15)	Yes	Transaction currency
TRX_CURRENCY_TYPE	VARCHAR2	(10)		Transaction currency type
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	(30)		Transaction status description
STATUS	VARCHAR2	(30)		Transaction status
TRX_DATE	DATE		Yes	Transaction date
CLEARED_DATE	DATE		Yes	Cleared date
MATURITY_DATE	DATE			Transaction maturity date
EXCHANGE_RATE_DATE	DATE			Date used in determining currency exchange rate
EXCHANGE_RATE_TYPE	VARCHAR2	(0)		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	(81)		Batch name
BATCH_ID	NUMBER			Batch identifier
AGENT_NAME	VARCHAR2	(0)		Agent name
CUSTOMER_NAME	VARCHAR2	(0)		Customer name
VENDOR_NAME	VARCHAR2	(0)		Vendor name
CUSTOMER_ID	NUMBER			Customer identifier
SUPPLIER_ID	NUMBER			Supplier identifier
REFERENCE_TYPE_DSP	VARCHAR2	(0)		Reference type description
REFERENCE_TYPE	VARCHAR2	(0)		Reference type
REFERENCE_ID	NUMBER			Reference identifier
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
BANK_BRANCH_ID	NUMBER	(15)	Yes	Bank branch identifier
RECEIPT_DATE	DATE			Receipt date
POSTED_FLAG	VARCHAR2	(0)		GL posting flag
POSTED_DATE	DATE			GL posting date
LINE_TYPE_MEANING	VARCHAR2	(80)	Yes	Statement line transaction type
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 meaning
STATEMENT_LINE_TYPE_MEANING	VARCHAR2	(240)		statement line transaction 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	Statement line transaction type
REMITTANCE_NUMBER	VARCHAR2	(0)		Remittance number
CONTROL_END_BALANCE	NUMBER			Statement control ending balance
APPLICATION_ID	NUMBER			Application identifier
COUNT_CLEARED	NUMBER			Internal use
ACTUAL_AMOUNT_CLEARED	NUMBER			Not used
CLEARING_TRX_TYPE	CHAR	(8)		Transaction type for clearing
CE_BANK_ACCT_USE_ID	NUMBER	(15)
ORG_ID	NUMBER
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
,      CE_BANK_ACCT_USE_ID
,      ORG_ID
,      LEGAL_ENTITY_ID
FROM APPS.CE_185_RECONCILED_V;

Dependencies

[top of page]

APPS.CE_185_RECONCILED_V references the following:

APPS: 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; GL_LEDGERS; XTR_DEAL_DATE_AMOUNTS; XTR_SETTLEMENT_SUMMARY

APPS.CE_185_RECONCILED_V is referenced by following:

APPS: CE_999_RECONCILED_V