eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.MTH_ERR_COUNT_V

Source

View Text - Preformatted


SELECT TABLE_NAME, UNREVIEWED, REPROCESS_READY, INTEGRATOR_NAME FROM ( SELECT 'MTH_ASSET_ERR' TABLE_NAME, nvl(sum(decode(REPROCESS_READY_YN,'Y',0,'D',0,1)),0) UNREVIEWED, nvl(sum(decode(REPROCESS_READY_YN,'Y',1,'D',1,0)),0) REPROCESS_READY, 'MTH_ERR_ASST_INTG' INTEGRATOR_NAME FROM MTH_ASSET_ERR UNION ALL SELECT 'MTH_DAY_ERR', nvl(sum(decode(REPROCESS_READY_YN,'Y',0,'D',0,1)),0), nvl(sum(decode(REPROCESS_READY_YN,'Y',1,'D',1,0)),0), 'MTH_ERR_DY_INTG' FROM MTH_DAY_ERR UNION ALL SELECT 'MTH_DIM_HIERARCHY_ERR', nvl(sum(decode(REPROCESS_READY_YN,'Y',0,'D',0,1)),0), nvl(sum(decode(REPROCESS_READY_YN,'Y',1,'D',1,0)),0), 'MTH_ERR_DMHRRCHY_INTG' FROM MTH_DIM_HIERARCHY_ERR UNION ALL SELECT 'MTH_DIM_LEVEL_LOOKUP_ERR', nvl(sum(decode(REPROCESS_READY_YN,'Y',0,'D',0,1)),0), nvl(sum(decode(REPROCESS_READY_YN,'Y',1,'D',1,0)),0), 'MTH_ERR_DMLVLLKP_INTG' FROM MTH_DIM_LEVEL_LOOKUP_ERR UNION ALL SELECT 'MTH_ENTITY_PLANNED_USAGE_ERR', nvl(sum(decode(REPROCESS_READY_YN,'Y',0,'D',0,1)),0), nvl(sum(decode(REPROCESS_READY_YN,'Y',1,'D',1,0)),0), 'MTH_ERR_ENTTYPLNNDSG_INTG' FROM MTH_ENTITY_PLANNED_USAGE_ERR UNION ALL SELECT 'MTH_EQUIPMENTS_ERR', nvl(sum(decode(REPROCESS_READY_YN,'Y',0,'D',0,1)),0), nvl(sum(decode(REPROCESS_READY_YN,'Y',1,'D',1,0)),0), 'MTH_ERR_EQPMNTS_INTG' FROM MTH_EQUIPMENTS_ERR UNION ALL SELECT 'MTH_EQUIPMENT_REASON_SETUP_ERR', nvl(sum(decode(REPROCESS_READY_YN,'Y',0,'D',0,1)),0), nvl(sum(decode(REPROCESS_READY_YN,'Y',1,'D',1,0)),0), 'MTH_ERR_EQPMNTRSNSTP_INTG' FROM MTH_EQUIPMENT_REASON_SETUP_ERR UNION ALL SELECT 'MTH_EQUIPMENT_SHIFTS_ERR', nvl(sum(decode(REPROCESS_READY_YN,'Y',0,'D',0,1)),0), nvl(sum(decode(REPROCESS_READY_YN,'Y',1,'D',1,0)),0), 'MTH_ERR_EQPMNTSHFTS_INTG' FROM MTH_EQUIPMENT_SHIFTS_ERR UNION ALL SELECT 'MTH_EQUIP_ENTITIES_ERR', nvl(sum(decode(REPROCESS_READY_YN,'Y',0,'D',0,1)),0), nvl(sum(decode(REPROCESS_READY_YN,'Y',1,'D',1,0)),0), 'MTH_ERR_EQPNTTS_INTG' FROM MTH_EQUIP_ENTITIES_ERR UNION ALL SELECT 'MTH_EQUIP_HIERARCHY_ERR', nvl(sum(decode(REPROCESS_READY_YN,'Y',0,'D',0,1)),0), nvl(sum(decode(REPROCESS_READY_YN,'Y',1,'D',1,0)),0), 'MTH_ERR_EQPHRRCHY_INTG' FROM MTH_EQUIP_HIERARCHY_ERR UNION ALL SELECT 'MTH_EQUIP_OUTPUT_ERR', nvl(sum(decode(REPROCESS_READY_YN,'Y',0,'D',0,1)),0), nvl(sum(decode(REPROCESS_READY_YN,'Y',1,'D',1,0)),0), 'MTH_ERR_EQPTPT_INTG' FROM MTH_EQUIP_OUTPUT_ERR UNION ALL SELECT 'MTH_EQUIP_PROD_SCHEDULE_ERR', nvl(sum(decode(REPROCESS_READY_YN,'Y',0,'D',0,1)),0), nvl(sum(decode(REPROCESS_READY_YN,'Y',1,'D',1,0)),0), 'MTH_ERR_EQPPRDSCHDL_INTG' FROM MTH_EQUIP_PROD_SCHEDULE_ERR UNION ALL SELECT 'MTH_EQUIP_STANDARD_RATES_ERR', nvl(sum(decode(REPROCESS_READY_YN,'Y',0,'D',0,1)),0), nvl(sum(decode(REPROCESS_READY_YN,'Y',1,'D',1,0)),0), 'MTH_ERR_EQPSTNDRDRTS_INTG' FROM MTH_EQUIP_STANDARD_RATES_ERR UNION ALL SELECT 'MTH_EQUIP_STATUSES_ERR', nvl(sum(decode(REPROCESS_READY_YN,'Y',0,'D',0,1)),0), nvl(sum(decode(REPROCESS_READY_YN,'Y',1,'D',1,0)),0), 'MTH_ERR_EQPSTTSS_INTG' FROM MTH_EQUIP_STATUSES_ERR UNION ALL SELECT 'MTH_EVENT_ACTION_SETUP_ERR', nvl(sum(decode(REPROCESS_READY_YN,'Y',0,'D',0,1)),0), nvl(sum(decode(REPROCESS_READY_YN,'Y',1,'D',1,0)),0), 'MTH_ERR_EVNTCTNSTP_INTG' FROM MTH_EVENT_ACTION_SETUP_ERR UNION ALL SELECT 'MTH_ITEMS_ERR', nvl(sum(decode(REPROCESS_READY_YN,'Y',0,'D',0,1)),0), nvl(sum(decode(REPROCESS_READY_YN,'Y',1,'D',1,0)),0), 'MTH_ERR_ITMS_INTG' FROM MTH_ITEMS_ERR UNION ALL SELECT 'MTH_ITEM_CATEGORIES_ERR', nvl(sum(decode(REPROCESS_READY_YN,'Y',0,'D',0,1)),0), nvl(sum(decode(REPROCESS_READY_YN,'Y',1,'D',1,0)),0), 'MTH_ERR_ITMCTGRS_INTG' FROM MTH_ITEM_CATEGORIES_ERR UNION ALL SELECT 'MTH_ITEM_COST_ERR', nvl(sum(decode(REPROCESS_READY_YN,'Y',0,'D',0,1)),0), nvl(sum(decode(REPROCESS_READY_YN,'Y',1,'D',1,0)),0), 'MTH_ERR_ITMCST_INTG' FROM MTH_ITEM_COST_ERR UNION ALL SELECT 'MTH_ITEM_HIERARCHY_ERR', nvl(sum(decode(REPROCESS_READY_YN,'Y',0,'D',0,1)),0), nvl(sum(decode(REPROCESS_READY_YN,'Y',1,'D',1,0)),0), 'MTH_ERR_ITMHRRCHY_INTG' FROM MTH_ITEM_HIERARCHY_ERR UNION ALL SELECT 'MTH_METER_READINGS_ERR', nvl(sum(decode(REPROCESS_READY_YN,'Y',0,'D',0,1)),0), nvl(sum(decode(REPROCESS_READY_YN,'Y',1,'D',1,0)),0), 'MTH_ERR_MTRRDNGS_INTG' FROM MTH_METER_READINGS_ERR UNION ALL SELECT 'MTH_MTL_CONSUMED_TXN_LOT_ERR', nvl(sum(decode(REPROCESS_READY_YN,'Y',0,'D',0,1)),0), nvl(sum(decode(REPROCESS_READY_YN,'Y',1,'D',1,0)),0), 'MTH_ERR_MTLCNSMDTXNL_INTG' FROM MTH_MTL_CONSUMED_TXN_LOT_ERR UNION ALL SELECT 'MTH_MTL_PRODUCED_TXN_LOT_ERR', nvl(sum(decode(REPROCESS_READY_YN,'Y',0,'D',0,1)),0), nvl(sum(decode(REPROCESS_READY_YN,'Y',1,'D',1,0)),0), 'MTH_ERR_MTLPRDCDTXNL_INTG' FROM MTH_MTL_PRODUCED_TXN_LOT_ERR UNION ALL SELECT 'MTH_PERIOD_ERR', nvl(sum(decode(REPROCESS_READY_YN,'Y',0,'D',0,1)),0), nvl(sum(decode(REPROCESS_READY_YN,'Y',1,'D',1,0)),0), 'MTH_ERR_PRD_INTG' FROM MTH_PERIOD_ERR UNION ALL SELECT 'MTH_PERSONNEL_ERR', nvl(sum(decode(REPROCESS_READY_YN,'Y',0,'D',0,1)),0), nvl(sum(decode(REPROCESS_READY_YN,'Y',1,'D',1,0)),0), 'MTH_ERR_PRSNNL_INTG' FROM MTH_PERSONNEL_ERR UNION ALL SELECT 'MTH_PRODUCTION_SCHEDULES_ERR', nvl(sum(decode(REPROCESS_READY_YN,'Y',0,'D',0,1)),0), nvl(sum(decode(REPROCESS_READY_YN,'Y',1,'D',1,0)),0), 'MTH_ERR_PRDCTNSCHDLS_INTG' FROM MTH_PRODUCTION_SCHEDULES_ERR UNION ALL SELECT 'MTH_PRODUCTION_SEGMENTS_ERR', nvl(sum(decode(REPROCESS_READY_YN,'Y',0,'D',0,1)),0), nvl(sum(decode(REPROCESS_READY_YN,'Y',1,'D',1,0)),0), 'MTH_ERR_PRDCTNSGMNTS_INTG' FROM MTH_PRODUCTION_SEGMENTS_ERR UNION ALL SELECT 'MTH_PROD_MTL_CONSUMED_ERR', nvl(sum(decode(REPROCESS_READY_YN,'Y',0,'D',0,1)),0), nvl(sum(decode(REPROCESS_READY_YN,'Y',1,'D',1,0)),0), 'MTH_ERR_PRDMTLCNSMD_INTG' FROM MTH_PROD_MTL_CONSUMED_ERR UNION ALL SELECT 'MTH_PROD_MTL_CONSUMED_TXN_ERR', nvl(sum(decode(REPROCESS_READY_YN,'Y',0,'D',0,1)),0), nvl(sum(decode(REPROCESS_READY_YN,'Y',1,'D',1,0)),0), 'MTH_ERR_PRDMTLCNSMDT_INTG' FROM MTH_PROD_MTL_CONSUMED_TXN_ERR UNION ALL SELECT 'MTH_PROD_MTL_PRODUCED_ERR', nvl(sum(decode(REPROCESS_READY_YN,'Y',0,'D',0,1)),0), nvl(sum(decode(REPROCESS_READY_YN,'Y',1,'D',1,0)),0), 'MTH_ERR_PRDMTLPRDCD_INTG' FROM MTH_PROD_MTL_PRODUCED_ERR UNION ALL SELECT 'MTH_PROD_MTL_PRODUCED_TXN_ERR', nvl(sum(decode(REPROCESS_READY_YN,'Y',0,'D',0,1)),0), nvl(sum(decode(REPROCESS_READY_YN,'Y',1,'D',1,0)),0), 'MTH_ERR_PRDMTLPRDCDT_INTG' FROM MTH_PROD_MTL_PRODUCED_TXN_ERR UNION ALL SELECT 'MTH_PROD_SEGMENTS_TXN_ERR', nvl(sum(decode(REPROCESS_READY_YN,'Y',0,'D',0,1)),0), nvl(sum(decode(REPROCESS_READY_YN,'Y',1,'D',1,0)),0), 'MTH_ERR_PRDSGMNTSTXN_INTG' FROM MTH_PROD_SEGMENTS_TXN_ERR UNION ALL SELECT 'MTH_PROD_SUB_SEGMENTS_ERR', nvl(sum(decode(REPROCESS_READY_YN,'Y',0,'D',0,1)),0), nvl(sum(decode(REPROCESS_READY_YN,'Y',1,'D',1,0)),0), 'MTH_ERR_PRDSBSGMNTS_INTG' FROM MTH_PROD_SUB_SEGMENTS_ERR UNION ALL SELECT 'MTH_QUARTER_ERR', nvl(sum(decode(REPROCESS_READY_YN,'Y',0,'D',0,1)),0), nvl(sum(decode(REPROCESS_READY_YN,'Y',1,'D',1,0)),0), 'MTH_ERR_QRTR_INTG' FROM MTH_QUARTER_ERR UNION ALL SELECT 'MTH_RESOURCES_ERR', nvl(sum(decode(REPROCESS_READY_YN,'Y',0,'D',0,1)),0), nvl(sum(decode(REPROCESS_READY_YN,'Y',1,'D',1,0)),0), 'MTH_ERR_RSRCS_INTG' FROM MTH_RESOURCES_ERR UNION ALL SELECT 'MTH_RESOURCE_COST_ERR', nvl(sum(decode(REPROCESS_READY_YN,'Y',0,'D',0,1)),0), nvl(sum(decode(REPROCESS_READY_YN,'Y',1,'D',1,0)),0), 'MTH_ERR_RSRCCST_INTG' FROM MTH_RESOURCE_COST_ERR UNION ALL SELECT 'MTH_RESOURCE_REQUIREMENTS_ERR', nvl(sum(decode(REPROCESS_READY_YN,'Y',0,'D',0,1)),0), nvl(sum(decode(REPROCESS_READY_YN,'Y',1,'D',1,0)),0), 'MTH_ERR_RSRCRQRMNTS_INTG' FROM MTH_RESOURCE_REQUIREMENTS_ERR UNION ALL SELECT 'MTH_RESOURCE_TXN_ERR', nvl(sum(decode(REPROCESS_READY_YN,'Y',0,'D',0,1)),0), nvl(sum(decode(REPROCESS_READY_YN,'Y',1,'D',1,0)),0), 'MTH_ERR_RSRCTXN_INTG' FROM MTH_RESOURCE_TXN_ERR UNION ALL SELECT 'MTH_TAG_MASTER_ERR', nvl(sum(decode(REPROCESS_READY_YN,'Y',0,'D',0,1)),0), nvl(sum(decode(REPROCESS_READY_YN,'Y',1,'D',1,0)),0), 'MTH_ERR_TGMSTR_INTG' FROM MTH_TAG_MASTER_ERR UNION ALL SELECT 'MTH_TIME_HIERARCHY_ERR', nvl(sum(decode(REPROCESS_READY_YN,'Y',0,'D',0,1)),0), nvl(sum(decode(REPROCESS_READY_YN,'Y',1,'D',1,0)),0), 'MTH_ERR_TMHRRCHY_INTG' FROM MTH_TIME_HIERARCHY_ERR UNION ALL SELECT 'MTH_USER_DIM_ENTITIES_ERR', nvl(sum(decode(REPROCESS_READY_YN,'Y',0,'D',0,1)),0), nvl(sum(decode(REPROCESS_READY_YN,'Y',1,'D',1,0)),0), 'MTH_ERR_USRDMNTTS_INTG' FROM MTH_USER_DIM_ENTITIES_ERR UNION ALL SELECT 'MTH_USER_DIM_HIERARCHY_ERR', nvl(sum(decode(REPROCESS_READY_YN,'Y',0,'D',0,1)),0), nvl(sum(decode(REPROCESS_READY_YN,'Y',1,'D',1,0)),0), 'MTH_ERR_USRDMHRRCHY_INTG' FROM MTH_USER_DIM_HIERARCHY_ERR UNION ALL SELECT 'MTH_WEEK_ERR', nvl(sum(decode(REPROCESS_READY_YN,'Y',0,'D',0,1)),0), nvl(sum(decode(REPROCESS_READY_YN,'Y',1,'D',1,0)),0), 'MTH_ERR_WK_INTG' FROM MTH_WEEK_ERR UNION ALL SELECT 'MTH_WORKDAY_SHIFTS_ERR', nvl(sum(decode(REPROCESS_READY_YN,'Y',0,'D',0,1)),0), nvl(sum(decode(REPROCESS_READY_YN,'Y',1,'D',1,0)),0), 'MTH_ERR_WRKDYSHFTS_INTG' FROM MTH_WORKDAY_SHIFTS_ERR UNION ALL SELECT 'MTH_WO_SALES_ORDERS_ERR', nvl(sum(decode(REPROCESS_READY_YN,'Y',0,'D',0,1)),0), nvl(sum(decode(REPROCESS_READY_YN,'Y',1,'D',1,0)),0), 'MTH_ERR_WSLSRDRS_INTG' FROM MTH_WO_SALES_ORDERS_ERR UNION ALL SELECT 'MTH_YEAR_ERR', nvl(sum(decode(REPROCESS_READY_YN,'Y',0,'D',0,1)),0), nvl(sum(decode(REPROCESS_READY_YN,'Y',1,'D',1,0)),0), 'MTH_ERR_YR_INTG' FROM MTH_YEAR_ERR)

