[Home] [Help]
View: HXC_TK_GROUPS_V
Product: | HXC - Time and Labor Engine |
Description: | Timekeeper Groups |
Implementation/DBA Data: |
APPS.HXC_TK_GROUPS_V
|
View Text
SELECT TKG.ROWID ROW_ID
, TKG.TK_GROUP_ID
, TKG.TK_GROUP_NAME
, TKG.TK_RESOURCE_ID
, P.LAST_NAME
, P.FIRST_NAME
, P.FULL_NAME
, TKG.OBJECT_VERSION_NUMBER
, TKG.CREATED_BY
, TKG.CREATION_DATE
, TKG.LAST_UPDATED_BY
, TKG.LAST_UPDATE_DATE
, TKG.LAST_UPDATE_LOGIN
, TKG.BUSINESS_GROUP_ID
FROM PER_PEOPLE P
, HXC_TK_GROUPS TKG
WHERE TKG.TK_RESOURCE_ID = P.PERSON_ID
Columns
Name |
ROW_ID |
TK_GROUP_ID |
TK_GROUP_NAME |
TK_RESOURCE_ID |
LAST_NAME |
FIRST_NAME |
FULL_NAME |
OBJECT_VERSION_NUMBER |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |
BUSINESS_GROUP_ID |