Product: | HXC - Time and Labor Engine |
---|---|
Description: | |
Implementation/DBA Data: | APPS.HXC_RETRIEVAL_RULE_GRP_COMPS_V |
SELECT EGC.ROWID ROW_ID
, EGC.ENTITY_GROUP_COMP_ID RETRIEVAL_RULE_GROUP_COMP_ID
, EGC.ENTITY_GROUP_ID RETRIEVAL_RULE_GROUP_ID
, EGC.ENTITY_ID RETRIEVAL_RULE_ID
, RR.NAME RETRIEVAL_RULE_NAME
, RP.NAME RETRIEVAL_PROCESS_NAME
, RP.RETRIEVAL_PROCESS_ID
, EGC.OBJECT_VERSION_NUMBER
, EGC.CREATED_BY
, EGC.CREATION_DATE
, EGC.LAST_UPDATED_BY
, EGC.LAST_UPDATE_DATE
, EGC.LAST_UPDATE_LOGIN
FROM HXC_RETRIEVAL_PROCESSES RP
, HXC_RETRIEVAL_RULES RR
, HXC_ENTITY_GROUP_COMPS EGC
WHERE EGC.ENTITY_TYPE = 'RETRIEVAL_RULES'
AND RR.RETRIEVAL_RULE_ID = EGC.ENTITY_ID
AND RP.RETRIEVAL_PROCESS_ID = RR.RETRIEVAL_PROCESS_ID