VIEW: APPS.HXC_TK_GROUPS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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