eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: PA_SPREAD_CURVES_VL

Product:	PA - Projects
Description:
Implementation/DBA Data:	APPS.PA_SPREAD_CURVES_VL

View Text

SELECT PSC.SPREAD_CURVE_ID
, PSC.SPREAD_CURVE_CODE
, PSC.RECORD_VERSION_NUMBER
, PSC.EFFECTIVE_START_DATE
, PSC.EFFECTIVE_END_DATE
, PSC.ROUNDING_FACTOR_CODE
, PSC.POINT1
, PSC.POINT2
, PSC.POINT3
, PSC.POINT4
, PSC.POINT5
, PSC.POINT6
, PSC.POINT7
, PSC.POINT8
, PSC.POINT9
, PSC.POINT10
, PSC.LAST_UPDATE_DATE
, PSC.LAST_UPDATED_BY
, PSC.CREATION_DATE
, PSC.CREATED_BY
, PSC.LAST_UPDATE_LOGIN
, PSCT.NAME
, PSCT.DESCRIPTION
, PSCT.LANGUAGE
, PSCT.SOURCE_LANG
FROM PA_SPREAD_CURVES_B PSC
, PA_SPREAD_CURVES_TL PSCT
WHERE PSC.SPREAD_CURVE_ID = PSCT.SPREAD_CURVE_ID
AND PSCT.LANGUAGE = USERENV('LANG')

Columns

Name
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