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

VIEW: APPS.XTR_PARTY_DEFAULTS_V

Object Details
Object Name: XTR_PARTY_DEFAULTS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewXTR.XTR_PARTY_DEFAULTS_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
TRANSACTION_NUMBER NUMBER
Yes
PARTY_CODE VARCHAR2 (7)
DEAL_TYPE VARCHAR2 (7)
DEAL_SUBTYPE VARCHAR2 (7)
PRODUCT_TYPE VARCHAR2 (10)
DFLT_PRINCIPAL_ACTION VARCHAR2 (1)
DFLT_INTEREST_ACTION VARCHAR2 (1)
FREQ_INTEREST_SETTLED VARCHAR2 (1)
INTEREST_SETTLED_BY VARCHAR2 (1)
PRINCIPAL_SETTLED_BY VARCHAR2 (1)
TAX_REFERENCE VARCHAR2 (7)
BROKERAGE_REFERENCE VARCHAR2 (7)
DEFAULT_TYPE VARCHAR2 (1)
SETTLEMENT_DEFAULT_CATEGORY VARCHAR2 (7)
TAX_CATEGORY VARCHAR2 (7)
BROKERAGE_CATEGORY VARCHAR2 (7)
UPDATED_BY VARCHAR2 (30)
UPDATED_ON DATE

AUDIT_INDICATOR VARCHAR2 (1)
CREATED_BY VARCHAR2 (30) Yes
CREATED_ON DATE
Yes
INCOME_TAX_REFERENCE VARCHAR2 (7)
Query Text

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


SELECT TRANSACTION_NUMBER
,      PARTY_CODE
,      DEAL_TYPE
,      DEAL_SUBTYPE
,      PRODUCT_TYPE
,      DFLT_PRINCIPAL_ACTION
,      DFLT_INTEREST_ACTION
,      FREQ_INTEREST_SETTLED
,      INTEREST_SETTLED_BY
,      PRINCIPAL_SETTLED_BY
,      TAX_REFERENCE
,      BROKERAGE_REFERENCE
,      DEFAULT_TYPE
,      SETTLEMENT_DEFAULT_CATEGORY
,      TAX_CATEGORY
,      BROKERAGE_CATEGORY
,      UPDATED_BY
,      UPDATED_ON
,      AUDIT_INDICATOR
,      CREATED_BY
,      CREATED_ON
,      INCOME_TAX_REFERENCE
FROM APPS.XTR_PARTY_DEFAULTS_V;

Dependencies

[top of page]

APPS.XTR_PARTY_DEFAULTS_V references the following:

SchemaAPPS
SynonymXTR_PARTY_DEFAULTS

APPS.XTR_PARTY_DEFAULTS_V is not referenced by any database object