HRC_ARM_PROCESS_VL

Details

• Schema: FUSION

• Object owner: HRC

• Object type: VIEW

Columns

Name

PROCESS_ID COMPOSITE_ID TASK_FILE_NAME RULE_FILE_NAME ACTIVE ENTERPRISE_ID MODULE_ID TXN_MODULE_IDENTIFIER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER NAME DESCRIPTION CATEGORY_CODE CATEGORY_NAME SUBCATEGORY_CODE SUBCATEGORY_NAME FAMILY REST_RESOURCE_KEY RESOURCE_CONTEXT_SHORT_NAME ADDITIONAL_REST_RESOURCE BYPASS_SUPPORTED ASYNC_BYPASS_SUPPORTED APPROVAL_OVERRIDE_SUPPORTED IS_TXN_FRAMEWORK_PROCESS TXN_SUB_MODULE_IDENTIFIER ARCHIVE_PERIOD IS_RULE_SIMULATION_SUPPORTED RULE_CONFIGURE_MODE RESUBMIT_CALLBACK_CLASS CONTEXT_PARAM_FETCH_CALLBACK IS_PARALLEL_TXN_SUPPORTED

Query

SQL_Statement

SELECT HAP.PROCESS_ID PROCESS_ID, HAP.COMPOSITE_ID COMPOSITE_ID, HAP.TASK_FILE_NAME TASK_FILE_NAME, HAP.RULE_FILE_NAME RULE_FILE_NAME, HAP.ACTIVE ACTIVE, HAP.ENTERPRISE_ID ENTERPRISE_ID, HAP.MODULE_ID MODULE_ID, HAP.TXN_MODULE_IDENTIFIER TXN_MODULE_IDENTIFIER, HAP.CREATED_BY CREATED_BY, HAP.CREATION_DATE CREATION_DATE, HAP.LAST_UPDATED_BY LAST_UPDATED_BY, HAP.LAST_UPDATE_DATE LAST_UPDATE_DATE, HAP.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, HAP.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, HAPTL.NAME NAME, HAPTL.DESCRIPTION DESCRIPTION, HAP.CATEGORY_CODE CATEGORY_CODE, HAPTL.CATEGORY_NAME CATEGORY_NAME, HAP.SUBCATEGORY_CODE SUBCATEGORY_CODE, HAPTL.SUBCATEGORY_NAME SUBCATEGORY_NAME, HAP.FAMILY FAMILY, HAP.REST_RESOURCE_KEY, HAP.RESOURCE_CONTEXT_SHORT_NAME, HAP.ADDITIONAL_REST_RESOURCE, HAP.BYPASS_SUPPORTED, HAP.ASYNC_BYPASS_SUPPORTED, HAP.APPROVAL_OVERRIDE_SUPPORTED, HAP.IS_TXN_FRAMEWORK_PROCESS, HAP.TXN_SUB_MODULE_IDENTIFIER, HAP.ARCHIVE_PERIOD, HAP.IS_RULE_SIMULATION_SUPPORTED, HAP.RULE_CONFIGURE_MODE, HAP.RESUBMIT_CALLBACK_CLASS, HAP.CONTEXT_PARAM_FETCH_CALLBACK, HAP.IS_PARALLEL_TXN_SUPPORTED FROM HRC_ARM_PROCESS_B HAP, HRC_ARM_PROCESS_TL HAPTL WHERE HAP.PROCESS_ID = HAPTL.PROCESS_ID AND HAPTL.LANGUAGE = USERENV('LANG')