[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PJI_SYSTEM_SETTINGS_U1 | NORMAL | UNIQUE | APPS_TS_SEED | SETTING_ID |
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 |
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
FROM PJI.PJI_SYSTEM_SETTINGS;
PJI.PJI_SYSTEM_SETTINGS does not reference any database object
PJI.PJI_SYSTEM_SETTINGS is referenced by following:
|
|
|