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.

DBA Data [Home] [Help] [Dependency Information]

VIEW: PJI.PJI_SYSTEM_SETTINGS#

Object Details

Object Name:	PJI_SYSTEM_SETTINGS#
Object Type:	VIEW
Owner:	PJI
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
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)

Query Text

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#;

Dependencies

[top of page]

PJI.PJI_SYSTEM_SETTINGS# references the following:

PJI: PJI_SYSTEM_SETTINGS

PJI.PJI_SYSTEM_SETTINGS# is referenced by following:

APPS: PJI_SYSTEM_SETTINGS; PJI_SYSTEM_SETTINGS+