[Home] [Help] [Dependency Information]
Object Name: | PA_REQ_CREATE_TEMP |
---|---|
Object Type: | TABLE |
Owner: | PA |
Subobject Name: | |
Status: | VALID |
The PA_REQ_CREATE_TEMP table stores the project creation requests.
PA.PA_REQ_CREATE_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 |
---|---|---|---|---|
REQUEST_NAME | VARCHAR2 | (30) | Yes | User-defined name that uniquely identifies the project request. |
REQUEST_NUMBER | VARCHAR2 | (25) | Yes | The project request number that uniquely identifies the project request. The project request number can be user-defined or system-generated as defined in the implementation options. (Note: in Phase 1, only system-generated project number is allowed. |
REQUEST_TYPE | VARCHAR2 | (30) | Yes | The request type that classifies the project request. |
REQUEST_STATUS_NAME | VARCHAR2 | (80) | Yes | The name of the request status. |
REQUEST_CUSTOMER | VARCHAR2 | (360) | The name of project request customer. | |
COUNTRY | VARCHAR2 | (60) | The country in which the project request customer is located. | |
STATE | VARCHAR2 | (60) | The state in which the project request customer is located. | |
CITY | VARCHAR2 | (60) | The city in which the project request customer is located. | |
VALUE | NUMBER | Monetary value of the proposed project. | ||
CURRENCY_CODE | VARCHAR2 | (15) | Currency code for the proposed project. | |
EXPECTED_PROJECT_APPROVAL_DATE | DATE | Expected approval date of the proposed project. | ||
SOURCE_REFERENCE | VARCHAR2 | (25) | The identifier in the external project management system from which the project request was created. |
Cut, paste (and edit) the following text to query this object:
SELECT REQUEST_NAME
, REQUEST_NUMBER
, REQUEST_TYPE
, REQUEST_STATUS_NAME
, REQUEST_CUSTOMER
, COUNTRY
, STATE
, CITY
, VALUE
, CURRENCY_CODE
, EXPECTED_PROJECT_APPROVAL_DATE
, SOURCE_REFERENCE
FROM PA.PA_REQ_CREATE_TEMP;
PA.PA_REQ_CREATE_TEMP does not reference any database object
PA.PA_REQ_CREATE_TEMP is referenced by following:
|
|
|