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

VIEW: APPS.XTR_PORTFOLIOS_V

Object Details
Object Name: XTR_PORTFOLIOS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewXTR.XTR_PORTFOLIOS_V
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[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)
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
,      CREATED_BY
,      CREATED_ON
FROM APPS.XTR_PORTFOLIOS_V;

Dependencies

[top of page]

APPS.XTR_PORTFOLIOS_V references the following:

SchemaAPPS
SynonymXTR_PORTFOLIOS
APPS.XTR_PORTFOLIOS_V is referenced by following:

SchemaAPPS
Package BodyXTR_EXP_TRANSFERS_PKG - show dependent code
Package BodyXTR_FX_TRANSFERS_PKG - show dependent code
Package BodyXTR_IAC_TRANSFERS_PKG - show dependent code
Package BodyXTR_IG_TRANSFERS_PKG - show dependent code
Package BodyXTR_NI_TRANSFERS_PKG - show dependent code