HRC_TXN_FND_BPM_TASK_VL

Details

• Schema: FUSION

• Object owner: HRC

• Object type: VIEW

Columns

Name

DOMAIN TASK_ID TASK_NUMBER TASK_QNAME TASK_DEFINITION_NAME TASK_TITLE ROOT_TASK_ID PARENT_TASK_ID IDENTIFICATION_KEY DUE_DATE EXPIRATION_DATE INITIATED_BY INITIATED_DATE COMPLETED_BY COMPLETED_DATE STATUS_CODE OUTCOME_CODE OUTCOME CATEGORY_CODE CATEGORY COMPOSITE_NAME COMPOSITE_VERSION TASK_CREATION_DATE TASK_CREATED_BY TASK_LAST_UPDATE_DATE TASK_LAST_UPDATED_BY TASK_LAST_UPDATE_LOGIN PROCESS_ID COMPOSITE_ID TASK_FILE_NAME RULE_FILE_NAME ACTIVE ENTERPRISE_ID MODULE_ID TXN_MODULE_IDENTIFIER ARM_PROCESS_CREATED_BY ARM_PROCESS_CREATION_DATE ARM_PROCESS_LAST_UPDATED_BY ARM_PROCESS_LAST_UPDATE_DATE ARM_PROCESS_LAST_UPDATE_LOGIN ARM_PROCESS_OBJ_VERSION_NUMBER NAME DESCRIPTION OBJECT_ID

Query

SQL_Statement

SELECT FND_BPM_TASK_VL.DOMAIN, FND_BPM_TASK_VL.TASK_ID, FND_BPM_TASK_VL.TASK_NUMBER, FND_BPM_TASK_VL.TASK_QNAME, FND_BPM_TASK_VL.TASK_DEFINITION_NAME, FND_BPM_TASK_VL.TASK_TITLE, FND_BPM_TASK_VL.ROOT_TASK_ID, FND_BPM_TASK_VL.PARENT_TASK_ID, FND_BPM_TASK_VL.IDENTIFICATION_KEY, FND_BPM_TASK_VL.DUE_DATE, FND_BPM_TASK_VL.EXPIRATION_DATE, FND_BPM_TASK_VL.INITIATED_BY, FND_BPM_TASK_VL.INITIATED_DATE, FND_BPM_TASK_VL.COMPLETED_BY, FND_BPM_TASK_VL.COMPLETED_DATE, FND_BPM_TASK_VL.STATUS_CODE, FND_BPM_TASK_VL.OUTCOME_CODE, FND_BPM_TASK_VL.OUTCOME, FND_BPM_TASK_VL.CATEGORY_CODE, FND_BPM_TASK_VL.CATEGORY, FND_BPM_TASK_VL.COMPOSITE_NAME, FND_BPM_TASK_VL.COMPOSITE_VERSION, FND_BPM_TASK_VL.CREATION_DATE TASK_CREATION_DATE, FND_BPM_TASK_VL.CREATED_BY TASK_CREATED_BY, FND_BPM_TASK_VL.LAST_UPDATE_DATE TASK_LAST_UPDATE_DATE, FND_BPM_TASK_VL.LAST_UPDATED_BY TASK_LAST_UPDATED_BY, FND_BPM_TASK_VL.LAST_UPDATE_LOGIN TASK_LAST_UPDATE_LOGIN, HRC_ARM_PROCESS_VL.PROCESS_ID, HRC_ARM_PROCESS_VL.COMPOSITE_ID, HRC_ARM_PROCESS_VL.TASK_FILE_NAME, HRC_ARM_PROCESS_VL.RULE_FILE_NAME, HRC_ARM_PROCESS_VL.ACTIVE, HRC_ARM_PROCESS_VL.ENTERPRISE_ID, HRC_ARM_PROCESS_VL.MODULE_ID, HRC_ARM_PROCESS_VL.TXN_MODULE_IDENTIFIER, HRC_ARM_PROCESS_VL.CREATED_BY ARM_PROCESS_CREATED_BY, HRC_ARM_PROCESS_VL.CREATION_DATE ARM_PROCESS_CREATION_DATE, HRC_ARM_PROCESS_VL.LAST_UPDATED_BY ARM_PROCESS_LAST_UPDATED_BY, HRC_ARM_PROCESS_VL.LAST_UPDATE_DATE ARM_PROCESS_LAST_UPDATE_DATE, HRC_ARM_PROCESS_VL.LAST_UPDATE_LOGIN ARM_PROCESS_LAST_UPDATE_LOGIN, HRC_ARM_PROCESS_VL.OBJECT_VERSION_NUMBER ARM_PROCESS_OBJ_VERSION_NUMBER, HRC_ARM_PROCESS_VL.NAME, HRC_ARM_PROCESS_VL.DESCRIPTION, nvl(HRC_TXN_HEADER.OBJECT_ID, HRC_TXN_HEADER_ARCHIVE.OBJECT_ID) as OBJECT_ID FROM FND_BPM_TASK_VL, hrc_txn_header, HRC_TXN_DATA, HRC_TXN_HEADER_ARCHIVE, HRC_TXN_DATA_ARCHIVE, HRC_ARM_PROCESS_VL WHERE TO_CHAR(HRC_TXN_HEADER.transaction_id(+)) =FND_BPM_TASK_VL.identification_keY AND HRC_TXN_HEADER.TRANSACTION_ID = HRC_TXN_DATA.TRANSACTION_ID (+) and TO_CHAR(HRC_TXN_HEADER_ARCHIVE.transaction_id(+)) =FND_BPM_TASK_VL.identification_keY AND HRC_TXN_HEADER_ARCHIVE.TRANSACTION_ID = HRC_TXN_DATA_ARCHIVE.TRANSACTION_ID (+) AND FND_BPM_TASK_VL.TASK_DEFINITION_NAME = HRC_ARM_PROCESS_VL.TASK_FILE_NAME and HRC_ARM_PROCESS_VL.FAMILY='HCM' AND (HRC_TXN_HEADER.MODULE_IDENTIFIER IS NULL OR HRC_ARM_PROCESS_VL.TXN_MODULE_IDENTIFIER IS NULL OR HRC_ARM_PROCESS_VL.process_id =HRC_TXN_HEADER.process_id) AND (HRC_TXN_HEADER_ARCHIVE.MODULE_IDENTIFIER IS NULL OR HRC_ARM_PROCESS_VL.TXN_MODULE_IDENTIFIER IS NULL OR HRC_ARM_PROCESS_VL.process_id =HRC_TXN_HEADER_ARCHIVE.process_id) AND(HRC_TXN_DATA.STATUS(+)='APPROVED' or HRC_TXN_DATA.STATUS(+)='REJECTED' or HRC_TXN_DATA.STATUS(+)='CANCELLED' ) AND(HRC_TXN_DATA_ARCHIVE.STATUS(+)='APPROVED' or HRC_TXN_DATA_ARCHIVE.STATUS(+)='REJECTED' or HRC_TXN_DATA_ARCHIVE.STATUS(+)='CANCELLED' )