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

TABLE: XTR.XTR_IRE_MATURITY_BY_POLICY

Object Details
Object Name: XTR_IRE_MATURITY_BY_POLICY
Object Type: TABLE
Owner: XTR
FND Design Data: TableXTR.XTR_IRE_MATURITY_BY_POLICY
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.

Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
ACT_P NUMBER

AMOUNT_UNIT NUMBER

COMPANY_CODE VARCHAR2 (7)
Company identifier. Foreign key to XTR_PARTIES_V.
COMPANY_NAME VARCHAR2 (30)
CREATED_BY VARCHAR2 (30)
User who created this record.
CREATED_ON DATE

Date on which this record is created.
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 does not reference any database object

XTR.XTR_IRE_MATURITY_BY_POLICY is referenced by following:

SchemaXTR
ViewXTR_IRE_MATURITY_BY_POLICY#