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]

TABLE: PJI.PJI_SYSTEM_SETTINGS

Object Details

Object Name:	PJI_SYSTEM_SETTINGS
Object Type:	TABLE
Owner:	PJI
FND Design Data:	PJI.PJI_SYSTEM_SETTINGS
Subobject Name:
Status:	VALID

PJI_SYSTEM_SETTINGS stores the parameters and defaults that define the configuration of your Oracle Projects Intelligence installation.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PJI_SYSTEM_SETTINGS_U1	NORMAL	UNIQUE	APPS_TS_SEED	SETTING_ID ZD_EDITION_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
SETTING_ID	NUMBER	(15)	Yes	Identifier for the setting
ORGANIZATION_STRUCTURE_ID	NUMBER	(15)		Identifier of the organization hierarchy used for reporting
ORG_STRUCTURE_VERSION_ID	NUMBER	(15)		Identifies the specific version of the hierarchy
DFLT_PRJPIP_PERIOD_TYPE	VARCHAR2	(30)		Reporting configuration attribute
DFLT_PRJPIP_AS_OF_DATE	VARCHAR2	(30)		Reporting configuration attribute
DFLT_PRJPIP_CYCLE_ID	NUMBER	(15)		Reporting configuration attribute
DFLT_PRJBAB_PERIOD_TYPE	VARCHAR2	(30)		Reporting configuration attribute
DFLT_PRJBAB_AS_OF_DATE	VARCHAR2	(30)		Reporting configuration attribute
DFLT_PRJBAB_CYCLE_ID	NUMBER	(15)		Reporting configuration attribute
DFLT_RESUTL_PERIOD_TYPE	VARCHAR2	(30)		Reporting configuration attribute
DFLT_RESUTL_AS_OF_DATE	VARCHAR2	(30)		Reporting configuration attribute
DFLT_RESUTL_CYCLE_ID	NUMBER	(15)		Reporting configuration attribute
DFLT_RESAVL_PERIOD_TYPE	VARCHAR2	(30)		Reporting configuration attribute
DFLT_RESAVL_AS_OF_DATE	VARCHAR2	(30)		Reporting configuration attribute
DFLT_RESAVL_CYCLE_ID	NUMBER	(15)		Reporting configuration attribute
DFLT_RESPLN_PERIOD_TYPE	VARCHAR2	(30)		Reporting configuration attribute
DFLT_RESPLN_AS_OF_DATE	VARCHAR2	(30)		Reporting configuration attribute
DFLT_RESPLN_CYCLE_ID	NUMBER	(15)		Reporting configuration attribute
DFLT_PRJHLT_PERIOD_TYPE	VARCHAR2	(30)		Reporting configuration attribute
DFLT_PRJHLT_AS_OF_DATE	VARCHAR2	(30)		Reporting configuration attribute
DFLT_PRJHLT_CYCLE_ID	NUMBER	(15)		Reporting configuration attribute
DFLT_PRJACT_PERIOD_TYPE	VARCHAR2	(30)		Reporting configuration attribute
DFLT_PRJACT_AS_OF_DATE	VARCHAR2	(30)		Reporting configuration attribute
DFLT_PRJACT_CYCLE_ID	NUMBER	(15)		Reporting configuration attribute
DFLT_PRJPRF_PERIOD_TYPE	VARCHAR2	(30)		Reporting configuration attribute
DFLT_PRJPRF_AS_OF_DATE	VARCHAR2	(30)		Reporting configuration attribute
DFLT_PRJPRF_CYCLE_ID	NUMBER	(15)		Reporting configuration attribute
DFLT_PRJCST_PERIOD_TYPE	VARCHAR2	(30)		Reporting configuration attribute
DFLT_PRJCST_AS_OF_DATE	VARCHAR2	(30)		Reporting configuration attribute
DFLT_PRJCST_CYCLE_ID	NUMBER	(15)		Reporting configuration attribute
PA_PERIOD_FLAG	VARCHAR2	(1)		PA Period Flag
GL_PERIOD_FLAG	VARCHAR2	(1)		GL Period Flag
CONVERSION_RATIO_DAYS	NUMBER	(22)		Conversion ratio days
BOOK_TO_BILL_DAYS	NUMBER	(22)		Days used in book to bill ratio calculation
DSO_DAYS	NUMBER	(22)		Days used in the days sales outstanding calculation
DORMANT_BACKLOG_DAYS	NUMBER	(22)		Days after which backlog is considered dormant
REPORT_COST_TYPE	VARCHAR2	(15)		Reporting cost type
COST_BUDGET_TYPE_CODE	VARCHAR2	(30)		Code for Cost Budget Type
COST_BUDGET_CONV_RULE	VARCHAR2	(30)		Conversion Rate Date Basis for Cost Budget
REVENUE_BUDGET_TYPE_CODE	VARCHAR2	(30)		Code for Revenue Budget Type
REVENUE_BUDGET_CONV_RULE	VARCHAR2	(30)		Conversion Rate Date Basis for Revenue Budget
COST_FORECAST_TYPE_CODE	VARCHAR2	(30)		Code for Cost Forecast Type
COST_FORECAST_CONV_RULE	VARCHAR2	(30)		Conversion Rate Date Basis for Cost Forecast
REVENUE_FORECAST_TYPE_CODE	VARCHAR2	(30)		Code for Revenue Forecast Type
REVENUE_FORECAST_CONV_RULE	VARCHAR2	(30)		Conversion Rate Date Basis for Revenue Forecast
REPORT_LABOR_UNITS	VARCHAR2	(15)		Reporting labor unit
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Column
CREATION_DATE	DATE		Yes	Standard Who Column
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who Column
ROLLING_WEEKS	NUMBER	(15)		Number of weeks in a rolling week
COST_FP_TYPE_ID	NUMBER	(15)		Identifier of the cost financial plan
REVENUE_FP_TYPE_ID	NUMBER	(15)		Identifier of the revenue financial plan
COST_FORECAST_FP_TYPE_ID	NUMBER	(15)		Identifier of the cost forecast financial plan
REVENUE_FORECAST_FP_TYPE_ID	NUMBER	(15)		Identifier of the revenue forecast financial plan
CONFIG_PROJ_PERF_FLAG	VARCHAR2	(1)		Project Performance Flag
CONFIG_COST_FLAG	VARCHAR2	(1)		Cost Flag
CONFIG_PROFIT_FLAG	VARCHAR2	(1)		Profitability Flag
CONFIG_UTIL_FLAG	VARCHAR2	(1)		Utilization Flag
PLANAMT_ALLOC_METHOD	VARCHAR2	(30)		Planning amount allocation method
PRJ_CURR_FLAG	VARCHAR2	(1)		Project Currency
PROJFUNC_CURR_FLAG	VARCHAR2	(1)		Project Functional Currency
CURR_REP_PA_PERIOD	VARCHAR2	(30)		Current reporting PA Period
CURR_REP_GL_PERIOD	VARCHAR2	(30)		Current reporting GL period
CURR_REP_ENT_PERIOD	VARCHAR2	(30)		Current reporting global period
PLANAMT_CONV_DATE	VARCHAR2	(30)		Planning amount conversion date basis
GLOBAL_CURR2_FLAG	VARCHAR2	(1)		Global Currency 2 Flag
TXN_CURR_FLAG	VARCHAR2	(1)		Transaction Currency flag
GLOBAL_CURR1_FLAG	VARCHAR2	(1)		Global Currency 1 Flag
TIME_PHASE_FLAG	VARCHAR2	(1)		Time Phase Flag
PER_ANALYSIS_FLAG	VARCHAR2	(1)		Periodic Analysis Flag
UP_PROCESS_FLAG	VARCHAR2	(1)		Financial Plans Processing Flag
ZD_EDITION_NAME	VARCHAR2	(30)	Yes
PSI_PPR_FLAG	VARCHAR2	(1)		Psi Ppr Reporting Flag

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 does not reference any database object

PJI.PJI_SYSTEM_SETTINGS is referenced by following:

PJI: PJI_SYSTEM_SETTINGS#