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: XTR.XTR_IRE_MATURITY_BY_POLICY#

Object Details

Object Name:	XTR_IRE_MATURITY_BY_POLICY#
Object Type:	VIEW
Owner:	XTR
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length
ACT_P	NUMBER
AMOUNT_UNIT	NUMBER
COMPANY_CODE	VARCHAR2	(7)
COMPANY_NAME	VARCHAR2	(30)
CREATED_BY	VARCHAR2	(30)
CREATED_ON	DATE
CURRENCY	VARCHAR2	(15)
FLOATING_LESS	VARCHAR2	(10)
FROM_DATE	DATE
FUND_INVEST	VARCHAR2	(6)
INC_IG	VARCHAR2	(1)
PACT_AMT	NUMBER
PERCENT_MAX_MATURING	NUMBER
PERIOD_DESC	VARCHAR2	(20)
PORTFOLIO_CODE	VARCHAR2	(7)
PORT_NAME	VARCHAR2	(30)
P_FROM	DATE
P_TO	DATE
SACT_AMT	NUMBER
TO_DATE	DATE
TT_AMT	NUMBER
UNIQUE_REF_NUMBER	NUMBER
VAR_AMT	NUMBER
VAR_P	NUMBER

Query Text

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


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

Dependencies

[top of page]

XTR.XTR_IRE_MATURITY_BY_POLICY# references the following:

XTR: XTR_IRE_MATURITY_BY_POLICY

XTR.XTR_IRE_MATURITY_BY_POLICY# is referenced by following:

APPS: XTR_IRE_MATURITY_BY_POLICY