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_CINT_RATE_INFO

Product:	PA - Projects
Description:	This is a single org view created for Form
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT RATE.ROWID
, RATE.IND_COST_CODE
, RATE.EXP_ORG_SOURCE
, RATE.PROJ_AMT_THRESHOLD
, RATE.TASK_AMT_THRESHOLD
, RATE.PROJ_DURATION_THRESHOLD
, RATE.TASK_DURATION_THRESHOLD
, RATE.CURR_PERIOD_CONVENTION
, RATE.INTEREST_CALCULATION_METHOD
, RATE.PERIOD_RATE_CODE
, RATE.THRESHOLD_AMT_TYPE
, RATE.BUDGET_TYPE_CODE
, RATE.FIN_PLAN_TYPE_ID
, RATE.CREATION_DATE
, RATE.CREATED_BY
, RATE.LAST_UPDATE_DATE
, RATE.LAST_UPDATED_BY
, RATE.LAST_UPDATE_LOGIN
, RATE.ORG_ID
FROM PA_CINT_RATE_INFO_ALL RATE
WHERE NVL(RATE.ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTR(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTR(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTR(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTR(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)

Columns

Name
ROW_ID
IND_COST_CODE
EXP_ORG_SOURCE
PROJ_AMT_THRESHOLD
TASK_AMT_THRESHOLD
PROJ_DURATION_THRESHOLD
TASK_DURATION_THRESHOLD
CURR_PERIOD_CONVENTION
INTEREST_CALCULATION_METHOD
PERIOD_RATE_CODE
THRESHOLD_AMT_TYPE
BUDGET_TYPE_CODE
FIN_PLAN_TYPE_ID
CREATION_DATE
CREATED_BY
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
ORG_ID