VIEW: PJI.PJI_SYSTEM_SETTINGS#

Source

View Text - Preformatted

select SETTING_ID SETTING_ID, ORGANIZATION_STRUCTURE_ID ORGANIZATION_STRUCTURE_ID, ORG_STRUCTURE_VERSION_ID ORG_STRUCTURE_VERSION_ID, DFLT_PRJPIP_PERIOD_TYPE DFLT_PRJPIP_PERIOD_TYPE, DFLT_PRJPIP_AS_OF_DATE DFLT_PRJPIP_AS_OF_DATE, DFLT_PRJPIP_CYCLE_ID DFLT_PRJPIP_CYCLE_ID, DFLT_PRJBAB_PERIOD_TYPE DFLT_PRJBAB_PERIOD_TYPE, DFLT_PRJBAB_AS_OF_DATE DFLT_PRJBAB_AS_OF_DATE, DFLT_PRJBAB_CYCLE_ID DFLT_PRJBAB_CYCLE_ID, DFLT_RESUTL_PERIOD_TYPE DFLT_RESUTL_PERIOD_TYPE, DFLT_RESUTL_AS_OF_DATE DFLT_RESUTL_AS_OF_DATE, DFLT_RESUTL_CYCLE_ID DFLT_RESUTL_CYCLE_ID, DFLT_RESAVL_PERIOD_TYPE DFLT_RESAVL_PERIOD_TYPE, DFLT_RESAVL_AS_OF_DATE DFLT_RESAVL_AS_OF_DATE, DFLT_RESAVL_CYCLE_ID DFLT_RESAVL_CYCLE_ID, DFLT_RESPLN_PERIOD_TYPE DFLT_RESPLN_PERIOD_TYPE, DFLT_RESPLN_AS_OF_DATE DFLT_RESPLN_AS_OF_DATE, DFLT_RESPLN_CYCLE_ID DFLT_RESPLN_CYCLE_ID, DFLT_PRJHLT_PERIOD_TYPE DFLT_PRJHLT_PERIOD_TYPE, DFLT_PRJHLT_AS_OF_DATE DFLT_PRJHLT_AS_OF_DATE, DFLT_PRJHLT_CYCLE_ID DFLT_PRJHLT_CYCLE_ID, DFLT_PRJACT_PERIOD_TYPE DFLT_PRJACT_PERIOD_TYPE, DFLT_PRJACT_AS_OF_DATE DFLT_PRJACT_AS_OF_DATE, DFLT_PRJACT_CYCLE_ID DFLT_PRJACT_CYCLE_ID, DFLT_PRJPRF_PERIOD_TYPE DFLT_PRJPRF_PERIOD_TYPE, DFLT_PRJPRF_AS_OF_DATE DFLT_PRJPRF_AS_OF_DATE, DFLT_PRJPRF_CYCLE_ID DFLT_PRJPRF_CYCLE_ID, DFLT_PRJCST_PERIOD_TYPE DFLT_PRJCST_PERIOD_TYPE, DFLT_PRJCST_AS_OF_DATE DFLT_PRJCST_AS_OF_DATE, DFLT_PRJCST_CYCLE_ID DFLT_PRJCST_CYCLE_ID, PA_PERIOD_FLAG PA_PERIOD_FLAG, GL_PERIOD_FLAG GL_PERIOD_FLAG, CONVERSION_RATIO_DAYS CONVERSION_RATIO_DAYS, BOOK_TO_BILL_DAYS BOOK_TO_BILL_DAYS, DSO_DAYS DSO_DAYS, DORMANT_BACKLOG_DAYS DORMANT_BACKLOG_DAYS, REPORT_COST_TYPE REPORT_COST_TYPE, COST_BUDGET_TYPE_CODE COST_BUDGET_TYPE_CODE, COST_BUDGET_CONV_RULE COST_BUDGET_CONV_RULE, REVENUE_BUDGET_TYPE_CODE REVENUE_BUDGET_TYPE_CODE, REVENUE_BUDGET_CONV_RULE REVENUE_BUDGET_CONV_RULE, COST_FORECAST_TYPE_CODE COST_FORECAST_TYPE_CODE, COST_FORECAST_CONV_RULE COST_FORECAST_CONV_RULE, REVENUE_FORECAST_TYPE_CODE REVENUE_FORECAST_TYPE_CODE, REVENUE_FORECAST_CONV_RULE REVENUE_FORECAST_CONV_RULE, REPORT_LABOR_UNITS REPORT_LABOR_UNITS, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, ROLLING_WEEKS ROLLING_WEEKS, COST_FP_TYPE_ID COST_FP_TYPE_ID, REVENUE_FP_TYPE_ID REVENUE_FP_TYPE_ID, COST_FORECAST_FP_TYPE_ID COST_FORECAST_FP_TYPE_ID, REVENUE_FORECAST_FP_TYPE_ID REVENUE_FORECAST_FP_TYPE_ID, CONFIG_PROJ_PERF_FLAG CONFIG_PROJ_PERF_FLAG, CONFIG_COST_FLAG CONFIG_COST_FLAG, CONFIG_PROFIT_FLAG CONFIG_PROFIT_FLAG, CONFIG_UTIL_FLAG CONFIG_UTIL_FLAG, PLANAMT_ALLOC_METHOD PLANAMT_ALLOC_METHOD, PRJ_CURR_FLAG PRJ_CURR_FLAG, PROJFUNC_CURR_FLAG PROJFUNC_CURR_FLAG, CURR_REP_PA_PERIOD CURR_REP_PA_PERIOD, CURR_REP_GL_PERIOD CURR_REP_GL_PERIOD, CURR_REP_ENT_PERIOD CURR_REP_ENT_PERIOD, PLANAMT_CONV_DATE PLANAMT_CONV_DATE, GLOBAL_CURR2_FLAG GLOBAL_CURR2_FLAG, TXN_CURR_FLAG TXN_CURR_FLAG, GLOBAL_CURR1_FLAG GLOBAL_CURR1_FLAG, TIME_PHASE_FLAG TIME_PHASE_FLAG, PER_ANALYSIS_FLAG PER_ANALYSIS_FLAG, UP_PROCESS_FLAG UP_PROCESS_FLAG, ZD_EDITION_NAME ZD_EDITION_NAME, PSI_PPR_FLAG PSI_PPR_FLAG from "PJI"."PJI_SYSTEM_SETTINGS"

