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

VIEW: APPS.PA_SPREAD_CURVES_VL

Object Details
Object Name: PA_SPREAD_CURVES_VL
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPA.PA_SPREAD_CURVES_VL
Subobject Name:
Status: VALID

View Type

MultiLingual view (a language resolved view of the data.)

[View Source]

Columns
Name Datatype Length Mandatory Comments
SPREAD_CURVE_ID NUMBER (15) Yes
SPREAD_CURVE_CODE VARCHAR2 (30)
RECORD_VERSION_NUMBER NUMBER (15) Yes
EFFECTIVE_START_DATE DATE
Yes
EFFECTIVE_END_DATE DATE

ROUNDING_FACTOR_CODE VARCHAR2 (30) Yes
POINT1 NUMBER

POINT2 NUMBER

POINT3 NUMBER

POINT4 NUMBER

POINT5 NUMBER

POINT6 NUMBER

POINT7 NUMBER

POINT8 NUMBER

POINT9 NUMBER

POINT10 NUMBER

LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER (15) Yes
NAME VARCHAR2 (240) Yes
DESCRIPTION VARCHAR2 (2000)
LANGUAGE VARCHAR2 (4) Yes
SOURCE_LANG VARCHAR2 (4) Yes
Query Text

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


SELECT SPREAD_CURVE_ID
,      SPREAD_CURVE_CODE
,      RECORD_VERSION_NUMBER
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      ROUNDING_FACTOR_CODE
,      POINT1
,      POINT2
,      POINT3
,      POINT4
,      POINT5
,      POINT6
,      POINT7
,      POINT8
,      POINT9
,      POINT10
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      NAME
,      DESCRIPTION
,      LANGUAGE
,      SOURCE_LANG
FROM APPS.PA_SPREAD_CURVES_VL;

Dependencies

[top of page]

APPS.PA_SPREAD_CURVES_VL references the following:

SchemaAPPS
SynonymPA_SPREAD_CURVES_B
SynonymPA_SPREAD_CURVES_TL
APPS.PA_SPREAD_CURVES_VL is referenced by following:

SchemaAPPS
Package BodyPA_BUDGET_PVT - show dependent code
Package BodyPA_FP_SPREAD_CURVES_UTILS - show dependent code