[Home] [Help] [Dependency Information]
Object Name: | XTR_IRE_MATURITY_BY_POLICY# |
---|---|
Object Type: | VIEW |
Owner: | XTR |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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 |
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#;
|
|
|