Advertisement
Guest User

Untitled

a guest
Apr 26th, 2017
97
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 36.20 KB | None | 0 0
  1. select count(*), 'AFUDC_CALC' from AFUDC_CALC union all
  2. select count(*), 'AFUDC_CALC_TEST' from AFUDC_CALC_TEST union all
  3. select count(*), 'AFUDC_CALC_WO_LIST_TEMP' from AFUDC_CALC_WO_LIST_TEMP union all
  4. select count(*), 'AFUDC_INPUT' from AFUDC_INPUT union all
  5. select count(*), 'AFUDC_INPUT_RATIO' from AFUDC_INPUT_RATIO union all
  6. select count(*), 'APPROVALS_PENDING' from APPROVALS_PENDING union all
  7. select count(*), 'APPROVAL_DELEGATION_HIST' from APPROVAL_DELEGATION_HIST union all
  8. select count(*), 'ARC_AFUDC_INPUT' from ARC_AFUDC_INPUT union all
  9. select count(*), 'ARC_FUNDING_JUSTIFICATION' from ARC_FUNDING_JUSTIFICATION union all
  10. select count(*), 'ARC_WORK_ORDER_BLANKETS_LIST' from ARC_WORK_ORDER_BLANKETS_LIST union all
  11. select count(*), 'ARC_WORK_ORDER_LIST' from ARC_WORK_ORDER_LIST union all
  12. select count(*), 'ARC_WO_AVAILABLE_LIST' from ARC_WO_AVAILABLE_LIST union all
  13. select count(*), 'ARC_WO_BK_AVAILABLE_LIST' from ARC_WO_BK_AVAILABLE_LIST union all
  14. select count(*), 'ARC_WO_BK_GROUPS' from ARC_WO_BK_GROUPS union all
  15. select count(*), 'ARC_WO_BK_UNITS' from ARC_WO_BK_UNITS union all
  16. select count(*), 'ARO_LAYER_WORK_ORDER' from ARO_LAYER_WORK_ORDER union all
  17. select count(*), 'ARO_WORK_ORDER' from ARO_WORK_ORDER union all
  18. select count(*), 'BI_EST_MONTH_IS_EDITABLE' from BI_EST_MONTH_IS_EDITABLE union all
  19. select count(*), 'BI_EST_MONTH_IS_EDITABLE_FY' from BI_EST_MONTH_IS_EDITABLE_FY union all
  20. select count(*), 'BUDGET_ACTUALS_TEMP' from BUDGET_ACTUALS_TEMP union all
  21. select count(*), 'BUDGET_AFUDC_CALC' from BUDGET_AFUDC_CALC union all
  22. select count(*), 'BUDGET_AFUDC_CALC_BEG_BAL' from BUDGET_AFUDC_CALC_BEG_BAL union all
  23. select count(*), 'BUDGET_AFUDC_CALC_BEG_BAL_TEMP' from BUDGET_AFUDC_CALC_BEG_BAL_TEMP union all
  24. select count(*), 'BUDGET_AFUDC_CALC_CLOSING' from BUDGET_AFUDC_CALC_CLOSING union all
  25. select count(*), 'BUDGET_AFUDC_CALC_CLOSING_TEMP' from BUDGET_AFUDC_CALC_CLOSING_TEMP union all
  26. select count(*), 'BUDGET_AFUDC_CALC_FY_SV' from BUDGET_AFUDC_CALC_FY_SV union all
  27. select count(*), 'BUDGET_AFUDC_CALC_SV' from BUDGET_AFUDC_CALC_SV union all
  28. select count(*), 'BUDGET_AFUDC_CALC_TEMP' from BUDGET_AFUDC_CALC_TEMP union all
  29. select count(*), 'BUDGET_APPROVAL_DATA' from BUDGET_APPROVAL_DATA union all
  30. select count(*), 'BUDGET_APPROVAL_DATA_ARCH' from BUDGET_APPROVAL_DATA_ARCH union all
  31. select count(*), 'BUDGET_APPROVAL_DATA_FY' from BUDGET_APPROVAL_DATA_FY union all
  32. select count(*), 'BUDGET_CAP_INTEREST_WO' from BUDGET_CAP_INTEREST_WO union all
  33. select count(*), 'BUDGET_CLOSINGS' from BUDGET_CLOSINGS union all
  34. select count(*), 'BUDGET_CLOSINGS_PCT' from BUDGET_CLOSINGS_PCT union all
  35. select count(*), 'BUDGET_CLOSINGS_STAGE' from BUDGET_CLOSINGS_STAGE union all
  36. select count(*), 'BUDGET_CLOSINGS_TEMP' from BUDGET_CLOSINGS_TEMP union all
  37. select count(*), 'BUDGET_CWIP_IN_RATE_BASE' from BUDGET_CWIP_IN_RATE_BASE union all
  38. select count(*), 'BUDGET_MONTHLY_DATA' from BUDGET_MONTHLY_DATA union all
  39. select count(*), 'BUDGET_MONTHLY_DATA_ARCH' from BUDGET_MONTHLY_DATA_ARCH union all
  40. select count(*), 'BUDGET_MONTHLY_DATA_CR' from BUDGET_MONTHLY_DATA_CR union all
  41. select count(*), 'BUDGET_MONTHLY_DATA_FY' from BUDGET_MONTHLY_DATA_FY union all
  42. select count(*), 'BUDGET_MONTHLY_DATA_MO_ID' from BUDGET_MONTHLY_DATA_MO_ID union all
  43. select count(*), 'BUDGET_MONTHLY_DATA_TRANSPOSE' from BUDGET_MONTHLY_DATA_TRANSPOSE union all
  44. select count(*), 'BUDGET_MONTHLY_DATA_TRANS_TEMP' from BUDGET_MONTHLY_DATA_TRANS_TEMP union all
  45. select count(*), 'BUDGET_MONTHLY_FISCAL_YEAR' from BUDGET_MONTHLY_FISCAL_YEAR union all
  46. select count(*), 'BUDGET_REVIEW' from BUDGET_REVIEW union all
  47. select count(*), 'BUDGET_REVIEW_ARCH' from BUDGET_REVIEW_ARCH union all
  48. select count(*), 'BUDGET_REVIEW_DETAIL' from BUDGET_REVIEW_DETAIL union all
  49. select count(*), 'BUDGET_REVIEW_DETAIL_ARCH' from BUDGET_REVIEW_DETAIL_ARCH union all
  50. select count(*), 'BUDGET_VERSION_FUND_PROJ' from BUDGET_VERSION_FUND_PROJ union all
  51. select count(*), 'BUDGET_VERSION_FUND_PROJ_ARCH' from BUDGET_VERSION_FUND_PROJ_ARCH union all
  52. select count(*), 'BUDGET_VERSION_FUND_PROJ_SV' from BUDGET_VERSION_FUND_PROJ_SV union all
  53. select count(*), 'BUDGET_WIP_COMP_CALC' from BUDGET_WIP_COMP_CALC union all
  54. select count(*), 'BUDGET_WIP_COMP_CALC_TEMP' from BUDGET_WIP_COMP_CALC_TEMP union all
  55. select count(*), 'BUDGET_WIP_COMP_INPUT' from BUDGET_WIP_COMP_INPUT union all
  56. select count(*), 'BUDG_MONTHLY_DATA_DEESC_SV' from BUDG_MONTHLY_DATA_DEESC_SV union all
  57. select count(*), 'BUDG_MONTHLY_DATA_FY_DEESC_SV' from BUDG_MONTHLY_DATA_FY_DEESC_SV union all
  58. select count(*), 'BUDG_MONTHLY_DATA_FY_SV' from BUDG_MONTHLY_DATA_FY_SV union all
  59. select count(*), 'BUDG_MONTHLY_DATA_SV' from BUDG_MONTHLY_DATA_SV union all
  60. select count(*), 'BV_FP_RESPREAD_AUDIT' from BV_FP_RESPREAD_AUDIT union all
  61. select count(*), 'BV_PROJ_RANKING_RESULTS' from BV_PROJ_RANKING_RESULTS union all
  62. select count(*), 'CAP_INTEREST_WO' from CAP_INTEREST_WO union all
  63. select count(*), 'CHARGE_GROUP_CONTROL' from CHARGE_GROUP_CONTROL union all
  64. select count(*), 'CHARGE_SUMMARY' from CHARGE_SUMMARY union all
  65. select count(*), 'CHARGE_SUMMARY_BACKUP' from CHARGE_SUMMARY_BACKUP union all
  66. select count(*), 'CHARGE_SUMMARY_CLOSINGS' from CHARGE_SUMMARY_CLOSINGS union all
  67. select count(*), 'CHARGE_SUPER_SUMMARY_VIEW' from CHARGE_SUPER_SUMMARY_VIEW union all
  68. select count(*), 'CLEARING_WO_CONTROL' from CLEARING_WO_CONTROL union all
  69. select count(*), 'COMMITMENTS' from COMMITMENTS union all
  70. select count(*), 'COMMITMENTS_BI_FY_SV' from COMMITMENTS_BI_FY_SV union all
  71. select count(*), 'COMMITMENTS_BI_SV' from COMMITMENTS_BI_SV union all
  72. select count(*), 'COMMITMENTS_FP_FY_SV' from COMMITMENTS_FP_FY_SV union all
  73. select count(*), 'COMMITMENTS_FP_SV' from COMMITMENTS_FP_SV union all
  74. select count(*), 'COMMITMENTS_TMP' from COMMITMENTS_TMP union all
  75. select count(*), 'CONV_PNG_WO_INTERFACE_STG' from CONV_PNG_WO_INTERFACE_STG union all
  76. select count(*), 'CO_TENANCY_WO' from CO_TENANCY_WO union all
  77. select count(*), 'CPI_RETRO_106_OOB_WO' from CPI_RETRO_106_OOB_WO union all
  78. select count(*), 'CPI_RETRO_ALLOC_ERROR' from CPI_RETRO_ALLOC_ERROR union all
  79. select count(*), 'CPI_RETRO_ASSET_ALLOCATION' from CPI_RETRO_ASSET_ALLOCATION union all
  80. select count(*), 'CPI_RETRO_BASE_ADJUST' from CPI_RETRO_BASE_ADJUST union all
  81. select count(*), 'CPI_RETRO_CALC' from CPI_RETRO_CALC union all
  82. select count(*), 'CPI_RETRO_CLOSINGS' from CPI_RETRO_CLOSINGS union all
  83. select count(*), 'CPI_RETRO_CLOSINGS_TEMP' from CPI_RETRO_CLOSINGS_TEMP union all
  84. select count(*), 'CPI_RETRO_COMPARE' from CPI_RETRO_COMPARE union all
  85. select count(*), 'CPI_RETRO_CPR_ASSETS' from CPI_RETRO_CPR_ASSETS union all
  86. select count(*), 'CPI_RETRO_WO_LIST_TEMP' from CPI_RETRO_WO_LIST_TEMP union all
  87. select count(*), 'CPI_WO_COMPARE' from CPI_WO_COMPARE union all
  88. select count(*), 'CPR_EQUIP_ESTIMATE_RELATE' from CPR_EQUIP_ESTIMATE_RELATE union all
  89. select count(*), 'CPR_EQUIP_LEDGER_API' from CPR_EQUIP_LEDGER_API union all
  90. select count(*), 'CPR_EQUIP_LEDGER_API_ARCHIVE' from CPR_EQUIP_LEDGER_API_ARCHIVE union all
  91. select count(*), 'CPR_EQUIP_LEDGER_API_TEMP' from CPR_EQUIP_LEDGER_API_TEMP union all
  92. select count(*), 'CPR_EQUIP_RETIRE_RELATE' from CPR_EQUIP_RETIRE_RELATE union all
  93. select count(*), 'CRB_BUDGET_DATA' from CRB_BUDGET_DATA union all
  94. select count(*), 'CR_BUDGET_AFUDC_CALC' from CR_BUDGET_AFUDC_CALC union all
  95. select count(*), 'CR_BUDGET_DATA' from CR_BUDGET_DATA union all
  96. select count(*), 'CR_BUDGET_DATA_PROJECTS' from CR_BUDGET_DATA_PROJECTS union all
  97. select count(*), 'CR_BUDGET_DATA_STSV' from CR_BUDGET_DATA_STSV union all
  98. select count(*), 'CR_BUDGET_DATA_SV' from CR_BUDGET_DATA_SV union all
  99. select count(*), 'CR_BUDGET_DATA_TEMP' from CR_BUDGET_DATA_TEMP union all
  100. select count(*), 'CR_BUDGET_DATA_TEST' from CR_BUDGET_DATA_TEST union all
  101. select count(*), 'CR_BUDGET_REVERSALS' from CR_BUDGET_REVERSALS union all
  102. select count(*), 'CR_CANCEL_DETAIL' from CR_CANCEL_DETAIL union all
  103. select count(*), 'CR_CANCEL_HEADER' from CR_CANCEL_HEADER union all
  104. select count(*), 'CR_CANCEL_RESULTS' from CR_CANCEL_RESULTS union all
  105. select count(*), 'CR_CANCEL_RESULTS_1' from CR_CANCEL_RESULTS_1 union all
  106. select count(*), 'CR_CANCEL_RESULTS_10' from CR_CANCEL_RESULTS_10 union all
  107. select count(*), 'CR_CANCEL_RESULTS_2' from CR_CANCEL_RESULTS_2 union all
  108. select count(*), 'CR_CANCEL_RESULTS_3' from CR_CANCEL_RESULTS_3 union all
  109. select count(*), 'CR_CANCEL_RESULTS_4' from CR_CANCEL_RESULTS_4 union all
  110. select count(*), 'CR_CANCEL_RESULTS_5' from CR_CANCEL_RESULTS_5 union all
  111. select count(*), 'CR_CANCEL_RESULTS_6' from CR_CANCEL_RESULTS_6 union all
  112. select count(*), 'CR_CANCEL_RESULTS_7' from CR_CANCEL_RESULTS_7 union all
  113. select count(*), 'CR_CANCEL_RESULTS_8' from CR_CANCEL_RESULTS_8 union all
  114. select count(*), 'CR_CANCEL_RESULTS_9' from CR_CANCEL_RESULTS_9 union all
  115. select count(*), 'CR_COMMITMENTS_SUM' from CR_COMMITMENTS_SUM union all
  116. select count(*), 'CR_COMMITMENTS_TRANSLATE' from CR_COMMITMENTS_TRANSLATE union all
  117. select count(*), 'CR_CWIP_CHARGE_SUM' from CR_CWIP_CHARGE_SUM union all
  118. select count(*), 'CR_CWIP_CHARGE_TRANSLATE' from CR_CWIP_CHARGE_TRANSLATE union all
  119. select count(*), 'CR_DERIVER_CONTROL' from CR_DERIVER_CONTROL union all
  120. select count(*), 'CR_DERIVER_CONTROL_VIRTUAL' from CR_DERIVER_CONTROL_VIRTUAL union all
  121. select count(*), 'CR_TEMP_CR_GL_BDG' from CR_TEMP_CR_GL_BDG union all
  122. select count(*), 'CR_TEMP_CR_GL_BDG_TEMP' from CR_TEMP_CR_GL_BDG_TEMP union all
  123. select count(*), 'CWIP_BI_FY_SV' from CWIP_BI_FY_SV union all
  124. select count(*), 'CWIP_BI_SV' from CWIP_BI_SV union all
  125. select count(*), 'CWIP_CHARGE' from CWIP_CHARGE union all
  126. select count(*), 'CWIP_CHARGE_NET_VIEW' from CWIP_CHARGE_NET_VIEW union all
  127. select count(*), 'CWIP_CHARGE_SOB_VIEW' from CWIP_CHARGE_SOB_VIEW union all
  128. select count(*), 'CWIP_FP_FY_SV' from CWIP_FP_FY_SV union all
  129. select count(*), 'CWIP_FP_SV' from CWIP_FP_SV union all
  130. select count(*), 'CWIP_IN_RATE_BASE' from CWIP_IN_RATE_BASE union all
  131. select count(*), 'D1_WO_INTERFACE_MONTHLY_ARC' from D1_WO_INTERFACE_MONTHLY_ARC union all
  132. select count(*), 'DIRECT_CHARGES_VIEW' from DIRECT_CHARGES_VIEW union all
  133. select count(*), 'EVERY_PROJECT_EVERY_REVISION' from EVERY_PROJECT_EVERY_REVISION union all
  134. select count(*), 'FCST_BUDGET_LOAD' from FCST_BUDGET_LOAD union all
  135. select count(*), 'FCST_BUDGET_LOAD_ARCH' from FCST_BUDGET_LOAD_ARCH union all
  136. select count(*), 'FUNDING_JUSTIFICATION' from FUNDING_JUSTIFICATION union all
  137. select count(*), 'INCREMENTAL_FP_ADJ_DATA' from INCREMENTAL_FP_ADJ_DATA union all
  138. select count(*), 'INCREMENTAL_FP_RUN_LOG' from INCREMENTAL_FP_RUN_LOG union all
  139. select count(*), 'JOB_TASK' from JOB_TASK union all
  140. select count(*), 'JOB_TASK_CLASS_CODE' from JOB_TASK_CLASS_CODE union all
  141. select count(*), 'JOB_TASK_DOCUMENT' from JOB_TASK_DOCUMENT union all
  142. select count(*), 'JOB_TASK_INTERFACE_STAGING' from JOB_TASK_INTERFACE_STAGING union all
  143. select count(*), 'JOB_TASK_INTERFACE_STAGING_ARC' from JOB_TASK_INTERFACE_STAGING_ARC union all
  144. select count(*), 'JOB_TASK_INT_STG_IMP_ARC' from JOB_TASK_INT_STG_IMP_ARC union all
  145. select count(*), 'JOB_TASK_INT_STG_IMP_STG' from JOB_TASK_INT_STG_IMP_STG union all
  146. select count(*), 'JUR_AFC_SHADOW_MAPPING' from JUR_AFC_SHADOW_MAPPING union all
  147. select count(*), 'LS_ASSET' from LS_ASSET union all
  148. select count(*), 'LS_IMPORT_ASSET' from LS_IMPORT_ASSET union all
  149. select count(*), 'LS_IMPORT_ASSET_ARCHIVE' from LS_IMPORT_ASSET_ARCHIVE union all
  150. select count(*), 'LS_PEND_TRANSACTION' from LS_PEND_TRANSACTION union all
  151. select count(*), 'LS_PEND_TRANSACTION_ARC' from LS_PEND_TRANSACTION_ARC union all
  152. select count(*), 'MATLREC_TRANS' from MATLREC_TRANS union all
  153. select count(*), 'MATLREC_TRANS_STG' from MATLREC_TRANS_STG union all
  154. select count(*), 'ORIGINAL_COST_RETIREMENT' from ORIGINAL_COST_RETIREMENT union all
  155. select count(*), 'ORIGINAL_COST_RETIREMENT_STG' from ORIGINAL_COST_RETIREMENT_STG union all
  156. select count(*), 'PNG_BUDGET_CONVERSION' from PNG_BUDGET_CONVERSION union all
  157. select count(*), 'PNG_BUDGET_CONVERSION3' from PNG_BUDGET_CONVERSION3 union all
  158. select count(*), 'PNG_BUDGET_CONVERSION4' from PNG_BUDGET_CONVERSION4 union all
  159. select count(*), 'PNG_BUDGET_CONV_POOL_PROJECTS' from PNG_BUDGET_CONV_POOL_PROJECTS union all
  160. select count(*), 'PNG_BVFP_BCK' from PNG_BVFP_BCK union all
  161. select count(*), 'PNG_DEPR_FCST_UA_PCT_FP' from PNG_DEPR_FCST_UA_PCT_FP union all
  162. select count(*), 'PNG_DISTRIB_COMPT_VW1_ARC' from PNG_DISTRIB_COMPT_VW1_ARC union all
  163. select count(*), 'PNG_DISTRIB_COMPT_VW1_PROCESS' from PNG_DISTRIB_COMPT_VW1_PROCESS union all
  164. select count(*), 'PNG_ERT_INTERFACE' from PNG_ERT_INTERFACE union all
  165. select count(*), 'PNG_JUST_MULTI_SELECT' from PNG_JUST_MULTI_SELECT union all
  166. select count(*), 'PNG_METER_INTERFACE' from PNG_METER_INTERFACE union all
  167. select count(*), 'PNG_METER_INTERFACE_TEST' from PNG_METER_INTERFACE_TEST union all
  168. select count(*), 'PNG_MGRAP_EST_FWDING' from PNG_MGRAP_EST_FWDING union all
  169. select count(*), 'PNG_MGRAP_EST_FWDING_ARC' from PNG_MGRAP_EST_FWDING_ARC union all
  170. select count(*), 'PNG_MGRAP_EST_FWDING_AUD' from PNG_MGRAP_EST_FWDING_AUD union all
  171. select count(*), 'PNG_PS_PROJ_ACTIVITY' from PNG_PS_PROJ_ACTIVITY union all
  172. select count(*), 'PNG_PT_DCMS_STAGING' from PNG_PT_DCMS_STAGING union all
  173. select count(*), 'PNG_Q1_BUDGET_MIGRATION' from PNG_Q1_BUDGET_MIGRATION union all
  174. select count(*), 'PNG_S2K_PROCESS' from PNG_S2K_PROCESS union all
  175. select count(*), 'PNG_SERV_ORDER_VW1_ARC' from PNG_SERV_ORDER_VW1_ARC union all
  176. select count(*), 'PNG_SERV_ORDER_VW1_PROCESS' from PNG_SERV_ORDER_VW1_PROCESS union all
  177. select count(*), 'PNG_WAM_WR_COST_MAN_RET' from PNG_WAM_WR_COST_MAN_RET union all
  178. select count(*), 'PNG_WEM_TO_WEM_FP' from PNG_WEM_TO_WEM_FP union all
  179. select count(*), 'PNG_WO_ESTIMATES_VIEW' from PNG_WO_ESTIMATES_VIEW union all
  180. select count(*), 'PNG_WO_INTERFACE_STAGING_1042' from PNG_WO_INTERFACE_STAGING_1042 union all
  181. select count(*), 'PNG_WO_INTERFACE_STAGING_ERROR' from PNG_WO_INTERFACE_STAGING_ERROR union all
  182. select count(*), 'PNG_WO_INTERFACE_UNIT_1042' from PNG_WO_INTERFACE_UNIT_1042 union all
  183. select count(*), 'PNG_WO_INTERFACE_UNIT_ERROR' from PNG_WO_INTERFACE_UNIT_ERROR union all
  184. select count(*), 'PP_TEMP_CWIP_CHARGE_SPLIT' from PP_TEMP_CWIP_CHARGE_SPLIT union all
  185. select count(*), 'PS84_DERIVER_CONTROL' from PS84_DERIVER_CONTROL union all
  186. select count(*), 'PS84_WORK_ORDER_DEPT' from PS84_WORK_ORDER_DEPT union all
  187. select count(*), 'PT_IMPORT_CWIP_ASSIGN' from PT_IMPORT_CWIP_ASSIGN union all
  188. select count(*), 'PT_IMPORT_CWIP_ASSIGN_ARCHIVE' from PT_IMPORT_CWIP_ASSIGN_ARCHIVE union all
  189. select count(*), 'REG_HIST_CWIP_ACTIVITY_VIEW' from REG_HIST_CWIP_ACTIVITY_VIEW union all
  190. select count(*), 'REG_HIST_CWIP_BALANCE_VIEW' from REG_HIST_CWIP_BALANCE_VIEW union all
  191. select count(*), 'REG_HIST_CWIP_RATE_BASE_VIEW' from REG_HIST_CWIP_RATE_BASE_VIEW union all
  192. select count(*), 'REG_INCREMENTAL_FP_ADJ_TRANS' from REG_INCREMENTAL_FP_ADJ_TRANS union all
  193. select count(*), 'REIMB_BILL_INTERFACE' from REIMB_BILL_INTERFACE union all
  194. select count(*), 'REIMB_BILL_LINE' from REIMB_BILL_LINE union all
  195. select count(*), 'REIMB_BILL_SUPPORT_CR' from REIMB_BILL_SUPPORT_CR union all
  196. select count(*), 'REIMB_BILL_SUPPORT_CWIP' from REIMB_BILL_SUPPORT_CWIP union all
  197. select count(*), 'REIMB_CR_OH_EXCLUSIONS' from REIMB_CR_OH_EXCLUSIONS union all
  198. select count(*), 'REIMB_ESTIMATE' from REIMB_ESTIMATE union all
  199. select count(*), 'REIMB_EST_BILL_HIST' from REIMB_EST_BILL_HIST union all
  200. select count(*), 'REIMB_EST_OH_EXCLUSIONS' from REIMB_EST_OH_EXCLUSIONS union all
  201. select count(*), 'REIMB_GL_TRANSACTION' from REIMB_GL_TRANSACTION union all
  202. select count(*), 'REIMB_OH_EXCLUSIONS' from REIMB_OH_EXCLUSIONS union all
  203. select count(*), 'REIMB_WORK_ORDER' from REIMB_WORK_ORDER union all
  204. select count(*), 'RELATED_WOS' from RELATED_WOS union all
  205. select count(*), 'REPAIR_BLANKET_PROCESSING' from REPAIR_BLANKET_PROCESSING union all
  206. select count(*), 'REPAIR_BLANKET_PROCESS_REPORT' from REPAIR_BLANKET_PROCESS_REPORT union all
  207. select count(*), 'REPAIR_BLANKET_PROC_DEBUG' from REPAIR_BLANKET_PROC_DEBUG union all
  208. select count(*), 'REPAIR_BLANKET_RESULTS' from REPAIR_BLANKET_RESULTS union all
  209. select count(*), 'REPAIR_BLANKET_RESULTS_DEBUG' from REPAIR_BLANKET_RESULTS_DEBUG union all
  210. select count(*), 'REPAIR_BLKT_RESULTS_REPORTING' from REPAIR_BLKT_RESULTS_REPORTING union all
  211. select count(*), 'REPAIR_CALC_CWIP' from REPAIR_CALC_CWIP union all
  212. select count(*), 'REPAIR_DETAIL_WMIS_FEED' from REPAIR_DETAIL_WMIS_FEED union all
  213. select count(*), 'REPAIR_WORK_ORDER_DEBUG' from REPAIR_WORK_ORDER_DEBUG union all
  214. select count(*), 'REPAIR_WORK_ORDER_ORIG_DEBUG' from REPAIR_WORK_ORDER_ORIG_DEBUG union all
  215. select count(*), 'REPAIR_WORK_ORDER_TEMP' from REPAIR_WORK_ORDER_TEMP union all
  216. select count(*), 'REPAIR_WORK_ORDER_TEMP_ORIG' from REPAIR_WORK_ORDER_TEMP_ORIG union all
  217. select count(*), 'REPAIR_WO_RUC_EXCEPTION' from REPAIR_WO_RUC_EXCEPTION union all
  218. select count(*), 'RPR_IMPORT_LOC_ROLLUP' from RPR_IMPORT_LOC_ROLLUP union all
  219. select count(*), 'RPR_IMPORT_LOC_ROLLUP_ARC' from RPR_IMPORT_LOC_ROLLUP_ARC union all
  220. select count(*), 'RPR_IMPORT_WO_TAX_REPAIRS' from RPR_IMPORT_WO_TAX_REPAIRS union all
  221. select count(*), 'RPR_IMPORT_WO_TAX_REPAIRS_ARC' from RPR_IMPORT_WO_TAX_REPAIRS_ARC union all
  222. select count(*), 'RWIP_ALLO_ERRORS' from RWIP_ALLO_ERRORS union all
  223. select count(*), 'RWIP_ALLO_EST' from RWIP_ALLO_EST union all
  224. select count(*), 'RWIP_CLOSEOUT_EXCLUDE' from RWIP_CLOSEOUT_EXCLUDE union all
  225. select count(*), 'RWIP_CLOSEOUT_REVISION' from RWIP_CLOSEOUT_REVISION union all
  226. select count(*), 'RWIP_CLOSEOUT_STAGING' from RWIP_CLOSEOUT_STAGING union all
  227. select count(*), 'RWIP_CLOSEOUT_STAG_AL' from RWIP_CLOSEOUT_STAG_AL union all
  228. select count(*), 'RWIP_CLOSEOUT_STAG_AL_ARC' from RWIP_CLOSEOUT_STAG_AL_ARC union all
  229. select count(*), 'RWIP_CLOSEOUT_STAG_ARC' from RWIP_CLOSEOUT_STAG_ARC union all
  230. select count(*), 'RWIP_CLOSEOUT_STAG_WOE' from RWIP_CLOSEOUT_STAG_WOE union all
  231. select count(*), 'SUSPENDED_CHARGE' from SUSPENDED_CHARGE union all
  232. select count(*), 'TEMP_ACCRUAL_WORK_ORDER' from TEMP_ACCRUAL_WORK_ORDER union all
  233. select count(*), 'TEMP_CHARGE_SUMMARY_CLOSINGS' from TEMP_CHARGE_SUMMARY_CLOSINGS union all
  234. select count(*), 'TEMP_JOB_TASK' from TEMP_JOB_TASK union all
  235. select count(*), 'TEMP_WOCG' from TEMP_WOCG union all
  236. select count(*), 'TEMP_WORK_ORDER' from TEMP_WORK_ORDER union all
  237. select count(*), 'TEMP_WORK_ORDER_CONTROL' from TEMP_WORK_ORDER_CONTROL union all
  238. select count(*), 'TEMP_WORK_ORDER_VIEW' from TEMP_WORK_ORDER_VIEW union all
  239. select count(*), 'TREPAIRS_WO_COMPARE' from TREPAIRS_WO_COMPARE union all
  240. select count(*), 'TREPAIRS_WO_CPR' from TREPAIRS_WO_CPR union all
  241. select count(*), 'TREPAIRS_WO_CWIP' from TREPAIRS_WO_CWIP union all
  242. select count(*), 'TREPAIR_FUNDING_PROJ_CHARGES' from TREPAIR_FUNDING_PROJ_CHARGES union all
  243. select count(*), 'UNITIZATION_TARGET' from UNITIZATION_TARGET union all
  244. select count(*), 'UNITIZED_WORK_ORDER' from UNITIZED_WORK_ORDER union all
  245. select count(*), 'UNITIZED_WORK_ORDER_MEMO' from UNITIZED_WORK_ORDER_MEMO union all
  246. select count(*), 'UNITIZED_WORK_ORDER_SL' from UNITIZED_WORK_ORDER_SL union all
  247. select count(*), 'UNITIZED_WORK_ORDER_SL_BASIS' from UNITIZED_WORK_ORDER_SL_BASIS union all
  248. select count(*), 'UNITIZE_ALLOC_CGC_INSERTS_ARC' from UNITIZE_ALLOC_CGC_INSERTS_ARC union all
  249. select count(*), 'UNITIZE_ALLOC_CGC_INSERTS_TEMP' from UNITIZE_ALLOC_CGC_INSERTS_TEMP union all
  250. select count(*), 'UNITIZE_ALLOC_ERRORS_TEMP' from UNITIZE_ALLOC_ERRORS_TEMP union all
  251. select count(*), 'UNITIZE_ALLOC_EST_STG_TEMP' from UNITIZE_ALLOC_EST_STG_TEMP union all
  252. select count(*), 'UNITIZE_ALLOC_EST_TEMP' from UNITIZE_ALLOC_EST_TEMP union all
  253. select count(*), 'UNITIZE_ALLOC_LATE_BK_ARC' from UNITIZE_ALLOC_LATE_BK_ARC union all
  254. select count(*), 'UNITIZE_ALLOC_LATE_BK_TEMP' from UNITIZE_ALLOC_LATE_BK_TEMP union all
  255. select count(*), 'UNITIZE_ALLOC_LATE_PT_ARC' from UNITIZE_ALLOC_LATE_PT_ARC union all
  256. select count(*), 'UNITIZE_ALLOC_LATE_PT_TEMP' from UNITIZE_ALLOC_LATE_PT_TEMP union all
  257. select count(*), 'UNITIZE_ALLOC_STND_TEMP' from UNITIZE_ALLOC_STND_TEMP union all
  258. select count(*), 'UNITIZE_CONVERT_OCR' from UNITIZE_CONVERT_OCR union all
  259. select count(*), 'UNITIZE_CONVERT_OCR_STG' from UNITIZE_CONVERT_OCR_STG union all
  260. select count(*), 'UNITIZE_ELIG_UNITS_ARC' from UNITIZE_ELIG_UNITS_ARC union all
  261. select count(*), 'UNITIZE_ELIG_UNITS_TEMP' from UNITIZE_ELIG_UNITS_TEMP union all
  262. select count(*), 'UNITIZE_PEND_TRANS_TEMP' from UNITIZE_PEND_TRANS_TEMP union all
  263. select count(*), 'UNITIZE_RATIO_LATE_ADD_ARC' from UNITIZE_RATIO_LATE_ADD_ARC union all
  264. select count(*), 'UNITIZE_RATIO_LATE_ADD_TEMP' from UNITIZE_RATIO_LATE_ADD_TEMP union all
  265. select count(*), 'UNITIZE_RATIO_LATE_RWIP_ARC' from UNITIZE_RATIO_LATE_RWIP_ARC union all
  266. select count(*), 'UNITIZE_RATIO_LATE_RWIP_TEMP' from UNITIZE_RATIO_LATE_RWIP_TEMP union all
  267. select count(*), 'UNITIZE_RATIO_UNITS_ARC' from UNITIZE_RATIO_UNITS_ARC union all
  268. select count(*), 'UNITIZE_RATIO_UNITS_TEMP' from UNITIZE_RATIO_UNITS_TEMP union all
  269. select count(*), 'UNITIZE_WO_LIST' from UNITIZE_WO_LIST union all
  270. select count(*), 'UNITIZE_WO_LIST_ARC' from UNITIZE_WO_LIST_ARC union all
  271. select count(*), 'UNITIZE_WO_LIST_TEMP' from UNITIZE_WO_LIST_TEMP union all
  272. select count(*), 'UNITIZE_WO_STG_UNITS_TEMP' from UNITIZE_WO_STG_UNITS_TEMP union all
  273. select count(*), 'UNIT_ITEM_CLASS_CODE' from UNIT_ITEM_CLASS_CODE union all
  274. select count(*), 'UNIT_TARGET_CONTROL' from UNIT_TARGET_CONTROL union all
  275. select count(*), 'WIP_COMP_CALC' from WIP_COMP_CALC union all
  276. select count(*), 'WIP_COMP_CHARGES' from WIP_COMP_CHARGES union all
  277. select count(*), 'WIP_COMP_INPUT' from WIP_COMP_INPUT union all
  278. select count(*), 'WIP_COMP_PENDING_TRANS' from WIP_COMP_PENDING_TRANS union all
  279. select count(*), 'WIP_COMP_PEND_TRANS_TEMP' from WIP_COMP_PEND_TRANS_TEMP union all
  280. select count(*), 'WIP_COMP_TEMP_WO' from WIP_COMP_TEMP_WO union all
  281. select count(*), 'WIP_COMP_UNIT_CALC' from WIP_COMP_UNIT_CALC union all
  282. select count(*), 'WIP_COMP_WO_OVERRIDE' from WIP_COMP_WO_OVERRIDE union all
  283. select count(*), 'WORK_ORDER_ACCOUNT' from WORK_ORDER_ACCOUNT union all
  284. select count(*), 'WORK_ORDER_ALTERNATIVES' from WORK_ORDER_ALTERNATIVES union all
  285. select count(*), 'WORK_ORDER_APPROVAL' from WORK_ORDER_APPROVAL union all
  286. select count(*), 'WORK_ORDER_APPROVAL_ARCH' from WORK_ORDER_APPROVAL_ARCH union all
  287. select count(*), 'WORK_ORDER_APPROVAL_V' from WORK_ORDER_APPROVAL_V union all
  288. select count(*), 'WORK_ORDER_CASHFLOW' from WORK_ORDER_CASHFLOW union all
  289. select count(*), 'WORK_ORDER_CHARGE_GROUP' from WORK_ORDER_CHARGE_GROUP union all
  290. select count(*), 'WORK_ORDER_CHARGE_GROUP_TEMP' from WORK_ORDER_CHARGE_GROUP_TEMP union all
  291. select count(*), 'WORK_ORDER_CLASS_CODE' from WORK_ORDER_CLASS_CODE union all
  292. select count(*), 'WORK_ORDER_CLASS_CODE_DELBKUP' from WORK_ORDER_CLASS_CODE_DELBKUP union all
  293. select count(*), 'WORK_ORDER_CONTROL' from WORK_ORDER_CONTROL union all
  294. select count(*), 'WORK_ORDER_CONTROL_SV' from WORK_ORDER_CONTROL_SV union all
  295. select count(*), 'WORK_ORDER_DEPARTMENT' from WORK_ORDER_DEPARTMENT union all
  296. select count(*), 'WORK_ORDER_DOCUMENT' from WORK_ORDER_DOCUMENT union all
  297. select count(*), 'WORK_ORDER_DOCUMENT_BAK' from WORK_ORDER_DOCUMENT_BAK union all
  298. select count(*), 'WORK_ORDER_INITIATOR' from WORK_ORDER_INITIATOR union all
  299. select count(*), 'WORK_ORDER_PREREQS' from WORK_ORDER_PREREQS union all
  300. select count(*), 'WORK_ORDER_TAX_REPAIRS' from WORK_ORDER_TAX_REPAIRS union all
  301. select count(*), 'WORK_ORDER_TAX_STATUS' from WORK_ORDER_TAX_STATUS union all
  302. select count(*), 'WO_ACCRUALS' from WO_ACCRUALS union all
  303. select count(*), 'WO_ACCRUALS_HISTORY' from WO_ACCRUALS_HISTORY union all
  304. select count(*), 'WO_ACCRUED_GAIN_LOSS' from WO_ACCRUED_GAIN_LOSS union all
  305. select count(*), 'WO_APPROVAL_MULTIPLE' from WO_APPROVAL_MULTIPLE union all
  306. select count(*), 'WO_APPROVAL_MULTIPLE_ARCH' from WO_APPROVAL_MULTIPLE_ARCH union all
  307. select count(*), 'WO_ARC_ALERT_HISTORY' from WO_ARC_ALERT_HISTORY union all
  308. select count(*), 'WO_ARC_RESULTS' from WO_ARC_RESULTS union all
  309. select count(*), 'WO_ARC_TEMP_RUN' from WO_ARC_TEMP_RUN union all
  310. select count(*), 'WO_AUTO101_CONTROL' from WO_AUTO101_CONTROL union all
  311. select count(*), 'WO_AUTO106_CHARGES' from WO_AUTO106_CHARGES union all
  312. select count(*), 'WO_AUTO106_CHARGES_SUMM' from WO_AUTO106_CHARGES_SUMM union all
  313. select count(*), 'WO_AUTO106_CLASS_CODES' from WO_AUTO106_CLASS_CODES union all
  314. select count(*), 'WO_AUTO106_CONTROL' from WO_AUTO106_CONTROL union all
  315. select count(*), 'WO_AUTO106_PENDING_TRANS' from WO_AUTO106_PENDING_TRANS union all
  316. select count(*), 'WO_AUTO106_PENDING_TRANS_ARC' from WO_AUTO106_PENDING_TRANS_ARC union all
  317. select count(*), 'WO_AUTO106_TEMP_WOS' from WO_AUTO106_TEMP_WOS union all
  318. select count(*), 'WO_AUTO106_WOS' from WO_AUTO106_WOS union all
  319. select count(*), 'WO_BILL_MATERIAL' from WO_BILL_MATERIAL union all
  320. select count(*), 'WO_CHARGE_TYPE_DOLLARS' from WO_CHARGE_TYPE_DOLLARS union all
  321. select count(*), 'WO_CLEAR_OVER' from WO_CLEAR_OVER union all
  322. select count(*), 'WO_COMPLETE_DATES_APPROVE' from WO_COMPLETE_DATES_APPROVE union all
  323. select count(*), 'WO_DOCUMENTATION' from WO_DOCUMENTATION union all
  324. select count(*), 'WO_DOCUMENTATION_BAK' from WO_DOCUMENTATION_BAK union all
  325. select count(*), 'WO_DOC_COMMENTS' from WO_DOC_COMMENTS union all
  326. select count(*), 'WO_DOC_JUSTIFICATION' from WO_DOC_JUSTIFICATION union all
  327. select count(*), 'WO_DOC_JUST_BAK' from WO_DOC_JUST_BAK union all
  328. select count(*), 'WO_ENG_ESTIMATE' from WO_ENG_ESTIMATE union all
  329. select count(*), 'WO_ENG_ESTIMATE_STATUS' from WO_ENG_ESTIMATE_STATUS union all
  330. select count(*), 'WO_ENG_EST_CHILD' from WO_ENG_EST_CHILD union all
  331. select count(*), 'WO_ENG_EST_DETAIL' from WO_ENG_EST_DETAIL union all
  332. select count(*), 'WO_ESTIMATE' from WO_ESTIMATE union all
  333. select count(*), 'WO_ESTIMATED_RETIRE' from WO_ESTIMATED_RETIRE union all
  334. select count(*), 'WO_ESTIMATE_BCK' from WO_ESTIMATE_BCK union all
  335. select count(*), 'WO_ESTIMATE_SPREAD_TEMP' from WO_ESTIMATE_SPREAD_TEMP union all
  336. select count(*), 'WO_ESTIMATE_SUMMARY_VIEW' from WO_ESTIMATE_SUMMARY_VIEW union all
  337. select count(*), 'WO_EST_ACTUALS_TEMP' from WO_EST_ACTUALS_TEMP union all
  338. select count(*), 'WO_EST_ACTUALS_TEMP2' from WO_EST_ACTUALS_TEMP2 union all
  339. select count(*), 'WO_EST_ALL_VIEW' from WO_EST_ALL_VIEW union all
  340. select count(*), 'WO_EST_ALL_VIEW2' from WO_EST_ALL_VIEW2 union all
  341. select count(*), 'WO_EST_ALL_VIEW2APP' from WO_EST_ALL_VIEW2APP union all
  342. select count(*), 'WO_EST_ALL_VIEWAPP' from WO_EST_ALL_VIEWAPP union all
  343. select count(*), 'WO_EST_APPR_REVISION_VIEW' from WO_EST_APPR_REVISION_VIEW union all
  344. select count(*), 'WO_EST_CAPITAL_VIEW' from WO_EST_CAPITAL_VIEW union all
  345. select count(*), 'WO_EST_CAPITAL_VIEW2' from WO_EST_CAPITAL_VIEW2 union all
  346. select count(*), 'WO_EST_CAPITAL_VIEW2APP' from WO_EST_CAPITAL_VIEW2APP union all
  347. select count(*), 'WO_EST_CAPITAL_VIEWAPP' from WO_EST_CAPITAL_VIEWAPP union all
  348. select count(*), 'WO_EST_CLOSINGS_WOS' from WO_EST_CLOSINGS_WOS union all
  349. select count(*), 'WO_EST_COPY_REVISION_TEMP' from WO_EST_COPY_REVISION_TEMP union all
  350. select count(*), 'WO_EST_COTENANT_SPREAD_TEMP' from WO_EST_COTENANT_SPREAD_TEMP union all
  351. select count(*), 'WO_EST_CREDITS_VIEW' from WO_EST_CREDITS_VIEW union all
  352. select count(*), 'WO_EST_CREDITS_VIEW2' from WO_EST_CREDITS_VIEW2 union all
  353. select count(*), 'WO_EST_CREDITS_VIEW2APP' from WO_EST_CREDITS_VIEW2APP union all
  354. select count(*), 'WO_EST_CREDITS_VIEWAPP' from WO_EST_CREDITS_VIEWAPP union all
  355. select count(*), 'WO_EST_DATE_CHANGES' from WO_EST_DATE_CHANGES union all
  356. select count(*), 'WO_EST_DERIVATION_PCT' from WO_EST_DERIVATION_PCT union all
  357. select count(*), 'WO_EST_EXPENSE_VIEW' from WO_EST_EXPENSE_VIEW union all
  358. select count(*), 'WO_EST_EXPENSE_VIEW2' from WO_EST_EXPENSE_VIEW2 union all
  359. select count(*), 'WO_EST_EXPENSE_VIEW2APP' from WO_EST_EXPENSE_VIEW2APP union all
  360. select count(*), 'WO_EST_EXPENSE_VIEWAPP' from WO_EST_EXPENSE_VIEWAPP union all
  361. select count(*), 'WO_EST_EXP_TYPE_VIEW' from WO_EST_EXP_TYPE_VIEW union all
  362. select count(*), 'WO_EST_FIRST_VIEW' from WO_EST_FIRST_VIEW union all
  363. select count(*), 'WO_EST_FIRST_VIEW_CASH_FLOW' from WO_EST_FIRST_VIEW_CASH_FLOW union all
  364. select count(*), 'WO_EST_INITIAL_REVISION' from WO_EST_INITIAL_REVISION union all
  365. select count(*), 'WO_EST_JOBBING_VIEW' from WO_EST_JOBBING_VIEW union all
  366. select count(*), 'WO_EST_JOBBING_VIEW2' from WO_EST_JOBBING_VIEW2 union all
  367. select count(*), 'WO_EST_JOBBING_VIEW2APP' from WO_EST_JOBBING_VIEW2APP union all
  368. select count(*), 'WO_EST_JOBBING_VIEWAPP' from WO_EST_JOBBING_VIEWAPP union all
  369. select count(*), 'WO_EST_MONTHLY' from WO_EST_MONTHLY union all
  370. select count(*), 'WO_EST_MONTHLY_20110318' from WO_EST_MONTHLY_20110318 union all
  371. select count(*), 'WO_EST_MONTHLY_ARCH' from WO_EST_MONTHLY_ARCH union all
  372. select count(*), 'WO_EST_MONTHLY_CR' from WO_EST_MONTHLY_CR union all
  373. select count(*), 'WO_EST_MONTHLY_DEESCALATED_VW' from WO_EST_MONTHLY_DEESCALATED_VW union all
  374. select count(*), 'WO_EST_MONTHLY_DEESCALATION_VW' from WO_EST_MONTHLY_DEESCALATION_VW union all
  375. select count(*), 'WO_EST_MONTHLY_DEESC_SV' from WO_EST_MONTHLY_DEESC_SV union all
  376. select count(*), 'WO_EST_MONTHLY_DEESC_VW_FY' from WO_EST_MONTHLY_DEESC_VW_FY union all
  377. select count(*), 'WO_EST_MONTHLY_FY' from WO_EST_MONTHLY_FY union all
  378. select count(*), 'WO_EST_MONTHLY_FY_BDG_V' from WO_EST_MONTHLY_FY_BDG_V union all
  379. select count(*), 'WO_EST_MONTHLY_FY_DEESC_SV' from WO_EST_MONTHLY_FY_DEESC_SV union all
  380. select count(*), 'WO_EST_MONTHLY_FY_SV' from WO_EST_MONTHLY_FY_SV union all
  381. select count(*), 'WO_EST_MONTHLY_FY_TEMP' from WO_EST_MONTHLY_FY_TEMP union all
  382. select count(*), 'WO_EST_MONTHLY_FY_TEMP_CAL' from WO_EST_MONTHLY_FY_TEMP_CAL union all
  383. select count(*), 'WO_EST_MONTHLY_MONTH_NUMBER' from WO_EST_MONTHLY_MONTH_NUMBER union all
  384. select count(*), 'WO_EST_MONTHLY_SUBS_DET' from WO_EST_MONTHLY_SUBS_DET union all
  385. select count(*), 'WO_EST_MONTHLY_SV' from WO_EST_MONTHLY_SV union all
  386. select count(*), 'WO_EST_MONTHLY_UPLOAD' from WO_EST_MONTHLY_UPLOAD union all
  387. select count(*), 'WO_EST_MONTHLY_UPLOAD_ARCH' from WO_EST_MONTHLY_UPLOAD_ARCH union all
  388. select count(*), 'WO_EST_MONTHLY_VIEW' from WO_EST_MONTHLY_VIEW union all
  389. select count(*), 'WO_EST_MONTHLY_VIEW_TEMP' from WO_EST_MONTHLY_VIEW_TEMP union all
  390. select count(*), 'WO_EST_MONTH_IS_EDITABLE' from WO_EST_MONTH_IS_EDITABLE union all
  391. select count(*), 'WO_EST_MONTH_IS_EDITABLE_FY' from WO_EST_MONTH_IS_EDITABLE_FY union all
  392. select count(*), 'WO_EST_MONTH_IS_EDITABLE_JT' from WO_EST_MONTH_IS_EDITABLE_JT union all
  393. select count(*), 'WO_EST_MONTH_IS_EDITABLE_JT_FY' from WO_EST_MONTH_IS_EDITABLE_JT_FY union all
  394. select count(*), 'WO_EST_MONTH_IS_EDITABLE_TEMP' from WO_EST_MONTH_IS_EDITABLE_TEMP union all
  395. select count(*), 'WO_EST_MONTH_IS_EDIT_JT_TEMP' from WO_EST_MONTH_IS_EDIT_JT_TEMP union all
  396. select count(*), 'WO_EST_PROCESSING_MO_ID' from WO_EST_PROCESSING_MO_ID union all
  397. select count(*), 'WO_EST_PROCESSING_TEMP' from WO_EST_PROCESSING_TEMP union all
  398. select count(*), 'WO_EST_PROCESSING_TRANSPOSE' from WO_EST_PROCESSING_TRANSPOSE union all
  399. select count(*), 'WO_EST_RATE_DEFAULT' from WO_EST_RATE_DEFAULT union all
  400. select count(*), 'WO_EST_RATE_FILTER' from WO_EST_RATE_FILTER union all
  401. select count(*), 'WO_EST_REMOVAL_VIEW' from WO_EST_REMOVAL_VIEW union all
  402. select count(*), 'WO_EST_REMOVAL_VIEW2' from WO_EST_REMOVAL_VIEW2 union all
  403. select count(*), 'WO_EST_REMOVAL_VIEW2APP' from WO_EST_REMOVAL_VIEW2APP union all
  404. select count(*), 'WO_EST_REMOVAL_VIEWAPP' from WO_EST_REMOVAL_VIEWAPP union all
  405. select count(*), 'WO_EST_RETIREMENT_VIEW' from WO_EST_RETIREMENT_VIEW union all
  406. select count(*), 'WO_EST_RETIREMENT_VIEW2' from WO_EST_RETIREMENT_VIEW2 union all
  407. select count(*), 'WO_EST_REVISION_VIEW' from WO_EST_REVISION_VIEW union all
  408. select count(*), 'WO_EST_SLIDE_RESULTS_TEMP' from WO_EST_SLIDE_RESULTS_TEMP union all
  409. select count(*), 'WO_EST_SUMMARY_TBL' from WO_EST_SUMMARY_TBL union all
  410. select count(*), 'WO_EST_SUMMARY_TOTAL_VIEW' from WO_EST_SUMMARY_TOTAL_VIEW union all
  411. select count(*), 'WO_EST_SUMMARY_TOTAL_VIEW_EXP' from WO_EST_SUMMARY_TOTAL_VIEW_EXP union all
  412. select count(*), 'WO_EST_SUMMARY_VIEW' from WO_EST_SUMMARY_VIEW union all
  413. select count(*), 'WO_EST_SUMMARY_WO_CREDITS_V2' from WO_EST_SUMMARY_WO_CREDITS_V2 union all
  414. select count(*), 'WO_EST_SUPPLEMENTAL_DATA' from WO_EST_SUPPLEMENTAL_DATA union all
  415. select count(*), 'WO_EST_TOTAL_COST_VIEW' from WO_EST_TOTAL_COST_VIEW union all
  416. select count(*), 'WO_EST_TRANSPOSE_TEMP' from WO_EST_TRANSPOSE_TEMP union all
  417. select count(*), 'WO_EST_UPDATE_WITH_ACT_TEMP' from WO_EST_UPDATE_WITH_ACT_TEMP union all
  418. select count(*), 'WO_EST_UPLOAD_NEW_COMBOS2' from WO_EST_UPLOAD_NEW_COMBOS2 union all
  419. select count(*), 'WO_GL_ACCOUNT_SUMMARY' from WO_GL_ACCOUNT_SUMMARY union all
  420. select count(*), 'WO_GL_ACCOUNT_SUMMARY_MO' from WO_GL_ACCOUNT_SUMMARY_MO union all
  421. select count(*), 'WO_GL_ACCOUNT_SUMMARY_PRESET' from WO_GL_ACCOUNT_SUMMARY_PRESET union all
  422. select count(*), 'WO_GL_ACCT_BEG_BAL_ANNUAL_VIEW' from WO_GL_ACCT_BEG_BAL_ANNUAL_VIEW union all
  423. select count(*), 'WO_GL_ACCT_BEG_BAL_SINGLE_VIEW' from WO_GL_ACCT_BEG_BAL_SINGLE_VIEW union all
  424. select count(*), 'WO_GL_ACCT_BEG_BAL_SPAN_VIEW' from WO_GL_ACCT_BEG_BAL_SPAN_VIEW union all
  425. select count(*), 'WO_GL_ACCT_BEG_BAL_VIEW2' from WO_GL_ACCT_BEG_BAL_VIEW2 union all
  426. select count(*), 'WO_GL_ACCT_END_BAL_VIEW2' from WO_GL_ACCT_END_BAL_VIEW2 union all
  427. select count(*), 'WO_GL_ACCT_END_BAL_VIEW3' from WO_GL_ACCT_END_BAL_VIEW3 union all
  428. select count(*), 'WO_GL_ACCT_END_BAL_VIEW4' from WO_GL_ACCT_END_BAL_VIEW4 union all
  429. select count(*), 'WO_INTERFACE_MONTHLY' from WO_INTERFACE_MONTHLY union all
  430. select count(*), 'WO_INTERFACE_MONTHLY_ARC' from WO_INTERFACE_MONTHLY_ARC union all
  431. select count(*), 'WO_INTERFACE_MONTHLY_BAK_ORIG' from WO_INTERFACE_MONTHLY_BAK_ORIG union all
  432. select count(*), 'WO_INTERFACE_MONTHLY_BAK_ORIG2' from WO_INTERFACE_MONTHLY_BAK_ORIG2 union all
  433. select count(*), 'WO_INTERFACE_MONTHLY_IDS' from WO_INTERFACE_MONTHLY_IDS union all
  434. select count(*), 'WO_INTERFACE_MONTHLY_IMP_ARC' from WO_INTERFACE_MONTHLY_IMP_ARC union all
  435. select count(*), 'WO_INTERFACE_MONTHLY_IMP_STG' from WO_INTERFACE_MONTHLY_IMP_STG union all
  436. select count(*), 'WO_INTERFACE_MONTHLY_TEMP' from WO_INTERFACE_MONTHLY_TEMP union all
  437. select count(*), 'WO_INTERFACE_MONTHLY_VIEW' from WO_INTERFACE_MONTHLY_VIEW union all
  438. select count(*), 'WO_INTERFACE_OCR_ARC' from WO_INTERFACE_OCR_ARC union all
  439. select count(*), 'WO_INTERFACE_OCR_IMP_ARC' from WO_INTERFACE_OCR_IMP_ARC union all
  440. select count(*), 'WO_INTERFACE_OCR_IMP_STG' from WO_INTERFACE_OCR_IMP_STG union all
  441. select count(*), 'WO_INTERFACE_OCR_STG' from WO_INTERFACE_OCR_STG union all
  442. select count(*), 'WO_INTERFACE_REVISIONS' from WO_INTERFACE_REVISIONS union all
  443. select count(*), 'WO_INTERFACE_STAGING' from WO_INTERFACE_STAGING union all
  444. select count(*), 'WO_INTERFACE_STAGING_ARC' from WO_INTERFACE_STAGING_ARC union all
  445. select count(*), 'WO_INTERFACE_STAGING_IMP_ARC' from WO_INTERFACE_STAGING_IMP_ARC union all
  446. select count(*), 'WO_INTERFACE_STAGING_IMP_STG' from WO_INTERFACE_STAGING_IMP_STG union all
  447. select count(*), 'WO_INTERFACE_STAGING_RON' from WO_INTERFACE_STAGING_RON union all
  448. select count(*), 'WO_INTERFACE_UNIT' from WO_INTERFACE_UNIT union all
  449. select count(*), 'WO_INTERFACE_UNIT_ARC' from WO_INTERFACE_UNIT_ARC union all
  450. select count(*), 'WO_INTERFACE_UNIT_IMP_ARC' from WO_INTERFACE_UNIT_IMP_ARC union all
  451. select count(*), 'WO_INTERFACE_UNIT_IMP_STG' from WO_INTERFACE_UNIT_IMP_STG union all
  452. select count(*), 'WO_MAX_REVISION_VIEW' from WO_MAX_REVISION_VIEW union all
  453. select count(*), 'WO_MAX_REVISION_VIEW_NOREV' from WO_MAX_REVISION_VIEW_NOREV union all
  454. select count(*), 'WO_PSEUDO_UNITIZE_SUMMARY' from WO_PSEUDO_UNITIZE_SUMMARY union all
  455. select count(*), 'WO_PSEUDO_UNITIZE_SUMMARY_BCK' from WO_PSEUDO_UNITIZE_SUMMARY_BCK union all
  456. select count(*), 'WO_PSEUDO_UNITIZE_SUMMARY_MO' from WO_PSEUDO_UNITIZE_SUMMARY_MO union all
  457. select count(*), 'WO_REIMBURSABLE' from WO_REIMBURSABLE union all
  458. select count(*), 'WO_STATUS_TRAIL' from WO_STATUS_TRAIL union all
  459. select count(*), 'WO_SUMMARY' from WO_SUMMARY union all
  460. select count(*), 'WO_SUMMARY_COMMITMENTS' from WO_SUMMARY_COMMITMENTS union all
  461. select count(*), 'WO_TOTAL_COST_CLOSE_VIEW' from WO_TOTAL_COST_CLOSE_VIEW union all
  462. select count(*), 'WO_TOTAL_COST_CURR_VIEW' from WO_TOTAL_COST_CURR_VIEW union all
  463. select count(*), 'WO_TOTAL_COST_VIEW' from WO_TOTAL_COST_VIEW union all
  464. select count(*), 'WO_TOTAL_COST_W_FUND_VIEW' from WO_TOTAL_COST_W_FUND_VIEW union all
  465. select count(*), 'WO_UNIT_ITEM_PEND_TRANS' from WO_UNIT_ITEM_PEND_TRANS
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement