DBA Data[Home] [Help] [Dependency Information]

VIEW: XTR.XTR_ACCRLS_AMORT#

Object Details
Object Name: XTR_ACCRLS_AMORT#
Object Type: VIEW
Owner: XTR
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
DEAL_NO NUMBER
Yes
TRANS_NO NUMBER
Yes
PERIOD_FROM DATE
Yes
PERIOD_TO DATE
Yes
COMPANY_CODE VARCHAR2 (7) Yes
DEAL_TYPE VARCHAR2 (7) Yes
DEAL_SUBTYPE VARCHAR2 (7)
CPARTY_CODE VARCHAR2 (7)
CURRENCY VARCHAR2 (15)
PRODUCT_TYPE VARCHAR2 (10)
PORTFOLIO_CODE VARCHAR2 (7)
AMOUNT_TYPE VARCHAR2 (7) Yes
ACTION_CODE VARCHAR2 (7) Yes
TRANSACTION_AMOUNT NUMBER

ACTUAL_START_DATE DATE

ACTUAL_MATURITY_DATE DATE

INTEREST_RATE NUMBER

NO_OF_DAYS NUMBER

YEAR_BASIS NUMBER

ACCRLS_AMOUNT NUMBER

FIRST_ACCRUAL_INDIC VARCHAR2 (1)
TRANSFERED_ON DATE

REVERSAL_DATE DATE

CREATED_ON DATE

CREATED_BY VARCHAR2 (20)
ACCRLS_AMOUNT_BAL NUMBER

EFFECTIVE_CALCULATED_VALUE NUMBER

AUTHORIZE_JOURNAL_CREATION VARCHAR2 (1)
JOURNAL_CREATED DATE

BATCH_ID NUMBER (15) Yes
CALC_FACE_VALUE NUMBER

EFFINT_ACCRLS_AMOUNT_BAL NUMBER

Query Text

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


SELECT DEAL_NO
,      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
,      AUTHORIZE_JOURNAL_CREATION
,      JOURNAL_CREATED
,      BATCH_ID
,      CALC_FACE_VALUE
,      EFFINT_ACCRLS_AMOUNT_BAL
FROM XTR.XTR_ACCRLS_AMORT#;

Dependencies

[top of page]

XTR.XTR_ACCRLS_AMORT# references the following:

SchemaXTR
TableXTR_ACCRLS_AMORT
XTR.XTR_ACCRLS_AMORT# is referenced by following:

SchemaAPPS
SynonymXTR_ACCRLS_AMORT