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

TABLE: EAM.EAM_EMP_SEARCH_RESULT_TBL

Object Details
Object Name: EAM_EMP_SEARCH_RESULT_TBL
Object Type: TABLE
Owner: EAM
FND Design Data: TableEAM.EAM_EMP_SEARCH_RESULT_TBL
Subobject Name:
Status: VALID

Temporary Table Details

EAM.EAM_EMP_SEARCH_RESULT_TBL 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.

Storage Details
Tablespace: Tablespace
PCT Free: 10
PCT Used: 40
Columns
Name Datatype Length Mandatory Comments
PERSON_ID NUMBER

EMPLOYEE_NAME VARCHAR2 (240)
EMPLOYEE_NUMBER VARCHAR2 (30)
INSTANCE_ID NUMBER

RESOURCE_ID NUMBER

DEPARTMENT_ID NUMBER

RESOURCE_CODE VARCHAR2 (10)
DEPARTMENT_CODE VARCHAR2 (10)
ASSIGN_UNASSIGN_ENABLE VARCHAR2 (30)
AVAILABLE_HOURS NUMBER

ASSIGNED_HOURS NUMBER

UNASSIGNED_HOURS NUMBER

ASSIGNED_PERCENTAGE NUMBER

START_DATE DATE

COMPLETION_DATE DATE

DURATION NUMBER

WO_FIRM_STATUS VARCHAR2 (1)
UOM VARCHAR2 (3)
Query Text

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


SELECT PERSON_ID
,      EMPLOYEE_NAME
,      EMPLOYEE_NUMBER
,      INSTANCE_ID
,      RESOURCE_ID
,      DEPARTMENT_ID
,      RESOURCE_CODE
,      DEPARTMENT_CODE
,      ASSIGN_UNASSIGN_ENABLE
,      AVAILABLE_HOURS
,      ASSIGNED_HOURS
,      UNASSIGNED_HOURS
,      ASSIGNED_PERCENTAGE
,      START_DATE
,      COMPLETION_DATE
,      DURATION
,      WO_FIRM_STATUS
,      UOM
FROM EAM.EAM_EMP_SEARCH_RESULT_TBL;

Dependencies

[top of page]

EAM.EAM_EMP_SEARCH_RESULT_TBL does not reference any database object

EAM.EAM_EMP_SEARCH_RESULT_TBL is referenced by following:

SchemaAPPS
SynonymEAM_EMP_SEARCH_RESULT_TBL