View Text - HTML Formatted

SELECT TABLE_NAME
, UNREVIEWED
, REPROCESS_READY
, INTEGRATOR_NAME
FROM ( SELECT 'MTH_ASSET_ERR' TABLE_NAME
, NVL(SUM(DECODE(REPROCESS_READY_YN
, 'Y'
, 0
, 'D'
, 0
, 1))
, 0) UNREVIEWED
, NVL(SUM(DECODE(REPROCESS_READY_YN
, 'Y'
, 1
, 'D'
, 1
, 0))
, 0) REPROCESS_READY
, 'MTH_ERR_ASST_INTG' INTEGRATOR_NAME
FROM MTH_ASSET_ERR UNION ALL SELECT 'MTH_DAY_ERR'
, NVL(SUM(DECODE(REPROCESS_READY_YN
, 'Y'
, 0
, 'D'
, 0
, 1))
, 0)
, NVL(SUM(DECODE(REPROCESS_READY_YN
, 'Y'
, 1
, 'D'
, 1
, 0))
, 0)
, 'MTH_ERR_DY_INTG'
FROM MTH_DAY_ERR UNION ALL SELECT 'MTH_DIM_HIERARCHY_ERR'
, NVL(SUM(DECODE(REPROCESS_READY_YN
, 'Y'
, 0
, 'D'
, 0
, 1))
, 0)
, NVL(SUM(DECODE(REPROCESS_READY_YN
, 'Y'
, 1
, 'D'
, 1
, 0))
, 0)
, 'MTH_ERR_DMHRRCHY_INTG'
FROM MTH_DIM_HIERARCHY_ERR UNION ALL SELECT 'MTH_DIM_LEVEL_LOOKUP_ERR'
, NVL(SUM(DECODE(REPROCESS_READY_YN
, 'Y'
, 0
, 'D'
, 0
, 1))
, 0)
, NVL(SUM(DECODE(REPROCESS_READY_YN
, 'Y'
, 1
, 'D'
, 1
, 0))
, 0)
, 'MTH_ERR_DMLVLLKP_INTG'
FROM MTH_DIM_LEVEL_LOOKUP_ERR UNION ALL SELECT 'MTH_ENTITY_PLANNED_USAGE_ERR'
, NVL(SUM(DECODE(REPROCESS_READY_YN
, 'Y'
, 0
, 'D'
, 0
, 1))
, 0)
, NVL(SUM(DECODE(REPROCESS_READY_YN
, 'Y'
, 1
, 'D'
, 1
, 0))
, 0)
, 'MTH_ERR_ENTTYPLNNDSG_INTG'
FROM MTH_ENTITY_PLANNED_USAGE_ERR UNION ALL SELECT 'MTH_EQUIPMENTS_ERR'
, NVL(SUM(DECODE(REPROCESS_READY_YN
, 'Y'
, 0
, 'D'
, 0
, 1))
, 0)
, NVL(SUM(DECODE(REPROCESS_READY_YN
, 'Y'
, 1
, 'D'
, 1
, 0))
, 0)
, 'MTH_ERR_EQPMNTS_INTG'
FROM MTH_EQUIPMENTS_ERR UNION ALL SELECT 'MTH_EQUIPMENT_REASON_SETUP_ERR'
, NVL(SUM(DECODE(REPROCESS_READY_YN
, 'Y'
, 0
, 'D'
, 0
, 1))
, 0)
, NVL(SUM(DECODE(REPROCESS_READY_YN
, 'Y'
, 1
, 'D'
, 1
, 0))
, 0)
, 'MTH_ERR_EQPMNTRSNSTP_INTG'
FROM MTH_EQUIPMENT_REASON_SETUP_ERR UNION ALL SELECT 'MTH_EQUIPMENT_SHIFTS_ERR'
, NVL(SUM(DECODE(REPROCESS_READY_YN
, 'Y'
, 0
, 'D'
, 0
, 1))
, 0)
, NVL(SUM(DECODE(REPROCESS_READY_YN
, 'Y'
, 1
, 'D'
, 1
, 0))
, 0)
, 'MTH_ERR_EQPMNTSHFTS_INTG'
FROM MTH_EQUIPMENT_SHIFTS_ERR UNION ALL SELECT 'MTH_EQUIP_ENTITIES_ERR'
, NVL(SUM(DECODE(REPROCESS_READY_YN
, 'Y'
, 0
, 'D'
, 0
, 1))
, 0)
, NVL(SUM(DECODE(REPROCESS_READY_YN
, 'Y'
, 1
, 'D'
, 1
, 0))
, 0)
, 'MTH_ERR_EQPNTTS_INTG'
FROM MTH_EQUIP_ENTITIES_ERR UNION ALL SELECT 'MTH_EQUIP_HIERARCHY_ERR'
, NVL(SUM(DECODE(REPROCESS_READY_YN
, 'Y'
, 0
, 'D'
, 0
, 1))
, 0)
, NVL(SUM(DECODE(REPROCESS_READY_YN
, 'Y'
, 1
, 'D'
, 1
, 0))
, 0)
, 'MTH_ERR_EQPHRRCHY_INTG'
FROM MTH_EQUIP_HIERARCHY_ERR UNION ALL SELECT 'MTH_EQUIP_OUTPUT_ERR'
, NVL(SUM(DECODE(REPROCESS_READY_YN
, 'Y'
, 0
, 'D'
, 0
, 1))
, 0)
, NVL(SUM(DECODE(REPROCESS_READY_YN
, 'Y'
, 1
, 'D'
, 1
, 0))
, 0)
, 'MTH_ERR_EQPTPT_INTG'
FROM MTH_EQUIP_OUTPUT_ERR UNION ALL SELECT 'MTH_EQUIP_PROD_SCHEDULE_ERR'
, NVL(SUM(DECODE(REPROCESS_READY_YN
, 'Y'
, 0
, 'D'
, 0
, 1))
, 0)
, NVL(SUM(DECODE(REPROCESS_READY_YN
, 'Y'
, 1
, 'D'
, 1
, 0))
, 0)
, 'MTH_ERR_EQPPRDSCHDL_INTG'
FROM MTH_EQUIP_PROD_SCHEDULE_ERR UNION ALL SELECT 'MTH_EQUIP_STANDARD_RATES_ERR'
, NVL(SUM(DECODE(REPROCESS_READY_YN
, 'Y'
, 0
, 'D'
, 0
, 1))
, 0)
, NVL(SUM(DECODE(REPROCESS_READY_YN
, 'Y'
, 1
, 'D'
, 1
, 0))
, 0)
, 'MTH_ERR_EQPSTNDRDRTS_INTG'
FROM MTH_EQUIP_STANDARD_RATES_ERR UNION ALL SELECT 'MTH_EQUIP_STATUSES_ERR'
, NVL(SUM(DECODE(REPROCESS_READY_YN
, 'Y'
, 0
, 'D'
, 0
, 1))
, 0)
, NVL(SUM(DECODE(REPROCESS_READY_YN
, 'Y'
, 1
, 'D'
, 1
, 0))
, 0)
, 'MTH_ERR_EQPSTTSS_INTG'
FROM MTH_EQUIP_STATUSES_ERR UNION ALL SELECT 'MTH_EVENT_ACTION_SETUP_ERR'
, NVL(SUM(DECODE(REPROCESS_READY_YN
, 'Y'
, 0
, 'D'
, 0
, 1))
, 0)
, NVL(SUM(DECODE(REPROCESS_READY_YN
, 'Y'
, 1
, 'D'
, 1
, 0))
, 0)
, 'MTH_ERR_EVNTCTNSTP_INTG'
FROM MTH_EVENT_ACTION_SETUP_ERR UNION ALL SELECT 'MTH_ITEMS_ERR'
, NVL(SUM(DECODE(REPROCESS_READY_YN
, 'Y'
, 0
, 'D'
, 0
, 1))
, 0)
, NVL(SUM(DECODE(REPROCESS_READY_YN
, 'Y'
, 1
, 'D'
, 1
, 0))
, 0)
, 'MTH_ERR_ITMS_INTG'
FROM MTH_ITEMS_ERR UNION ALL SELECT 'MTH_ITEM_CATEGORIES_ERR'
, NVL(SUM(DECODE(REPROCESS_READY_YN
, 'Y'
, 0
, 'D'
, 0
, 1))
, 0)
, NVL(SUM(DECODE(REPROCESS_READY_YN
, 'Y'
, 1
, 'D'
, 1
, 0))
, 0)
, 'MTH_ERR_ITMCTGRS_INTG'
FROM MTH_ITEM_CATEGORIES_ERR UNION ALL SELECT 'MTH_ITEM_COST_ERR'
, NVL(SUM(DECODE(REPROCESS_READY_YN
, 'Y'
, 0
, 'D'
, 0
, 1))
, 0)
, NVL(SUM(DECODE(REPROCESS_READY_YN
, 'Y'
, 1
, 'D'
, 1
, 0))
, 0)
, 'MTH_ERR_ITMCST_INTG'
FROM MTH_ITEM_COST_ERR UNION ALL SELECT 'MTH_ITEM_HIERARCHY_ERR'
, NVL(SUM(DECODE(REPROCESS_READY_YN
, 'Y'
, 0
, 'D'
, 0
, 1))
, 0)
, NVL(SUM(DECODE(REPROCESS_READY_YN
, 'Y'
, 1
, 'D'
, 1
, 0))
, 0)
, 'MTH_ERR_ITMHRRCHY_INTG'
FROM MTH_ITEM_HIERARCHY_ERR UNION ALL SELECT 'MTH_METER_READINGS_ERR'
, NVL(SUM(DECODE(REPROCESS_READY_YN
, 'Y'
, 0
, 'D'
, 0
, 1))
, 0)
, NVL(SUM(DECODE(REPROCESS_READY_YN
, 'Y'
, 1
, 'D'
, 1
, 0))
, 0)
, 'MTH_ERR_MTRRDNGS_INTG'
FROM MTH_METER_READINGS_ERR UNION ALL SELECT 'MTH_MTL_CONSUMED_TXN_LOT_ERR'
, NVL(SUM(DECODE(REPROCESS_READY_YN
, 'Y'
, 0
, 'D'
, 0
, 1))
, 0)
, NVL(SUM(DECODE(REPROCESS_READY_YN
, 'Y'
, 1
, 'D'
, 1
, 0))
, 0)
, 'MTH_ERR_MTLCNSMDTXNL_INTG'
FROM MTH_MTL_CONSUMED_TXN_LOT_ERR UNION ALL SELECT 'MTH_MTL_PRODUCED_TXN_LOT_ERR'
, NVL(SUM(DECODE(REPROCESS_READY_YN
, 'Y'
, 0
, 'D'
, 0
, 1))
, 0)
, NVL(SUM(DECODE(REPROCESS_READY_YN
, 'Y'
, 1
, 'D'
, 1
, 0))
, 0)
, 'MTH_ERR_MTLPRDCDTXNL_INTG'
FROM MTH_MTL_PRODUCED_TXN_LOT_ERR UNION ALL SELECT 'MTH_PERIOD_ERR'
, NVL(SUM(DECODE(REPROCESS_READY_YN
, 'Y'
, 0
, 'D'
, 0
, 1))
, 0)
, NVL(SUM(DECODE(REPROCESS_READY_YN
, 'Y'
, 1
, 'D'
, 1
, 0))
, 0)
, 'MTH_ERR_PRD_INTG'
FROM MTH_PERIOD_ERR UNION ALL SELECT 'MTH_PERSONNEL_ERR'
, NVL(SUM(DECODE(REPROCESS_READY_YN
, 'Y'
, 0
, 'D'
, 0
, 1))
, 0)
, NVL(SUM(DECODE(REPROCESS_READY_YN
, 'Y'
, 1
, 'D'
, 1
, 0))
, 0)
, 'MTH_ERR_PRSNNL_INTG'
FROM MTH_PERSONNEL_ERR UNION ALL SELECT 'MTH_PRODUCTION_SCHEDULES_ERR'
, NVL(SUM(DECODE(REPROCESS_READY_YN
, 'Y'
, 0
, 'D'
, 0
, 1))
, 0)
, NVL(SUM(DECODE(REPROCESS_READY_YN
, 'Y'
, 1
, 'D'
, 1
, 0))
, 0)
, 'MTH_ERR_PRDCTNSCHDLS_INTG'
FROM MTH_PRODUCTION_SCHEDULES_ERR UNION ALL SELECT 'MTH_PRODUCTION_SEGMENTS_ERR'
, NVL(SUM(DECODE(REPROCESS_READY_YN
, 'Y'
, 0
, 'D'
, 0
, 1))
, 0)
, NVL(SUM(DECODE(REPROCESS_READY_YN
, 'Y'
, 1
, 'D'
, 1
, 0))
, 0)
, 'MTH_ERR_PRDCTNSGMNTS_INTG'
FROM MTH_PRODUCTION_SEGMENTS_ERR UNION ALL SELECT 'MTH_PROD_MTL_CONSUMED_ERR'
, NVL(SUM(DECODE(REPROCESS_READY_YN
, 'Y'
, 0
, 'D'
, 0
, 1))
, 0)
, NVL(SUM(DECODE(REPROCESS_READY_YN
, 'Y'
, 1
, 'D'
, 1
, 0))
, 0)
, 'MTH_ERR_PRDMTLCNSMD_INTG'
FROM MTH_PROD_MTL_CONSUMED_ERR UNION ALL SELECT 'MTH_PROD_MTL_CONSUMED_TXN_ERR'
, NVL(SUM(DECODE(REPROCESS_READY_YN
, 'Y'
, 0
, 'D'
, 0
, 1))
, 0)
, NVL(SUM(DECODE(REPROCESS_READY_YN
, 'Y'
, 1
, 'D'
, 1
, 0))
, 0)
, 'MTH_ERR_PRDMTLCNSMDT_INTG'
FROM MTH_PROD_MTL_CONSUMED_TXN_ERR UNION ALL SELECT 'MTH_PROD_MTL_PRODUCED_ERR'
, NVL(SUM(DECODE(REPROCESS_READY_YN
, 'Y'
, 0
, 'D'
, 0
, 1))
, 0)
, NVL(SUM(DECODE(REPROCESS_READY_YN
, 'Y'
, 1
, 'D'
, 1
, 0))
, 0)
, 'MTH_ERR_PRDMTLPRDCD_INTG'
FROM MTH_PROD_MTL_PRODUCED_ERR UNION ALL SELECT 'MTH_PROD_MTL_PRODUCED_TXN_ERR'
, NVL(SUM(DECODE(REPROCESS_READY_YN
, 'Y'
, 0
, 'D'
, 0
, 1))
, 0)
, NVL(SUM(DECODE(REPROCESS_READY_YN
, 'Y'
, 1
, 'D'
, 1
, 0))
, 0)
, 'MTH_ERR_PRDMTLPRDCDT_INTG'
FROM MTH_PROD_MTL_PRODUCED_TXN_ERR UNION ALL SELECT 'MTH_PROD_SEGMENTS_TXN_ERR'
, NVL(SUM(DECODE(REPROCESS_READY_YN
, 'Y'
, 0
, 'D'
, 0
, 1))
, 0)
, NVL(SUM(DECODE(REPROCESS_READY_YN
, 'Y'
, 1
, 'D'
, 1
, 0))
, 0)
, 'MTH_ERR_PRDSGMNTSTXN_INTG'
FROM MTH_PROD_SEGMENTS_TXN_ERR UNION ALL SELECT 'MTH_PROD_SUB_SEGMENTS_ERR'
, NVL(SUM(DECODE(REPROCESS_READY_YN
, 'Y'
, 0
, 'D'
, 0
, 1))
, 0)
, NVL(SUM(DECODE(REPROCESS_READY_YN
, 'Y'
, 1
, 'D'
, 1
, 0))
, 0)
, 'MTH_ERR_PRDSBSGMNTS_INTG'
FROM MTH_PROD_SUB_SEGMENTS_ERR UNION ALL SELECT 'MTH_QUARTER_ERR'
, NVL(SUM(DECODE(REPROCESS_READY_YN
, 'Y'
, 0
, 'D'
, 0
, 1))
, 0)
, NVL(SUM(DECODE(REPROCESS_READY_YN
, 'Y'
, 1
, 'D'
, 1
, 0))
, 0)
, 'MTH_ERR_QRTR_INTG'
FROM MTH_QUARTER_ERR UNION ALL SELECT 'MTH_RESOURCES_ERR'
, NVL(SUM(DECODE(REPROCESS_READY_YN
, 'Y'
, 0
, 'D'
, 0
, 1))
, 0)
, NVL(SUM(DECODE(REPROCESS_READY_YN
, 'Y'
, 1
, 'D'
, 1
, 0))
, 0)
, 'MTH_ERR_RSRCS_INTG'
FROM MTH_RESOURCES_ERR UNION ALL SELECT 'MTH_RESOURCE_COST_ERR'
, NVL(SUM(DECODE(REPROCESS_READY_YN
, 'Y'
, 0
, 'D'
, 0
, 1))
, 0)
, NVL(SUM(DECODE(REPROCESS_READY_YN
, 'Y'
, 1
, 'D'
, 1
, 0))
, 0)
, 'MTH_ERR_RSRCCST_INTG'
FROM MTH_RESOURCE_COST_ERR UNION ALL SELECT 'MTH_RESOURCE_REQUIREMENTS_ERR'
, NVL(SUM(DECODE(REPROCESS_READY_YN
, 'Y'
, 0
, 'D'
, 0
, 1))
, 0)
, NVL(SUM(DECODE(REPROCESS_READY_YN
, 'Y'
, 1
, 'D'
, 1
, 0))
, 0)
, 'MTH_ERR_RSRCRQRMNTS_INTG'
FROM MTH_RESOURCE_REQUIREMENTS_ERR UNION ALL SELECT 'MTH_RESOURCE_TXN_ERR'
, NVL(SUM(DECODE(REPROCESS_READY_YN
, 'Y'
, 0
, 'D'
, 0
, 1))
, 0)
, NVL(SUM(DECODE(REPROCESS_READY_YN
, 'Y'
, 1
, 'D'
, 1
, 0))
, 0)
, 'MTH_ERR_RSRCTXN_INTG'
FROM MTH_RESOURCE_TXN_ERR UNION ALL SELECT 'MTH_TAG_MASTER_ERR'
, NVL(SUM(DECODE(REPROCESS_READY_YN
, 'Y'
, 0
, 'D'
, 0
, 1))
, 0)
, NVL(SUM(DECODE(REPROCESS_READY_YN
, 'Y'
, 1
, 'D'
, 1
, 0))
, 0)
, 'MTH_ERR_TGMSTR_INTG'
FROM MTH_TAG_MASTER_ERR UNION ALL SELECT 'MTH_TIME_HIERARCHY_ERR'
, NVL(SUM(DECODE(REPROCESS_READY_YN
, 'Y'
, 0
, 'D'
, 0
, 1))
, 0)
, NVL(SUM(DECODE(REPROCESS_READY_YN
, 'Y'
, 1
, 'D'
, 1
, 0))
, 0)
, 'MTH_ERR_TMHRRCHY_INTG'
FROM MTH_TIME_HIERARCHY_ERR UNION ALL SELECT 'MTH_USER_DIM_ENTITIES_ERR'
, NVL(SUM(DECODE(REPROCESS_READY_YN
, 'Y'
, 0
, 'D'
, 0
, 1))
, 0)
, NVL(SUM(DECODE(REPROCESS_READY_YN
, 'Y'
, 1
, 'D'
, 1
, 0))
, 0)
, 'MTH_ERR_USRDMNTTS_INTG'
FROM MTH_USER_DIM_ENTITIES_ERR UNION ALL SELECT 'MTH_USER_DIM_HIERARCHY_ERR'
, NVL(SUM(DECODE(REPROCESS_READY_YN
, 'Y'
, 0
, 'D'
, 0
, 1))
, 0)
, NVL(SUM(DECODE(REPROCESS_READY_YN
, 'Y'
, 1
, 'D'
, 1
, 0))
, 0)
, 'MTH_ERR_USRDMHRRCHY_INTG'
FROM MTH_USER_DIM_HIERARCHY_ERR UNION ALL SELECT 'MTH_WEEK_ERR'
, NVL(SUM(DECODE(REPROCESS_READY_YN
, 'Y'
, 0
, 'D'
, 0
, 1))
, 0)
, NVL(SUM(DECODE(REPROCESS_READY_YN
, 'Y'
, 1
, 'D'
, 1
, 0))
, 0)
, 'MTH_ERR_WK_INTG'
FROM MTH_WEEK_ERR UNION ALL SELECT 'MTH_WORKDAY_SHIFTS_ERR'
, NVL(SUM(DECODE(REPROCESS_READY_YN
, 'Y'
, 0
, 'D'
, 0
, 1))
, 0)
, NVL(SUM(DECODE(REPROCESS_READY_YN
, 'Y'
, 1
, 'D'
, 1
, 0))
, 0)
, 'MTH_ERR_WRKDYSHFTS_INTG'
FROM MTH_WORKDAY_SHIFTS_ERR UNION ALL SELECT 'MTH_WO_SALES_ORDERS_ERR'
, NVL(SUM(DECODE(REPROCESS_READY_YN
, 'Y'
, 0
, 'D'
, 0
, 1))
, 0)
, NVL(SUM(DECODE(REPROCESS_READY_YN
, 'Y'
, 1
, 'D'
, 1
, 0))
, 0)
, 'MTH_ERR_WSLSRDRS_INTG'
FROM MTH_WO_SALES_ORDERS_ERR UNION ALL SELECT 'MTH_YEAR_ERR'
, NVL(SUM(DECODE(REPROCESS_READY_YN
, 'Y'
, 0
, 'D'
, 0
, 1))
, 0)
, NVL(SUM(DECODE(REPROCESS_READY_YN
, 'Y'
, 1
, 'D'
, 1
, 0))
, 0)
, 'MTH_ERR_YR_INTG'
FROM MTH_YEAR_ERR)