[Home] [Help] [Dependency Information]
Object Name: | XTR_RECONCILIATION_MATRIX_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | XTR.XTR_RECONCILIATION_MATRIX_V |
Subobject Name: | |
Status: | VALID |
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.
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 |
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;
APPS.XTR_RECONCILIATION_MATRIX_V is not referenced by any database object
|
|
|