[Home] [Help] [Dependency Information]
Object Name: | HXC_TEMP_TCD |
---|---|
Object Type: | TABLE |
Owner: | APPS |
FND Design Data: | HXT.HXC_TEMP_TCD |
Subobject Name: | |
Status: | VALID |
APPS.HXC_TEMP_TCD 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 |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RESOURCE_ID | NUMBER | |||
START_TIME | DATE | |||
STOP_TIME | DATE | |||
APPROVAL_STATUS | VARCHAR2 | (50) | ||
USER_ID | NUMBER | |||
RECURRING_PERIOD_ID | NUMBER | |||
TIMECARD_EXIST | VARCHAR2 | (1) | ||
PERSON_NUMBER | VARCHAR2 | (240) | ||
FULL_NAME | VARCHAR2 | (240) | ||
PAYROLL_NAME | VARCHAR2 | (240) | ||
ORGANIZATION_NAME | VARCHAR2 | (240) | ||
LOCATION_NAME | VARCHAR2 | (240) | ||
SUPERVISOR_NAME | VARCHAR2 | (240) | ||
PERSON_TYPE | VARCHAR2 | (240) | ||
TIMECARD_ID | NUMBER | |||
TIMECARD_OVN | NUMBER | |||
LAST_MODIFIED_BY | VARCHAR2 | (240) | ||
LAST_MODIFIED_DATE | DATE | |||
APPLICATION | VARCHAR2 | (240) | ||
SUPERVISOR_ID | NUMBER | (15) | ||
PERIOD_EXIST | VARCHAR2 | (1) | ||
APPLICATION_PERIOD_ID | NUMBER | |||
NOTIFICATION_ID | NUMBER | |||
MEANING | VARCHAR2 | (50) | ||
ASSG_START_DATE | DATE | |||
ASSG_END_DATE | DATE | |||
PERIOD_START_DATE | DATE | |||
PERIOD_END_DATE | DATE |
Cut, paste (and edit) the following text to query this object:
SELECT RESOURCE_ID
, START_TIME
, STOP_TIME
, APPROVAL_STATUS
, USER_ID
, RECURRING_PERIOD_ID
, TIMECARD_EXIST
, PERSON_NUMBER
, FULL_NAME
, PAYROLL_NAME
, ORGANIZATION_NAME
, LOCATION_NAME
, SUPERVISOR_NAME
, PERSON_TYPE
, TIMECARD_ID
, TIMECARD_OVN
, LAST_MODIFIED_BY
, LAST_MODIFIED_DATE
, APPLICATION
, SUPERVISOR_ID
, PERIOD_EXIST
, APPLICATION_PERIOD_ID
, NOTIFICATION_ID
, MEANING
, ASSG_START_DATE
, ASSG_END_DATE
, PERIOD_START_DATE
, PERIOD_END_DATE
FROM APPS.HXC_TEMP_TCD;
APPS.HXC_TEMP_TCD does not reference any database object
APPS.HXC_TEMP_TCD is referenced by following:
|
|
|