[Home] [Help]
View: HXC_RETRIEVAL_RULES_V
View Text
SELECT RTR.ROWID ROW_ID
, RTR.RETRIEVAL_RULE_ID
, RTR.NAME RETRIEVAL_RULE_NAME
, RTR.RETRIEVAL_PROCESS_ID
, HRT.NAME RETRIEVAL_PROCESS_NAME
, RTR.OBJECT_VERSION_NUMBER
, RTR.CREATED_BY
, RTR.CREATION_DATE
, RTR.LAST_UPDATED_BY
, RTR.LAST_UPDATE_DATE
, RTR.LAST_UPDATE_LOGIN
FROM HXC_RETRIEVAL_PROCESSES HRT
, HXC_RETRIEVAL_RULES RTR
WHERE RTR.RETRIEVAL_PROCESS_ID = HRT.RETRIEVAL_PROCESS_ID(+)
Columns
Name |
ROW_ID |
RETRIEVAL_RULE_ID |
RETRIEVAL_RULE_NAME |
RETRIEVAL_PROCESS_ID |
RETRIEVAL_PROCESS_NAME |
OBJECT_VERSION_NUMBER |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |