Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select count(*), 'AFUDC_CALC' from AFUDC_CALC union all
- select count(*), 'AFUDC_CALC_TEST' from AFUDC_CALC_TEST union all
- select count(*), 'AFUDC_CALC_WO_LIST_TEMP' from AFUDC_CALC_WO_LIST_TEMP union all
- select count(*), 'AFUDC_INPUT' from AFUDC_INPUT union all
- select count(*), 'AFUDC_INPUT_RATIO' from AFUDC_INPUT_RATIO union all
- select count(*), 'APPROVALS_PENDING' from APPROVALS_PENDING union all
- select count(*), 'APPROVAL_DELEGATION_HIST' from APPROVAL_DELEGATION_HIST union all
- select count(*), 'ARC_AFUDC_INPUT' from ARC_AFUDC_INPUT union all
- select count(*), 'ARC_FUNDING_JUSTIFICATION' from ARC_FUNDING_JUSTIFICATION union all
- select count(*), 'ARC_WORK_ORDER_BLANKETS_LIST' from ARC_WORK_ORDER_BLANKETS_LIST union all
- select count(*), 'ARC_WORK_ORDER_LIST' from ARC_WORK_ORDER_LIST union all
- select count(*), 'ARC_WO_AVAILABLE_LIST' from ARC_WO_AVAILABLE_LIST union all
- select count(*), 'ARC_WO_BK_AVAILABLE_LIST' from ARC_WO_BK_AVAILABLE_LIST union all
- select count(*), 'ARC_WO_BK_GROUPS' from ARC_WO_BK_GROUPS union all
- select count(*), 'ARC_WO_BK_UNITS' from ARC_WO_BK_UNITS union all
- select count(*), 'ARO_LAYER_WORK_ORDER' from ARO_LAYER_WORK_ORDER union all
- select count(*), 'ARO_WORK_ORDER' from ARO_WORK_ORDER union all
- select count(*), 'BI_EST_MONTH_IS_EDITABLE' from BI_EST_MONTH_IS_EDITABLE union all
- select count(*), 'BI_EST_MONTH_IS_EDITABLE_FY' from BI_EST_MONTH_IS_EDITABLE_FY union all
- select count(*), 'BUDGET_ACTUALS_TEMP' from BUDGET_ACTUALS_TEMP union all
- select count(*), 'BUDGET_AFUDC_CALC' from BUDGET_AFUDC_CALC union all
- select count(*), 'BUDGET_AFUDC_CALC_BEG_BAL' from BUDGET_AFUDC_CALC_BEG_BAL union all
- select count(*), 'BUDGET_AFUDC_CALC_BEG_BAL_TEMP' from BUDGET_AFUDC_CALC_BEG_BAL_TEMP union all
- select count(*), 'BUDGET_AFUDC_CALC_CLOSING' from BUDGET_AFUDC_CALC_CLOSING union all
- select count(*), 'BUDGET_AFUDC_CALC_CLOSING_TEMP' from BUDGET_AFUDC_CALC_CLOSING_TEMP union all
- select count(*), 'BUDGET_AFUDC_CALC_FY_SV' from BUDGET_AFUDC_CALC_FY_SV union all
- select count(*), 'BUDGET_AFUDC_CALC_SV' from BUDGET_AFUDC_CALC_SV union all
- select count(*), 'BUDGET_AFUDC_CALC_TEMP' from BUDGET_AFUDC_CALC_TEMP union all
- select count(*), 'BUDGET_APPROVAL_DATA' from BUDGET_APPROVAL_DATA union all
- select count(*), 'BUDGET_APPROVAL_DATA_ARCH' from BUDGET_APPROVAL_DATA_ARCH union all
- select count(*), 'BUDGET_APPROVAL_DATA_FY' from BUDGET_APPROVAL_DATA_FY union all
- select count(*), 'BUDGET_CAP_INTEREST_WO' from BUDGET_CAP_INTEREST_WO union all
- select count(*), 'BUDGET_CLOSINGS' from BUDGET_CLOSINGS union all
- select count(*), 'BUDGET_CLOSINGS_PCT' from BUDGET_CLOSINGS_PCT union all
- select count(*), 'BUDGET_CLOSINGS_STAGE' from BUDGET_CLOSINGS_STAGE union all
- select count(*), 'BUDGET_CLOSINGS_TEMP' from BUDGET_CLOSINGS_TEMP union all
- select count(*), 'BUDGET_CWIP_IN_RATE_BASE' from BUDGET_CWIP_IN_RATE_BASE union all
- select count(*), 'BUDGET_MONTHLY_DATA' from BUDGET_MONTHLY_DATA union all
- select count(*), 'BUDGET_MONTHLY_DATA_ARCH' from BUDGET_MONTHLY_DATA_ARCH union all
- select count(*), 'BUDGET_MONTHLY_DATA_CR' from BUDGET_MONTHLY_DATA_CR union all
- select count(*), 'BUDGET_MONTHLY_DATA_FY' from BUDGET_MONTHLY_DATA_FY union all
- select count(*), 'BUDGET_MONTHLY_DATA_MO_ID' from BUDGET_MONTHLY_DATA_MO_ID union all
- select count(*), 'BUDGET_MONTHLY_DATA_TRANSPOSE' from BUDGET_MONTHLY_DATA_TRANSPOSE union all
- select count(*), 'BUDGET_MONTHLY_DATA_TRANS_TEMP' from BUDGET_MONTHLY_DATA_TRANS_TEMP union all
- select count(*), 'BUDGET_MONTHLY_FISCAL_YEAR' from BUDGET_MONTHLY_FISCAL_YEAR union all
- select count(*), 'BUDGET_REVIEW' from BUDGET_REVIEW union all
- select count(*), 'BUDGET_REVIEW_ARCH' from BUDGET_REVIEW_ARCH union all
- select count(*), 'BUDGET_REVIEW_DETAIL' from BUDGET_REVIEW_DETAIL union all
- select count(*), 'BUDGET_REVIEW_DETAIL_ARCH' from BUDGET_REVIEW_DETAIL_ARCH union all
- select count(*), 'BUDGET_VERSION_FUND_PROJ' from BUDGET_VERSION_FUND_PROJ union all
- select count(*), 'BUDGET_VERSION_FUND_PROJ_ARCH' from BUDGET_VERSION_FUND_PROJ_ARCH union all
- select count(*), 'BUDGET_VERSION_FUND_PROJ_SV' from BUDGET_VERSION_FUND_PROJ_SV union all
- select count(*), 'BUDGET_WIP_COMP_CALC' from BUDGET_WIP_COMP_CALC union all
- select count(*), 'BUDGET_WIP_COMP_CALC_TEMP' from BUDGET_WIP_COMP_CALC_TEMP union all
- select count(*), 'BUDGET_WIP_COMP_INPUT' from BUDGET_WIP_COMP_INPUT union all
- select count(*), 'BUDG_MONTHLY_DATA_DEESC_SV' from BUDG_MONTHLY_DATA_DEESC_SV union all
- select count(*), 'BUDG_MONTHLY_DATA_FY_DEESC_SV' from BUDG_MONTHLY_DATA_FY_DEESC_SV union all
- select count(*), 'BUDG_MONTHLY_DATA_FY_SV' from BUDG_MONTHLY_DATA_FY_SV union all
- select count(*), 'BUDG_MONTHLY_DATA_SV' from BUDG_MONTHLY_DATA_SV union all
- select count(*), 'BV_FP_RESPREAD_AUDIT' from BV_FP_RESPREAD_AUDIT union all
- select count(*), 'BV_PROJ_RANKING_RESULTS' from BV_PROJ_RANKING_RESULTS union all
- select count(*), 'CAP_INTEREST_WO' from CAP_INTEREST_WO union all
- select count(*), 'CHARGE_GROUP_CONTROL' from CHARGE_GROUP_CONTROL union all
- select count(*), 'CHARGE_SUMMARY' from CHARGE_SUMMARY union all
- select count(*), 'CHARGE_SUMMARY_BACKUP' from CHARGE_SUMMARY_BACKUP union all
- select count(*), 'CHARGE_SUMMARY_CLOSINGS' from CHARGE_SUMMARY_CLOSINGS union all
- select count(*), 'CHARGE_SUPER_SUMMARY_VIEW' from CHARGE_SUPER_SUMMARY_VIEW union all
- select count(*), 'CLEARING_WO_CONTROL' from CLEARING_WO_CONTROL union all
- select count(*), 'COMMITMENTS' from COMMITMENTS union all
- select count(*), 'COMMITMENTS_BI_FY_SV' from COMMITMENTS_BI_FY_SV union all
- select count(*), 'COMMITMENTS_BI_SV' from COMMITMENTS_BI_SV union all
- select count(*), 'COMMITMENTS_FP_FY_SV' from COMMITMENTS_FP_FY_SV union all
- select count(*), 'COMMITMENTS_FP_SV' from COMMITMENTS_FP_SV union all
- select count(*), 'COMMITMENTS_TMP' from COMMITMENTS_TMP union all
- select count(*), 'CONV_PNG_WO_INTERFACE_STG' from CONV_PNG_WO_INTERFACE_STG union all
- select count(*), 'CO_TENANCY_WO' from CO_TENANCY_WO union all
- select count(*), 'CPI_RETRO_106_OOB_WO' from CPI_RETRO_106_OOB_WO union all
- select count(*), 'CPI_RETRO_ALLOC_ERROR' from CPI_RETRO_ALLOC_ERROR union all
- select count(*), 'CPI_RETRO_ASSET_ALLOCATION' from CPI_RETRO_ASSET_ALLOCATION union all
- select count(*), 'CPI_RETRO_BASE_ADJUST' from CPI_RETRO_BASE_ADJUST union all
- select count(*), 'CPI_RETRO_CALC' from CPI_RETRO_CALC union all
- select count(*), 'CPI_RETRO_CLOSINGS' from CPI_RETRO_CLOSINGS union all
- select count(*), 'CPI_RETRO_CLOSINGS_TEMP' from CPI_RETRO_CLOSINGS_TEMP union all
- select count(*), 'CPI_RETRO_COMPARE' from CPI_RETRO_COMPARE union all
- select count(*), 'CPI_RETRO_CPR_ASSETS' from CPI_RETRO_CPR_ASSETS union all
- select count(*), 'CPI_RETRO_WO_LIST_TEMP' from CPI_RETRO_WO_LIST_TEMP union all
- select count(*), 'CPI_WO_COMPARE' from CPI_WO_COMPARE union all
- select count(*), 'CPR_EQUIP_ESTIMATE_RELATE' from CPR_EQUIP_ESTIMATE_RELATE union all
- select count(*), 'CPR_EQUIP_LEDGER_API' from CPR_EQUIP_LEDGER_API union all
- select count(*), 'CPR_EQUIP_LEDGER_API_ARCHIVE' from CPR_EQUIP_LEDGER_API_ARCHIVE union all
- select count(*), 'CPR_EQUIP_LEDGER_API_TEMP' from CPR_EQUIP_LEDGER_API_TEMP union all
- select count(*), 'CPR_EQUIP_RETIRE_RELATE' from CPR_EQUIP_RETIRE_RELATE union all
- select count(*), 'CRB_BUDGET_DATA' from CRB_BUDGET_DATA union all
- select count(*), 'CR_BUDGET_AFUDC_CALC' from CR_BUDGET_AFUDC_CALC union all
- select count(*), 'CR_BUDGET_DATA' from CR_BUDGET_DATA union all
- select count(*), 'CR_BUDGET_DATA_PROJECTS' from CR_BUDGET_DATA_PROJECTS union all
- select count(*), 'CR_BUDGET_DATA_STSV' from CR_BUDGET_DATA_STSV union all
- select count(*), 'CR_BUDGET_DATA_SV' from CR_BUDGET_DATA_SV union all
- select count(*), 'CR_BUDGET_DATA_TEMP' from CR_BUDGET_DATA_TEMP union all
- select count(*), 'CR_BUDGET_DATA_TEST' from CR_BUDGET_DATA_TEST union all
- select count(*), 'CR_BUDGET_REVERSALS' from CR_BUDGET_REVERSALS union all
- select count(*), 'CR_CANCEL_DETAIL' from CR_CANCEL_DETAIL union all
- select count(*), 'CR_CANCEL_HEADER' from CR_CANCEL_HEADER union all
- select count(*), 'CR_CANCEL_RESULTS' from CR_CANCEL_RESULTS union all
- select count(*), 'CR_CANCEL_RESULTS_1' from CR_CANCEL_RESULTS_1 union all
- select count(*), 'CR_CANCEL_RESULTS_10' from CR_CANCEL_RESULTS_10 union all
- select count(*), 'CR_CANCEL_RESULTS_2' from CR_CANCEL_RESULTS_2 union all
- select count(*), 'CR_CANCEL_RESULTS_3' from CR_CANCEL_RESULTS_3 union all
- select count(*), 'CR_CANCEL_RESULTS_4' from CR_CANCEL_RESULTS_4 union all
- select count(*), 'CR_CANCEL_RESULTS_5' from CR_CANCEL_RESULTS_5 union all
- select count(*), 'CR_CANCEL_RESULTS_6' from CR_CANCEL_RESULTS_6 union all
- select count(*), 'CR_CANCEL_RESULTS_7' from CR_CANCEL_RESULTS_7 union all
- select count(*), 'CR_CANCEL_RESULTS_8' from CR_CANCEL_RESULTS_8 union all
- select count(*), 'CR_CANCEL_RESULTS_9' from CR_CANCEL_RESULTS_9 union all
- select count(*), 'CR_COMMITMENTS_SUM' from CR_COMMITMENTS_SUM union all
- select count(*), 'CR_COMMITMENTS_TRANSLATE' from CR_COMMITMENTS_TRANSLATE union all
- select count(*), 'CR_CWIP_CHARGE_SUM' from CR_CWIP_CHARGE_SUM union all
- select count(*), 'CR_CWIP_CHARGE_TRANSLATE' from CR_CWIP_CHARGE_TRANSLATE union all
- select count(*), 'CR_DERIVER_CONTROL' from CR_DERIVER_CONTROL union all
- select count(*), 'CR_DERIVER_CONTROL_VIRTUAL' from CR_DERIVER_CONTROL_VIRTUAL union all
- select count(*), 'CR_TEMP_CR_GL_BDG' from CR_TEMP_CR_GL_BDG union all
- select count(*), 'CR_TEMP_CR_GL_BDG_TEMP' from CR_TEMP_CR_GL_BDG_TEMP union all
- select count(*), 'CWIP_BI_FY_SV' from CWIP_BI_FY_SV union all
- select count(*), 'CWIP_BI_SV' from CWIP_BI_SV union all
- select count(*), 'CWIP_CHARGE' from CWIP_CHARGE union all
- select count(*), 'CWIP_CHARGE_NET_VIEW' from CWIP_CHARGE_NET_VIEW union all
- select count(*), 'CWIP_CHARGE_SOB_VIEW' from CWIP_CHARGE_SOB_VIEW union all
- select count(*), 'CWIP_FP_FY_SV' from CWIP_FP_FY_SV union all
- select count(*), 'CWIP_FP_SV' from CWIP_FP_SV union all
- select count(*), 'CWIP_IN_RATE_BASE' from CWIP_IN_RATE_BASE union all
- select count(*), 'D1_WO_INTERFACE_MONTHLY_ARC' from D1_WO_INTERFACE_MONTHLY_ARC union all
- select count(*), 'DIRECT_CHARGES_VIEW' from DIRECT_CHARGES_VIEW union all
- select count(*), 'EVERY_PROJECT_EVERY_REVISION' from EVERY_PROJECT_EVERY_REVISION union all
- select count(*), 'FCST_BUDGET_LOAD' from FCST_BUDGET_LOAD union all
- select count(*), 'FCST_BUDGET_LOAD_ARCH' from FCST_BUDGET_LOAD_ARCH union all
- select count(*), 'FUNDING_JUSTIFICATION' from FUNDING_JUSTIFICATION union all
- select count(*), 'INCREMENTAL_FP_ADJ_DATA' from INCREMENTAL_FP_ADJ_DATA union all
- select count(*), 'INCREMENTAL_FP_RUN_LOG' from INCREMENTAL_FP_RUN_LOG union all
- select count(*), 'JOB_TASK' from JOB_TASK union all
- select count(*), 'JOB_TASK_CLASS_CODE' from JOB_TASK_CLASS_CODE union all
- select count(*), 'JOB_TASK_DOCUMENT' from JOB_TASK_DOCUMENT union all
- select count(*), 'JOB_TASK_INTERFACE_STAGING' from JOB_TASK_INTERFACE_STAGING union all
- select count(*), 'JOB_TASK_INTERFACE_STAGING_ARC' from JOB_TASK_INTERFACE_STAGING_ARC union all
- select count(*), 'JOB_TASK_INT_STG_IMP_ARC' from JOB_TASK_INT_STG_IMP_ARC union all
- select count(*), 'JOB_TASK_INT_STG_IMP_STG' from JOB_TASK_INT_STG_IMP_STG union all
- select count(*), 'JUR_AFC_SHADOW_MAPPING' from JUR_AFC_SHADOW_MAPPING union all
- select count(*), 'LS_ASSET' from LS_ASSET union all
- select count(*), 'LS_IMPORT_ASSET' from LS_IMPORT_ASSET union all
- select count(*), 'LS_IMPORT_ASSET_ARCHIVE' from LS_IMPORT_ASSET_ARCHIVE union all
- select count(*), 'LS_PEND_TRANSACTION' from LS_PEND_TRANSACTION union all
- select count(*), 'LS_PEND_TRANSACTION_ARC' from LS_PEND_TRANSACTION_ARC union all
- select count(*), 'MATLREC_TRANS' from MATLREC_TRANS union all
- select count(*), 'MATLREC_TRANS_STG' from MATLREC_TRANS_STG union all
- select count(*), 'ORIGINAL_COST_RETIREMENT' from ORIGINAL_COST_RETIREMENT union all
- select count(*), 'ORIGINAL_COST_RETIREMENT_STG' from ORIGINAL_COST_RETIREMENT_STG union all
- select count(*), 'PNG_BUDGET_CONVERSION' from PNG_BUDGET_CONVERSION union all
- select count(*), 'PNG_BUDGET_CONVERSION3' from PNG_BUDGET_CONVERSION3 union all
- select count(*), 'PNG_BUDGET_CONVERSION4' from PNG_BUDGET_CONVERSION4 union all
- select count(*), 'PNG_BUDGET_CONV_POOL_PROJECTS' from PNG_BUDGET_CONV_POOL_PROJECTS union all
- select count(*), 'PNG_BVFP_BCK' from PNG_BVFP_BCK union all
- select count(*), 'PNG_DEPR_FCST_UA_PCT_FP' from PNG_DEPR_FCST_UA_PCT_FP union all
- select count(*), 'PNG_DISTRIB_COMPT_VW1_ARC' from PNG_DISTRIB_COMPT_VW1_ARC union all
- select count(*), 'PNG_DISTRIB_COMPT_VW1_PROCESS' from PNG_DISTRIB_COMPT_VW1_PROCESS union all
- select count(*), 'PNG_ERT_INTERFACE' from PNG_ERT_INTERFACE union all
- select count(*), 'PNG_JUST_MULTI_SELECT' from PNG_JUST_MULTI_SELECT union all
- select count(*), 'PNG_METER_INTERFACE' from PNG_METER_INTERFACE union all
- select count(*), 'PNG_METER_INTERFACE_TEST' from PNG_METER_INTERFACE_TEST union all
- select count(*), 'PNG_MGRAP_EST_FWDING' from PNG_MGRAP_EST_FWDING union all
- select count(*), 'PNG_MGRAP_EST_FWDING_ARC' from PNG_MGRAP_EST_FWDING_ARC union all
- select count(*), 'PNG_MGRAP_EST_FWDING_AUD' from PNG_MGRAP_EST_FWDING_AUD union all
- select count(*), 'PNG_PS_PROJ_ACTIVITY' from PNG_PS_PROJ_ACTIVITY union all
- select count(*), 'PNG_PT_DCMS_STAGING' from PNG_PT_DCMS_STAGING union all
- select count(*), 'PNG_Q1_BUDGET_MIGRATION' from PNG_Q1_BUDGET_MIGRATION union all
- select count(*), 'PNG_S2K_PROCESS' from PNG_S2K_PROCESS union all
- select count(*), 'PNG_SERV_ORDER_VW1_ARC' from PNG_SERV_ORDER_VW1_ARC union all
- select count(*), 'PNG_SERV_ORDER_VW1_PROCESS' from PNG_SERV_ORDER_VW1_PROCESS union all
- select count(*), 'PNG_WAM_WR_COST_MAN_RET' from PNG_WAM_WR_COST_MAN_RET union all
- select count(*), 'PNG_WEM_TO_WEM_FP' from PNG_WEM_TO_WEM_FP union all
- select count(*), 'PNG_WO_ESTIMATES_VIEW' from PNG_WO_ESTIMATES_VIEW union all
- select count(*), 'PNG_WO_INTERFACE_STAGING_1042' from PNG_WO_INTERFACE_STAGING_1042 union all
- select count(*), 'PNG_WO_INTERFACE_STAGING_ERROR' from PNG_WO_INTERFACE_STAGING_ERROR union all
- select count(*), 'PNG_WO_INTERFACE_UNIT_1042' from PNG_WO_INTERFACE_UNIT_1042 union all
- select count(*), 'PNG_WO_INTERFACE_UNIT_ERROR' from PNG_WO_INTERFACE_UNIT_ERROR union all
- select count(*), 'PP_TEMP_CWIP_CHARGE_SPLIT' from PP_TEMP_CWIP_CHARGE_SPLIT union all
- select count(*), 'PS84_DERIVER_CONTROL' from PS84_DERIVER_CONTROL union all
- select count(*), 'PS84_WORK_ORDER_DEPT' from PS84_WORK_ORDER_DEPT union all
- select count(*), 'PT_IMPORT_CWIP_ASSIGN' from PT_IMPORT_CWIP_ASSIGN union all
- select count(*), 'PT_IMPORT_CWIP_ASSIGN_ARCHIVE' from PT_IMPORT_CWIP_ASSIGN_ARCHIVE union all
- select count(*), 'REG_HIST_CWIP_ACTIVITY_VIEW' from REG_HIST_CWIP_ACTIVITY_VIEW union all
- select count(*), 'REG_HIST_CWIP_BALANCE_VIEW' from REG_HIST_CWIP_BALANCE_VIEW union all
- select count(*), 'REG_HIST_CWIP_RATE_BASE_VIEW' from REG_HIST_CWIP_RATE_BASE_VIEW union all
- select count(*), 'REG_INCREMENTAL_FP_ADJ_TRANS' from REG_INCREMENTAL_FP_ADJ_TRANS union all
- select count(*), 'REIMB_BILL_INTERFACE' from REIMB_BILL_INTERFACE union all
- select count(*), 'REIMB_BILL_LINE' from REIMB_BILL_LINE union all
- select count(*), 'REIMB_BILL_SUPPORT_CR' from REIMB_BILL_SUPPORT_CR union all
- select count(*), 'REIMB_BILL_SUPPORT_CWIP' from REIMB_BILL_SUPPORT_CWIP union all
- select count(*), 'REIMB_CR_OH_EXCLUSIONS' from REIMB_CR_OH_EXCLUSIONS union all
- select count(*), 'REIMB_ESTIMATE' from REIMB_ESTIMATE union all
- select count(*), 'REIMB_EST_BILL_HIST' from REIMB_EST_BILL_HIST union all
- select count(*), 'REIMB_EST_OH_EXCLUSIONS' from REIMB_EST_OH_EXCLUSIONS union all
- select count(*), 'REIMB_GL_TRANSACTION' from REIMB_GL_TRANSACTION union all
- select count(*), 'REIMB_OH_EXCLUSIONS' from REIMB_OH_EXCLUSIONS union all
- select count(*), 'REIMB_WORK_ORDER' from REIMB_WORK_ORDER union all
- select count(*), 'RELATED_WOS' from RELATED_WOS union all
- select count(*), 'REPAIR_BLANKET_PROCESSING' from REPAIR_BLANKET_PROCESSING union all
- select count(*), 'REPAIR_BLANKET_PROCESS_REPORT' from REPAIR_BLANKET_PROCESS_REPORT union all
- select count(*), 'REPAIR_BLANKET_PROC_DEBUG' from REPAIR_BLANKET_PROC_DEBUG union all
- select count(*), 'REPAIR_BLANKET_RESULTS' from REPAIR_BLANKET_RESULTS union all
- select count(*), 'REPAIR_BLANKET_RESULTS_DEBUG' from REPAIR_BLANKET_RESULTS_DEBUG union all
- select count(*), 'REPAIR_BLKT_RESULTS_REPORTING' from REPAIR_BLKT_RESULTS_REPORTING union all
- select count(*), 'REPAIR_CALC_CWIP' from REPAIR_CALC_CWIP union all
- select count(*), 'REPAIR_DETAIL_WMIS_FEED' from REPAIR_DETAIL_WMIS_FEED union all
- select count(*), 'REPAIR_WORK_ORDER_DEBUG' from REPAIR_WORK_ORDER_DEBUG union all
- select count(*), 'REPAIR_WORK_ORDER_ORIG_DEBUG' from REPAIR_WORK_ORDER_ORIG_DEBUG union all
- select count(*), 'REPAIR_WORK_ORDER_TEMP' from REPAIR_WORK_ORDER_TEMP union all
- select count(*), 'REPAIR_WORK_ORDER_TEMP_ORIG' from REPAIR_WORK_ORDER_TEMP_ORIG union all
- select count(*), 'REPAIR_WO_RUC_EXCEPTION' from REPAIR_WO_RUC_EXCEPTION union all
- select count(*), 'RPR_IMPORT_LOC_ROLLUP' from RPR_IMPORT_LOC_ROLLUP union all
- select count(*), 'RPR_IMPORT_LOC_ROLLUP_ARC' from RPR_IMPORT_LOC_ROLLUP_ARC union all
- select count(*), 'RPR_IMPORT_WO_TAX_REPAIRS' from RPR_IMPORT_WO_TAX_REPAIRS union all
- select count(*), 'RPR_IMPORT_WO_TAX_REPAIRS_ARC' from RPR_IMPORT_WO_TAX_REPAIRS_ARC union all
- select count(*), 'RWIP_ALLO_ERRORS' from RWIP_ALLO_ERRORS union all
- select count(*), 'RWIP_ALLO_EST' from RWIP_ALLO_EST union all
- select count(*), 'RWIP_CLOSEOUT_EXCLUDE' from RWIP_CLOSEOUT_EXCLUDE union all
- select count(*), 'RWIP_CLOSEOUT_REVISION' from RWIP_CLOSEOUT_REVISION union all
- select count(*), 'RWIP_CLOSEOUT_STAGING' from RWIP_CLOSEOUT_STAGING union all
- select count(*), 'RWIP_CLOSEOUT_STAG_AL' from RWIP_CLOSEOUT_STAG_AL union all
- select count(*), 'RWIP_CLOSEOUT_STAG_AL_ARC' from RWIP_CLOSEOUT_STAG_AL_ARC union all
- select count(*), 'RWIP_CLOSEOUT_STAG_ARC' from RWIP_CLOSEOUT_STAG_ARC union all
- select count(*), 'RWIP_CLOSEOUT_STAG_WOE' from RWIP_CLOSEOUT_STAG_WOE union all
- select count(*), 'SUSPENDED_CHARGE' from SUSPENDED_CHARGE union all
- select count(*), 'TEMP_ACCRUAL_WORK_ORDER' from TEMP_ACCRUAL_WORK_ORDER union all
- select count(*), 'TEMP_CHARGE_SUMMARY_CLOSINGS' from TEMP_CHARGE_SUMMARY_CLOSINGS union all
- select count(*), 'TEMP_JOB_TASK' from TEMP_JOB_TASK union all
- select count(*), 'TEMP_WOCG' from TEMP_WOCG union all
- select count(*), 'TEMP_WORK_ORDER' from TEMP_WORK_ORDER union all
- select count(*), 'TEMP_WORK_ORDER_CONTROL' from TEMP_WORK_ORDER_CONTROL union all
- select count(*), 'TEMP_WORK_ORDER_VIEW' from TEMP_WORK_ORDER_VIEW union all
- select count(*), 'TREPAIRS_WO_COMPARE' from TREPAIRS_WO_COMPARE union all
- select count(*), 'TREPAIRS_WO_CPR' from TREPAIRS_WO_CPR union all
- select count(*), 'TREPAIRS_WO_CWIP' from TREPAIRS_WO_CWIP union all
- select count(*), 'TREPAIR_FUNDING_PROJ_CHARGES' from TREPAIR_FUNDING_PROJ_CHARGES union all
- select count(*), 'UNITIZATION_TARGET' from UNITIZATION_TARGET union all
- select count(*), 'UNITIZED_WORK_ORDER' from UNITIZED_WORK_ORDER union all
- select count(*), 'UNITIZED_WORK_ORDER_MEMO' from UNITIZED_WORK_ORDER_MEMO union all
- select count(*), 'UNITIZED_WORK_ORDER_SL' from UNITIZED_WORK_ORDER_SL union all
- select count(*), 'UNITIZED_WORK_ORDER_SL_BASIS' from UNITIZED_WORK_ORDER_SL_BASIS union all
- select count(*), 'UNITIZE_ALLOC_CGC_INSERTS_ARC' from UNITIZE_ALLOC_CGC_INSERTS_ARC union all
- select count(*), 'UNITIZE_ALLOC_CGC_INSERTS_TEMP' from UNITIZE_ALLOC_CGC_INSERTS_TEMP union all
- select count(*), 'UNITIZE_ALLOC_ERRORS_TEMP' from UNITIZE_ALLOC_ERRORS_TEMP union all
- select count(*), 'UNITIZE_ALLOC_EST_STG_TEMP' from UNITIZE_ALLOC_EST_STG_TEMP union all
- select count(*), 'UNITIZE_ALLOC_EST_TEMP' from UNITIZE_ALLOC_EST_TEMP union all
- select count(*), 'UNITIZE_ALLOC_LATE_BK_ARC' from UNITIZE_ALLOC_LATE_BK_ARC union all
- select count(*), 'UNITIZE_ALLOC_LATE_BK_TEMP' from UNITIZE_ALLOC_LATE_BK_TEMP union all
- select count(*), 'UNITIZE_ALLOC_LATE_PT_ARC' from UNITIZE_ALLOC_LATE_PT_ARC union all
- select count(*), 'UNITIZE_ALLOC_LATE_PT_TEMP' from UNITIZE_ALLOC_LATE_PT_TEMP union all
- select count(*), 'UNITIZE_ALLOC_STND_TEMP' from UNITIZE_ALLOC_STND_TEMP union all
- select count(*), 'UNITIZE_CONVERT_OCR' from UNITIZE_CONVERT_OCR union all
- select count(*), 'UNITIZE_CONVERT_OCR_STG' from UNITIZE_CONVERT_OCR_STG union all
- select count(*), 'UNITIZE_ELIG_UNITS_ARC' from UNITIZE_ELIG_UNITS_ARC union all
- select count(*), 'UNITIZE_ELIG_UNITS_TEMP' from UNITIZE_ELIG_UNITS_TEMP union all
- select count(*), 'UNITIZE_PEND_TRANS_TEMP' from UNITIZE_PEND_TRANS_TEMP union all
- select count(*), 'UNITIZE_RATIO_LATE_ADD_ARC' from UNITIZE_RATIO_LATE_ADD_ARC union all
- select count(*), 'UNITIZE_RATIO_LATE_ADD_TEMP' from UNITIZE_RATIO_LATE_ADD_TEMP union all
- select count(*), 'UNITIZE_RATIO_LATE_RWIP_ARC' from UNITIZE_RATIO_LATE_RWIP_ARC union all
- select count(*), 'UNITIZE_RATIO_LATE_RWIP_TEMP' from UNITIZE_RATIO_LATE_RWIP_TEMP union all
- select count(*), 'UNITIZE_RATIO_UNITS_ARC' from UNITIZE_RATIO_UNITS_ARC union all
- select count(*), 'UNITIZE_RATIO_UNITS_TEMP' from UNITIZE_RATIO_UNITS_TEMP union all
- select count(*), 'UNITIZE_WO_LIST' from UNITIZE_WO_LIST union all
- select count(*), 'UNITIZE_WO_LIST_ARC' from UNITIZE_WO_LIST_ARC union all
- select count(*), 'UNITIZE_WO_LIST_TEMP' from UNITIZE_WO_LIST_TEMP union all
- select count(*), 'UNITIZE_WO_STG_UNITS_TEMP' from UNITIZE_WO_STG_UNITS_TEMP union all
- select count(*), 'UNIT_ITEM_CLASS_CODE' from UNIT_ITEM_CLASS_CODE union all
- select count(*), 'UNIT_TARGET_CONTROL' from UNIT_TARGET_CONTROL union all
- select count(*), 'WIP_COMP_CALC' from WIP_COMP_CALC union all
- select count(*), 'WIP_COMP_CHARGES' from WIP_COMP_CHARGES union all
- select count(*), 'WIP_COMP_INPUT' from WIP_COMP_INPUT union all
- select count(*), 'WIP_COMP_PENDING_TRANS' from WIP_COMP_PENDING_TRANS union all
- select count(*), 'WIP_COMP_PEND_TRANS_TEMP' from WIP_COMP_PEND_TRANS_TEMP union all
- select count(*), 'WIP_COMP_TEMP_WO' from WIP_COMP_TEMP_WO union all
- select count(*), 'WIP_COMP_UNIT_CALC' from WIP_COMP_UNIT_CALC union all
- select count(*), 'WIP_COMP_WO_OVERRIDE' from WIP_COMP_WO_OVERRIDE union all
- select count(*), 'WORK_ORDER_ACCOUNT' from WORK_ORDER_ACCOUNT union all
- select count(*), 'WORK_ORDER_ALTERNATIVES' from WORK_ORDER_ALTERNATIVES union all
- select count(*), 'WORK_ORDER_APPROVAL' from WORK_ORDER_APPROVAL union all
- select count(*), 'WORK_ORDER_APPROVAL_ARCH' from WORK_ORDER_APPROVAL_ARCH union all
- select count(*), 'WORK_ORDER_APPROVAL_V' from WORK_ORDER_APPROVAL_V union all
- select count(*), 'WORK_ORDER_CASHFLOW' from WORK_ORDER_CASHFLOW union all
- select count(*), 'WORK_ORDER_CHARGE_GROUP' from WORK_ORDER_CHARGE_GROUP union all
- select count(*), 'WORK_ORDER_CHARGE_GROUP_TEMP' from WORK_ORDER_CHARGE_GROUP_TEMP union all
- select count(*), 'WORK_ORDER_CLASS_CODE' from WORK_ORDER_CLASS_CODE union all
- select count(*), 'WORK_ORDER_CLASS_CODE_DELBKUP' from WORK_ORDER_CLASS_CODE_DELBKUP union all
- select count(*), 'WORK_ORDER_CONTROL' from WORK_ORDER_CONTROL union all
- select count(*), 'WORK_ORDER_CONTROL_SV' from WORK_ORDER_CONTROL_SV union all
- select count(*), 'WORK_ORDER_DEPARTMENT' from WORK_ORDER_DEPARTMENT union all
- select count(*), 'WORK_ORDER_DOCUMENT' from WORK_ORDER_DOCUMENT union all
- select count(*), 'WORK_ORDER_DOCUMENT_BAK' from WORK_ORDER_DOCUMENT_BAK union all
- select count(*), 'WORK_ORDER_INITIATOR' from WORK_ORDER_INITIATOR union all
- select count(*), 'WORK_ORDER_PREREQS' from WORK_ORDER_PREREQS union all
- select count(*), 'WORK_ORDER_TAX_REPAIRS' from WORK_ORDER_TAX_REPAIRS union all
- select count(*), 'WORK_ORDER_TAX_STATUS' from WORK_ORDER_TAX_STATUS union all
- select count(*), 'WO_ACCRUALS' from WO_ACCRUALS union all
- select count(*), 'WO_ACCRUALS_HISTORY' from WO_ACCRUALS_HISTORY union all
- select count(*), 'WO_ACCRUED_GAIN_LOSS' from WO_ACCRUED_GAIN_LOSS union all
- select count(*), 'WO_APPROVAL_MULTIPLE' from WO_APPROVAL_MULTIPLE union all
- select count(*), 'WO_APPROVAL_MULTIPLE_ARCH' from WO_APPROVAL_MULTIPLE_ARCH union all
- select count(*), 'WO_ARC_ALERT_HISTORY' from WO_ARC_ALERT_HISTORY union all
- select count(*), 'WO_ARC_RESULTS' from WO_ARC_RESULTS union all
- select count(*), 'WO_ARC_TEMP_RUN' from WO_ARC_TEMP_RUN union all
- select count(*), 'WO_AUTO101_CONTROL' from WO_AUTO101_CONTROL union all
- select count(*), 'WO_AUTO106_CHARGES' from WO_AUTO106_CHARGES union all
- select count(*), 'WO_AUTO106_CHARGES_SUMM' from WO_AUTO106_CHARGES_SUMM union all
- select count(*), 'WO_AUTO106_CLASS_CODES' from WO_AUTO106_CLASS_CODES union all
- select count(*), 'WO_AUTO106_CONTROL' from WO_AUTO106_CONTROL union all
- select count(*), 'WO_AUTO106_PENDING_TRANS' from WO_AUTO106_PENDING_TRANS union all
- select count(*), 'WO_AUTO106_PENDING_TRANS_ARC' from WO_AUTO106_PENDING_TRANS_ARC union all
- select count(*), 'WO_AUTO106_TEMP_WOS' from WO_AUTO106_TEMP_WOS union all
- select count(*), 'WO_AUTO106_WOS' from WO_AUTO106_WOS union all
- select count(*), 'WO_BILL_MATERIAL' from WO_BILL_MATERIAL union all
- select count(*), 'WO_CHARGE_TYPE_DOLLARS' from WO_CHARGE_TYPE_DOLLARS union all
- select count(*), 'WO_CLEAR_OVER' from WO_CLEAR_OVER union all
- select count(*), 'WO_COMPLETE_DATES_APPROVE' from WO_COMPLETE_DATES_APPROVE union all
- select count(*), 'WO_DOCUMENTATION' from WO_DOCUMENTATION union all
- select count(*), 'WO_DOCUMENTATION_BAK' from WO_DOCUMENTATION_BAK union all
- select count(*), 'WO_DOC_COMMENTS' from WO_DOC_COMMENTS union all
- select count(*), 'WO_DOC_JUSTIFICATION' from WO_DOC_JUSTIFICATION union all
- select count(*), 'WO_DOC_JUST_BAK' from WO_DOC_JUST_BAK union all
- select count(*), 'WO_ENG_ESTIMATE' from WO_ENG_ESTIMATE union all
- select count(*), 'WO_ENG_ESTIMATE_STATUS' from WO_ENG_ESTIMATE_STATUS union all
- select count(*), 'WO_ENG_EST_CHILD' from WO_ENG_EST_CHILD union all
- select count(*), 'WO_ENG_EST_DETAIL' from WO_ENG_EST_DETAIL union all
- select count(*), 'WO_ESTIMATE' from WO_ESTIMATE union all
- select count(*), 'WO_ESTIMATED_RETIRE' from WO_ESTIMATED_RETIRE union all
- select count(*), 'WO_ESTIMATE_BCK' from WO_ESTIMATE_BCK union all
- select count(*), 'WO_ESTIMATE_SPREAD_TEMP' from WO_ESTIMATE_SPREAD_TEMP union all
- select count(*), 'WO_ESTIMATE_SUMMARY_VIEW' from WO_ESTIMATE_SUMMARY_VIEW union all
- select count(*), 'WO_EST_ACTUALS_TEMP' from WO_EST_ACTUALS_TEMP union all
- select count(*), 'WO_EST_ACTUALS_TEMP2' from WO_EST_ACTUALS_TEMP2 union all
- select count(*), 'WO_EST_ALL_VIEW' from WO_EST_ALL_VIEW union all
- select count(*), 'WO_EST_ALL_VIEW2' from WO_EST_ALL_VIEW2 union all
- select count(*), 'WO_EST_ALL_VIEW2APP' from WO_EST_ALL_VIEW2APP union all
- select count(*), 'WO_EST_ALL_VIEWAPP' from WO_EST_ALL_VIEWAPP union all
- select count(*), 'WO_EST_APPR_REVISION_VIEW' from WO_EST_APPR_REVISION_VIEW union all
- select count(*), 'WO_EST_CAPITAL_VIEW' from WO_EST_CAPITAL_VIEW union all
- select count(*), 'WO_EST_CAPITAL_VIEW2' from WO_EST_CAPITAL_VIEW2 union all
- select count(*), 'WO_EST_CAPITAL_VIEW2APP' from WO_EST_CAPITAL_VIEW2APP union all
- select count(*), 'WO_EST_CAPITAL_VIEWAPP' from WO_EST_CAPITAL_VIEWAPP union all
- select count(*), 'WO_EST_CLOSINGS_WOS' from WO_EST_CLOSINGS_WOS union all
- select count(*), 'WO_EST_COPY_REVISION_TEMP' from WO_EST_COPY_REVISION_TEMP union all
- select count(*), 'WO_EST_COTENANT_SPREAD_TEMP' from WO_EST_COTENANT_SPREAD_TEMP union all
- select count(*), 'WO_EST_CREDITS_VIEW' from WO_EST_CREDITS_VIEW union all
- select count(*), 'WO_EST_CREDITS_VIEW2' from WO_EST_CREDITS_VIEW2 union all
- select count(*), 'WO_EST_CREDITS_VIEW2APP' from WO_EST_CREDITS_VIEW2APP union all
- select count(*), 'WO_EST_CREDITS_VIEWAPP' from WO_EST_CREDITS_VIEWAPP union all
- select count(*), 'WO_EST_DATE_CHANGES' from WO_EST_DATE_CHANGES union all
- select count(*), 'WO_EST_DERIVATION_PCT' from WO_EST_DERIVATION_PCT union all
- select count(*), 'WO_EST_EXPENSE_VIEW' from WO_EST_EXPENSE_VIEW union all
- select count(*), 'WO_EST_EXPENSE_VIEW2' from WO_EST_EXPENSE_VIEW2 union all
- select count(*), 'WO_EST_EXPENSE_VIEW2APP' from WO_EST_EXPENSE_VIEW2APP union all
- select count(*), 'WO_EST_EXPENSE_VIEWAPP' from WO_EST_EXPENSE_VIEWAPP union all
- select count(*), 'WO_EST_EXP_TYPE_VIEW' from WO_EST_EXP_TYPE_VIEW union all
- select count(*), 'WO_EST_FIRST_VIEW' from WO_EST_FIRST_VIEW union all
- select count(*), 'WO_EST_FIRST_VIEW_CASH_FLOW' from WO_EST_FIRST_VIEW_CASH_FLOW union all
- select count(*), 'WO_EST_INITIAL_REVISION' from WO_EST_INITIAL_REVISION union all
- select count(*), 'WO_EST_JOBBING_VIEW' from WO_EST_JOBBING_VIEW union all
- select count(*), 'WO_EST_JOBBING_VIEW2' from WO_EST_JOBBING_VIEW2 union all
- select count(*), 'WO_EST_JOBBING_VIEW2APP' from WO_EST_JOBBING_VIEW2APP union all
- select count(*), 'WO_EST_JOBBING_VIEWAPP' from WO_EST_JOBBING_VIEWAPP union all
- select count(*), 'WO_EST_MONTHLY' from WO_EST_MONTHLY union all
- select count(*), 'WO_EST_MONTHLY_20110318' from WO_EST_MONTHLY_20110318 union all
- select count(*), 'WO_EST_MONTHLY_ARCH' from WO_EST_MONTHLY_ARCH union all
- select count(*), 'WO_EST_MONTHLY_CR' from WO_EST_MONTHLY_CR union all
- select count(*), 'WO_EST_MONTHLY_DEESCALATED_VW' from WO_EST_MONTHLY_DEESCALATED_VW union all
- select count(*), 'WO_EST_MONTHLY_DEESCALATION_VW' from WO_EST_MONTHLY_DEESCALATION_VW union all
- select count(*), 'WO_EST_MONTHLY_DEESC_SV' from WO_EST_MONTHLY_DEESC_SV union all
- select count(*), 'WO_EST_MONTHLY_DEESC_VW_FY' from WO_EST_MONTHLY_DEESC_VW_FY union all
- select count(*), 'WO_EST_MONTHLY_FY' from WO_EST_MONTHLY_FY union all
- select count(*), 'WO_EST_MONTHLY_FY_BDG_V' from WO_EST_MONTHLY_FY_BDG_V union all
- select count(*), 'WO_EST_MONTHLY_FY_DEESC_SV' from WO_EST_MONTHLY_FY_DEESC_SV union all
- select count(*), 'WO_EST_MONTHLY_FY_SV' from WO_EST_MONTHLY_FY_SV union all
- select count(*), 'WO_EST_MONTHLY_FY_TEMP' from WO_EST_MONTHLY_FY_TEMP union all
- select count(*), 'WO_EST_MONTHLY_FY_TEMP_CAL' from WO_EST_MONTHLY_FY_TEMP_CAL union all
- select count(*), 'WO_EST_MONTHLY_MONTH_NUMBER' from WO_EST_MONTHLY_MONTH_NUMBER union all
- select count(*), 'WO_EST_MONTHLY_SUBS_DET' from WO_EST_MONTHLY_SUBS_DET union all
- select count(*), 'WO_EST_MONTHLY_SV' from WO_EST_MONTHLY_SV union all
- select count(*), 'WO_EST_MONTHLY_UPLOAD' from WO_EST_MONTHLY_UPLOAD union all
- select count(*), 'WO_EST_MONTHLY_UPLOAD_ARCH' from WO_EST_MONTHLY_UPLOAD_ARCH union all
- select count(*), 'WO_EST_MONTHLY_VIEW' from WO_EST_MONTHLY_VIEW union all
- select count(*), 'WO_EST_MONTHLY_VIEW_TEMP' from WO_EST_MONTHLY_VIEW_TEMP union all
- select count(*), 'WO_EST_MONTH_IS_EDITABLE' from WO_EST_MONTH_IS_EDITABLE union all
- select count(*), 'WO_EST_MONTH_IS_EDITABLE_FY' from WO_EST_MONTH_IS_EDITABLE_FY union all
- select count(*), 'WO_EST_MONTH_IS_EDITABLE_JT' from WO_EST_MONTH_IS_EDITABLE_JT union all
- select count(*), 'WO_EST_MONTH_IS_EDITABLE_JT_FY' from WO_EST_MONTH_IS_EDITABLE_JT_FY union all
- select count(*), 'WO_EST_MONTH_IS_EDITABLE_TEMP' from WO_EST_MONTH_IS_EDITABLE_TEMP union all
- select count(*), 'WO_EST_MONTH_IS_EDIT_JT_TEMP' from WO_EST_MONTH_IS_EDIT_JT_TEMP union all
- select count(*), 'WO_EST_PROCESSING_MO_ID' from WO_EST_PROCESSING_MO_ID union all
- select count(*), 'WO_EST_PROCESSING_TEMP' from WO_EST_PROCESSING_TEMP union all
- select count(*), 'WO_EST_PROCESSING_TRANSPOSE' from WO_EST_PROCESSING_TRANSPOSE union all
- select count(*), 'WO_EST_RATE_DEFAULT' from WO_EST_RATE_DEFAULT union all
- select count(*), 'WO_EST_RATE_FILTER' from WO_EST_RATE_FILTER union all
- select count(*), 'WO_EST_REMOVAL_VIEW' from WO_EST_REMOVAL_VIEW union all
- select count(*), 'WO_EST_REMOVAL_VIEW2' from WO_EST_REMOVAL_VIEW2 union all
- select count(*), 'WO_EST_REMOVAL_VIEW2APP' from WO_EST_REMOVAL_VIEW2APP union all
- select count(*), 'WO_EST_REMOVAL_VIEWAPP' from WO_EST_REMOVAL_VIEWAPP union all
- select count(*), 'WO_EST_RETIREMENT_VIEW' from WO_EST_RETIREMENT_VIEW union all
- select count(*), 'WO_EST_RETIREMENT_VIEW2' from WO_EST_RETIREMENT_VIEW2 union all
- select count(*), 'WO_EST_REVISION_VIEW' from WO_EST_REVISION_VIEW union all
- select count(*), 'WO_EST_SLIDE_RESULTS_TEMP' from WO_EST_SLIDE_RESULTS_TEMP union all
- select count(*), 'WO_EST_SUMMARY_TBL' from WO_EST_SUMMARY_TBL union all
- select count(*), 'WO_EST_SUMMARY_TOTAL_VIEW' from WO_EST_SUMMARY_TOTAL_VIEW union all
- select count(*), 'WO_EST_SUMMARY_TOTAL_VIEW_EXP' from WO_EST_SUMMARY_TOTAL_VIEW_EXP union all
- select count(*), 'WO_EST_SUMMARY_VIEW' from WO_EST_SUMMARY_VIEW union all
- select count(*), 'WO_EST_SUMMARY_WO_CREDITS_V2' from WO_EST_SUMMARY_WO_CREDITS_V2 union all
- select count(*), 'WO_EST_SUPPLEMENTAL_DATA' from WO_EST_SUPPLEMENTAL_DATA union all
- select count(*), 'WO_EST_TOTAL_COST_VIEW' from WO_EST_TOTAL_COST_VIEW union all
- select count(*), 'WO_EST_TRANSPOSE_TEMP' from WO_EST_TRANSPOSE_TEMP union all
- select count(*), 'WO_EST_UPDATE_WITH_ACT_TEMP' from WO_EST_UPDATE_WITH_ACT_TEMP union all
- select count(*), 'WO_EST_UPLOAD_NEW_COMBOS2' from WO_EST_UPLOAD_NEW_COMBOS2 union all
- select count(*), 'WO_GL_ACCOUNT_SUMMARY' from WO_GL_ACCOUNT_SUMMARY union all
- select count(*), 'WO_GL_ACCOUNT_SUMMARY_MO' from WO_GL_ACCOUNT_SUMMARY_MO union all
- select count(*), 'WO_GL_ACCOUNT_SUMMARY_PRESET' from WO_GL_ACCOUNT_SUMMARY_PRESET union all
- select count(*), 'WO_GL_ACCT_BEG_BAL_ANNUAL_VIEW' from WO_GL_ACCT_BEG_BAL_ANNUAL_VIEW union all
- select count(*), 'WO_GL_ACCT_BEG_BAL_SINGLE_VIEW' from WO_GL_ACCT_BEG_BAL_SINGLE_VIEW union all
- select count(*), 'WO_GL_ACCT_BEG_BAL_SPAN_VIEW' from WO_GL_ACCT_BEG_BAL_SPAN_VIEW union all
- select count(*), 'WO_GL_ACCT_BEG_BAL_VIEW2' from WO_GL_ACCT_BEG_BAL_VIEW2 union all
- select count(*), 'WO_GL_ACCT_END_BAL_VIEW2' from WO_GL_ACCT_END_BAL_VIEW2 union all
- select count(*), 'WO_GL_ACCT_END_BAL_VIEW3' from WO_GL_ACCT_END_BAL_VIEW3 union all
- select count(*), 'WO_GL_ACCT_END_BAL_VIEW4' from WO_GL_ACCT_END_BAL_VIEW4 union all
- select count(*), 'WO_INTERFACE_MONTHLY' from WO_INTERFACE_MONTHLY union all
- select count(*), 'WO_INTERFACE_MONTHLY_ARC' from WO_INTERFACE_MONTHLY_ARC union all
- select count(*), 'WO_INTERFACE_MONTHLY_BAK_ORIG' from WO_INTERFACE_MONTHLY_BAK_ORIG union all
- select count(*), 'WO_INTERFACE_MONTHLY_BAK_ORIG2' from WO_INTERFACE_MONTHLY_BAK_ORIG2 union all
- select count(*), 'WO_INTERFACE_MONTHLY_IDS' from WO_INTERFACE_MONTHLY_IDS union all
- select count(*), 'WO_INTERFACE_MONTHLY_IMP_ARC' from WO_INTERFACE_MONTHLY_IMP_ARC union all
- select count(*), 'WO_INTERFACE_MONTHLY_IMP_STG' from WO_INTERFACE_MONTHLY_IMP_STG union all
- select count(*), 'WO_INTERFACE_MONTHLY_TEMP' from WO_INTERFACE_MONTHLY_TEMP union all
- select count(*), 'WO_INTERFACE_MONTHLY_VIEW' from WO_INTERFACE_MONTHLY_VIEW union all
- select count(*), 'WO_INTERFACE_OCR_ARC' from WO_INTERFACE_OCR_ARC union all
- select count(*), 'WO_INTERFACE_OCR_IMP_ARC' from WO_INTERFACE_OCR_IMP_ARC union all
- select count(*), 'WO_INTERFACE_OCR_IMP_STG' from WO_INTERFACE_OCR_IMP_STG union all
- select count(*), 'WO_INTERFACE_OCR_STG' from WO_INTERFACE_OCR_STG union all
- select count(*), 'WO_INTERFACE_REVISIONS' from WO_INTERFACE_REVISIONS union all
- select count(*), 'WO_INTERFACE_STAGING' from WO_INTERFACE_STAGING union all
- select count(*), 'WO_INTERFACE_STAGING_ARC' from WO_INTERFACE_STAGING_ARC union all
- select count(*), 'WO_INTERFACE_STAGING_IMP_ARC' from WO_INTERFACE_STAGING_IMP_ARC union all
- select count(*), 'WO_INTERFACE_STAGING_IMP_STG' from WO_INTERFACE_STAGING_IMP_STG union all
- select count(*), 'WO_INTERFACE_STAGING_RON' from WO_INTERFACE_STAGING_RON union all
- select count(*), 'WO_INTERFACE_UNIT' from WO_INTERFACE_UNIT union all
- select count(*), 'WO_INTERFACE_UNIT_ARC' from WO_INTERFACE_UNIT_ARC union all
- select count(*), 'WO_INTERFACE_UNIT_IMP_ARC' from WO_INTERFACE_UNIT_IMP_ARC union all
- select count(*), 'WO_INTERFACE_UNIT_IMP_STG' from WO_INTERFACE_UNIT_IMP_STG union all
- select count(*), 'WO_MAX_REVISION_VIEW' from WO_MAX_REVISION_VIEW union all
- select count(*), 'WO_MAX_REVISION_VIEW_NOREV' from WO_MAX_REVISION_VIEW_NOREV union all
- select count(*), 'WO_PSEUDO_UNITIZE_SUMMARY' from WO_PSEUDO_UNITIZE_SUMMARY union all
- select count(*), 'WO_PSEUDO_UNITIZE_SUMMARY_BCK' from WO_PSEUDO_UNITIZE_SUMMARY_BCK union all
- select count(*), 'WO_PSEUDO_UNITIZE_SUMMARY_MO' from WO_PSEUDO_UNITIZE_SUMMARY_MO union all
- select count(*), 'WO_REIMBURSABLE' from WO_REIMBURSABLE union all
- select count(*), 'WO_STATUS_TRAIL' from WO_STATUS_TRAIL union all
- select count(*), 'WO_SUMMARY' from WO_SUMMARY union all
- select count(*), 'WO_SUMMARY_COMMITMENTS' from WO_SUMMARY_COMMITMENTS union all
- select count(*), 'WO_TOTAL_COST_CLOSE_VIEW' from WO_TOTAL_COST_CLOSE_VIEW union all
- select count(*), 'WO_TOTAL_COST_CURR_VIEW' from WO_TOTAL_COST_CURR_VIEW union all
- select count(*), 'WO_TOTAL_COST_VIEW' from WO_TOTAL_COST_VIEW union all
- select count(*), 'WO_TOTAL_COST_W_FUND_VIEW' from WO_TOTAL_COST_W_FUND_VIEW union all
- select count(*), 'WO_UNIT_ITEM_PEND_TRANS' from WO_UNIT_ITEM_PEND_TRANS
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement