Product: | HXC - Time and Labor Engine |
---|---|
Description: | |
Implementation/DBA Data: | APPS.HXC_DATA_APP_RULE_USAGES_V |
SELECT DRU.ROWID ROW_ID
, DRU.DATA_APP_RULE_USAGE_ID
, DRU.APPROVAL_STYLE_ID
, HAS.NAME APPROVAL_STYLE_NAME
, DRU.TIME_ENTRY_RULE_ID
, DAR.NAME RULE
, DRU.TIME_RECIPIENT_ID
, HTR.NAME APPLICATION
, DRU.OBJECT_VERSION_NUMBER
, DRU.CREATED_BY
, DRU.CREATION_DATE
, DRU.LAST_UPDATED_BY
, DRU.LAST_UPDATE_DATE
, DRU.LAST_UPDATE_LOGIN
FROM HXC_TIME_RECIPIENTS HTR
, HXC_TIME_ENTRY_RULES DAR
, HXC_APPROVAL_STYLES HAS
, HXC_DATA_APP_RULE_USAGES DRU
WHERE DRU.TIME_ENTRY_RULE_ID = DAR.TIME_ENTRY_RULE_ID
AND DRU.TIME_RECIPIENT_ID = HTR.TIME_RECIPIENT_ID(+)
AND DRU.APPROVAL_STYLE_ID = HAS.APPROVAL_STYLE_ID