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.XTR_RECONCILIATION_MATRIX_V

Object Details

Object Name:	XTR_RECONCILIATION_MATRIX_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	XTR.XTR_RECONCILIATION_MATRIX_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
VERIFICATION_METHOD	VARCHAR2	(30)	Yes	Verification Method Code
RECONCILIATION_PASS_CODE	VARCHAR2	(2)	Yes	Reconciliation Pass Code
SEQUENCE_ORDER	NUMBER		Yes	Sequence Order
AMOUNT_RECON_DETAIL	VARCHAR2	(80)		Amount Verification Criteria
BANK_ACCT_RECON_DETAIL	VARCHAR2	(80)		Bank Account Number Verification Criteria
DATE_RECON_DETAIL	VARCHAR2	(80)		Date Verification Criteria
DEAL_NUM_RECON_DETAIL	VARCHAR2	(80)		Deal Number Verification Criteria
DEAL_TYPE_RECON_DETAIL	VARCHAR2	(80)		Deal Type Verification Criteria
PARTY_RECON_DETAIL	VARCHAR2	(80)		Party Code Verification Criteria
PORTFOLIO_RECON_DETAIL	VARCHAR2	(80)		Portfolio Code Verification Criteria
PRODUCT_RECON_DETAIL	VARCHAR2	(80)		Product Code Verification Criteria
SERIAL_NUM_RECON_DETAIL	VARCHAR2	(80)		Serial Number Verification Criteria
SUBTYPE_RECON_DETAIL	VARCHAR2	(80)		Deal Subtype Verification Criteria

Query Text

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


SELECT VERIFICATION_METHOD
,      RECONCILIATION_PASS_CODE
,      SEQUENCE_ORDER
,      AMOUNT_RECON_DETAIL
,      BANK_ACCT_RECON_DETAIL
,      DATE_RECON_DETAIL
,      DEAL_NUM_RECON_DETAIL
,      DEAL_TYPE_RECON_DETAIL
,      PARTY_RECON_DETAIL
,      PORTFOLIO_RECON_DETAIL
,      PRODUCT_RECON_DETAIL
,      SERIAL_NUM_RECON_DETAIL
,      SUBTYPE_RECON_DETAIL
FROM APPS.XTR_RECONCILIATION_MATRIX_V;

Dependencies

[top of page]

APPS.XTR_RECONCILIATION_MATRIX_V references the following:

APPS: FND_GLOBAL - show dependent code; FND_LOOKUPS; XTR_RECONCILIATION_PASSES_V; XTR_RECONCILIATION_PROCESS_V

APPS.XTR_RECONCILIATION_MATRIX_V is not referenced by any database object