Product: | HXC - Time and Labor Engine |
---|---|
Description: | |
Implementation/DBA Data: | APPS.HXC_TIME_CATEGORIES_V |
SELECT HTC.ROWID
, HTC.TIME_CATEGORY_ID
, HTC.OBJECT_VERSION_NUMBER
, HTC.TIME_CATEGORY_NAME
, HTC.DESCRIPTION
, HTC.TIME_SQL
, HTC.OPERATOR
, LK.MEANING OPERATOR_MEANING
, HTC.DISPLAY
, HTC.CREATED_BY
, HTC.CREATION_DATE
, HTC.LAST_UPDATED_BY
, HTC.LAST_UPDATE_DATE
, HTC.LAST_UPDATE_LOGIN
FROM HR_LOOKUPS LK
, HXC_TIME_CATEGORIES HTC
WHERE LK.LOOKUP_TYPE = 'HXC_TIMECARD_SEARCH_CONNECTORS'
AND LK.LOOKUP_CODE = HTC.OPERATOR
AND LK.APPLICATION_ID = 800