PJO_SPREAD_CURVES

Details

Schema: FUSION
Object owner: PJO
Object type: VIEW

Columns

Name
SPREAD_CURVE_ID LAST_UPDATE_DATE LAST_UPDATED_BY CREATED_BY CREATION_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER SPREAD_CURVE_CODE START_DATE END_DATE ROUNDING_FACTOR_CODE POINT1 POINT2 POINT3 POINT4 POINT5 POINT6 POINT7 POINT8 POINT9 POINT10 NAME DESCRIPTION

Name

SPREAD_CURVE_ID

LAST_UPDATE_DATE

LAST_UPDATED_BY

CREATED_BY

CREATION_DATE

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

SPREAD_CURVE_CODE

START_DATE

END_DATE

ROUNDING_FACTOR_CODE

POINT1

POINT2

POINT3

POINT4

POINT5

POINT6

POINT7

POINT8

POINT9

POINT10

NAME

DESCRIPTION

Query

SQL_Statement
SELECT B.SPREAD_CURVE_ID, B.LAST_UPDATE_DATE, B.LAST_UPDATED_BY, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATE_LOGIN, B.OBJECT_VERSION_NUMBER, B.SPREAD_CURVE_CODE, B.START_DATE, B.END_DATE, B.ROUNDING_FACTOR_CODE, B.POINT1, B.POINT2, B.POINT3, B.POINT4, B.POINT5, B.POINT6, B.POINT7, B.POINT8, B.POINT9, B.POINT10, T.NAME, T.DESCRIPTION FROM PJO_SPREAD_CURVES_B B, PJO_SPREAD_CURVES_TL T WHERE B.SPREAD_CURVE_ID = T.SPREAD_CURVE_ID AND T.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

B.SPREAD_CURVE_ID,

B.LAST_UPDATE_DATE,

B.LAST_UPDATED_BY,

B.CREATED_BY,

B.CREATION_DATE,

B.LAST_UPDATE_LOGIN,

B.OBJECT_VERSION_NUMBER,

B.SPREAD_CURVE_CODE,

B.START_DATE,

B.END_DATE,

B.ROUNDING_FACTOR_CODE,

B.POINT1,

B.POINT2,

B.POINT3,

B.POINT4,

B.POINT5,

B.POINT6,

B.POINT7,

B.POINT8,

B.POINT9,

B.POINT10,

T.NAME,

T.DESCRIPTION

FROM

PJO_SPREAD_CURVES_B B,

PJO_SPREAD_CURVES_TL T

WHERE

B.SPREAD_CURVE_ID = T.SPREAD_CURVE_ID AND T.LANGUAGE = USERENV('LANG')