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


VIEW: CSD.CSD_TIME_CLOCK_ENTRIES#

Object Details
Object Name: CSD_TIME_CLOCK_ENTRIES#
Object Type: VIEW
Owner: CSD
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
TIME_CLOCK_ENTRY_ID NUMBER
Yes
OBJECT_VERSION_NUMBER NUMBER
Yes
CREATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER (15)
REPAIR_LINE_ID NUMBER (15) Yes
WIP_ENTITY_ID NUMBER

OPERATION_SEQ_NUM NUMBER

RESOURCE_ID NUMBER

EMPLOYEE_ID NUMBER (15)
CLOCK_IN_TIME DATE
Yes
CLOCK_OUT_TIME DATE

Query Text

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


SELECT TIME_CLOCK_ENTRY_ID
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REPAIR_LINE_ID
,      WIP_ENTITY_ID
,      OPERATION_SEQ_NUM
,      RESOURCE_ID
,      EMPLOYEE_ID
,      CLOCK_IN_TIME
,      CLOCK_OUT_TIME
FROM CSD.CSD_TIME_CLOCK_ENTRIES#;

Dependencies

[top of page]

CSD.CSD_TIME_CLOCK_ENTRIES# references the following:

SchemaCSD
TableCSD_TIME_CLOCK_ENTRIES
CSD.CSD_TIME_CLOCK_ENTRIES# is referenced by following:

SchemaAPPS
SynonymCSD_TIME_CLOCK_ENTRIES