Sunday, September 1, 2019

idempiere total-record

drop materialized view z_afei_total_record_03;



create materialized view z_afei_total_record_03 as
select 'a_asset_delivery' as namatable, (select count(*) from a_asset_delivery) as jumlah
union all select 'a_asset_group_acct' as namatable, (select count(*) from a_asset_group_acct) as jumlah
union all select 'a_asset_acct' as namatable, (select count(*) from a_asset_acct) as jumlah
union all select 'a_asset' as namatable, (select count(*) from a_asset) as jumlah
union all select 'a_asset_group_trl' as namatable, (select count(*) from a_asset_group_trl) as jumlah
union all select 'a_asset_class' as namatable, (select count(*) from a_asset_class) as jumlah
union all select 'a_asset_group' as namatable, (select count(*) from a_asset_group) as jumlah
union all select 'a_asset_disposed' as namatable, (select count(*) from a_asset_disposed) as jumlah
union all select 'a_asset_info_fin' as namatable, (select count(*) from a_asset_info_fin) as jumlah
union all select 'a_asset_change_amt' as namatable, (select count(*) from a_asset_change_amt) as jumlah
union all select 'a_asset_info_ins' as namatable, (select count(*) from a_asset_info_ins) as jumlah
union all select 'a_asset_addition' as namatable, (select count(*) from a_asset_addition) as jumlah
union all select 'a_asset_change' as namatable, (select count(*) from a_asset_change) as jumlah
union all select 'a_asset_info_oth' as namatable, (select count(*) from a_asset_info_oth) as jumlah
union all select 'a_asset_info_tax' as namatable, (select count(*) from a_asset_info_tax) as jumlah
union all select 'a_asset_info_lic' as namatable, (select count(*) from a_asset_info_lic) as jumlah
union all select 'a_asset_retirement' as namatable, (select count(*) from a_asset_retirement) as jumlah
union all select 'a_asset_product' as namatable, (select count(*) from a_asset_product) as jumlah
union all select 'a_asset_split' as namatable, (select count(*) from a_asset_split) as jumlah
union all select 'a_asset_reval_index' as namatable, (select count(*) from a_asset_reval_index) as jumlah
union all select 'a_asset_type' as namatable, (select count(*) from a_asset_type) as jumlah
union all select 'a_asset_reval' as namatable, (select count(*) from a_asset_reval) as jumlah
union all select 'a_asset_reval_entry' as namatable, (select count(*) from a_asset_reval_entry) as jumlah
union all select 'a_asset_transfer' as namatable, (select count(*) from a_asset_transfer) as jumlah
union all select 'a_asset_spread' as namatable, (select count(*) from a_asset_spread) as jumlah
union all select 'a_depreciation_convention' as namatable, (select count(*) from a_depreciation_convention) as jumlah
union all select 'a_depreciation_forecast' as namatable, (select count(*) from a_depreciation_forecast) as jumlah
union all select 'a_depreciation_entry' as namatable, (select count(*) from a_depreciation_entry) as jumlah
union all select 'a_depreciation_method' as namatable, (select count(*) from a_depreciation_method) as jumlah
union all select 'a_depreciation_table_detail' as namatable, (select count(*) from a_depreciation_table_detail) as jumlah
union all select 'a_asset_use' as namatable, (select count(*) from a_asset_use) as jumlah
union all select 'a_fundingmode' as namatable, (select count(*) from a_fundingmode) as jumlah
union all select 'a_depreciation_table_header' as namatable, (select count(*) from a_depreciation_table_header) as jumlah
union all select 'a_registration' as namatable, (select count(*) from a_registration) as jumlah
union all select 'a_registrationattribute' as namatable, (select count(*) from a_registrationattribute) as jumlah
union all select 'a_fundingmode_acct' as namatable, (select count(*) from a_fundingmode_acct) as jumlah
union all select 'a_depreciation_workfile' as namatable, (select count(*) from a_depreciation_workfile) as jumlah
union all select 'a_depreciation' as namatable, (select count(*) from a_depreciation) as jumlah
union all select 'a_depreciation_build' as namatable, (select count(*) from a_depreciation_build) as jumlah
union all select 'a_depreciation_exp' as namatable, (select count(*) from a_depreciation_exp) as jumlah
union all select 'a_registrationproduct' as namatable, (select count(*) from a_registrationproduct) as jumlah
union all select 'a_registrationvalue' as namatable, (select count(*) from a_registrationvalue) as jumlah
union all select 'ad_alertprocessorlog' as namatable, (select count(*) from ad_alertprocessorlog) as jumlah
union all select 'ad_alertrule' as namatable, (select count(*) from ad_alertrule) as jumlah
union all select 'ad_archive' as namatable, (select count(*) from ad_archive) as jumlah
union all select 'ad_alert' as namatable, (select count(*) from ad_alert) as jumlah
union all select 'ad_alertprocessor' as namatable, (select count(*) from ad_alertprocessor) as jumlah
union all select 'ad_client' as namatable, (select count(*) from ad_client) as jumlah
union all select 'ad_alertrecipient' as namatable, (select count(*) from ad_alertrecipient) as jumlah
union all select 'ad_user' as namatable, (select count(*) from ad_user) as jumlah
union all select 'ad_attachment' as namatable, (select count(*) from ad_attachment) as jumlah
union all select 'ad_attribute' as namatable, (select count(*) from ad_attribute) as jumlah
union all select 'ad_broadcastmessage' as namatable, (select count(*) from ad_broadcastmessage) as jumlah
union all select 'ad_broadcastmessage_trl' as namatable, (select count(*) from ad_broadcastmessage_trl) as jumlah
union all select 'ad_chart' as namatable, (select count(*) from ad_chart) as jumlah
union all select 'ad_chartdatasource' as namatable, (select count(*) from ad_chartdatasource) as jumlah
union all select 'ad_column_access' as namatable, (select count(*) from ad_column_access) as jumlah
union all select 'ad_attribute_value' as namatable, (select count(*) from ad_attribute_value) as jumlah
union all select 'ad_chart_trl' as namatable, (select count(*) from ad_chart_trl) as jumlah
union all select 'ad_clientinfo' as namatable, (select count(*) from ad_clientinfo) as jumlah
union all select 'ad_clientshare' as namatable, (select count(*) from ad_clientshare) as jumlah
union all select 'ad_color_trl' as namatable, (select count(*) from ad_color_trl) as jumlah
union all select 'ad_color' as namatable, (select count(*) from ad_color) as jumlah
union all select 'ad_changelog' as namatable, (select count(*) from ad_changelog) as jumlah
union all select 'ad_column' as namatable, (select count(*) from ad_column) as jumlah
union all select 'ad_ctxhelpsuggestion' as namatable, (select count(*) from ad_ctxhelpsuggestion) as jumlah
union all select 'ad_ctxhelpmsg_trl' as namatable, (select count(*) from ad_ctxhelpmsg_trl) as jumlah
union all select 'ad_element' as namatable, (select count(*) from ad_element) as jumlah
union all select 'ad_desktop_trl' as namatable, (select count(*) from ad_desktop_trl) as jumlah
union all select 'ad_desktopworkbench' as namatable, (select count(*) from ad_desktopworkbench) as jumlah
union all select 'ad_column_trl' as namatable, (select count(*) from ad_column_trl) as jumlah
union all select 'ad_fieldgroup' as namatable, (select count(*) from ad_fieldgroup) as jumlah
union all select 'ad_entitytype' as namatable, (select count(*) from ad_entitytype) as jumlah
union all select 'ad_error' as namatable, (select count(*) from ad_error) as jumlah
union all select 'ad_field_trl' as namatable, (select count(*) from ad_field_trl) as jumlah
union all select 'ad_desktop' as namatable, (select count(*) from ad_desktop) as jumlah
union all select 'ad_document_action_access' as namatable, (select count(*) from ad_document_action_access) as jumlah
union all select 'ad_element_trl' as namatable, (select count(*) from ad_element_trl) as jumlah
union all select 'ad_field' as namatable, (select count(*) from ad_field) as jumlah
union all select 'ad_tab' as namatable, (select count(*) from ad_tab) as jumlah
union all select 'ad_ctxhelp' as namatable, (select count(*) from ad_ctxhelp) as jumlah
union all select 'ad_ctxhelpmsg' as namatable, (select count(*) from ad_ctxhelpmsg) as jumlah
union all select 'ad_form_access' as namatable, (select count(*) from ad_form_access) as jumlah
union all select 'ad_fieldgroup_trl' as namatable, (select count(*) from ad_fieldgroup_trl) as jumlah
union all select 'ad_impformat_row' as namatable, (select count(*) from ad_impformat_row) as jumlah
union all select 'ad_infocolumn' as namatable, (select count(*) from ad_infocolumn) as jumlah
union all select 'ad_form_trl' as namatable, (select count(*) from ad_form_trl) as jumlah
union all select 'ad_image' as namatable, (select count(*) from ad_image) as jumlah
union all select 'ad_indexcolumn' as namatable, (select count(*) from ad_indexcolumn) as jumlah
union all select 'ad_infoprocess' as namatable, (select count(*) from ad_infoprocess) as jumlah
union all select 'ad_impformat' as namatable, (select count(*) from ad_impformat) as jumlah
union all select 'ad_infocolumn_trl' as namatable, (select count(*) from ad_infocolumn_trl) as jumlah
union all select 'ad_importtemplateaccess' as namatable, (select count(*) from ad_importtemplateaccess) as jumlah
union all select 'ad_find' as namatable, (select count(*) from ad_find) as jumlah
union all select 'ad_form' as namatable, (select count(*) from ad_form) as jumlah
union all select 'ad_fieldsuggestion' as namatable, (select count(*) from ad_fieldsuggestion) as jumlah
union all select 'ad_housekeeping' as namatable, (select count(*) from ad_housekeeping) as jumlah
union all select 'ad_val_rule' as namatable, (select count(*) from ad_val_rule) as jumlah
union all select 'ad_importtemplate' as namatable, (select count(*) from ad_importtemplate) as jumlah
union all select 'ad_language' as namatable, (select count(*) from ad_language) as jumlah
union all select 'ad_infowindow_trl' as namatable, (select count(*) from ad_infowindow_trl) as jumlah
union all select 'ad_labelprinter' as namatable, (select count(*) from ad_labelprinter) as jumlah
union all select 'ad_infowindow' as namatable, (select count(*) from ad_infowindow) as jumlah
union all select 'ad_ldapprocessor' as namatable, (select count(*) from ad_ldapprocessor) as jumlah
union all select 'ad_ldapaccess' as namatable, (select count(*) from ad_ldapaccess) as jumlah
union all select 'ad_menu_trl' as namatable, (select count(*) from ad_menu_trl) as jumlah
union all select 'ad_ldapprocessorlog' as namatable, (select count(*) from ad_ldapprocessorlog) as jumlah
union all select 'ad_modelvalidator' as namatable, (select count(*) from ad_modelvalidator) as jumlah
union all select 'ad_note' as namatable, (select count(*) from ad_note) as jumlah
union all select 'ad_inforelated' as namatable, (select count(*) from ad_inforelated) as jumlah
union all select 'ad_message' as namatable, (select count(*) from ad_message) as jumlah
union all select 'ad_message_trl' as namatable, (select count(*) from ad_message_trl) as jumlah
union all select 'ad_menu' as namatable, (select count(*) from ad_menu) as jumlah
union all select 'ad_migrationscript' as namatable, (select count(*) from ad_migrationscript) as jumlah
union all select 'ad_infowindow_access' as namatable, (select count(*) from ad_infowindow_access) as jumlah
union all select 'ad_issue' as namatable, (select count(*) from ad_issue) as jumlah
union all select 'ad_modification' as namatable, (select count(*) from ad_modification) as jumlah
union all select 'ad_labelprinterfunction' as namatable, (select count(*) from ad_labelprinterfunction) as jumlah
union all select 'ad_orgtype' as namatable, (select count(*) from ad_orgtype) as jumlah
union all select 'ad_password_history' as namatable, (select count(*) from ad_password_history) as jumlah
union all select 'ad_package_imp' as namatable, (select count(*) from ad_package_imp) as jumlah
union all select 'ad_package_exp_detail' as namatable, (select count(*) from ad_package_exp_detail) as jumlah
union all select 'ad_orginfo' as namatable, (select count(*) from ad_orginfo) as jumlah
union all select 'ad_package_imp_proc' as namatable, (select count(*) from ad_package_imp_proc) as jumlah
union all select 'ad_package_exp_common' as namatable, (select count(*) from ad_package_exp_common) as jumlah
union all select 'ad_passwordrule' as namatable, (select count(*) from ad_passwordrule) as jumlah
union all select 'ad_package_imp_inst' as namatable, (select count(*) from ad_package_imp_inst) as jumlah
union all select 'ad_package_uuid_map' as namatable, (select count(*) from ad_package_uuid_map) as jumlah
union all select 'ad_package_imp_backup' as namatable, (select count(*) from ad_package_imp_backup) as jumlah
union all select 'ad_package_exp' as namatable, (select count(*) from ad_package_exp) as jumlah
union all select 'ad_org' as namatable, (select count(*) from ad_org) as jumlah
union all select 'c_bpartner' as namatable, (select count(*) from c_bpartner) as jumlah
union all select 'ad_pinstance_log' as namatable, (select count(*) from ad_pinstance_log) as jumlah
union all select 'ad_printcolor_trl' as namatable, (select count(*) from ad_printcolor_trl) as jumlah
union all select 'ad_printfont' as namatable, (select count(*) from ad_printfont) as jumlah
union all select 'ad_printgraph' as namatable, (select count(*) from ad_printgraph) as jumlah
union all select 'ad_printform' as namatable, (select count(*) from ad_printform) as jumlah
union all select 'ad_printformat_trl' as namatable, (select count(*) from ad_printformat_trl) as jumlah
union all select 'ad_process' as namatable, (select count(*) from ad_process) as jumlah
union all select 'ad_process_access' as namatable, (select count(*) from ad_process_access) as jumlah
union all select 'ad_pinstance_para' as namatable, (select count(*) from ad_pinstance_para) as jumlah
union all select 'ad_printpaper' as namatable, (select count(*) from ad_printpaper) as jumlah
union all select 'ad_printlabelline' as namatable, (select count(*) from ad_printlabelline) as jumlah
union all select 'ad_private_access' as namatable, (select count(*) from ad_private_access) as jumlah
union all select 'ad_printlabelline_trl' as namatable, (select count(*) from ad_printlabelline_trl) as jumlah
union all select 'ad_printtableformat' as namatable, (select count(*) from ad_printtableformat) as jumlah
union all select 'ad_printformatitem_trl' as namatable, (select count(*) from ad_printformatitem_trl) as jumlah
union all select 'ad_printlabel' as namatable, (select count(*) from ad_printlabel) as jumlah
union all select 'ad_postit' as namatable, (select count(*) from ad_postit) as jumlah
union all select 'ad_printcolor' as namatable, (select count(*) from ad_printcolor) as jumlah
union all select 'ad_preference' as namatable, (select count(*) from ad_preference) as jumlah
union all select 'ad_printformat' as namatable, (select count(*) from ad_printformat) as jumlah
union all select 'ad_printformatitem' as namatable, (select count(*) from ad_printformatitem) as jumlah
union all select 'ad_reportview' as namatable, (select count(*) from ad_reportview) as jumlah
union all select 'ad_replication' as namatable, (select count(*) from ad_replication) as jumlah
union all select 'ad_reference_trl' as namatable, (select count(*) from ad_reference_trl) as jumlah
union all select 'ad_record_access' as namatable, (select count(*) from ad_record_access) as jumlah
union all select 'ad_registration' as namatable, (select count(*) from ad_registration) as jumlah
union all select 'ad_reportview_column' as namatable, (select count(*) from ad_reportview_column) as jumlah
union all select 'ad_replicationstrategy' as namatable, (select count(*) from ad_replicationstrategy) as jumlah
union all select 'ad_process_trl' as namatable, (select count(*) from ad_process_trl) as jumlah
union all select 'ad_ref_list' as namatable, (select count(*) from ad_ref_list) as jumlah
union all select 'ad_ref_list_trl' as namatable, (select count(*) from ad_ref_list_trl) as jumlah
union all select 'ad_replicationdocument' as namatable, (select count(*) from ad_replicationdocument) as jumlah
union all select 'ad_replication_log' as namatable, (select count(*) from ad_replication_log) as jumlah
union all select 'ad_replicationtable' as namatable, (select count(*) from ad_replicationtable) as jumlah
union all select 'ad_recentitem' as namatable, (select count(*) from ad_recentitem) as jumlah
union all select 'ad_reference' as namatable, (select count(*) from ad_reference) as jumlah
union all select 'ad_relationtype' as namatable, (select count(*) from ad_relationtype) as jumlah
union all select 'ad_process_para' as namatable, (select count(*) from ad_process_para) as jumlah
union all select 'ad_reportview_col' as namatable, (select count(*) from ad_reportview_col) as jumlah
union all select 'ad_ref_table' as namatable, (select count(*) from ad_ref_table) as jumlah
union all select 'ad_process_para_trl' as namatable, (select count(*) from ad_process_para_trl) as jumlah
union all select 'ad_sequence' as namatable, (select count(*) from ad_sequence) as jumlah
union all select 'ad_sequence_audit' as namatable, (select count(*) from ad_sequence_audit) as jumlah
union all select 'ad_scheduler' as namatable, (select count(*) from ad_scheduler) as jumlah
union all select 'ad_schedule' as namatable, (select count(*) from ad_schedule) as jumlah
union all select 'ad_sequence_no' as namatable, (select count(*) from ad_sequence_no) as jumlah
union all select 'ad_schedulerlog' as namatable, (select count(*) from ad_schedulerlog) as jumlah
union all select 'ad_scheduler_para' as namatable, (select count(*) from ad_scheduler_para) as jumlah
union all select 'ad_schedulerrecipient' as namatable, (select count(*) from ad_schedulerrecipient) as jumlah
union all select 'ad_storageprovider' as namatable, (select count(*) from ad_storageprovider) as jumlah
union all select 'ad_session' as namatable, (select count(*) from ad_session) as jumlah
union all select 'ad_statusline' as namatable, (select count(*) from ad_statusline) as jumlah
union all select 'ad_searchdefinition' as namatable, (select count(*) from ad_searchdefinition) as jumlah
union all select 'ad_statuslineusedin' as namatable, (select count(*) from ad_statuslineusedin) as jumlah
union all select 'ad_rule' as namatable, (select count(*) from ad_rule) as jumlah
union all select 'ad_role_orgaccess' as namatable, (select count(*) from ad_role_orgaccess) as jumlah
union all select 'ad_role' as namatable, (select count(*) from ad_role) as jumlah
union all select 'ad_style' as namatable, (select count(*) from ad_style) as jumlah
union all select 'ad_role_included' as namatable, (select count(*) from ad_role_included) as jumlah
union all select 'ad_task_access' as namatable, (select count(*) from ad_task_access) as jumlah
union all select 'ad_styleline' as namatable, (select count(*) from ad_styleline) as jumlah
union all select 'ad_tab_customization' as namatable, (select count(*) from ad_tab_customization) as jumlah
union all select 'ad_table_trl' as namatable, (select count(*) from ad_table_trl) as jumlah
union all select 'ad_tree' as namatable, (select count(*) from ad_tree) as jumlah
union all select 'ad_task_trl' as namatable, (select count(*) from ad_task_trl) as jumlah
union all select 'ad_tab_trl' as namatable, (select count(*) from ad_tab_trl) as jumlah
union all select 'ad_toolbarbutton' as namatable, (select count(*) from ad_toolbarbutton) as jumlah
union all select 'ad_tableindex' as namatable, (select count(*) from ad_tableindex) as jumlah
union all select 'ad_table_scriptvalidator' as namatable, (select count(*) from ad_table_scriptvalidator) as jumlah
union all select 'ad_task' as namatable, (select count(*) from ad_task) as jumlah
union all select 'ad_toolbarbuttonrestrict' as namatable, (select count(*) from ad_toolbarbuttonrestrict) as jumlah
union all select 'ad_system' as namatable, (select count(*) from ad_system) as jumlah
union all select 'ad_treebar' as namatable, (select count(*) from ad_treebar) as jumlah
union all select 'ad_treenode' as namatable, (select count(*) from ad_treenode) as jumlah
union all select 'ad_treenodebp' as namatable, (select count(*) from ad_treenodebp) as jumlah
union all select 'ad_treenodecmc' as namatable, (select count(*) from ad_treenodecmc) as jumlah
union all select 'ad_treenodecmm' as namatable, (select count(*) from ad_treenodecmm) as jumlah
union all select 'ad_treenodecms' as namatable, (select count(*) from ad_treenodecms) as jumlah
union all select 'ad_treenodecmt' as namatable, (select count(*) from ad_treenodecmt) as jumlah
union all select 'ad_treenodemm' as namatable, (select count(*) from ad_treenodemm) as jumlah
union all select 'ad_sysconfig' as namatable, (select count(*) from ad_sysconfig) as jumlah
union all select 'ad_table_access' as namatable, (select count(*) from ad_table_access) as jumlah
union all select 'ad_treenodeu2' as namatable, (select count(*) from ad_treenodeu2) as jumlah
union all select 'ad_treenodeu3' as namatable, (select count(*) from ad_treenodeu3) as jumlah
union all select 'ad_treenodeu4' as namatable, (select count(*) from ad_treenodeu4) as jumlah
union all select 'ad_userbpaccess' as namatable, (select count(*) from ad_userbpaccess) as jumlah
union all select 'ad_userdef_tab' as namatable, (select count(*) from ad_userdef_tab) as jumlah
union all select 'ad_userpreference' as namatable, (select count(*) from ad_userpreference) as jumlah
union all select 'ad_wf_activityapprover' as namatable, (select count(*) from ad_wf_activityapprover) as jumlah
union all select 'ad_usermail' as namatable, (select count(*) from ad_usermail) as jumlah
union all select 'ad_userdef_win' as namatable, (select count(*) from ad_userdef_win) as jumlah
union all select 'ad_userquery' as namatable, (select count(*) from ad_userquery) as jumlah
union all select 'ad_wf_activity' as namatable, (select count(*) from ad_wf_activity) as jumlah
union all select 'ad_user_substitute' as namatable, (select count(*) from ad_user_substitute) as jumlah
union all select 'ad_userdef_field' as namatable, (select count(*) from ad_userdef_field) as jumlah
union all select 'ad_viewcomponent' as namatable, (select count(*) from ad_viewcomponent) as jumlah
union all select 'ad_wf_activityresult' as namatable, (select count(*) from ad_wf_activityresult) as jumlah
union all select 'ad_user_orgaccess' as namatable, (select count(*) from ad_user_orgaccess) as jumlah
union all select 'ad_treenodepr' as namatable, (select count(*) from ad_treenodepr) as jumlah
union all select 'ad_viewcolumn' as namatable, (select count(*) from ad_viewcolumn) as jumlah
union all select 'ad_wf_block' as namatable, (select count(*) from ad_wf_block) as jumlah
union all select 'ad_user_roles' as namatable, (select count(*) from ad_user_roles) as jumlah
union all select 'ad_treenodeu1' as namatable, (select count(*) from ad_treenodeu1) as jumlah
union all select 'ad_workbenchwindow' as namatable, (select count(*) from ad_workbenchwindow) as jumlah
union all select 'ad_window' as namatable, (select count(*) from ad_window) as jumlah
union all select 'ad_workflowprocessor' as namatable, (select count(*) from ad_workflowprocessor) as jumlah
union all select 'ad_window_trl' as namatable, (select count(*) from ad_window_trl) as jumlah
union all select 'ad_wf_processdata' as namatable, (select count(*) from ad_wf_processdata) as jumlah
union all select 'ad_wf_responsible' as namatable, (select count(*) from ad_wf_responsible) as jumlah
union all select 'ad_wf_node_para' as namatable, (select count(*) from ad_wf_node_para) as jumlah
union all select 'ad_workflow_access' as namatable, (select count(*) from ad_workflow_access) as jumlah
union all select 'ad_wf_node_trl' as namatable, (select count(*) from ad_wf_node_trl) as jumlah
union all select 'ad_wf_process' as namatable, (select count(*) from ad_wf_process) as jumlah
union all select 'ad_workflow_trl' as namatable, (select count(*) from ad_workflow_trl) as jumlah
union all select 'ad_wf_nodenext' as namatable, (select count(*) from ad_wf_nodenext) as jumlah
union all select 'ad_wf_nextcondition' as namatable, (select count(*) from ad_wf_nextcondition) as jumlah
union all select 'ad_workbench_trl' as namatable, (select count(*) from ad_workbench_trl) as jumlah
union all select 'ad_workflow' as namatable, (select count(*) from ad_workflow) as jumlah
union all select 'ad_workbench' as namatable, (select count(*) from ad_workbench) as jumlah
union all select 'ad_wf_node' as namatable, (select count(*) from ad_wf_node) as jumlah
union all select 'ad_window_access' as namatable, (select count(*) from ad_window_access) as jumlah
union all select 'ad_wf_eventaudit' as namatable, (select count(*) from ad_wf_eventaudit) as jumlah
union all select 'ad_wizardprocess' as namatable, (select count(*) from ad_wizardprocess) as jumlah
union all select 'asp_task' as namatable, (select count(*) from asp_task) as jumlah
union all select 'asp_field' as namatable, (select count(*) from asp_field) as jumlah
union all select 'ad_workflowprocessorlog' as namatable, (select count(*) from ad_workflowprocessorlog) as jumlah
union all select 'asp_module' as namatable, (select count(*) from asp_module) as jumlah
union all select 'asp_form' as namatable, (select count(*) from asp_form) as jumlah
union all select 'asp_process' as namatable, (select count(*) from asp_process) as jumlah
union all select 'ad_zoomcondition' as namatable, (select count(*) from ad_zoomcondition) as jumlah
union all select 'asp_process_para' as namatable, (select count(*) from asp_process_para) as jumlah
union all select 'asp_ref_list' as namatable, (select count(*) from asp_ref_list) as jumlah
union all select 'asp_tab' as namatable, (select count(*) from asp_tab) as jumlah
union all select 'b_bid' as namatable, (select count(*) from b_bid) as jumlah
union all select 'asp_workflow' as namatable, (select count(*) from asp_workflow) as jumlah
union all select 'b_buyer' as namatable, (select count(*) from b_buyer) as jumlah
union all select 'b_offer' as namatable, (select count(*) from b_offer) as jumlah
union all select 'b_buyerfunds' as namatable, (select count(*) from b_buyerfunds) as jumlah
union all select 'b_seller' as namatable, (select count(*) from b_seller) as jumlah
union all select 'b_bidcomment' as namatable, (select count(*) from b_bidcomment) as jumlah
union all select 'b_sellerfunds' as namatable, (select count(*) from b_sellerfunds) as jumlah
union all select 'asp_window' as namatable, (select count(*) from asp_window) as jumlah
union all select 'asp_clientexception' as namatable, (select count(*) from asp_clientexception) as jumlah
union all select 'asp_level' as namatable, (select count(*) from asp_level) as jumlah
union all select 'asp_clientlevel' as namatable, (select count(*) from asp_clientlevel) as jumlah
union all select 'b_topictype' as namatable, (select count(*) from b_topictype) as jumlah
union all select 'c_1099box' as namatable, (select count(*) from c_1099box) as jumlah
union all select 'c_addressvalidation' as namatable, (select count(*) from c_addressvalidation) as jumlah
union all select 'c_acctprocessorlog' as namatable, (select count(*) from c_acctprocessorlog) as jumlah
union all select 'c_acctschema_gl' as namatable, (select count(*) from c_acctschema_gl) as jumlah
union all select 'c_activity_trl' as namatable, (select count(*) from c_activity_trl) as jumlah
union all select 'c_allocationhdr' as namatable, (select count(*) from c_allocationhdr) as jumlah
union all select 'c_acctprocessor' as namatable, (select count(*) from c_acctprocessor) as jumlah
union all select 'c_bankaccount_acct' as namatable, (select count(*) from c_bankaccount_acct) as jumlah
union all select 'c_acctschema' as namatable, (select count(*) from c_acctschema) as jumlah
union all select 'c_addresstransaction' as namatable, (select count(*) from c_addresstransaction) as jumlah
union all select 'c_addressvalidationcfg' as namatable, (select count(*) from c_addressvalidationcfg) as jumlah
union all select 'c_bankaccount' as namatable, (select count(*) from c_bankaccount) as jumlah
union all select 'c_acctschema_element' as namatable, (select count(*) from c_acctschema_element) as jumlah
union all select 'c_bank' as namatable, (select count(*) from c_bank) as jumlah
union all select 'c_acctschema_default' as namatable, (select count(*) from c_acctschema_default) as jumlah
union all select 'b_topic' as namatable, (select count(*) from b_topic) as jumlah
union all select 'b_topiccategory' as namatable, (select count(*) from b_topiccategory) as jumlah
union all select 'c_bankstatement' as namatable, (select count(*) from c_bankstatement) as jumlah
union all select 'c_bp_edi' as namatable, (select count(*) from c_bp_edi) as jumlah
union all select 'c_bankaccountdoc' as namatable, (select count(*) from c_bankaccountdoc) as jumlah
union all select 'c_bankstatementloader' as namatable, (select count(*) from c_bankstatementloader) as jumlah
union all select 'c_bpartner_product' as namatable, (select count(*) from c_bpartner_product) as jumlah
union all select 'c_bankaccount_processor' as namatable, (select count(*) from c_bankaccount_processor) as jumlah
union all select 'c_bankstatementline' as namatable, (select count(*) from c_bankstatementline) as jumlah
union all select 'c_bankstatementmatcher' as namatable, (select count(*) from c_bankstatementmatcher) as jumlah
union all select 'c_bpartner_location' as namatable, (select count(*) from c_bpartner_location) as jumlah
union all select 'c_bp_employee_acct' as namatable, (select count(*) from c_bp_employee_acct) as jumlah
union all select 'c_bp_bankaccount' as namatable, (select count(*) from c_bp_bankaccount) as jumlah
union all select 'c_bp_group_acct' as namatable, (select count(*) from c_bp_group_acct) as jumlah
union all select 'c_bp_withholding' as namatable, (select count(*) from c_bp_withholding) as jumlah
union all select 'c_calendar' as namatable, (select count(*) from c_calendar) as jumlah
union all select 'c_campaign' as namatable, (select count(*) from c_campaign) as jumlah
union all select 'c_bp_vendor_acct' as namatable, (select count(*) from c_bp_vendor_acct) as jumlah
union all select 'c_bp_relation' as namatable, (select count(*) from c_bp_relation) as jumlah
union all select 'c_cashbook' as namatable, (select count(*) from c_cashbook) as jumlah
union all select 'c_cash' as namatable, (select count(*) from c_cash) as jumlah
union all select 'c_bp_group' as namatable, (select count(*) from c_bp_group) as jumlah
union all select 'c_bp_customer_acct' as namatable, (select count(*) from c_bp_customer_acct) as jumlah
union all select 'c_campaign_trl' as namatable, (select count(*) from c_campaign_trl) as jumlah
union all select 'c_bp_shippingacct' as namatable, (select count(*) from c_bp_shippingacct) as jumlah
union all select 'c_charge' as namatable, (select count(*) from c_charge) as jumlah
union all select 'c_commissionrun' as namatable, (select count(*) from c_commissionrun) as jumlah
union all select 'c_cashplanline' as namatable, (select count(*) from c_cashplanline) as jumlah
union all select 'c_commissionline' as namatable, (select count(*) from c_commissionline) as jumlah
union all select 'c_contactactivity' as namatable, (select count(*) from c_contactactivity) as jumlah
union all select 'c_commissiondetail' as namatable, (select count(*) from c_commissiondetail) as jumlah
union all select 'c_commission' as namatable, (select count(*) from c_commission) as jumlah
union all select 'c_cashline' as namatable, (select count(*) from c_cashline) as jumlah
union all select 'c_cashplan' as namatable, (select count(*) from c_cashplan) as jumlah
union all select 'c_chargetype_doctype' as namatable, (select count(*) from c_chargetype_doctype) as jumlah
union all select 'c_commissionamt' as namatable, (select count(*) from c_commissionamt) as jumlah
union all select 'c_conversion_rate' as namatable, (select count(*) from c_conversion_rate) as jumlah
union all select 'c_chargetype' as namatable, (select count(*) from c_chargetype) as jumlah
union all select 'c_conversiontype' as namatable, (select count(*) from c_conversiontype) as jumlah
union all select 'c_channel' as namatable, (select count(*) from c_channel) as jumlah
union all select 'c_city' as namatable, (select count(*) from c_city) as jumlah
union all select 'c_cashbook_acct' as namatable, (select count(*) from c_cashbook_acct) as jumlah
union all select 'c_charge_trl' as namatable, (select count(*) from c_charge_trl) as jumlah
union all select 'c_charge_acct' as namatable, (select count(*) from c_charge_acct) as jumlah
union all select 'c_currency_trl' as namatable, (select count(*) from c_currency_trl) as jumlah
union all select 'c_doctypecounter' as namatable, (select count(*) from c_doctypecounter) as jumlah
union all select 'c_countrygroupcountry' as namatable, (select count(*) from c_countrygroupcountry) as jumlah
union all select 'c_country' as namatable, (select count(*) from c_country) as jumlah
union all select 'c_countrygroup_trl' as namatable, (select count(*) from c_countrygroup_trl) as jumlah
union all select 'c_currency_acct' as namatable, (select count(*) from c_currency_acct) as jumlah
union all select 'c_depositbatch' as namatable, (select count(*) from c_depositbatch) as jumlah
union all select 'c_doctype_trl' as namatable, (select count(*) from c_doctype_trl) as jumlah
union all select 'c_cyclestep' as namatable, (select count(*) from c_cyclestep) as jumlah
union all select 'c_dunningrun' as namatable, (select count(*) from c_dunningrun) as jumlah
union all select 'c_cyclephase' as namatable, (select count(*) from c_cyclephase) as jumlah
union all select 'c_cycle' as namatable, (select count(*) from c_cycle) as jumlah
union all select 'c_countrygroup' as namatable, (select count(*) from c_countrygroup) as jumlah
union all select 'c_greeting' as namatable, (select count(*) from c_greeting) as jumlah
union all select 'c_dunninglevel' as namatable, (select count(*) from c_dunninglevel) as jumlah
union all select 'c_dunning' as namatable, (select count(*) from c_dunning) as jumlah
union all select 'c_dunningrunentry' as namatable, (select count(*) from c_dunningrunentry) as jumlah
union all select 'c_currency' as namatable, (select count(*) from c_currency) as jumlah
union all select 'c_doctype' as namatable, (select count(*) from c_doctype) as jumlah
union all select 'c_country_trl' as namatable, (select count(*) from c_country_trl) as jumlah
union all select 'c_depositbatchline' as namatable, (select count(*) from c_depositbatchline) as jumlah
union all select 'c_elementvalue_trl' as namatable, (select count(*) from c_elementvalue_trl) as jumlah
union all select 'c_paymentterm_trl' as namatable, (select count(*) from c_paymentterm_trl) as jumlah
union all select 'c_invoiceschedule' as namatable, (select count(*) from c_invoiceschedule) as jumlah
union all select 'c_location' as namatable, (select count(*) from c_location) as jumlah
union all select 'c_dunningrunline' as namatable, (select count(*) from c_dunningrunline) as jumlah
union all select 'c_order' as namatable, (select count(*) from c_order) as jumlah
union all select 'c_orderline' as namatable, (select count(*) from c_orderline) as jumlah
union all select 'c_interorg_acct' as namatable, (select count(*) from c_interorg_acct) as jumlah
union all select 'c_element' as namatable, (select count(*) from c_element) as jumlah
union all select 'c_greeting_trl' as namatable, (select count(*) from c_greeting_trl) as jumlah
union all select 'c_invoice' as namatable, (select count(*) from c_invoice) as jumlah
union all select 'c_paymentterm' as namatable, (select count(*) from c_paymentterm) as jumlah
union all select 'c_payment' as namatable, (select count(*) from c_payment) as jumlah
union all select 'c_elementvalue' as namatable, (select count(*) from c_elementvalue) as jumlah
union all select 'c_dunninglevel_trl' as namatable, (select count(*) from c_dunninglevel_trl) as jumlah
union all select 'm_product' as namatable, (select count(*) from m_product) as jumlah
union all select 'pp_product_bom' as namatable, (select count(*) from pp_product_bom) as jumlah
union all select 'c_uom_trl' as namatable, (select count(*) from c_uom_trl) as jumlah
union all select 'c_invoicebatch' as namatable, (select count(*) from c_invoicebatch) as jumlah
union all select 'c_invoicepayschedule' as namatable, (select count(*) from c_invoicepayschedule) as jumlah
union all select 's_resourceassignment' as namatable, (select count(*) from s_resourceassignment) as jumlah
union all select 'c_tax_trl' as namatable, (select count(*) from c_tax_trl) as jumlah
union all select 'm_product_trl' as namatable, (select count(*) from m_product_trl) as jumlah
union all select 'pp_product_bomline' as namatable, (select count(*) from pp_product_bomline) as jumlah
union all select 'm_attributesetinstance' as namatable, (select count(*) from m_attributesetinstance) as jumlah
union all select 'c_invoicetax' as namatable, (select count(*) from c_invoicetax) as jumlah
union all select 'c_invoicebatchline' as namatable, (select count(*) from c_invoicebatchline) as jumlah
union all select 'c_uom' as namatable, (select count(*) from c_uom) as jumlah
union all select 'c_tax' as namatable, (select count(*) from c_tax) as jumlah
union all select 'c_invoiceline' as namatable, (select count(*) from c_invoiceline) as jumlah
union all select 'c_jobremuneration' as namatable, (select count(*) from c_jobremuneration) as jumlah
union all select 'c_opportunity' as namatable, (select count(*) from c_opportunity) as jumlah
union all select 'c_orderlandedcost' as namatable, (select count(*) from c_orderlandedcost) as jumlah
union all select 'c_jobcategory' as namatable, (select count(*) from c_jobcategory) as jumlah
union all select 'c_job' as namatable, (select count(*) from c_job) as jumlah
union all select 'm_warehouse' as namatable, (select count(*) from m_warehouse) as jumlah
union all select 'c_jobassignment' as namatable, (select count(*) from c_jobassignment) as jumlah
union all select 'm_product_po' as namatable, (select count(*) from m_product_po) as jumlah
union all select 'c_landedcost' as namatable, (select count(*) from c_landedcost) as jumlah
union all select 'c_orderlandedcostallocation' as namatable, (select count(*) from c_orderlandedcostallocation) as jumlah
union all select 'c_nonbusinessday' as namatable, (select count(*) from c_nonbusinessday) as jumlah
union all select 'c_orderpayschedule' as namatable, (select count(*) from c_orderpayschedule) as jumlah
union all select 'c_ordertax' as namatable, (select count(*) from c_ordertax) as jumlah
union all select 'c_orgassignment' as namatable, (select count(*) from c_orgassignment) as jumlah
union all select 'c_ordersource' as namatable, (select count(*) from c_ordersource) as jumlah
union all select 'c_onlinetrxhistory' as namatable, (select count(*) from c_onlinetrxhistory) as jumlah
union all select 'c_landedcostallocation' as namatable, (select count(*) from c_landedcostallocation) as jumlah
union all select 'c_paymentbatch' as namatable, (select count(*) from c_paymentbatch) as jumlah
union all select 'c_payselectionline' as namatable, (select count(*) from c_payselectionline) as jumlah
union all select 'c_payschedule' as namatable, (select count(*) from c_payschedule) as jumlah
union all select 'c_pos' as namatable, (select count(*) from c_pos) as jumlah
union all select 'c_poskeylayout' as namatable, (select count(*) from c_poskeylayout) as jumlah
union all select 'c_phase' as namatable, (select count(*) from c_phase) as jumlah
union all select 'c_payselectioncheck' as namatable, (select count(*) from c_payselectioncheck) as jumlah
union all select 'c_paymentallocate' as namatable, (select count(*) from c_paymentallocate) as jumlah
union all select 'c_periodcontrol' as namatable, (select count(*) from c_periodcontrol) as jumlah
union all select 'c_payselection' as namatable, (select count(*) from c_payselection) as jumlah
union all select 'c_paymenttransaction' as namatable, (select count(*) from c_paymenttransaction) as jumlah
union all select 'c_period' as namatable, (select count(*) from c_period) as jumlah
union all select 'c_paymentprocessor' as namatable, (select count(*) from c_paymentprocessor) as jumlah
union all select 'c_poskey' as namatable, (select count(*) from c_poskey) as jumlah
union all select 'c_projectissue' as namatable, (select count(*) from c_projectissue) as jumlah
union all select 'c_recurringgroup' as namatable, (select count(*) from c_recurringgroup) as jumlah
union all select 'c_projectphase' as namatable, (select count(*) from c_projectphase) as jumlah
union all select 'c_postendertype' as namatable, (select count(*) from c_postendertype) as jumlah
union all select 'c_project' as namatable, (select count(*) from c_project) as jumlah
union all select 'c_region' as namatable, (select count(*) from c_region) as jumlah
union all select 'c_projectissuema' as namatable, (select count(*) from c_projectissuema) as jumlah
union all select 'c_pospayment' as namatable, (select count(*) from c_pospayment) as jumlah
union all select 'c_projecttask' as namatable, (select count(*) from c_projecttask) as jumlah
union all select 'c_projecttype' as namatable, (select count(*) from c_projecttype) as jumlah
union all select 'c_recurring_run' as namatable, (select count(*) from c_recurring_run) as jumlah
union all select 'c_recurring' as namatable, (select count(*) from c_recurring) as jumlah
union all select 'c_region_trl' as namatable, (select count(*) from c_region_trl) as jumlah
union all select 'c_project_acct' as namatable, (select count(*) from c_project_acct) as jumlah
union all select 'c_projectline' as namatable, (select count(*) from c_projectline) as jumlah
union all select 'c_salesregion_trl' as namatable, (select count(*) from c_salesregion_trl) as jumlah
union all select 'c_revenuerecognition_run' as namatable, (select count(*) from c_revenuerecognition_run) as jumlah
union all select 'c_remuneration' as namatable, (select count(*) from c_remuneration) as jumlah
union all select 'c_salesregion' as namatable, (select count(*) from c_salesregion) as jumlah
union all select 'c_rfqline' as namatable, (select count(*) from c_rfqline) as jumlah
union all select 'c_rfqresponse' as namatable, (select count(*) from c_rfqresponse) as jumlah
union all select 'c_rfq_topicsubscriber' as namatable, (select count(*) from c_rfq_topicsubscriber) as jumlah
union all select 'c_rfq' as namatable, (select count(*) from c_rfq) as jumlah
union all select 'c_rfqlineqty' as namatable, (select count(*) from c_rfqlineqty) as jumlah
union all select 'c_rfqresponseline' as namatable, (select count(*) from c_rfqresponseline) as jumlah
union all select 'c_rfq_topicsubscriberonly' as namatable, (select count(*) from c_rfq_topicsubscriberonly) as jumlah
union all select 'c_rfqresponselineqty' as namatable, (select count(*) from c_rfqresponselineqty) as jumlah
union all select 'c_revenuerecognition_plan' as namatable, (select count(*) from c_revenuerecognition_plan) as jumlah
union all select 'c_rfq_topic' as namatable, (select count(*) from c_rfq_topic) as jumlah
union all select 'c_revenuerecog_service' as namatable, (select count(*) from c_revenuerecog_service) as jumlah
union all select 'c_revenuerecognition' as namatable, (select count(*) from c_revenuerecognition) as jumlah
union all select 'c_taxprovider' as namatable, (select count(*) from c_taxprovider) as jumlah
union all select 'c_salesstage' as namatable, (select count(*) from c_salesstage) as jumlah
union all select 'c_taxtype' as namatable, (select count(*) from c_taxtype) as jumlah
union all select 'c_subscription_delivery' as namatable, (select count(*) from c_subscription_delivery) as jumlah
union all select 'c_task' as namatable, (select count(*) from c_task) as jumlah
union all select 'c_servicelevel' as namatable, (select count(*) from c_servicelevel) as jumlah
union all select 'c_taxdeclarationacct' as namatable, (select count(*) from c_taxdeclarationacct) as jumlah
union all select 'c_taxcategory' as namatable, (select count(*) from c_taxcategory) as jumlah
union all select 'c_taxdeclaration' as namatable, (select count(*) from c_taxdeclaration) as jumlah
union all select 'c_taxdefinition' as namatable, (select count(*) from c_taxdefinition) as jumlah
union all select 'c_taxgroup' as namatable, (select count(*) from c_taxgroup) as jumlah
union all select 'c_taxdeclarationline' as namatable, (select count(*) from c_taxdeclarationline) as jumlah
union all select 'c_subscription' as namatable, (select count(*) from c_subscription) as jumlah
union all select 'c_tax_acct' as namatable, (select count(*) from c_tax_acct) as jumlah
union all select 'c_taxbase' as namatable, (select count(*) from c_taxbase) as jumlah
union all select 'c_taxcategory_trl' as namatable, (select count(*) from c_taxcategory_trl) as jumlah
union all select 'c_salesstage_trl' as namatable, (select count(*) from c_salesstage_trl) as jumlah
union all select 'c_taxprovidercfg' as namatable, (select count(*) from c_taxprovidercfg) as jumlah
union all select 'c_subacct' as namatable, (select count(*) from c_subacct) as jumlah
union all select 'c_servicelevelline' as namatable, (select count(*) from c_servicelevelline) as jumlah
union all select 'c_subscriptiontype' as namatable, (select count(*) from c_subscriptiontype) as jumlah
union all select 'c_taxpostal' as namatable, (select count(*) from c_taxpostal) as jumlah
union all select 'c_withholding_acct' as namatable, (select count(*) from c_withholding_acct) as jumlah
union all select 'cm_broadcastserver' as namatable, (select count(*) from cm_broadcastserver) as jumlah
union all select 'c_withholding' as namatable, (select count(*) from c_withholding) as jumlah
union all select 'cm_accesslistrole' as namatable, (select count(*) from cm_accesslistrole) as jumlah
union all select 'c_year' as namatable, (select count(*) from c_year) as jumlah
union all select 'cm_accesslistbpgroup' as namatable, (select count(*) from cm_accesslistbpgroup) as jumlah
union all select 'c_uom_conversion' as namatable, (select count(*) from c_uom_conversion) as jumlah
union all select 'cm_accessmedia' as namatable, (select count(*) from cm_accessmedia) as jumlah
union all select 'cm_accessprofile' as namatable, (select count(*) from cm_accessprofile) as jumlah
union all select 'cm_chat' as namatable, (select count(*) from cm_chat) as jumlah
union all select 'cm_accessstage' as namatable, (select count(*) from cm_accessstage) as jumlah
union all select 'cm_accesscontainer' as namatable, (select count(*) from cm_accesscontainer) as jumlah
union all select 'cm_ad_cat' as namatable, (select count(*) from cm_ad_cat) as jumlah
union all select 'cm_ad' as namatable, (select count(*) from cm_ad) as jumlah
union all select 'cm_chattypeupdate' as namatable, (select count(*) from cm_chattypeupdate) as jumlah
union all select 'cm_container' as namatable, (select count(*) from cm_container) as jumlah
union all select 'cm_chattype' as namatable, (select count(*) from cm_chattype) as jumlah
union all select 'c_userremuneration' as namatable, (select count(*) from c_userremuneration) as jumlah
union all select 'cm_chatentry' as namatable, (select count(*) from cm_chatentry) as jumlah
union all select 'cm_chatupdate' as namatable, (select count(*) from cm_chatupdate) as jumlah
union all select 'c_validcombination' as namatable, (select count(*) from c_validcombination) as jumlah
union all select 'cm_accessnewschannel' as namatable, (select count(*) from cm_accessnewschannel) as jumlah
union all select 'cm_container_trl' as namatable, (select count(*) from cm_container_trl) as jumlah
union all select 'cm_newsitem' as namatable, (select count(*) from cm_newsitem) as jumlah
union all select 'cm_cstage_element_trl' as namatable, (select count(*) from cm_cstage_element_trl) as jumlah
union all select 'cm_cstage' as namatable, (select count(*) from cm_cstage) as jumlah
union all select 'cm_container_url' as namatable, (select count(*) from cm_container_url) as jumlah
union all select 'cm_cstage_element' as namatable, (select count(*) from cm_cstage_element) as jumlah
union all select 'cm_mediadeploy' as namatable, (select count(*) from cm_mediadeploy) as jumlah
union all select 'cm_cstage_trl' as namatable, (select count(*) from cm_cstage_trl) as jumlah
union all select 'cm_media_server' as namatable, (select count(*) from cm_media_server) as jumlah
union all select 'cm_container_element' as namatable, (select count(*) from cm_container_element) as jumlah
union all select 'cm_newschannel' as namatable, (select count(*) from cm_newschannel) as jumlah
union all select 'cm_container_element_trl' as namatable, (select count(*) from cm_container_element_trl) as jumlah
union all select 'cm_cstagettable' as namatable, (select count(*) from cm_cstagettable) as jumlah
union all select 'cm_media' as namatable, (select count(*) from cm_media) as jumlah
union all select 'cm_containerttable' as namatable, (select count(*) from cm_containerttable) as jumlah
union all select 'cm_webproject_domain' as namatable, (select count(*) from cm_webproject_domain) as jumlah
union all select 'cm_wikitoken' as namatable, (select count(*) from cm_wikitoken) as jumlah
union all select 'cm_template_ad_cat' as namatable, (select count(*) from cm_template_ad_cat) as jumlah
union all select 'dd_orderline' as namatable, (select count(*) from dd_orderline) as jumlah
union all select 'cm_webaccesslog' as namatable, (select count(*) from cm_webaccesslog) as jumlah
union all select 'cm_template' as namatable, (select count(*) from cm_template) as jumlah
union all select 'exp_format' as namatable, (select count(*) from exp_format) as jumlah
union all select 'exp_processor' as namatable, (select count(*) from exp_processor) as jumlah
union all select 'dbreplicasyncverifier' as namatable, (select count(*) from dbreplicasyncverifier) as jumlah
union all select 'cm_templatetable' as namatable, (select count(*) from cm_templatetable) as jumlah
union all select 'cm_webproject' as namatable, (select count(*) from cm_webproject) as jumlah
union all select 'dd_order' as namatable, (select count(*) from dd_order) as jumlah
union all select 'dual' as namatable, (select count(*) from dual) as jumlah
union all select 'exp_formatline' as namatable, (select count(*) from exp_formatline) as jumlah
union all select 'dd_networkdistribution' as namatable, (select count(*) from dd_networkdistribution) as jumlah
union all select 'gl_journal' as namatable, (select count(*) from gl_journal) as jumlah
union all select 'exp_processor_type' as namatable, (select count(*) from exp_processor_type) as jumlah
union all select 'fact_acct_summary' as namatable, (select count(*) from fact_acct_summary) as jumlah
union all select 'gl_category_trl' as namatable, (select count(*) from gl_category_trl) as jumlah
union all select 'gl_budget' as namatable, (select count(*) from gl_budget) as jumlah
union all select 'gl_category' as namatable, (select count(*) from gl_category) as jumlah
union all select 'gl_fund' as namatable, (select count(*) from gl_fund) as jumlah
union all select 'gl_distribution' as namatable, (select count(*) from gl_distribution) as jumlah
union all select 'gl_distributionline' as namatable, (select count(*) from gl_distributionline) as jumlah
union all select 'gl_journalgenerator' as namatable, (select count(*) from gl_journalgenerator) as jumlah
union all select 'exp_processorparameter' as namatable, (select count(*) from exp_processorparameter) as jumlah
union all select 'gl_budgetcontrol' as namatable, (select count(*) from gl_budgetcontrol) as jumlah
union all select 'gl_journalbatch' as namatable, (select count(*) from gl_journalbatch) as jumlah
union all select 'gl_journalgeneratorline' as namatable, (select count(*) from gl_journalgeneratorline) as jumlah
union all select 'gl_fundrestriction' as namatable, (select count(*) from gl_fundrestriction) as jumlah
union all select 'fact_acct' as namatable, (select count(*) from fact_acct) as jumlah
union all select 'fact_reconciliation' as namatable, (select count(*) from fact_reconciliation) as jumlah
union all select 'hr_department' as namatable, (select count(*) from hr_department) as jumlah
union all select 'hr_payroll' as namatable, (select count(*) from hr_payroll) as jumlah
union all select 'hr_payrollconcept' as namatable, (select count(*) from hr_payrollconcept) as jumlah
union all select 'hr_attribute' as namatable, (select count(*) from hr_attribute) as jumlah
union all select 'hr_employee' as namatable, (select count(*) from hr_employee) as jumlah
union all select 'hr_job' as namatable, (select count(*) from hr_job) as jumlah
union all select 'gl_journalgeneratorsource' as namatable, (select count(*) from gl_journalgeneratorsource) as jumlah
union all select 'hr_movement' as namatable, (select count(*) from hr_movement) as jumlah
union all select 'i_bankstatement' as namatable, (select count(*) from i_bankstatement) as jumlah
union all select 'hr_list' as namatable, (select count(*) from hr_list) as jumlah
union all select 'hr_listversion' as namatable, (select count(*) from hr_listversion) as jumlah
union all select 'hr_listline' as namatable, (select count(*) from hr_listline) as jumlah
union all select 'hr_listtype' as namatable, (select count(*) from hr_listtype) as jumlah
union all select 'hr_process' as namatable, (select count(*) from hr_process) as jumlah
union all select 'i_bpartner' as namatable, (select count(*) from i_bpartner) as jumlah
union all select 'hr_year' as namatable, (select count(*) from hr_year) as jumlah
union all select 'hr_concept' as namatable, (select count(*) from hr_concept) as jumlah
union all select 'hr_concept_category' as namatable, (select count(*) from hr_concept_category) as jumlah
union all select 'gl_journalline' as namatable, (select count(*) from gl_journalline) as jumlah
union all select 'hr_contract' as namatable, (select count(*) from hr_contract) as jumlah
union all select 'hr_concept_acct' as namatable, (select count(*) from hr_concept_acct) as jumlah
union all select 'i_asset' as namatable, (select count(*) from i_asset) as jumlah
union all select 'hr_period' as namatable, (select count(*) from hr_period) as jumlah
union all select 'i_gljournal' as namatable, (select count(*) from i_gljournal) as jumlah
union all select 'i_hr_movement' as namatable, (select count(*) from i_hr_movement) as jumlah
union all select 'i_elementvalue' as namatable, (select count(*) from i_elementvalue) as jumlah
union all select 'i_fajournal' as namatable, (select count(*) from i_fajournal) as jumlah
union all select 'i_invoice' as namatable, (select count(*) from i_invoice) as jumlah
union all select 'i_productplanning' as namatable, (select count(*) from i_productplanning) as jumlah
union all select 'i_pricelist' as namatable, (select count(*) from i_pricelist) as jumlah
union all select 'i_conversion_rate' as namatable, (select count(*) from i_conversion_rate) as jumlah
union all select 'i_order' as namatable, (select count(*) from i_order) as jumlah
union all select 'i_movement' as namatable, (select count(*) from i_movement) as jumlah
union all select 'i_product' as namatable, (select count(*) from i_product) as jumlah
union all select 'i_inventory' as namatable, (select count(*) from i_inventory) as jumlah
union all select 'i_payment' as namatable, (select count(*) from i_payment) as jumlah
union all select 'i_fixedasset' as namatable, (select count(*) from i_fixedasset) as jumlah
union all select 'i_inoutlineconfirm' as namatable, (select count(*) from i_inoutlineconfirm) as jumlah
union all select 'k_entryrelated' as namatable, (select count(*) from k_entryrelated) as jumlah
union all select 'imp_processorparameter' as namatable, (select count(*) from imp_processorparameter) as jumlah
union all select 'k_category' as namatable, (select count(*) from k_category) as jumlah
union all select 'k_source' as namatable, (select count(*) from k_source) as jumlah
union all select 'imp_processor_type' as namatable, (select count(*) from imp_processor_type) as jumlah
union all select 'k_categoryvalue' as namatable, (select count(*) from k_categoryvalue) as jumlah
union all select 'k_comment' as namatable, (select count(*) from k_comment) as jumlah
union all select 'k_entrycategory' as namatable, (select count(*) from k_entrycategory) as jumlah
union all select 'k_topic' as namatable, (select count(*) from k_topic) as jumlah
union all select 'k_entry' as namatable, (select count(*) from k_entry) as jumlah
union all select 'k_index' as namatable, (select count(*) from k_index) as jumlah
union all select 'k_indexstop' as namatable, (select count(*) from k_indexstop) as jumlah
union all select 'k_indexlog' as namatable, (select count(*) from k_indexlog) as jumlah
union all select 'i_reportline' as namatable, (select count(*) from i_reportline) as jumlah
union all select 'k_type' as namatable, (select count(*) from k_type) as jumlah
union all select 'm_attribute' as namatable, (select count(*) from m_attribute) as jumlah
union all select 'k_synonym' as namatable, (select count(*) from k_synonym) as jumlah
union all select 'imp_processor' as namatable, (select count(*) from imp_processor) as jumlah
union all select 'imp_processorlog' as namatable, (select count(*) from imp_processorlog) as jumlah
union all select 'm_attributeset' as namatable, (select count(*) from m_attributeset) as jumlah
union all select 'm_costhistory' as namatable, (select count(*) from m_costhistory) as jumlah
union all select 'm_costqueue' as namatable, (select count(*) from m_costqueue) as jumlah
union all select 'm_attributevalue' as namatable, (select count(*) from m_attributevalue) as jumlah
union all select 'm_attributesearch' as namatable, (select count(*) from m_attributesearch) as jumlah
union all select 'm_bomalternative' as namatable, (select count(*) from m_bomalternative) as jumlah
union all select 'm_changenotice' as namatable, (select count(*) from m_changenotice) as jumlah
union all select 'm_bom' as namatable, (select count(*) from m_bom) as jumlah
union all select 'm_attributeinstance' as namatable, (select count(*) from m_attributeinstance) as jumlah
union all select 'm_costelement' as namatable, (select count(*) from m_costelement) as jumlah
union all select 'm_changerequest' as namatable, (select count(*) from m_changerequest) as jumlah
union all select 'm_costdetail' as namatable, (select count(*) from m_costdetail) as jumlah
union all select 'm_costtype' as namatable, (select count(*) from m_costtype) as jumlah
union all select 'm_bomproduct' as namatable, (select count(*) from m_bomproduct) as jumlah
union all select 'm_attributesetexclude' as namatable, (select count(*) from m_attributesetexclude) as jumlah
union all select 'm_commodityshipment' as namatable, (select count(*) from m_commodityshipment) as jumlah
union all select 'm_bp_price' as namatable, (select count(*) from m_bp_price) as jumlah
union all select 'm_cost' as namatable, (select count(*) from m_cost) as jumlah
union all select 'm_attributeuse' as namatable, (select count(*) from m_attributeuse) as jumlah
union all select 'm_demandline' as namatable, (select count(*) from m_demandline) as jumlah
union all select 'm_forecastline' as namatable, (select count(*) from m_forecastline) as jumlah
union all select 'm_freight' as namatable, (select count(*) from m_freight) as jumlah
union all select 'm_discountschemabreak' as namatable, (select count(*) from m_discountschemabreak) as jumlah
union all select 'm_distributionlist' as namatable, (select count(*) from m_distributionlist) as jumlah
union all select 'm_distributionlistline' as namatable, (select count(*) from m_distributionlistline) as jumlah
union all select 'm_demand' as namatable, (select count(*) from m_demand) as jumlah
union all select 'm_distributionrunline' as namatable, (select count(*) from m_distributionrunline) as jumlah
union all select 'm_distributionrun' as namatable, (select count(*) from m_distributionrun) as jumlah
union all select 'm_edi' as namatable, (select count(*) from m_edi) as jumlah
union all select 'm_edi_info' as namatable, (select count(*) from m_edi_info) as jumlah
union all select 'm_freightcategory' as namatable, (select count(*) from m_freightcategory) as jumlah
union all select 'm_discountschema' as namatable, (select count(*) from m_discountschema) as jumlah
union all select 'm_demanddetail' as namatable, (select count(*) from m_demanddetail) as jumlah
union all select 'm_discountschemaline' as namatable, (select count(*) from m_discountschemaline) as jumlah
union all select 'm_forecast' as namatable, (select count(*) from m_forecast) as jumlah
union all select 'm_inventory' as namatable, (select count(*) from m_inventory) as jumlah
union all select 'm_inoutlinema' as namatable, (select count(*) from m_inoutlinema) as jumlah
union all select 'm_inventorylinema' as namatable, (select count(*) from m_inventorylinema) as jumlah
union all select 'm_locator' as namatable, (select count(*) from m_locator) as jumlah
union all select 'm_inoutlineconfirm' as namatable, (select count(*) from m_inoutlineconfirm) as jumlah
union all select 'm_inventoryline' as namatable, (select count(*) from m_inventoryline) as jumlah
union all select 'm_inoutconfirm' as namatable, (select count(*) from m_inoutconfirm) as jumlah
union all select 'm_rmaline' as namatable, (select count(*) from m_rmaline) as jumlah
union all select 'm_inout' as namatable, (select count(*) from m_inout) as jumlah
union all select 'm_inoutline' as namatable, (select count(*) from m_inoutline) as jumlah
union all select 'm_lot' as namatable, (select count(*) from m_lot) as jumlah
union all select 'm_lotctl' as namatable, (select count(*) from m_lotctl) as jumlah
union all select 'm_product_bom' as namatable, (select count(*) from m_product_bom) as jumlah
union all select 'm_package' as namatable, (select count(*) from m_package) as jumlah
union all select 'm_movementline' as namatable, (select count(*) from m_movementline) as jumlah
union all select 'm_movementconfirm' as namatable, (select count(*) from m_movementconfirm) as jumlah
union all select 'm_matchinv' as namatable, (select count(*) from m_matchinv) as jumlah
union all select 'm_lotctlexclude' as namatable, (select count(*) from m_lotctlexclude) as jumlah
union all select 'm_movementlinema' as namatable, (select count(*) from m_movementlinema) as jumlah
union all select 'm_packageline' as namatable, (select count(*) from m_packageline) as jumlah
union all select 'm_movementlineconfirm' as namatable, (select count(*) from m_movementlineconfirm) as jumlah
union all select 'm_locatortype' as namatable, (select count(*) from m_locatortype) as jumlah
union all select 'm_matchpo' as namatable, (select count(*) from m_matchpo) as jumlah
union all select 'm_operationresource' as namatable, (select count(*) from m_operationresource) as jumlah
union all select 'm_movement' as namatable, (select count(*) from m_movement) as jumlah
union all select 'm_substitute' as namatable, (select count(*) from m_substitute) as jumlah
union all select 'm_productionline' as namatable, (select count(*) from m_productionline) as jumlah
union all select 'm_perpetualinv' as namatable, (select count(*) from m_perpetualinv) as jumlah
union all select 'm_productprice' as namatable, (select count(*) from m_productprice) as jumlah
union all select 'm_product_category_acct' as namatable, (select count(*) from m_product_category_acct) as jumlah
union all select 'm_pricelist_version_trl' as namatable, (select count(*) from m_pricelist_version_trl) as jumlah
union all select 'm_parttype' as namatable, (select count(*) from m_parttype) as jumlah
union all select 'm_product_category_trl' as namatable, (select count(*) from m_product_category_trl) as jumlah
union all select 'm_packagemps' as namatable, (select count(*) from m_packagemps) as jumlah
union all select 'm_pricelist_trl' as namatable, (select count(*) from m_pricelist_trl) as jumlah
union all select 'm_product_acct' as namatable, (select count(*) from m_product_acct) as jumlah
union all select 'm_production' as namatable, (select count(*) from m_production) as jumlah
union all select 'm_relatedproduct' as namatable, (select count(*) from m_relatedproduct) as jumlah
union all select 'm_storagereservation' as namatable, (select count(*) from m_storagereservation) as jumlah
union all select 'm_product_qualitytest' as namatable, (select count(*) from m_product_qualitytest) as jumlah
union all select 'm_productdownload' as namatable, (select count(*) from m_productdownload) as jumlah
union all select 'm_productionlinema' as namatable, (select count(*) from m_productionlinema) as jumlah
union all select 'm_pricelist' as namatable, (select count(*) from m_pricelist) as jumlah
union all select 'm_pricelist_version' as namatable, (select count(*) from m_pricelist_version) as jumlah
union all select 'm_storageonhand' as namatable, (select count(*) from m_storageonhand) as jumlah
union all select 'm_product_category' as namatable, (select count(*) from m_product_category) as jumlah
union all select 'm_promotiongroupline' as namatable, (select count(*) from m_promotiongroupline) as jumlah
union all select 'm_productionplan' as namatable, (select count(*) from m_productionplan) as jumlah
union all select 'm_requisitionline' as namatable, (select count(*) from m_requisitionline) as jumlah
union all select 'm_promotionreward' as namatable, (select count(*) from m_promotionreward) as jumlah
union all select 'm_promotionline' as namatable, (select count(*) from m_promotionline) as jumlah
union all select 'm_qualitytest' as namatable, (select count(*) from m_qualitytest) as jumlah
union all select 'm_promotiondistribution' as namatable, (select count(*) from m_promotiondistribution) as jumlah
union all select 'm_promotiongroup' as namatable, (select count(*) from m_promotiongroup) as jumlah
union all select 'm_productpricevendorbreak' as namatable, (select count(*) from m_productpricevendorbreak) as jumlah
union all select 'm_rmatax' as namatable, (select count(*) from m_rmatax) as jumlah
union all select 'm_qualitytestresult' as namatable, (select count(*) from m_qualitytestresult) as jumlah
union all select 'm_rma' as namatable, (select count(*) from m_rma) as jumlah
union all select 'm_promotionprecondition' as namatable, (select count(*) from m_promotionprecondition) as jumlah
union all select 'm_promotion' as namatable, (select count(*) from m_promotion) as jumlah
union all select 'm_replenish' as namatable, (select count(*) from m_replenish) as jumlah
union all select 'm_requisition' as namatable, (select count(*) from m_requisition) as jumlah
union all select 'm_productoperation' as namatable, (select count(*) from m_productoperation) as jumlah
union all select 'm_shipperlabels' as namatable, (select count(*) from m_shipperlabels) as jumlah
union all select 'm_shippingtransaction' as namatable, (select count(*) from m_shippingtransaction) as jumlah
union all select 'm_transaction' as namatable, (select count(*) from m_transaction) as jumlah
union all select 'm_shipperlabelscfg' as namatable, (select count(*) from m_shipperlabelscfg) as jumlah
union all select 'm_shipperpackaging' as namatable, (select count(*) from m_shipperpackaging) as jumlah
union all select 'm_shipperpackagingcfg' as namatable, (select count(*) from m_shipperpackagingcfg) as jumlah
union all select 'm_shipperpickuptypes' as namatable, (select count(*) from m_shipperpickuptypes) as jumlah
union all select 'm_warehouse_acct' as namatable, (select count(*) from m_warehouse_acct) as jumlah
union all select 'm_shipperpickuptypescfg' as namatable, (select count(*) from m_shipperpickuptypescfg) as jumlah
union all select 'm_shippercfg' as namatable, (select count(*) from m_shippercfg) as jumlah
union all select 'm_shippingprocessor' as namatable, (select count(*) from m_shippingprocessor) as jumlah
union all select 'm_shippingprocessorcfg' as namatable, (select count(*) from m_shippingprocessorcfg) as jumlah
union all select 'pa_achievement' as namatable, (select count(*) from pa_achievement) as jumlah
union all select 'm_transactionallocation' as namatable, (select count(*) from m_transactionallocation) as jumlah
union all select 'm_shippingtransactionline' as namatable, (select count(*) from m_shippingtransactionline) as jumlah
union all select 'm_rmatype' as namatable, (select count(*) from m_rmatype) as jumlah
union all select 'm_shipper' as namatable, (select count(*) from m_shipper) as jumlah
union all select 'm_sernoctlexclude' as namatable, (select count(*) from m_sernoctlexclude) as jumlah
union all select 'm_sernoctl' as namatable, (select count(*) from m_sernoctl) as jumlah
union all select 'pa_reportcolumnset' as namatable, (select count(*) from pa_reportcolumnset) as jumlah
union all select 'pa_dashboardpreference' as namatable, (select count(*) from pa_dashboardpreference) as jumlah
union all select 'pa_dashboardcontent_access' as namatable, (select count(*) from pa_dashboardcontent_access) as jumlah
union all select 'pa_ratio' as namatable, (select count(*) from pa_ratio) as jumlah
union all select 'pa_documentstatus_trl' as namatable, (select count(*) from pa_documentstatus_trl) as jumlah
union all select 'pa_goal' as namatable, (select count(*) from pa_goal) as jumlah
union all select 'pa_dashboardcontent_trl' as namatable, (select count(*) from pa_dashboardcontent_trl) as jumlah
union all select 'pa_goalrestriction' as namatable, (select count(*) from pa_goalrestriction) as jumlah
union all select 'pa_measurecalc' as namatable, (select count(*) from pa_measurecalc) as jumlah
union all select 'pa_report' as namatable, (select count(*) from pa_report) as jumlah
union all select 'pa_ratioelement' as namatable, (select count(*) from pa_ratioelement) as jumlah
union all select 'pa_benchmark' as namatable, (select count(*) from pa_benchmark) as jumlah
union all select 'pa_hierarchy' as namatable, (select count(*) from pa_hierarchy) as jumlah
union all select 'pa_measure' as namatable, (select count(*) from pa_measure) as jumlah
union all select 'pa_reportcolumn' as namatable, (select count(*) from pa_reportcolumn) as jumlah
union all select 'pa_colorschema' as namatable, (select count(*) from pa_colorschema) as jumlah
union all select 'pa_documentstatus' as namatable, (select count(*) from pa_documentstatus) as jumlah
union all select 'pa_dashboardcontent' as namatable, (select count(*) from pa_dashboardcontent) as jumlah
union all select 'pp_cost_collectorma' as namatable, (select count(*) from pp_cost_collectorma) as jumlah
union all select 'pa_sla_criteria' as namatable, (select count(*) from pa_sla_criteria) as jumlah
union all select 'pp_cost_collector' as namatable, (select count(*) from pp_cost_collector) as jumlah
union all select 'pa_sla_measure' as namatable, (select count(*) from pa_sla_measure) as jumlah
union all select 'pp_mrp' as namatable, (select count(*) from pp_mrp) as jumlah
union all select 'pp_order_bomline' as namatable, (select count(*) from pp_order_bomline) as jumlah
union all select 'pp_order' as namatable, (select count(*) from pp_order) as jumlah
union all select 'pa_reportlineset' as namatable, (select count(*) from pa_reportlineset) as jumlah
union all select 'pa_reportline' as namatable, (select count(*) from pa_reportline) as jumlah
union all select 'pa_reportcube' as namatable, (select count(*) from pa_reportcube) as jumlah
union all select 'pa_reportsource' as namatable, (select count(*) from pa_reportsource) as jumlah
union all select 'pa_sla_goal' as namatable, (select count(*) from pa_sla_goal) as jumlah
union all select 'pp_order_bom_trl' as namatable, (select count(*) from pp_order_bom_trl) as jumlah
union all select 'pp_order_bomline_trl' as namatable, (select count(*) from pp_order_bomline_trl) as jumlah
union all select 'pp_order_bom' as namatable, (select count(*) from pp_order_bom) as jumlah
union all select 'pp_order_node_trl' as namatable, (select count(*) from pp_order_node_trl) as jumlah
union all select 'pp_wf_node_asset' as namatable, (select count(*) from pp_wf_node_asset) as jumlah
union all select 'pp_product_bomline_trl' as namatable, (select count(*) from pp_product_bomline_trl) as jumlah
union all select 'pp_order_workflow_trl' as namatable, (select count(*) from pp_order_workflow_trl) as jumlah
union all select 'pp_wf_node_product' as namatable, (select count(*) from pp_wf_node_product) as jumlah
union all select 'pp_order_nodenext' as namatable, (select count(*) from pp_order_nodenext) as jumlah
union all select 'pp_order_workflow' as namatable, (select count(*) from pp_order_workflow) as jumlah
union all select 'pp_product_bom_trl' as namatable, (select count(*) from pp_product_bom_trl) as jumlah
union all select 'pp_order_node' as namatable, (select count(*) from pp_order_node) as jumlah
union all select 'qm_specification' as namatable, (select count(*) from qm_specification) as jumlah
union all select 'pp_order_cost' as namatable, (select count(*) from pp_order_cost) as jumlah
union all select 'pp_order_node_product' as namatable, (select count(*) from pp_order_node_product) as jumlah
union all select 'pp_order_node_asset' as namatable, (select count(*) from pp_order_node_asset) as jumlah
union all select 'pp_product_planning' as namatable, (select count(*) from pp_product_planning) as jumlah
union all select 'r_requestprocessor_route' as namatable, (select count(*) from r_requestprocessor_route) as jumlah
union all select 'r_interestarea' as namatable, (select count(*) from r_interestarea) as jumlah
union all select 'r_contactinterest' as namatable, (select count(*) from r_contactinterest) as jumlah
union all select 'r_issueuser' as namatable, (select count(*) from r_issueuser) as jumlah
union all select 'r_category' as namatable, (select count(*) from r_category) as jumlah
union all select 'r_mailtext' as namatable, (select count(*) from r_mailtext) as jumlah
union all select 'r_issuesource' as namatable, (select count(*) from r_issuesource) as jumlah
union all select 'r_issuestatus' as namatable, (select count(*) from r_issuestatus) as jumlah
union all select 'r_issuesystem' as namatable, (select count(*) from r_issuesystem) as jumlah
union all select 'r_requestprocessorlog' as namatable, (select count(*) from r_requestprocessorlog) as jumlah
union all select 'r_issuerecommendation' as namatable, (select count(*) from r_issuerecommendation) as jumlah
union all select 'r_requesttype' as namatable, (select count(*) from r_requesttype) as jumlah
union all select 'r_request' as namatable, (select count(*) from r_request) as jumlah
union all select 'qm_specificationline' as namatable, (select count(*) from qm_specificationline) as jumlah
union all select 'r_requestprocessor' as namatable, (select count(*) from r_requestprocessor) as jumlah
union all select 'r_categoryupdates' as namatable, (select count(*) from r_categoryupdates) as jumlah
union all select 'r_requestaction' as namatable, (select count(*) from r_requestaction) as jumlah
union all select 'r_mailtext_trl' as namatable, (select count(*) from r_mailtext_trl) as jumlah
union all select 'r_groupupdates' as namatable, (select count(*) from r_groupupdates) as jumlah
union all select 'r_issueproject' as namatable, (select count(*) from r_issueproject) as jumlah
union all select 'r_group' as namatable, (select count(*) from r_group) as jumlah
union all select 'r_status' as namatable, (select count(*) from r_status) as jumlah
union all select 'w_click' as namatable, (select count(*) from w_click) as jumlah
union all select 'r_standardresponse' as namatable, (select count(*) from r_standardresponse) as jumlah
union all select 'r_statuscategory' as namatable, (select count(*) from r_statuscategory) as jumlah
union all select 'r_resolution' as namatable, (select count(*) from r_resolution) as jumlah
union all select 'r_requestupdate' as namatable, (select count(*) from r_requestupdate) as jumlah
union all select 'r_requesttypeupdates' as namatable, (select count(*) from r_requesttypeupdates) as jumlah
union all select 'r_requestupdates' as namatable, (select count(*) from r_requestupdates) as jumlah
union all select 't_bomline' as namatable, (select count(*) from t_bomline) as jumlah
union all select 'w_clickcount' as namatable, (select count(*) from w_clickcount) as jumlah
union all select 't_1099extract' as namatable, (select count(*) from t_1099extract) as jumlah
union all select 's_resourcetype' as namatable, (select count(*) from s_resourcetype) as jumlah
union all select 's_expensetype' as namatable, (select count(*) from s_expensetype) as jumlah
union all select 's_timeexpenseline' as namatable, (select count(*) from s_timeexpenseline) as jumlah
union all select 's_training' as namatable, (select count(*) from s_training) as jumlah
union all select 's_timetype' as namatable, (select count(*) from s_timetype) as jumlah
union all select 's_resourceunavailable' as namatable, (select count(*) from s_resourceunavailable) as jumlah
union all select 's_timeexpense' as namatable, (select count(*) from s_timeexpense) as jumlah
union all select 's_training_class' as namatable, (select count(*) from s_training_class) as jumlah
union all select 's_resource' as namatable, (select count(*) from s_resource) as jumlah
union all select 't_bankregister' as namatable, (select count(*) from t_bankregister) as jumlah
union all select 't_alter_column' as namatable, (select count(*) from t_alter_column) as jumlah
union all select 't_aging' as namatable, (select count(*) from t_aging) as jumlah
union all select 't_bom_indented' as namatable, (select count(*) from t_bom_indented) as jumlah
union all select 't_cashflow' as namatable, (select count(*) from t_cashflow) as jumlah
union all select 't_invoicegl' as namatable, (select count(*) from t_invoicegl) as jumlah
union all select 't_selection' as namatable, (select count(*) from t_selection) as jumlah
union all select 't_replenish' as namatable, (select count(*) from t_replenish) as jumlah
union all select 't_mrp_crp' as namatable, (select count(*) from t_mrp_crp) as jumlah
union all select 't_reconciliation' as namatable, (select count(*) from t_reconciliation) as jumlah
union all select 't_report' as namatable, (select count(*) from t_report) as jumlah
union all select 't_reportstatement' as namatable, (select count(*) from t_reportstatement) as jumlah
union all select 't_spool' as namatable, (select count(*) from t_spool) as jumlah
union all select 't_selection2' as namatable, (select count(*) from t_selection2) as jumlah
union all select 't_selection_infowindow' as namatable, (select count(*) from t_selection_infowindow) as jumlah
union all select 't_transaction' as namatable, (select count(*) from t_transaction) as jumlah
union all select 't_distributionrundetail' as namatable, (select count(*) from t_distributionrundetail) as jumlah
union all select 't_inventoryvalue' as namatable, (select count(*) from t_inventoryvalue) as jumlah
union all select 'w_mailmsg' as namatable, (select count(*) from w_mailmsg) as jumlah
union all select 'u_blacklistcheque' as namatable, (select count(*) from u_blacklistcheque) as jumlah
union all select 'w_countercount' as namatable, (select count(*) from w_countercount) as jumlah
union all select 'w_advertisement' as namatable, (select count(*) from w_advertisement) as jumlah
union all select 'u_web_properties' as namatable, (select count(*) from u_web_properties) as jumlah
union all select 'w_basketline' as namatable, (select count(*) from w_basketline) as jumlah
union all select 'test' as namatable, (select count(*) from test) as jumlah
union all select 'w_basket' as namatable, (select count(*) from w_basket) as jumlah
union all select 'w_counter' as namatable, (select count(*) from w_counter) as jumlah
union all select 'u_webmenu' as namatable, (select count(*) from u_webmenu) as jumlah
union all select 'u_posterminal' as namatable, (select count(*) from u_posterminal) as jumlah
union all select 'w_store_trl' as namatable, (select count(*) from w_store_trl) as jumlah
union all select 'w_mailmsg_trl' as namatable, (select count(*) from w_mailmsg_trl) as jumlah
union all select 'u_rolemenu' as namatable, (select count(*) from u_rolemenu) as jumlah
union all select 'ws_webservice' as namatable, (select count(*) from ws_webservice) as jumlah
union all select 'w_store' as namatable, (select count(*) from w_store) as jumlah
union all select 'ws_webservicefieldoutput' as namatable, (select count(*) from ws_webservicefieldoutput) as jumlah
union all select 'ws_webservicetypeaccess' as namatable, (select count(*) from ws_webservicetypeaccess) as jumlah
union all select 'ws_webservice_para' as namatable, (select count(*) from ws_webservice_para) as jumlah
union all select 'ws_webservicemethod' as namatable, (select count(*) from ws_webservicemethod) as jumlah
union all select 'ws_webservicetype' as namatable, (select count(*) from ws_webservicetype) as jumlah
union all select 'c_activity' as namatable, (select count(*) from c_activity) as jumlah
union all select 't_trialbalance' as namatable, (select count(*) from t_trialbalance) as jumlah
union all select 'ad_table' as namatable, (select count(*) from ad_table) as jumlah
union all select 'ad_taskinstance' as namatable, (select count(*) from ad_taskinstance) as jumlah
union all select 'ad_attachmentnote' as namatable, (select count(*) from ad_attachmentnote) as jumlah
union all select 'ad_accesslog' as namatable, (select count(*) from ad_accesslog) as jumlah
union all select 'ws_webservicefieldinput' as namatable, (select count(*) from ws_webservicefieldinput) as jumlah
union all select 'ad_package_imp_detail' as namatable, (select count(*) from ad_package_imp_detail) as jumlah
union all select 'ad_replication_run' as namatable, (select count(*) from ad_replication_run) as jumlah
union all select 'c_allocationline' as namatable, (select count(*) from c_allocationline) as jumlah
union all select 'dd_networkdistributionline' as namatable, (select count(*) from dd_networkdistributionline) as jumlah
union all select 'pa_benchmarkdata' as namatable, (select count(*) from pa_benchmarkdata) as jumlah
union all select 'r_issueknown' as namatable, (select count(*) from r_issueknown) as jumlah
union all select 'z_document' as namatable, (select count(*) from z_document) as jumlah
union all select 't_moveclient' as namatable, (select count(*) from t_moveclient) as jumlah
union all select 'ad_pinstance' as namatable, (select count(*) from ad_pinstance) as jumlah
union all select 'p_namafile' as namatable, (select count(*) from p_namafile) as jumlah
union all select 'z_csv' as namatable, (select count(*) from z_csv) as jumlah
union all select 'z_csv_result' as namatable, (select count(*) from z_csv_result) as jumlah
union all select 'z_csv_data' as namatable, (select count(*) from z_csv_data) as jumlah
union all select 'z_product' as namatable, (select count(*) from z_product) as jumlah
union all select 'z_afei' as namatable, (select count(*) from z_afei) as jumlah
union all select 'z_aa' as namatable, (select count(*) from z_aa) as jumlah

No comments:

Post a Comment