Product: | PA - Projects |
---|---|
Description: | This view is based on the table pa_forecasting_options_all and stores the parameters and defaults that define the various options for forecasting options. If you have a multi-organization installation, you define one row for each operating |
Implementation/DBA Data: | Not implemented in this database |
SELECT ORG_ID
, INCLUDE_ADMIN_PROJ_FLAG
, GL_PERIOD_FLAG
, PA_PERIOD_FLAG
, FORECAST_THRU_DATE
, ACTUALS_THRU_DATE
, MAX_HISTORICAL_VERSIONS
, UTIL_CALC_METHOD
, DEFAULT_ASSIGN_EXP_TYPE_CLASS
, DEFAULT_ASSIGN_EXP_TYPE
, DEFAULT_TP_AMOUNT_TYPE
, BILL_UNASSIGN_TIME_FLAG
, NONBILL_UNASSIGN_TIME_FLAG
, BILL_UNASSIGN_PROJ_ID
, BILL_UNASSIGN_EXP_TYPE_CLASS
, BILL_UNASSIGN_EXP_TYPE
, NONBILL_UNASSIGN_PROJ_ID
, NONBILL_UNASSIGN_EXP_TYP_CLS
, NONBILL_UNASSIGN_EXP_TYPE
, JOB_COST_RATE_SCHEDULE_ID
, KEY_MEMBER_ROLE_ID
, FORECAST_CLASS_CATEGORY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, ORG_FCST_PERIOD_TYPE
, START_PERIOD_NAME
, NUMBER_OF_PERIODS
, ORG_FCST_PROJECT_TEMPLATE_ID
, WEIGHTED_OR_FULL_CODE
FROM PA_FORECASTING_OPTIONS_ALL
WHERE NVL(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)