[Home] [Help] [Dependency Information]
Object Name: | PA_SEARCH_RESULTS_TEMP |
---|---|
Object Type: | TABLE |
Owner: | PA |
FND Design Data: | PA.PA_SEARCH_RESULTS_TEMP |
Subobject Name: | |
Status: | VALID |
PA.PA_SEARCH_RESULTS_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$TRANSACTION. Data is removed at the end of this period.
Tablespace: | |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PA_SEARCH_RESULTS_TEMP_U1 | NORMAL | UNIQUE | PERSON_ID | |
PA_SEARCH_RESULTS_TEMP_U2 | NORMAL | UNIQUE | ASSIGNMENT_ID | |
PA_SEARCH_RESULTS_TEMP_U3 | NORMAL | UNIQUE | RESOURCE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PERSON_ID | NUMBER | |||
RESOURCE_ID | NUMBER | |||
RESOURCE_NAME | VARCHAR2 | (240) | ||
RESOURCE_TYPE | VARCHAR2 | (60) | ||
RESOURCE_ORGANIZATION_ID | NUMBER | |||
RESOURCE_ORGANIZATION_NAME | VARCHAR2 | (240) | ||
RESOURCE_JOB_LEVEL | NUMBER | |||
ASSIGNMENT_ID | NUMBER | |||
ASSIGNMENT_NUMBER | NUMBER | |||
ASSIGNMENT_NAME | VARCHAR2 | (80) | ||
ASSIGNMENT_START_DATE | DATE | |||
ASSIGNMENT_END_DATE | DATE | |||
PROJECT_ID | NUMBER | |||
PROJECT_NAME | VARCHAR2 | (30) | ||
PROJECT_NUMBER | VARCHAR2 | (25) | ||
COUNTRY | VARCHAR2 | (60) | ||
COUNTRY_CODE | VARCHAR2 | (2) | ||
REGION | VARCHAR2 | (140) | ||
CITY | VARCHAR2 | (30) | ||
OPTIONAL_COMPETENCE_MATCH | NUMBER | |||
OPTIONAL_COMPETENCE_COUNT | NUMBER | |||
MANDATORY_COMPETENCE_MATCH | NUMBER | |||
MANDATORY_COMPETENCE_COUNT | NUMBER | |||
AVAILABILITY | NUMBER | |||
CANDIDATE_IN_REQ_FLAG | VARCHAR2 | (1) | ||
NO_OF_ACTIVE_CANDIDATES | NUMBER | |||
CANDIDATE_SCORE | NUMBER | |||
POTENTIAL_AVAILABILITY | NUMBER | |||
RESOURCE_EMAIL | VARCHAR2 | (240) | ||
RESOURCE_MANAGER | VARCHAR2 | (240) |
Cut, paste (and edit) the following text to query this object:
SELECT PERSON_ID
, RESOURCE_ID
, RESOURCE_NAME
, RESOURCE_TYPE
, RESOURCE_ORGANIZATION_ID
, RESOURCE_ORGANIZATION_NAME
, RESOURCE_JOB_LEVEL
, ASSIGNMENT_ID
, ASSIGNMENT_NUMBER
, ASSIGNMENT_NAME
, ASSIGNMENT_START_DATE
, ASSIGNMENT_END_DATE
, PROJECT_ID
, PROJECT_NAME
, PROJECT_NUMBER
, COUNTRY
, COUNTRY_CODE
, REGION
, CITY
, OPTIONAL_COMPETENCE_MATCH
, OPTIONAL_COMPETENCE_COUNT
, MANDATORY_COMPETENCE_MATCH
, MANDATORY_COMPETENCE_COUNT
, AVAILABILITY
, CANDIDATE_IN_REQ_FLAG
, NO_OF_ACTIVE_CANDIDATES
, CANDIDATE_SCORE
, POTENTIAL_AVAILABILITY
, RESOURCE_EMAIL
, RESOURCE_MANAGER
FROM PA.PA_SEARCH_RESULTS_TEMP;
PA.PA_SEARCH_RESULTS_TEMP does not reference any database object
PA.PA_SEARCH_RESULTS_TEMP is referenced by following:
|
|
|