HWM_XFR_GRP_FAILURE_V

Details

• Schema: FUSION

• Object owner: HWM

• Object type: VIEW

Columns

Name
XFR_JOB_ID XFR_GRP_ID TM_REC_GRP_ID START_TIME STOP_TIME TCSMRS_ID RESOURCE_ID LAST_UPDATE_DATE ORIG_TM_REC_GRP_ID FAILURE_COUNT

Query

SQL_Statement

SELECT XREC.XFR_JOB_ID, XREC.XFR_GRP_ID, XREC.TM_REC_GRP_ID, GRP.START_TIME, GRP.STOP_TIME, DEF.TCSMRS_ID, GRP.RESOURCE_ID, JOB.LAST_UPDATE_DATE, GRP.ORIG_TM_REC_GRP_ID, COUNT(*) AS FAILURE_COUNT FROM HWM_XFR_JOB JOB, HWM_TM_REC_GRP GRP, HWM_XFR_TRANS XREC, HWM_TM_REC REC, HWM_TM_STATUSES STA, HWM_TM_STATUS_DEFINITIONS_VL DEF WHERE XREC.XFR_ROW_STATUS = 'FAILWFM' AND XREC.XFR_JOB_ID=JOB.XFR_JOB_ID AND STA.TM_STATUS_DEF_ID = DEF. TM_STATUS_DEF_ID AND DEF.DEFINITIONCODE = 'A_XFR_STATUS' AND (SYSDATE BETWEEN STA.DATE_FROM AND STA.DATE_TO) AND STA.STATUS_VALUE = 'FAILWFM' AND STA.TM_BLDG_BLK_ID = XREC.TM_REC_ID AND STA.TM_BLDG_BLK_VERSION = XREC.TM_REC_VERSION AND XREC.TM_REC_ID = REC.TM_REC_ID AND XREC.TM_REC_VERSION = REC.TM_REC_VERSION AND GRP.TM_REC_GRP_ID=XREC.TM_REC_GRP_ID AND GRP.TM_REC_GRP_VERSION=XREC.TM_REC_GRP_VERSION AND GRP.DELETE_FLAG IS NULL AND NVL(GRP.LATEST_VERSION,'N') = 'Y' AND NVL(REC.LATEST_VERSION,'N') = 'Y' GROUP BY XREC.XFR_JOB_ID, XREC.XFR_GRP_ID, XREC.TM_REC_GRP_ID, GRP.ORIG_TM_REC_GRP_ID, GRP.START_TIME, GRP.STOP_TIME, DEF.TCSMRS_ID, GRP.RESOURCE_ID, JOB.LAST_UPDATE_DATE