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

TABLE: PA.PA_SPREAD_CURVES_B

Object Details
Object Name: PA_SPREAD_CURVES_B
Object Type: TABLE
Owner: PA
FND Design Data: TablePA.PA_SPREAD_CURVES_B
Subobject Name:
Status: VALID


This table stores the spread curve information.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PA_SPREAD_CURVES_B_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSPREAD_CURVE_ID
ColumnZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
SPREAD_CURVE_ID NUMBER (15) Yes Indicates the spread curve.
SPREAD_CURVE_CODE VARCHAR2 (30)
To be used internally for Oracle Projects
RECORD_VERSION_NUMBER NUMBER (15) Yes Record version number.
EFFECTIVE_START_DATE DATE
Yes Indicates effective start date.
EFFECTIVE_END_DATE DATE

Indicates effective end date.
ROUNDING_FACTOR_CODE VARCHAR2 (30) Yes Indicates the rounding factor to be used
POINT1 NUMBER

Indicates point1 weighting.
POINT2 NUMBER

Indicates point2 weighting.
POINT3 NUMBER

Indicates point3 weighting.
POINT4 NUMBER

Indicates point4 weighting.
POINT5 NUMBER

Indicates point5 weighting.
POINT6 NUMBER

Indicates point6 weighting.
POINT7 NUMBER

Indicates point7 weighting.
POINT8 NUMBER

Indicates point8 weighting.
POINT9 NUMBER

Indicates point9 weighting.
POINT10 NUMBER

Indicates point10 weighting.
LAST_UPDATE_DATE DATE
Yes Standard Who Column.
LAST_UPDATED_BY NUMBER (15) Yes Standard Who Column.
CREATION_DATE DATE
Yes Standard Who Column.
CREATED_BY NUMBER
Yes Standard Who Column.
LAST_UPDATE_LOGIN NUMBER (15) Yes Standard Who Column.
ZD_EDITION_NAME VARCHAR2 (30) 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
,      ZD_EDITION_NAME
FROM PA.PA_SPREAD_CURVES_B;

Dependencies

[top of page]

PA.PA_SPREAD_CURVES_B does not reference any database object

PA.PA_SPREAD_CURVES_B is referenced by following:

SchemaPA
ViewPA_SPREAD_CURVES_B#