[Home] [Help]
View: HXC_APPLICATION_SET_COMPS_V
View Text
SELECT EGC.ROWID ROW_ID
, EGC.ENTITY_GROUP_COMP_ID APPLICATION_SET_COMP_ID
, EGC.ENTITY_GROUP_ID APPLICATION_SET_ID
, EGC.ENTITY_ID TIME_RECIPIENT_ID
, TR.NAME TIME_RECIPIENT_NAME
, EGC.OBJECT_VERSION_NUMBER
, EGC.CREATED_BY
, EGC.CREATION_DATE
, EGC.LAST_UPDATED_BY
, EGC.LAST_UPDATE_DATE
, EGC.LAST_UPDATE_LOGIN
FROM HXC_TIME_RECIPIENTS TR
, HXC_ENTITY_GROUP_COMPS EGC
WHERE EGC.ENTITY_TYPE = 'TIME_RECIPIENTS'
AND TR.TIME_RECIPIENT_ID = EGC.ENTITY_ID
Columns
Name |
ROW_ID |
APPLICATION_SET_COMP_ID |
APPLICATION_SET_ID |
TIME_RECIPIENT_ID |
TIME_RECIPIENT_NAME |
OBJECT_VERSION_NUMBER |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |