[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | XTR_ACCRLS_AMORT_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  XTR.XTR_ACCRLS_AMORT_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 |
|---|---|---|---|---|
| DEAL_NO | NUMBER | Yes | Unique number assigned to each deal | |
| BATCH_ID | NUMBER | (15) | Yes | Identifier that groups events into one process flow. |
| TRANS_NO | NUMBER | Yes | Unique reference number assigned to a transaction | |
| PERIOD_FROM | DATE | Yes | Start date of accrual period | |
| PERIOD_TO | DATE | Yes | End date of accrual period | |
| COMPANY_CODE | VARCHAR2 | (7) | Yes | Company code |
| DEAL_TYPE | VARCHAR2 | (7) | Yes | Code for high level deals |
| DEAL_SUBTYPE | VARCHAR2 | (7) | Code for deal executions permissible within a deal type | |
| CPARTY_CODE | VARCHAR2 | (7) | Counterparty code | |
| CURRENCY | VARCHAR2 | (15) | Currency code | |
| PRODUCT_TYPE | VARCHAR2 | (10) | Code for products used in a deal type | |
| PORTFOLIO_CODE | VARCHAR2 | (7) | Code for grouping deals under a single portfolio | |
| AMOUNT_TYPE | VARCHAR2 | (7) | Yes | Amount type used in accruals |
| ACTION_CODE | VARCHAR2 | (7) | Yes | Code for actions involved in executing deals |
| TRANSACTION_AMOUNT | NUMBER | Transaction amount used to calculate the accrual amount | ||
| ACTUAL_START_DATE | DATE | Start date used in accrual calculations | ||
| ACTUAL_MATURITY_DATE | DATE | Maturity date used in accrual calculations | ||
| INTEREST_RATE | NUMBER | Interest rate at which a deal or transaction is executed | ||
| NO_OF_DAYS | NUMBER | Number of days used to calculate interest | ||
| YEAR_BASIS | NUMBER | Number of days in a year used in calculations | ||
| ACCRLS_AMOUNT | NUMBER | Accrual amount | ||
| FIRST_ACCRUAL_INDIC | VARCHAR2 | (1) | Flag to indicate if this is the first accrual or amortization for this deal (Y), or not (N) | |
| TRANSFERED_ON | DATE | Not currently used | ||
| REVERSAL_DATE | DATE | Date accrual is reversed | ||
| CREATED_ON | DATE | Date this record was created | ||
| CREATED_BY | VARCHAR2 | (20) | User who created this record | |
| ACCRLS_AMOUNT_BAL | NUMBER | Running balance of the accrual amount for the deal and transaction | ||
| EFFECTIVE_CALCULATED_VALUE | NUMBER | Running balance of the discounted amount for the accrual period for the deal and transaction | ||
| CALC_FACE_VALUE | NUMBER | |||
| EFFINT_ACCRLS_AMOUNT_BAL | NUMBER | Effint accruals amount balance. |
Cut, paste (and edit) the following text to query this object:
SELECT DEAL_NO
, BATCH_ID
, TRANS_NO
, PERIOD_FROM
, PERIOD_TO
, COMPANY_CODE
, DEAL_TYPE
, DEAL_SUBTYPE
, CPARTY_CODE
, CURRENCY
, PRODUCT_TYPE
, PORTFOLIO_CODE
, AMOUNT_TYPE
, ACTION_CODE
, TRANSACTION_AMOUNT
, ACTUAL_START_DATE
, ACTUAL_MATURITY_DATE
, INTEREST_RATE
, NO_OF_DAYS
, YEAR_BASIS
, ACCRLS_AMOUNT
, FIRST_ACCRUAL_INDIC
, TRANSFERED_ON
, REVERSAL_DATE
, CREATED_ON
, CREATED_BY
, ACCRLS_AMOUNT_BAL
, EFFECTIVE_CALCULATED_VALUE
, CALC_FACE_VALUE
, EFFINT_ACCRLS_AMOUNT_BAL
FROM APPS.XTR_ACCRLS_AMORT_V;
APPS
XTR_ACCRLS_AMORT
APPS.XTR_ACCRLS_AMORT_V is not referenced by any database object
|
|
|
|