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

VIEW: APPS.XTR_RATE_SETS_V

Object Details
Object Name: XTR_RATE_SETS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewXTR.XTR_RATE_SETS_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
UNIQUE_REF_NUM NUMBER
Yes
DEAL_TYPE VARCHAR2 (7) Yes
DEAL_SUBTYPE VARCHAR2 (7) Yes
PRODUCT_TYPE VARCHAR2 (10) Yes
EFFECTIVE_FROM DATE
Yes
RATE_EFFECTIVE_CREATED DATE
Yes
CURRENCY VARCHAR2 (15) Yes
LOW_RANGE NUMBER
Yes
HIGH_RANGE NUMBER
Yes
RATE NUMBER

MARGIN NUMBER

INTEREST_PERIOD VARCHAR2 (7)
FIXED_FLOATING VARCHAR2 (5)
CLIENT_GROUPING VARCHAR2 (7)
UPDATED_BY VARCHAR2 (30)
UPDATED_ON DATE

AUDIT_INDICATOR VARCHAR2 (1)
TERM VARCHAR2 (3)
UPDATE_EXISTING_DEALS VARCHAR2 (1)
PI_CONSTANT VARCHAR2 (1)
POSTED DATE

RESET_BASIS VARCHAR2 (15)
NO_OF_DAYS NUMBER

CREATED_BY VARCHAR2 (30) Yes
CREATED_ON DATE
Yes
CONCURRENT_REQUEST VARCHAR2 (1)
Query Text

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


SELECT UNIQUE_REF_NUM
,      DEAL_TYPE
,      DEAL_SUBTYPE
,      PRODUCT_TYPE
,      EFFECTIVE_FROM
,      RATE_EFFECTIVE_CREATED
,      CURRENCY
,      LOW_RANGE
,      HIGH_RANGE
,      RATE
,      MARGIN
,      INTEREST_PERIOD
,      FIXED_FLOATING
,      CLIENT_GROUPING
,      UPDATED_BY
,      UPDATED_ON
,      AUDIT_INDICATOR
,      TERM
,      UPDATE_EXISTING_DEALS
,      PI_CONSTANT
,      POSTED
,      RESET_BASIS
,      NO_OF_DAYS
,      CREATED_BY
,      CREATED_ON
,      CONCURRENT_REQUEST
FROM APPS.XTR_RATE_SETS_V;

Dependencies

[top of page]

APPS.XTR_RATE_SETS_V references the following:

SchemaAPPS
SynonymXTR_RATE_SETS

APPS.XTR_RATE_SETS_V is not referenced by any database object