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

VIEW: XTR.XTR_CASHPOOL_ATTRIBUTES#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
CASHPOOL_ATTRIBUTE_ID NUMBER (15) Yes
CASHPOOL_ID NUMBER (15) Yes
IAC_PORTFOLIO VARCHAR2 (7)
IAC_PRODUCT_TYPE VARCHAR2 (10)
PORTFOLIO VARCHAR2 (7)
PRODUCT_TYPE VARCHAR2 (10)
ROUNDING_TYPE VARCHAR2 (1)
DAY_COUNT_TYPE VARCHAR2 (1)
PRICING_MODEL VARCHAR2 (30)
FUND_LIMIT_CODE VARCHAR2 (7)
INVEST_LIMIT_CODE VARCHAR2 (7)
PARTY_CODE VARCHAR2 (7)
PARTY_PORTFOLIO VARCHAR2 (7)
PARTY_PRODUCT_TYPE VARCHAR2 (10)
PARTY_PRICING_MODEL VARCHAR2 (30)
PARTY_FUND_LIMIT_CODE VARCHAR2 (7)
PARTY_INVEST_LIMIT_CODE VARCHAR2 (7)
CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER (15)
Query Text

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


SELECT CASHPOOL_ATTRIBUTE_ID
,      CASHPOOL_ID
,      IAC_PORTFOLIO
,      IAC_PRODUCT_TYPE
,      PORTFOLIO
,      PRODUCT_TYPE
,      ROUNDING_TYPE
,      DAY_COUNT_TYPE
,      PRICING_MODEL
,      FUND_LIMIT_CODE
,      INVEST_LIMIT_CODE
,      PARTY_CODE
,      PARTY_PORTFOLIO
,      PARTY_PRODUCT_TYPE
,      PARTY_PRICING_MODEL
,      PARTY_FUND_LIMIT_CODE
,      PARTY_INVEST_LIMIT_CODE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM XTR.XTR_CASHPOOL_ATTRIBUTES#;

Dependencies

[top of page]

XTR.XTR_CASHPOOL_ATTRIBUTES# references the following:

SchemaXTR
TableXTR_CASHPOOL_ATTRIBUTES
XTR.XTR_CASHPOOL_ATTRIBUTES# is referenced by following:

SchemaAPPS
SynonymXTR_CASHPOOL_ATTRIBUTES