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

VIEW: APPS.XTR_A_PORTFOLIOS_V

Object Details
Object Name: XTR_A_PORTFOLIOS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewXTR.XTR_A_PORTFOLIOS_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
COMPANY_CODE VARCHAR2 (7) Yes
PORTFOLIO VARCHAR2 (7) Yes
NAME VARCHAR2 (20) Yes
DEFAULT_PORTFOLIO VARCHAR2 (1) Yes
AS_PRINCIPAL VARCHAR2 (1)
EXTERNAL_PORTFOLIO VARCHAR2 (1)
EXTERNAL_PARTY VARCHAR2 (7)
INTEREST_FREQ VARCHAR2 (1)
BROKERAGE_FREQ VARCHAR2 (1)
LAST_INTEREST_SETTLEMENT DATE

LAST_BROKERAGE_SETTLEMENT DATE

PHYSICAL_PORTFOLIO_ACCT VARCHAR2 (20)
CMF_YN VARCHAR2 (1)
EXTERNAL_DEFAULT_PORTFOLIO VARCHAR2 (1)
UPDATED_BY VARCHAR2 (30)
UPDATED_ON DATE

AUDIT_INDICATOR VARCHAR2 (1)
AUDIT_DATE_STORED DATE

CREATED_BY VARCHAR2 (30) Yes
CREATED_ON DATE
Yes
Query Text

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


SELECT COMPANY_CODE
,      PORTFOLIO
,      NAME
,      DEFAULT_PORTFOLIO
,      AS_PRINCIPAL
,      EXTERNAL_PORTFOLIO
,      EXTERNAL_PARTY
,      INTEREST_FREQ
,      BROKERAGE_FREQ
,      LAST_INTEREST_SETTLEMENT
,      LAST_BROKERAGE_SETTLEMENT
,      PHYSICAL_PORTFOLIO_ACCT
,      CMF_YN
,      EXTERNAL_DEFAULT_PORTFOLIO
,      UPDATED_BY
,      UPDATED_ON
,      AUDIT_INDICATOR
,      AUDIT_DATE_STORED
,      CREATED_BY
,      CREATED_ON
FROM APPS.XTR_A_PORTFOLIOS_V;

Dependencies

[top of page]

APPS.XTR_A_PORTFOLIOS_V references the following:

SchemaAPPS
SynonymXTR_A_PORTFOLIOS

APPS.XTR_A_PORTFOLIOS_V is not referenced by any database object