View Text - HTML Formatted

SELECT SETTING_ID SETTING_ID
, ORGANIZATION_STRUCTURE_ID ORGANIZATION_STRUCTURE_ID
, ORG_STRUCTURE_VERSION_ID ORG_STRUCTURE_VERSION_ID
, DFLT_PRJPIP_PERIOD_TYPE DFLT_PRJPIP_PERIOD_TYPE
, DFLT_PRJPIP_AS_OF_DATE DFLT_PRJPIP_AS_OF_DATE
, DFLT_PRJPIP_CYCLE_ID DFLT_PRJPIP_CYCLE_ID
, DFLT_PRJBAB_PERIOD_TYPE DFLT_PRJBAB_PERIOD_TYPE
, DFLT_PRJBAB_AS_OF_DATE DFLT_PRJBAB_AS_OF_DATE
, DFLT_PRJBAB_CYCLE_ID DFLT_PRJBAB_CYCLE_ID
, DFLT_RESUTL_PERIOD_TYPE DFLT_RESUTL_PERIOD_TYPE
, DFLT_RESUTL_AS_OF_DATE DFLT_RESUTL_AS_OF_DATE
, DFLT_RESUTL_CYCLE_ID DFLT_RESUTL_CYCLE_ID
, DFLT_RESAVL_PERIOD_TYPE DFLT_RESAVL_PERIOD_TYPE
, DFLT_RESAVL_AS_OF_DATE DFLT_RESAVL_AS_OF_DATE
, DFLT_RESAVL_CYCLE_ID DFLT_RESAVL_CYCLE_ID
, DFLT_RESPLN_PERIOD_TYPE DFLT_RESPLN_PERIOD_TYPE
, DFLT_RESPLN_AS_OF_DATE DFLT_RESPLN_AS_OF_DATE
, DFLT_RESPLN_CYCLE_ID DFLT_RESPLN_CYCLE_ID
, DFLT_PRJHLT_PERIOD_TYPE DFLT_PRJHLT_PERIOD_TYPE
, DFLT_PRJHLT_AS_OF_DATE DFLT_PRJHLT_AS_OF_DATE
, DFLT_PRJHLT_CYCLE_ID DFLT_PRJHLT_CYCLE_ID
, DFLT_PRJACT_PERIOD_TYPE DFLT_PRJACT_PERIOD_TYPE
, DFLT_PRJACT_AS_OF_DATE DFLT_PRJACT_AS_OF_DATE
, DFLT_PRJACT_CYCLE_ID DFLT_PRJACT_CYCLE_ID
, DFLT_PRJPRF_PERIOD_TYPE DFLT_PRJPRF_PERIOD_TYPE
, DFLT_PRJPRF_AS_OF_DATE DFLT_PRJPRF_AS_OF_DATE
, DFLT_PRJPRF_CYCLE_ID DFLT_PRJPRF_CYCLE_ID
, DFLT_PRJCST_PERIOD_TYPE DFLT_PRJCST_PERIOD_TYPE
, DFLT_PRJCST_AS_OF_DATE DFLT_PRJCST_AS_OF_DATE
, DFLT_PRJCST_CYCLE_ID DFLT_PRJCST_CYCLE_ID
, PA_PERIOD_FLAG PA_PERIOD_FLAG
, GL_PERIOD_FLAG GL_PERIOD_FLAG
, CONVERSION_RATIO_DAYS CONVERSION_RATIO_DAYS
, BOOK_TO_BILL_DAYS BOOK_TO_BILL_DAYS
, DSO_DAYS DSO_DAYS
, DORMANT_BACKLOG_DAYS DORMANT_BACKLOG_DAYS
, REPORT_COST_TYPE REPORT_COST_TYPE
, COST_BUDGET_TYPE_CODE COST_BUDGET_TYPE_CODE
, COST_BUDGET_CONV_RULE COST_BUDGET_CONV_RULE
, REVENUE_BUDGET_TYPE_CODE REVENUE_BUDGET_TYPE_CODE
, REVENUE_BUDGET_CONV_RULE REVENUE_BUDGET_CONV_RULE
, COST_FORECAST_TYPE_CODE COST_FORECAST_TYPE_CODE
, COST_FORECAST_CONV_RULE COST_FORECAST_CONV_RULE
, REVENUE_FORECAST_TYPE_CODE REVENUE_FORECAST_TYPE_CODE
, REVENUE_FORECAST_CONV_RULE REVENUE_FORECAST_CONV_RULE
, REPORT_LABOR_UNITS REPORT_LABOR_UNITS
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ROLLING_WEEKS ROLLING_WEEKS
, COST_FP_TYPE_ID COST_FP_TYPE_ID
, REVENUE_FP_TYPE_ID REVENUE_FP_TYPE_ID
, COST_FORECAST_FP_TYPE_ID COST_FORECAST_FP_TYPE_ID
, REVENUE_FORECAST_FP_TYPE_ID REVENUE_FORECAST_FP_TYPE_ID
, CONFIG_PROJ_PERF_FLAG CONFIG_PROJ_PERF_FLAG
, CONFIG_COST_FLAG CONFIG_COST_FLAG
, CONFIG_PROFIT_FLAG CONFIG_PROFIT_FLAG
, CONFIG_UTIL_FLAG CONFIG_UTIL_FLAG
, PLANAMT_ALLOC_METHOD PLANAMT_ALLOC_METHOD
, PRJ_CURR_FLAG PRJ_CURR_FLAG
, PROJFUNC_CURR_FLAG PROJFUNC_CURR_FLAG
, CURR_REP_PA_PERIOD CURR_REP_PA_PERIOD
, CURR_REP_GL_PERIOD CURR_REP_GL_PERIOD
, CURR_REP_ENT_PERIOD CURR_REP_ENT_PERIOD
, PLANAMT_CONV_DATE PLANAMT_CONV_DATE
, GLOBAL_CURR2_FLAG GLOBAL_CURR2_FLAG
, TXN_CURR_FLAG TXN_CURR_FLAG
, GLOBAL_CURR1_FLAG GLOBAL_CURR1_FLAG
, TIME_PHASE_FLAG TIME_PHASE_FLAG
, PER_ANALYSIS_FLAG PER_ANALYSIS_FLAG
, UP_PROCESS_FLAG UP_PROCESS_FLAG
, ZD_EDITION_NAME ZD_EDITION_NAME
, PSI_PPR_FLAG PSI_PPR_FLAG
FROM "PJI"."PJI_SYSTEM_SETTINGS"