[Home] [Help] [Dependency Information]
Object Name: | PJI_SYSTEM_SETTINGS# |
---|---|
Object Type: | VIEW |
Owner: | PJI |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SETTING_ID | NUMBER | (15) | Yes | |
ORGANIZATION_STRUCTURE_ID | NUMBER | (15) | ||
ORG_STRUCTURE_VERSION_ID | NUMBER | (15) | ||
DFLT_PRJPIP_PERIOD_TYPE | VARCHAR2 | (30) | ||
DFLT_PRJPIP_AS_OF_DATE | VARCHAR2 | (30) | ||
DFLT_PRJPIP_CYCLE_ID | NUMBER | (15) | ||
DFLT_PRJBAB_PERIOD_TYPE | VARCHAR2 | (30) | ||
DFLT_PRJBAB_AS_OF_DATE | VARCHAR2 | (30) | ||
DFLT_PRJBAB_CYCLE_ID | NUMBER | (15) | ||
DFLT_RESUTL_PERIOD_TYPE | VARCHAR2 | (30) | ||
DFLT_RESUTL_AS_OF_DATE | VARCHAR2 | (30) | ||
DFLT_RESUTL_CYCLE_ID | NUMBER | (15) | ||
DFLT_RESAVL_PERIOD_TYPE | VARCHAR2 | (30) | ||
DFLT_RESAVL_AS_OF_DATE | VARCHAR2 | (30) | ||
DFLT_RESAVL_CYCLE_ID | NUMBER | (15) | ||
DFLT_RESPLN_PERIOD_TYPE | VARCHAR2 | (30) | ||
DFLT_RESPLN_AS_OF_DATE | VARCHAR2 | (30) | ||
DFLT_RESPLN_CYCLE_ID | NUMBER | (15) | ||
DFLT_PRJHLT_PERIOD_TYPE | VARCHAR2 | (30) | ||
DFLT_PRJHLT_AS_OF_DATE | VARCHAR2 | (30) | ||
DFLT_PRJHLT_CYCLE_ID | NUMBER | (15) | ||
DFLT_PRJACT_PERIOD_TYPE | VARCHAR2 | (30) | ||
DFLT_PRJACT_AS_OF_DATE | VARCHAR2 | (30) | ||
DFLT_PRJACT_CYCLE_ID | NUMBER | (15) | ||
DFLT_PRJPRF_PERIOD_TYPE | VARCHAR2 | (30) | ||
DFLT_PRJPRF_AS_OF_DATE | VARCHAR2 | (30) | ||
DFLT_PRJPRF_CYCLE_ID | NUMBER | (15) | ||
DFLT_PRJCST_PERIOD_TYPE | VARCHAR2 | (30) | ||
DFLT_PRJCST_AS_OF_DATE | VARCHAR2 | (30) | ||
DFLT_PRJCST_CYCLE_ID | NUMBER | (15) | ||
PA_PERIOD_FLAG | VARCHAR2 | (1) | ||
GL_PERIOD_FLAG | VARCHAR2 | (1) | ||
CONVERSION_RATIO_DAYS | NUMBER | (22) | ||
BOOK_TO_BILL_DAYS | NUMBER | (22) | ||
DSO_DAYS | NUMBER | (22) | ||
DORMANT_BACKLOG_DAYS | NUMBER | (22) | ||
REPORT_COST_TYPE | VARCHAR2 | (15) | ||
COST_BUDGET_TYPE_CODE | VARCHAR2 | (30) | ||
COST_BUDGET_CONV_RULE | VARCHAR2 | (30) | ||
REVENUE_BUDGET_TYPE_CODE | VARCHAR2 | (30) | ||
REVENUE_BUDGET_CONV_RULE | VARCHAR2 | (30) | ||
COST_FORECAST_TYPE_CODE | VARCHAR2 | (30) | ||
COST_FORECAST_CONV_RULE | VARCHAR2 | (30) | ||
REVENUE_FORECAST_TYPE_CODE | VARCHAR2 | (30) | ||
REVENUE_FORECAST_CONV_RULE | VARCHAR2 | (30) | ||
REPORT_LABOR_UNITS | VARCHAR2 | (15) | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
ROLLING_WEEKS | NUMBER | (15) | ||
COST_FP_TYPE_ID | NUMBER | (15) | ||
REVENUE_FP_TYPE_ID | NUMBER | (15) | ||
COST_FORECAST_FP_TYPE_ID | NUMBER | (15) | ||
REVENUE_FORECAST_FP_TYPE_ID | NUMBER | (15) | ||
CONFIG_PROJ_PERF_FLAG | VARCHAR2 | (1) | ||
CONFIG_COST_FLAG | VARCHAR2 | (1) | ||
CONFIG_PROFIT_FLAG | VARCHAR2 | (1) | ||
CONFIG_UTIL_FLAG | VARCHAR2 | (1) | ||
PLANAMT_ALLOC_METHOD | VARCHAR2 | (30) | ||
PRJ_CURR_FLAG | VARCHAR2 | (1) | ||
PROJFUNC_CURR_FLAG | VARCHAR2 | (1) | ||
CURR_REP_PA_PERIOD | VARCHAR2 | (30) | ||
CURR_REP_GL_PERIOD | VARCHAR2 | (30) | ||
CURR_REP_ENT_PERIOD | VARCHAR2 | (30) | ||
PLANAMT_CONV_DATE | VARCHAR2 | (30) | ||
GLOBAL_CURR2_FLAG | VARCHAR2 | (1) | ||
TXN_CURR_FLAG | VARCHAR2 | (1) | ||
GLOBAL_CURR1_FLAG | VARCHAR2 | (1) | ||
TIME_PHASE_FLAG | VARCHAR2 | (1) | ||
PER_ANALYSIS_FLAG | VARCHAR2 | (1) | ||
UP_PROCESS_FLAG | VARCHAR2 | (1) | ||
ZD_EDITION_NAME | VARCHAR2 | (30) | Yes | |
PSI_PPR_FLAG | VARCHAR2 | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT SETTING_ID
, ORGANIZATION_STRUCTURE_ID
, ORG_STRUCTURE_VERSION_ID
, DFLT_PRJPIP_PERIOD_TYPE
, DFLT_PRJPIP_AS_OF_DATE
, DFLT_PRJPIP_CYCLE_ID
, DFLT_PRJBAB_PERIOD_TYPE
, DFLT_PRJBAB_AS_OF_DATE
, DFLT_PRJBAB_CYCLE_ID
, DFLT_RESUTL_PERIOD_TYPE
, DFLT_RESUTL_AS_OF_DATE
, DFLT_RESUTL_CYCLE_ID
, DFLT_RESAVL_PERIOD_TYPE
, DFLT_RESAVL_AS_OF_DATE
, DFLT_RESAVL_CYCLE_ID
, DFLT_RESPLN_PERIOD_TYPE
, DFLT_RESPLN_AS_OF_DATE
, DFLT_RESPLN_CYCLE_ID
, DFLT_PRJHLT_PERIOD_TYPE
, DFLT_PRJHLT_AS_OF_DATE
, DFLT_PRJHLT_CYCLE_ID
, DFLT_PRJACT_PERIOD_TYPE
, DFLT_PRJACT_AS_OF_DATE
, DFLT_PRJACT_CYCLE_ID
, DFLT_PRJPRF_PERIOD_TYPE
, DFLT_PRJPRF_AS_OF_DATE
, DFLT_PRJPRF_CYCLE_ID
, DFLT_PRJCST_PERIOD_TYPE
, DFLT_PRJCST_AS_OF_DATE
, DFLT_PRJCST_CYCLE_ID
, PA_PERIOD_FLAG
, GL_PERIOD_FLAG
, CONVERSION_RATIO_DAYS
, BOOK_TO_BILL_DAYS
, DSO_DAYS
, DORMANT_BACKLOG_DAYS
, REPORT_COST_TYPE
, COST_BUDGET_TYPE_CODE
, COST_BUDGET_CONV_RULE
, REVENUE_BUDGET_TYPE_CODE
, REVENUE_BUDGET_CONV_RULE
, COST_FORECAST_TYPE_CODE
, COST_FORECAST_CONV_RULE
, REVENUE_FORECAST_TYPE_CODE
, REVENUE_FORECAST_CONV_RULE
, REPORT_LABOR_UNITS
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, ROLLING_WEEKS
, COST_FP_TYPE_ID
, REVENUE_FP_TYPE_ID
, COST_FORECAST_FP_TYPE_ID
, REVENUE_FORECAST_FP_TYPE_ID
, CONFIG_PROJ_PERF_FLAG
, CONFIG_COST_FLAG
, CONFIG_PROFIT_FLAG
, CONFIG_UTIL_FLAG
, PLANAMT_ALLOC_METHOD
, PRJ_CURR_FLAG
, PROJFUNC_CURR_FLAG
, CURR_REP_PA_PERIOD
, CURR_REP_GL_PERIOD
, CURR_REP_ENT_PERIOD
, PLANAMT_CONV_DATE
, GLOBAL_CURR2_FLAG
, TXN_CURR_FLAG
, GLOBAL_CURR1_FLAG
, TIME_PHASE_FLAG
, PER_ANALYSIS_FLAG
, UP_PROCESS_FLAG
, ZD_EDITION_NAME
, PSI_PPR_FLAG
FROM PJI.PJI_SYSTEM_SETTINGS#;
|
|
|