[Home] [Help]
View: HXC_RETRIEVAL_RULE_COMPS_V
View Text
SELECT RTC.ROWID ROW_ID
, RTC.RETRIEVAL_RULE_COMP_ID
, RTC.RETRIEVAL_RULE_ID
, RTC.STATUS
, HRL.MEANING
, RTC.TIME_RECIPIENT_ID
, HTR.NAME TIME_RECIPIENT
, RTC.OBJECT_VERSION_NUMBER
, RTC.CREATED_BY
, RTC.CREATION_DATE
, RTC.LAST_UPDATED_BY
, RTC.LAST_UPDATE_DATE
, RTC.LAST_UPDATE_LOGIN
FROM HXC_TIME_RECIPIENTS HTR
, HR_STANDARD_LOOKUPS HRL
, HXC_RETRIEVAL_RULE_COMPS RTC
WHERE RTC.TIME_RECIPIENT_ID = HTR.TIME_RECIPIENT_ID
AND RTC.STATUS = HRL.LOOKUP_CODE
AND HRL.LOOKUP_TYPE = 'HXC_STATUS_RULE'
AND HRL.APPLICATION_ID = 809
Columns
Name |
ROW_ID |
RETRIEVAL_RULE_COMP_ID |
RETRIEVAL_RULE_ID |
STATUS |
MEANING |
TIME_RECIPIENT_ID |
TIME_RECIPIENT |
OBJECT_VERSION_NUMBER |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |