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

TABLE: PJI.PJI_SYSTEM_CONFIG_HIST

Object Details
Object Name: PJI_SYSTEM_CONFIG_HIST
Object Type: TABLE
Owner: PJI
FND Design Data: TablePJI.PJI_SYSTEM_CONFIG_HIST
Subobject Name:
Status: VALID


PJI_SYSTEM_CONFIG_HIST stores the configuration of your Oracle Projects Intelligence.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 0
PCT Used:
Columns
Name Datatype Length Mandatory Comments
MAIN_REQUEST_ID NUMBER

PROCESS_NAME VARCHAR2 (30)
Name of the process
RUN_TYPE VARCHAR2 (30)
Summarization mode
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
START_DATE DATE

Start Date of the Summarization process
END_DATE DATE

End Date of the Summarization process
REQUEST_ID NUMBER (15)
Request Idenitifier for the Concurrent Program
USER_NAME VARCHAR2 (10)
Name of the User who submitted the request
PARAMETERS VARCHAR2 (240)
List of parameters with which the request was submitted
COMPLETION_TEXT VARCHAR2 (240)
Completion text of the process, this will have information if the process has failed or completed successfully
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT MAIN_REQUEST_ID
,      PROCESS_NAME
,      RUN_TYPE
,      CONFIG_PROJ_PERF_FLAG
,      CONFIG_COST_FLAG
,      CONFIG_PROFIT_FLAG
,      CONFIG_UTIL_FLAG
,      START_DATE
,      END_DATE
,      REQUEST_ID
,      USER_NAME
,      PARAMETERS
,      COMPLETION_TEXT
FROM PJI.PJI_SYSTEM_CONFIG_HIST;

Dependencies

[top of page]

PJI.PJI_SYSTEM_CONFIG_HIST does not reference any database object

PJI.PJI_SYSTEM_CONFIG_HIST is referenced by following:

SchemaPJI
ViewPJI_SYSTEM_CONFIG_HIST#