HRC_DL_EXT_ERROR_DETAILS_V

Details

• Schema: FUSION

• Object owner: HRC

• Object type: VIEW

Columns

Name

SRC_LN_ID SRC_TBL_NM DAT_LINE_NUM VO_MAPPING_ID USERKEY UI_DATE_FROM UI_DATE_TO P_EFFECTIVE_START_DATE P_EFFECTIVE_END_DATE P_EFFECTIVE_SEQUENCE P_EFFECTIVE_LATEST_CHANGE KEY_GUID KEY_SURROGATE_ID KEY_SOURCE_OWNER KEY_SOURCE_ID SOURCE_TABLE_NAME SOURCE_REF_NAME001 SOURCE_REF_NAME002 SOURCE_REF_NAME003 SOURCE_REF_NAME004 SOURCE_REF_NAME005 SOURCE_REF_NAME006 SOURCE_REFERENCE001 SOURCE_REFERENCE002 SOURCE_REFERENCE003 SOURCE_REFERENCE004 SOURCE_REFERENCE005 SOURCE_REFERENCE006 BUS_OBJ_FILE_DISCRIMINATOR

Query

SQL_Statement

select SRC_LN_ID ,SRC_TBL_NM ,DAT_LINE_NUM ,VO_MAPPING_ID ,USERKEY ,UI_DATE_FROM ,UI_DATE_TO ,P_EFFECTIVE_START_DATE ,P_EFFECTIVE_END_DATE ,P_EFFECTIVE_SEQUENCE ,P_EFFECTIVE_LATEST_CHANGE ,KEY_GUID ,KEY_SURROGATE_ID ,KEY_SOURCE_OWNER ,KEY_SOURCE_ID ,SOURCE_TABLE_NAME ,SOURCE_REF_NAME001 ,SOURCE_REF_NAME002 ,SOURCE_REF_NAME003 ,SOURCE_REF_NAME004 ,SOURCE_REF_NAME005 ,SOURCE_REF_NAME006 ,SOURCE_REFERENCE001 ,SOURCE_REFERENCE002 ,SOURCE_REFERENCE003 ,SOURCE_REFERENCE004 ,SOURCE_REFERENCE005 ,SOURCE_REFERENCE006 ,BUS_OBJ_FILE_DISCRIMINATOR from (SELECT A.*,BO.BUS_OBJ_FILE_DISCRIMINATOR FROM(SELECT PL.PHYSICAL_LINE_ID SRC_LN_ID ,'HRC_DL_PHYSICAL_LINES' SRC_TBL_NM ,FL.SEQ_NUM DAT_LINE_NUM ,PL.VO_MAPPING_ID ,PL.UI_USER_KEY USERKEY ,PL.UI_DATE_FROM ,PL.UI_DATE_TO ,PL.P_EFFECTIVE_START_DATE ,PL.P_EFFECTIVE_END_DATE ,PL.P_EFFECTIVE_SEQUENCE ,PL.P_EFFECTIVE_LATEST_CHANGE ,RW.KEY_GUID ,RW.KEY_SURROGATE_ID ,RW.KEY_SOURCE_OWNER ,RW.KEY_SOURCE_ID ,SK.SOURCE_TABLE_NAME ,SK.SOURCE_REF_NAME001 ,SK.SOURCE_REF_NAME002 ,SK.SOURCE_REF_NAME003 ,SK.SOURCE_REF_NAME004 ,SK.SOURCE_REF_NAME005 ,SK.SOURCE_REF_NAME006 ,PL.SOURCE_REFERENCE001 ,PL.SOURCE_REFERENCE002 ,PL.SOURCE_REFERENCE003 ,PL.SOURCE_REFERENCE004 ,PL.SOURCE_REFERENCE005 ,PL.SOURCE_REFERENCE006 FROM HRC_DL_PHYSICAL_LINES PL ,HRC_DL_FILE_ROWS RW ,HRC_DL_FILE_LINES FL ,HRC_DL_FILE_HEADERS FH ,HRC_DL_SOURCE_KEYS SK WHERE PL.ROW_ID=RW.ROW_ID AND RW.LINE_ID=FL.LINE_ID AND SK.DATA_SET_BUS_OBJ_ID=PL.DATA_SET_BUS_OBJ_ID AND FH.HEADER_ID=RW.HEADER_ID AND FH.DATA_SET_BUS_OBJ_ID=PL.DATA_SET_BUS_OBJ_ID AND SK.BUSINESS_OBJECT_ID=FH.BUSINESS_OBJECT_ID UNION SELECT PL.PHYSICAL_LINE_ID SRC_LN_ID ,'HRC_DL_PHYSICAL_LINES' SRC_TBL_NM ,FL.SEQ_NUM DAT_LINE_NUM ,PL.VO_MAPPING_ID ,PL.UI_USER_KEY USERKEY ,PL.UI_DATE_FROM ,PL.UI_DATE_TO ,PL.P_EFFECTIVE_START_DATE ,PL.P_EFFECTIVE_END_DATE ,PL.P_EFFECTIVE_SEQUENCE ,PL.P_EFFECTIVE_LATEST_CHANGE ,RW.KEY_GUID ,RW.KEY_SURROGATE_ID ,RW.KEY_SOURCE_OWNER ,RW.KEY_SOURCE_ID ,SK.SOURCE_TABLE_NAME ,SK.SOURCE_REF_NAME001 ,SK.SOURCE_REF_NAME002 ,SK.SOURCE_REF_NAME003 ,SK.SOURCE_REF_NAME004 ,SK.SOURCE_REF_NAME005 ,SK.SOURCE_REF_NAME006 ,PL.SOURCE_REFERENCE001 ,PL.SOURCE_REFERENCE002 ,PL.SOURCE_REFERENCE003 ,PL.SOURCE_REFERENCE004 ,PL.SOURCE_REFERENCE005 ,PL.SOURCE_REFERENCE006 FROM hrc_dl_stg_physical_lines PL ,hrc_dl_stg_file_rows RW ,HRC_DL_FILE_LINES FL ,HRC_DL_FILE_HEADERS FH ,HRC_DL_SOURCE_KEYS SK WHERE PL.ROW_ID=RW.ROW_ID AND RW.LINE_ID=FL.LINE_ID AND SK.DATA_SET_BUS_OBJ_ID=PL.DATA_SET_BUS_OBJ_ID AND FH.HEADER_ID=RW.HEADER_ID AND FH.DATA_SET_BUS_OBJ_ID=PL.DATA_SET_BUS_OBJ_ID AND SK.BUSINESS_OBJECT_ID=FH.BUSINESS_OBJECT_ID UNION SELECT LO.LOGICAL_LINE_ID SRC_LN_ID ,'HRC_DL_LOGICAL_LINES' SRC_TBL_NM ,FL.SEQ_NUM DAT_LINE_NUM ,LO.VO_MAPPING_ID ,LO.UI_USER_KEY USERKEY ,NULL ,NULL ,RO.P_EFFECTIVE_START_DATE ,RO.P_EFFECTIVE_END_DATE ,RO.P_EFFECTIVE_SEQUENCE ,RO.P_EFFECTIVE_LATEST_CHANGE ,RO.KEY_GUID ,RO.KEY_SURROGATE_ID ,RO.KEY_SOURCE_OWNER ,RO.KEY_SOURCE_ID ,SK.SOURCE_TABLE_NAME ,SK.SOURCE_REF_NAME001 ,SK.SOURCE_REF_NAME002 ,SK.SOURCE_REF_NAME003 ,SK.SOURCE_REF_NAME004 ,SK.SOURCE_REF_NAME005 ,SK.SOURCE_REF_NAME006 ,RO.SOURCE_REFERENCE001 ,RO.SOURCE_REFERENCE002 ,RO.SOURCE_REFERENCE003 ,RO.SOURCE_REFERENCE004 ,RO.SOURCE_REFERENCE005 ,RO.SOURCE_REFERENCE006 FROM HRC_DL_LOGICAL_LINES LO ,HRC_DL_FILE_ROWS RO ,HRC_DL_FILE_LINES FL ,HRC_DL_SOURCE_KEYS SK ,HRC_DL_FILE_HEADERS FH WHERE RO.LOGICAL_LINE_ID=LO.LOGICAL_LINE_ID AND RO.LINE_ID=FL.LINE_ID AND FH.HEADER_ID=RO.HEADER_ID AND FH.DATA_SET_BUS_OBJ_ID=LO.DATA_SET_BUS_OBJ_ID AND SK.DATA_SET_BUS_OBJ_ID=LO.DATA_SET_BUS_OBJ_ID AND SK.BUSINESS_OBJECT_ID=FH.BUSINESS_OBJECT_ID UNION SELECT LO.LOGICAL_LINE_ID SRC_LN_ID ,'HRC_DL_LOGICAL_LINES' SRC_TBL_NM ,FL.SEQ_NUM DAT_LINE_NUM ,LO.VO_MAPPING_ID ,LO.UI_USER_KEY USERKEY ,NULL ,NULL ,RO.P_EFFECTIVE_START_DATE ,RO.P_EFFECTIVE_END_DATE ,RO.P_EFFECTIVE_SEQUENCE ,RO.P_EFFECTIVE_LATEST_CHANGE ,RO.KEY_GUID ,RO.KEY_SURROGATE_ID ,RO.KEY_SOURCE_OWNER ,RO.KEY_SOURCE_ID ,SK.SOURCE_TABLE_NAME ,SK.SOURCE_REF_NAME001 ,SK.SOURCE_REF_NAME002 ,SK.SOURCE_REF_NAME003 ,SK.SOURCE_REF_NAME004 ,SK.SOURCE_REF_NAME005 ,SK.SOURCE_REF_NAME006 ,RO.SOURCE_REFERENCE001 ,RO.SOURCE_REFERENCE002 ,RO.SOURCE_REFERENCE003 ,RO.SOURCE_REFERENCE004 ,RO.SOURCE_REFERENCE005 ,RO.SOURCE_REFERENCE006 FROM hrc_dl_stg_logical_lines LO ,hrc_dl_stg_file_rows RO ,HRC_DL_FILE_LINES FL ,HRC_DL_SOURCE_KEYS SK ,HRC_DL_FILE_HEADERS FH WHERE RO.LOGICAL_LINE_ID=LO.LOGICAL_LINE_ID AND RO.LINE_ID=FL.LINE_ID AND FH.HEADER_ID=RO.HEADER_ID AND FH.DATA_SET_BUS_OBJ_ID=LO.DATA_SET_BUS_OBJ_ID AND SK.DATA_SET_BUS_OBJ_ID=LO.DATA_SET_BUS_OBJ_ID AND SK.BUSINESS_OBJECT_ID=FH.BUSINESS_OBJECT_ID UNION SELECT RW.ROW_ID SRC_LN_ID ,'HRC_DL_FILE_ROWS' SRC_TBL_NM ,FL.SEQ_NUM DAT_LINE_NUM ,RW.VO_MAPPING_ID ,NULL ,NULL ,NULL ,RW.P_EFFECTIVE_START_DATE ,RW.P_EFFECTIVE_END_DATE ,RW.P_EFFECTIVE_SEQUENCE ,RW.P_EFFECTIVE_LATEST_CHANGE ,RW.KEY_GUID ,RW.KEY_SURROGATE_ID ,RW.KEY_SOURCE_OWNER ,RW.KEY_SOURCE_ID ,SK.SOURCE_TABLE_NAME ,SK.SOURCE_REF_NAME001 ,SK.SOURCE_REF_NAME002 ,SK.SOURCE_REF_NAME003 ,SK.SOURCE_REF_NAME004 ,SK.SOURCE_REF_NAME005 ,SK.SOURCE_REF_NAME006 ,RW.SOURCE_REFERENCE001 ,RW.SOURCE_REFERENCE002 ,RW.SOURCE_REFERENCE003 ,RW.SOURCE_REFERENCE004 ,RW.SOURCE_REFERENCE005 ,RW.SOURCE_REFERENCE006 FROM HRC_DL_FILE_ROWS RW ,HRC_DL_FILE_LINES FL ,HRC_DL_FILE_HEADERS FH ,HRC_DL_SOURCE_KEYS SK WHERE RW.LINE_ID=FL.LINE_ID AND FH.HEADER_ID=RW.HEADER_ID AND FH.DATA_SET_BUS_OBJ_ID=FL.DATA_SET_BUS_OBJ_ID AND SK.BUSINESS_OBJECT_ID=FH.BUSINESS_OBJECT_ID AND SK.DATA_SET_BUS_OBJ_ID=FL.DATA_SET_BUS_OBJ_ID UNION SELECT RW.ROW_ID SRC_LN_ID ,'HRC_DL_FILE_ROWS' SRC_TBL_NM ,FL.SEQ_NUM DAT_LINE_NUM ,RW.VO_MAPPING_ID ,NULL ,NULL ,NULL ,RW.P_EFFECTIVE_START_DATE ,RW.P_EFFECTIVE_END_DATE ,RW.P_EFFECTIVE_SEQUENCE ,RW.P_EFFECTIVE_LATEST_CHANGE ,RW.KEY_GUID ,RW.KEY_SURROGATE_ID ,RW.KEY_SOURCE_OWNER ,RW.KEY_SOURCE_ID ,SK.SOURCE_TABLE_NAME ,SK.SOURCE_REF_NAME001 ,SK.SOURCE_REF_NAME002 ,SK.SOURCE_REF_NAME003 ,SK.SOURCE_REF_NAME004 ,SK.SOURCE_REF_NAME005 ,SK.SOURCE_REF_NAME006 ,RW.SOURCE_REFERENCE001 ,RW.SOURCE_REFERENCE002 ,RW.SOURCE_REFERENCE003 ,RW.SOURCE_REFERENCE004 ,RW.SOURCE_REFERENCE005 ,RW.SOURCE_REFERENCE006 FROM hrc_dl_stg_file_rows RW ,HRC_DL_FILE_LINES FL ,HRC_DL_FILE_HEADERS FH ,HRC_DL_SOURCE_KEYS SK WHERE RW.LINE_ID=FL.LINE_ID AND FH.HEADER_ID=RW.HEADER_ID AND FH.DATA_SET_BUS_OBJ_ID=FL.DATA_SET_BUS_OBJ_ID AND SK.BUSINESS_OBJECT_ID=FH.BUSINESS_OBJECT_ID AND SK.DATA_SET_BUS_OBJ_ID=FL.DATA_SET_BUS_OBJ_ID UNION SELECT B.* ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL FROM (SELECT FL.LINE_ID SRC_LN_ID ,'HRC_DL_FILE_LINES' SRC_TBL_NM ,FL.SEQ_NUM DAT_LINE_NUM ,NULL FROM HRC_DL_MESSAGE_LINES MSG ,HRC_DL_DATA_SET_BUS_OBJS DSBO ,HRC_DL_FILE_LINES FL WHERE MSG.DATA_SET_BUS_OBJ_ID=DSBO.DATA_SET_BUS_OBJ_ID AND MSG.MESSAGE_SOURCE_LINE_ID=FL.LINE_ID AND MSG.MESSAGE_SOURCE_TABLE_NAME='HRC_DL_FILE_LINES' UNION ALL SELECT HD.HEADER_ID SRC_LN_ID ,'HRC_DL_FILE_HEADERS' SRC_TBL_NM ,FL.SEQ_NUM DAT_LINE_NUM ,HD.VO_MAPPING_ID FROM HRC_DL_FILE_HEADERS HD ,HRC_DL_FILE_LINES FL WHERE HD.LINE_ID=FL.LINE_ID )B)A, HRC_DL_BUSINESS_OBJECTS BO, HRC_DL_VO_MAPS VM WHERE VM.BUSINESS_OBJECT_ID = BO.BUSINESS_OBJECT_ID(+) AND A.VO_MAPPING_ID = VM.VO_MAPPING_ID(+) )