[Home] [Help] [Dependency Information]
Object Name: | PA_PROJECTS_UPDATE_TEMP |
---|---|
Object Type: | TABLE |
Owner: | PA |
Subobject Name: | |
Status: | VALID |
The PA_PROJECTS_UPDATE_TEMP table stores the project updating information.
PA.PA_PROJECTS_UPDATE_TEMP is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$SESSION. Data is removed at the end of this period.
Tablespace: | |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PROJECT_NAME | VARCHAR2 | (30) | Yes | User-defined name that uniquely identifies the project. |
PROJECT_NUMBER | VARCHAR2 | (25) | Yes | The project request number that uniquely identifies the project. The project request number can be user-defined or system-generated as defined in the implementation options. |
PROJECT_STATUS_NAME | VARCHAR2 | (80) | Yes | The name of the project status. |
OLD_PROBABILITY | NUMBER | The probability of the project before running the concurrent program in updates mode. | ||
NEW_PROBABILITY | NUMBER | The probability of the project after running the concurrent program in updates mode. | ||
OLD_VALUE | NUMBER | Monetary value of the proposed project before running the concurrent program in updates mode. | ||
NEW_VALUE | NUMBER | Monetary value of the proposed project after running the concurrent program in updates mode. | ||
OLD_VALUE_CURRENCY | VARCHAR2 | (15) | Currency of the monetary value of the proposed project before running the concurrent program in updates mode. | |
NEW_VALUE_CURRENCY | VARCHAR2 | (15) | Currency of the monetary value of the proposed project after running the concurrent program in updates mode. | |
OLD_EXPECTED_PROJ_APPRVL_DATE | DATE | Expected approval date of the proposed project before running the concurrent program in updates mode. | ||
NEW_EXPECTED_PROJ_APPRVL_DATE | DATE | Expected approval date of the proposed project after running the concurrent program in updates mode in updates mode. |
Cut, paste (and edit) the following text to query this object:
SELECT PROJECT_NAME
, PROJECT_NUMBER
, PROJECT_STATUS_NAME
, OLD_PROBABILITY
, NEW_PROBABILITY
, OLD_VALUE
, NEW_VALUE
, OLD_VALUE_CURRENCY
, NEW_VALUE_CURRENCY
, OLD_EXPECTED_PROJ_APPRVL_DATE
, NEW_EXPECTED_PROJ_APPRVL_DATE
FROM PA.PA_PROJECTS_UPDATE_TEMP;
PA.PA_PROJECTS_UPDATE_TEMP does not reference any database object
PA.PA_PROJECTS_UPDATE_TEMP is referenced by following:
|
|
|