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

VIEW: APPS.XTR_IRE_MATURITY_BY_POLICY_V

Object Details
Object Name: XTR_IRE_MATURITY_BY_POLICY_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewXTR.XTR_IRE_MATURITY_BY_POLICY_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
UNIQUE_REF_NUMBER NUMBER

COMPANY_CODE VARCHAR2 (7)
CURRENCY VARCHAR2 (15)
PORTFOLIO_CODE VARCHAR2 (7)
INC_IG VARCHAR2 (1)
AMOUNT_UNIT NUMBER

FUND_INVEST VARCHAR2 (6)
FROM_DATE DATE

TO_DATE DATE

COMPANY_NAME VARCHAR2 (30)
PORT_NAME VARCHAR2 (30)
FLOATING_LESS VARCHAR2 (10)
P_FROM DATE

P_TO DATE

PERIOD_DESC VARCHAR2 (20)
PERCENT_MAX_MATURING NUMBER

TT_AMT NUMBER

PACT_AMT NUMBER

SACT_AMT NUMBER

ACT_P NUMBER

VAR_P NUMBER

VAR_AMT NUMBER

CREATED_ON DATE

CREATED_BY VARCHAR2 (30)
Query Text

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


SELECT UNIQUE_REF_NUMBER
,      COMPANY_CODE
,      CURRENCY
,      PORTFOLIO_CODE
,      INC_IG
,      AMOUNT_UNIT
,      FUND_INVEST
,      FROM_DATE
,      TO_DATE
,      COMPANY_NAME
,      PORT_NAME
,      FLOATING_LESS
,      P_FROM
,      P_TO
,      PERIOD_DESC
,      PERCENT_MAX_MATURING
,      TT_AMT
,      PACT_AMT
,      SACT_AMT
,      ACT_P
,      VAR_P
,      VAR_AMT
,      CREATED_ON
,      CREATED_BY
FROM APPS.XTR_IRE_MATURITY_BY_POLICY_V;

Dependencies

[top of page]

APPS.XTR_IRE_MATURITY_BY_POLICY_V references the following:

SchemaAPPS
SynonymXTR_IRE_MATURITY_BY_POLICY

APPS.XTR_IRE_MATURITY_BY_POLICY_V is not referenced by any database object