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.PA_FORECASTING_OPTIONS_ALL#

Source

View Text - Preformatted


select ORG_ID ORG_ID, INCLUDE_ADMIN_PROJ_FLAG INCLUDE_ADMIN_PROJ_FLAG, GL_PERIOD_FLAG GL_PERIOD_FLAG, PA_PERIOD_FLAG PA_PERIOD_FLAG, MAX_HISTORICAL_VERSIONS MAX_HISTORICAL_VERSIONS, FORECAST_THRU_DATE FORECAST_THRU_DATE, ACTUALS_THRU_DATE ACTUALS_THRU_DATE, UTIL_CALC_METHOD UTIL_CALC_METHOD, DEFAULT_ASSIGN_EXP_TYPE_CLASS DEFAULT_ASSIGN_EXP_TYPE_CLASS, DEFAULT_ASSIGN_EXP_TYPE DEFAULT_ASSIGN_EXP_TYPE, DEFAULT_TP_AMOUNT_TYPE DEFAULT_TP_AMOUNT_TYPE, BILL_UNASSIGN_TIME_FLAG BILL_UNASSIGN_TIME_FLAG, NONBILL_UNASSIGN_TIME_FLAG NONBILL_UNASSIGN_TIME_FLAG, BILL_UNASSIGN_PROJ_ID BILL_UNASSIGN_PROJ_ID, BILL_UNASSIGN_EXP_TYPE_CLASS BILL_UNASSIGN_EXP_TYPE_CLASS, BILL_UNASSIGN_EXP_TYPE BILL_UNASSIGN_EXP_TYPE, NONBILL_UNASSIGN_PROJ_ID NONBILL_UNASSIGN_PROJ_ID, NONBILL_UNASSIGN_EXP_TYP_CLS NONBILL_UNASSIGN_EXP_TYP_CLS, NONBILL_UNASSIGN_EXP_TYPE NONBILL_UNASSIGN_EXP_TYPE, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, JOB_COST_RATE_SCHEDULE_ID JOB_COST_RATE_SCHEDULE_ID, KEY_MEMBER_ROLE_ID KEY_MEMBER_ROLE_ID, FORECAST_CLASS_CATEGORY FORECAST_CLASS_CATEGORY, ORG_FCST_PERIOD_TYPE ORG_FCST_PERIOD_TYPE, START_PERIOD_NAME START_PERIOD_NAME, NUMBER_OF_PERIODS NUMBER_OF_PERIODS, WEIGHTED_OR_FULL_CODE WEIGHTED_OR_FULL_CODE, ORG_FCST_PROJECT_TEMPLATE_ID ORG_FCST_PROJECT_TEMPLATE_ID from "PA"."PA_FORECASTING_OPTIONS_ALL"

View Text - HTML Formatted

SELECT ORG_ID ORG_ID
, INCLUDE_ADMIN_PROJ_FLAG INCLUDE_ADMIN_PROJ_FLAG
, GL_PERIOD_FLAG GL_PERIOD_FLAG
, PA_PERIOD_FLAG PA_PERIOD_FLAG
, MAX_HISTORICAL_VERSIONS MAX_HISTORICAL_VERSIONS
, FORECAST_THRU_DATE FORECAST_THRU_DATE
, ACTUALS_THRU_DATE ACTUALS_THRU_DATE
, UTIL_CALC_METHOD UTIL_CALC_METHOD
, DEFAULT_ASSIGN_EXP_TYPE_CLASS DEFAULT_ASSIGN_EXP_TYPE_CLASS
, DEFAULT_ASSIGN_EXP_TYPE DEFAULT_ASSIGN_EXP_TYPE
, DEFAULT_TP_AMOUNT_TYPE DEFAULT_TP_AMOUNT_TYPE
, BILL_UNASSIGN_TIME_FLAG BILL_UNASSIGN_TIME_FLAG
, NONBILL_UNASSIGN_TIME_FLAG NONBILL_UNASSIGN_TIME_FLAG
, BILL_UNASSIGN_PROJ_ID BILL_UNASSIGN_PROJ_ID
, BILL_UNASSIGN_EXP_TYPE_CLASS BILL_UNASSIGN_EXP_TYPE_CLASS
, BILL_UNASSIGN_EXP_TYPE BILL_UNASSIGN_EXP_TYPE
, NONBILL_UNASSIGN_PROJ_ID NONBILL_UNASSIGN_PROJ_ID
, NONBILL_UNASSIGN_EXP_TYP_CLS NONBILL_UNASSIGN_EXP_TYP_CLS
, NONBILL_UNASSIGN_EXP_TYPE NONBILL_UNASSIGN_EXP_TYPE
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, JOB_COST_RATE_SCHEDULE_ID JOB_COST_RATE_SCHEDULE_ID
, KEY_MEMBER_ROLE_ID KEY_MEMBER_ROLE_ID
, FORECAST_CLASS_CATEGORY FORECAST_CLASS_CATEGORY
, ORG_FCST_PERIOD_TYPE ORG_FCST_PERIOD_TYPE
, START_PERIOD_NAME START_PERIOD_NAME
, NUMBER_OF_PERIODS NUMBER_OF_PERIODS
, WEIGHTED_OR_FULL_CODE WEIGHTED_OR_FULL_CODE
, ORG_FCST_PROJECT_TEMPLATE_ID ORG_FCST_PROJECT_TEMPLATE_ID
FROM "PA"."PA_FORECASTING_OPTIONS_ALL"