Count of Table Script

Description
Enterprise warehouse table counts

Please download to get full document.

View again

of 9
All materials on our website are shared by users. If you have any questions about copyright issues, please report us to resolve them. We are always happy to assist you.
Information
Category:

Documents

Publish on:

Views: 314 | Pages: 9

Extension: PDF | Download: 1

Share
Transcript
  Select 'W_ACCT_BUDGET_F' as W_ACCT_BUDGET_F, count(*) from W_ACCT_BUDGET_Funion select 'W_ACCT_BUDGET_FS' as W_ACCT_BUDGET_FS, count(*) from W_ACCT_BUDGET _FSunion select 'W_AP_AGING_INVOICE_A' as W_AP_AGING_INVOICE_A, count(*) from W_AP_ AGING_INVOICE_Aunion select 'W_AP_AGING_SUPPLIER_A' as W_AP_AGING_SUPPLIER_A, count(*) from W_AP_AGING_SUPPLIER_Aunion select 'W_AP_BALANCE_F' as W_AP_BALANCE_F, count(*) from W_AP_BALANCE_Funion select 'W_AP_BALANCE_F_TMP' as W_AP_BALANCE_F_TMP, count(*) from W_AP_BALANCE_F_TMPunion select 'W_AP_FUACT_F_TMP' as W_AP_FUACT_F_TMP, count(*) from W_AP_FUACT_F_ TMPunion select 'W_AP_TERMS_D' as W_AP_TERMS_D, count(*) from W_AP_TERMS_Dunion select 'W_AP_TERMS_DS' as W_AP_TERMS_DS, count(*) from W_AP_TERMS_DSunion select 'W_AP_XACT_F' as W_AP_XACT_F, count(*) from W_AP_XACT_Funion select 'W_AP_XACT_FS' as W_AP_XACT_FS, count(*) from W_AP_XACT_FSunion select 'W_AP_XACT_GRPACCOUNT_A_TMP' as W_AP_XACT_GRPACCOUNT_A_TMP, count(*) from W_AP_XACT_GRPACCOUNT_A_TMPunion select 'W_AP_XACT_GRPACCT_DAY_A' as W_AP_XACT_GRPACCT_DAY_A, count(*) from W_AP_XACT_GRPACCT_DAY_Aunion select 'W_AP_XACT_GRPACCT_FSCLPRD_A' as W_AP_XACT_GRPACCT_FSCLPRD_A, count(*) from W_AP_XACT_GRPACCT_FSCLPRD_Aunion select 'W_AP_XACT_GRPACCT_FSCLQTR_A' as W_AP_XACT_GRPACCT_FSCLQTR_A, count(*) from W_AP_XACT_GRPACCT_FSCLQTR_Aunion select 'W_AP_XACT_GRPACCT_FSCLYR_A' as W_AP_XACT_GRPACCT_FSCLYR_A, count(*) from W_AP_XACT_GRPACCT_FSCLYR_Aunion select 'W_AR_AGING_CUSTOMER_A' as W_AR_AGING_CUSTOMER_A, count(*) from W_AR_AGING_CUSTOMER_Aunion select 'W_AR_AGING_INVOICE_A' as W_AR_AGING_INVOICE_A, count(*) from W_AR_ AGING_INVOICE_Aunion select 'W_AR_BALANCE_F' as W_AR_BALANCE_F, count(*) from W_AR_BALANCE_Funion select 'W_AR_BALANCE_F_TMP' as W_AR_BALANCE_F_TMP, count(*) from W_AR_BALANCE_F_TMPunion select 'W_AR_FUACT_F_TMP' as W_AR_FUACT_F_TMP, count(*) from W_AR_FUACT_F_ TMPunion select 'W_AR_XACT_F' as W_AR_XACT_F, count(*) from W_AR_XACT_Funion select 'W_AR_XACT_FS' as W_AR_XACT_FS, count(*) from W_AR_XACT_FSunion select 'W_AR_XACT_GRPACCOUNT_A_TMP' as W_AR_XACT_GRPACCOUNT_A_TMP, count(*) from W_AR_XACT_GRPACCOUNT_A_TMPunion select 'W_AR_XACT_GRPACCT_DAY_A' as W_AR_XACT_GRPACCT_DAY_A, count(*) from W_AR_XACT_GRPACCT_DAY_Aunion select 'W_AR_XACT_GRPACCT_FSCLPRD_A' as W_AR_XACT_GRPACCT_FSCLPRD_A, count(*) from W_AR_XACT_GRPACCT_FSCLPRD_Aunion select 'W_AR_XACT_GRPACCT_FSCLQTR_A' as W_AR_XACT_GRPACCT_FSCLQTR_A, count(*) from W_AR_XACT_GRPACCT_FSCLQTR_Aunion select 'W_AR_XACT_GRPACCT_FSCLYR_A' as W_AR_XACT_GRPACCT_FSCLYR_A, count(*) from W_AR_XACT_GRPACCT_FSCLYR_Aunion select 'W_BOM_HEADER_D' as W_BOM_HEADER_D, count(*) from W_BOM_HEADER_Dunion select 'W_BOM_HEADER_DS' as W_BOM_HEADER_DS, count(*) from W_BOM_HEADER_DSunion select 'W_BOM_ITEM_F' as W_BOM_ITEM_F, count(*) from W_BOM_ITEM_Funion select 'W_BOM_ITEM_FS' as W_BOM_ITEM_FS, count(*) from W_BOM_ITEM_FSunion select 'W_BUDGET_D' as W_BUDGET_D, count(*) from W_BUDGET_Dunion select 'W_BUSN_LOCATION_D' as W_BUSN_LOCATION_D, count(*) from W_BUSN_LOCATION_Dunion select 'W_BUSN_LOCATION_DS' as W_BUSN_LOCATION_DS, count(*) from W_BUSN_LOCATION_DSunion select 'W_CHNL_TYPE_D' as W_CHNL_TYPE_D, count(*) from W_CHNL_TYPE_Dunion select 'W_CHNL_TYPE_DS' as W_CHNL_TYPE_DS, count(*) from W_CHNL_TYPE_DSunion select 'W_CODE_D' as W_CODE_D, count(*) from W_CODE_Dunion select 'W_COST_CENTER_D' as W_COST_CENTER_D, count(*) from W_COST_CENTER_D  union select 'W_COST_CENTER_DS' as W_COST_CENTER_DS, count(*) from W_COST_CENTER _DSunion select 'W_CURRENCY_TYPE_G' as W_CURRENCY_TYPE_G, count(*) from W_CURRENCY_ TYPE_Gunion select 'W_CUSTOMER_ACCOUNT_D' as W_CUSTOMER_ACCOUNT_D, count(*) from W_CUSTOMER_ACCOUNT_Dunion select 'W_CUSTOMER_ACCOUNT_DS' as W_CUSTOMER_ACCOUNT_DS, count(*) from W_CUSTOMER_ACCOUNT_DSunion select 'W_CUSTOMER_FIN_PROFL_D' as W_CUSTOMER_FIN_PROFL_D, count(*) from W _CUSTOMER_FIN_PROFL_Dunion select 'W_CUSTOMER_FIN_PROFL_DS' as W_CUSTOMER_FIN_PROFL_DS, count(*) from W_CUSTOMER_FIN_PROFL_DSunion select 'W_CUSTOMER_LOC_D' as W_CUSTOMER_LOC_D, count(*) from W_CUSTOMER_LOC_Dunion select 'W_CUSTOMER_LOC_DS' as W_CUSTOMER_LOC_DS, count(*) from W_CUSTOMER_ LOC_DSunion select 'W_CUSTOMER_STATUS_HIST_F' as W_CUSTOMER_STATUS_HIST_F, count(*) from W_CUSTOMER_STATUS_HIST_Funion select 'W_CUSTOMER_STATUS_HIST_F_TMP' as W_CUSTOMER_STATUS_HIST_F_TMP, count(*) from W_CUSTOMER_STATUS_HIST_F_TMPunion select 'W_DAY_D' as W_DAY_D, count(*) from W_DAY_Dunion select 'W_DUAL_G' as W_DUAL_G, count(*) from W_DUAL_Gunion select 'W_EMPLOYEE_D' as W_EMPLOYEE_D, count(*) from W_EMPLOYEE_Dunion select 'W_EMPLOYEE_DS' as W_EMPLOYEE_DS, count(*) from W_EMPLOYEE_DSunion select 'W_EMP_DEMOGRAPHICS_D' as W_EMP_DEMOGRAPHICS_D, count(*) from W_EMP _DEMOGRAPHICS_Dunion select 'W_ENT_PERIOD_D' as W_ENT_PERIOD_D, count(*) from W_ENT_PERIOD_Dunion select 'W_ENT_QTR_D' as W_ENT_QTR_D, count(*) from W_ENT_QTR_Dunion select 'W_ENT_WEEK_D' as W_ENT_WEEK_D, count(*) from W_ENT_WEEK_Dunion select 'W_ENT_YEAR_D' as W_ENT_YEAR_D, count(*) from W_ENT_YEAR_Dunion select 'W_EXCH_RATE_G' as W_EXCH_RATE_G, count(*) from W_EXCH_RATE_Gunion select 'W_EXCH_RATE_GS' as W_EXCH_RATE_GS, count(*) from W_EXCH_RATE_GSunion select 'W_FINANCIAL_RESOURCE_D' as W_FINANCIAL_RESOURCE_D, count(*) from W _FINANCIAL_RESOURCE_Dunion select 'W_FREIGHT_TERMS_D' as W_FREIGHT_TERMS_D, count(*) from W_FREIGHT_TERMS_Dunion select 'W_FREIGHT_TERMS_DS' as W_FREIGHT_TERMS_DS, count(*) from W_FREIGHT _TERMS_DSunion select 'W_GEO_COUNTRY_D' as W_GEO_COUNTRY_D, count(*) from W_GEO_COUNTRY_Dunion select 'W_GLACCT_GRPACCT_TMP' as W_GLACCT_GRPACCT_TMP, count(*) from W_GLACCT_GRPACCT_TMPunion select 'W_GLACCT_SEG_CONFIG_TMP' as W_GLACCT_SEG_CONFIG_TMP, count(*) from W_GLACCT_SEG_CONFIG_TMPunion select 'W_GLOBAL_CURR_G' as W_GLOBAL_CURR_G, count(*) from W_GLOBAL_CURR_Gunion select 'W_GL_ACCOUNT_D' as W_GL_ACCOUNT_D, count(*) from W_GL_ACCOUNT_Dunion select 'W_GL_ACCOUNT_DS' as W_GL_ACCOUNT_DS, count(*) from W_GL_ACCOUNT_DSunion select 'W_GL_BALANCE_A' as W_GL_BALANCE_A, count(*) from W_GL_BALANCE_Aunion select 'W_GL_BALANCE_F' as W_GL_BALANCE_F, count(*) from W_GL_BALANCE_Funion select 'W_GL_BALANCE_FS' as W_GL_BALANCE_FS, count(*) from W_GL_BALANCE_FSunion select 'W_GL_COGS_F' as W_GL_COGS_F, count(*) from W_GL_COGS_Funion select 'W_GL_COGS_FS' as W_GL_COGS_FS, count(*) from W_GL_COGS_FSunion select 'W_GL_COGS_GRPACCOUNT_A_TMP' as W_GL_COGS_GRPACCOUNT_A_TMP, count(*) from W_GL_COGS_GRPACCOUNT_A_TMPunion select 'W_GL_COGS_GRPACCT_DAY_A' as W_GL_COGS_GRPACCT_DAY_A, count(*) from W_GL_COGS_GRPACCT_DAY_Aunion select 'W_GL_COGS_GRPACCT_FSCLPRD_A' as W_GL_COGS_GRPACCT_FSCLPRD_A, count(*) from W_GL_COGS_GRPACCT_FSCLPRD_Aunion select 'W_GL_COGS_GRPACCT_FSCLQTR_A' as W_GL_COGS_GRPACCT_FSCLQTR_A, count(*) from W_GL_COGS_GRPACCT_FSCLQTR_Aunion select 'W_GL_COGS_GRPACCT_FSCLYR_A' as W_GL_COGS_GRPACCT_FSCLYR_A, count(*  ) from W_GL_COGS_GRPACCT_FSCLYR_Aunion select 'W_GL_GROUP_ACCOUNT_D' as W_GL_GROUP_ACCOUNT_D, count(*) from W_GL_ GROUP_ACCOUNT_Dunion select 'W_GL_OTHER_F' as W_GL_OTHER_F, count(*) from W_GL_OTHER_Funion select 'W_GL_OTHER_FS' as W_GL_OTHER_FS, count(*) from W_GL_OTHER_FSunion select 'W_GL_OTHER_GRPACCOUNT_A_TMP' as W_GL_OTHER_GRPACCOUNT_A_TMP, count(*) from W_GL_OTHER_GRPACCOUNT_A_TMPunion select 'W_GL_OTHER_GRPACCT_DAY_A' as W_GL_OTHER_GRPACCT_DAY_A, count(*) from W_GL_OTHER_GRPACCT_DAY_Aunion select 'W_GL_OTHER_GRPACCT_FSCLPRD_A' as W_GL_OTHER_GRPACCT_FSCLPRD_A, count(*) from W_GL_OTHER_GRPACCT_FSCLPRD_Aunion select 'W_GL_OTHER_GRPACCT_FSCLQTR_A' as W_GL_OTHER_GRPACCT_FSCLQTR_A, count(*) from W_GL_OTHER_GRPACCT_FSCLQTR_Aunion select 'W_GL_OTHER_GRPACCT_FSCLYR_A' as W_GL_OTHER_GRPACCT_FSCLYR_A, count(*) from W_GL_OTHER_GRPACCT_FSCLYR_Aunion select 'W_GL_REVN_F' as W_GL_REVN_F, count(*) from W_GL_REVN_Funion select 'W_GL_REVN_FS' as W_GL_REVN_FS, count(*) from W_GL_REVN_FSunion select 'W_GL_REVN_GRPACCOUNT_A_TMP' as W_GL_REVN_GRPACCOUNT_A_TMP, count(*) from W_GL_REVN_GRPACCOUNT_A_TMPunion select 'W_GL_REVN_GRPACCT_DAY_A' as W_GL_REVN_GRPACCT_DAY_A, count(*) from W_GL_REVN_GRPACCT_DAY_Aunion select 'W_GL_REVN_GRPACCT_FSCLPRD_A' as W_GL_REVN_GRPACCT_FSCLPRD_A, count(*) from W_GL_REVN_GRPACCT_FSCLPRD_Aunion select 'W_GL_REVN_GRPACCT_FSCLQTR_A' as W_GL_REVN_GRPACCT_FSCLQTR_A, count(*) from W_GL_REVN_GRPACCT_FSCLQTR_Aunion select 'W_GL_REVN_GRPACCT_FSCLYR_A' as W_GL_REVN_GRPACCT_FSCLYR_A, count(*) from W_GL_REVN_GRPACCT_FSCLYR_Aunion select 'W_GROUP_ACCT_FIN_STMT_D_TMP' as W_GROUP_ACCT_FIN_STMT_D_TMP, count(*) from W_GROUP_ACCT_FIN_STMT_D_TMPunion select 'W_HIERARCHY_D' as W_HIERARCHY_D, count(*) from W_HIERARCHY_Dunion select 'W_HOUR_OF_DAY_D' as W_HOUR_OF_DAY_D, count(*) from W_HOUR_OF_DAY_Dunion select 'W_INT_ORG_D' as W_INT_ORG_D, count(*) from W_INT_ORG_Dunion select 'W_INT_ORG_DH' as W_INT_ORG_DH, count(*) from W_INT_ORG_DHunion select 'W_INT_ORG_DHS' as W_INT_ORG_DHS, count(*) from W_INT_ORG_DHSunion select 'W_INT_ORG_DS' as W_INT_ORG_DS, count(*) from W_INT_ORG_DSunion select 'W_INVENTORY_DAILY_BAL_F' as W_INVENTORY_DAILY_BAL_F, count(*) from W_INVENTORY_DAILY_BAL_Funion select 'W_INVENTORY_DAILY_BAL_FS' as W_INVENTORY_DAILY_BAL_FS, count(*) from W_INVENTORY_DAILY_BAL_FSunion select 'W_INVENTORY_MONTHLY_BAL_F' as W_INVENTORY_MONTHLY_BAL_F, count(*) from W_INVENTORY_MONTHLY_BAL_Funion select 'W_INVENTORY_PRODUCT_D' as W_INVENTORY_PRODUCT_D, count(*) from W_INVENTORY_PRODUCT_Dunion select 'W_INVENTORY_PRODUCT_DS' as W_INVENTORY_PRODUCT_DS, count(*) from W _INVENTORY_PRODUCT_DSunion select 'W_JDEE1_DECIMALSHIFT_G' as W_JDEE1_DECIMALSHIFT_G, count(*) from W _JDEE1_DECIMALSHIFT_Gunion select 'W_JDE_FIN_SUB_D_TMP' as W_JDE_FIN_SUB_D_TMP, count(*) from W_JDE_FIN_SUB_D_TMPunion select 'W_JDE_GL_ACC_AID_SBLT_TMP' as W_JDE_GL_ACC_AID_SBLT_TMP, count(*) from W_JDE_GL_ACC_AID_SBLT_TMPunion select 'W_JDE_GL_ACC_CAT_CODES_TMP' as W_JDE_GL_ACC_CAT_CODES_TMP, count(*) from W_JDE_GL_ACC_CAT_CODES_TMPunion select 'W_JDE_GL_JOURNALS_F_TMP' as W_JDE_GL_JOURNALS_F_TMP, count(*) from W_JDE_GL_JOURNALS_F_TMPunion select 'W_JDE_GROUP_ACCOUNT_NUM_D_TMP' as W_JDE_GROUP_ACCOUNT_NUM_D_TMP, count(*) from W_JDE_GROUP_ACCOUNT_NUM_D_TMPunion select 'W_JDE_INT_ORG_TOP_HIER_TMP' as W_JDE_INT_ORG_TOP_HIER_TMP, count(*) from W_JDE_INT_ORG_TOP_HIER_TMPunion select 'W_JDE_SALES_ORDER_EXTRACT_TMP' as W_JDE_SALES_ORDER_EXTRACT_TMP, c  ount(*) from W_JDE_SALES_ORDER_EXTRACT_TMPunion select 'W_JDE_UDC_CATEGORY_MAP_TMP' as W_JDE_UDC_CATEGORY_MAP_TMP, count(*) from W_JDE_UDC_CATEGORY_MAP_TMPunion select 'W_LEDGER_D' as W_LEDGER_D, count(*) from W_LEDGER_Dunion select 'W_LEDGER_DS' as W_LEDGER_DS, count(*) from W_LEDGER_DSunion select 'W_LST_OF_VAL_G' as W_LST_OF_VAL_G, count(*) from W_LST_OF_VAL_Gunion select 'W_MCAL_CAL_D' as W_MCAL_CAL_D, count(*) from W_MCAL_CAL_Dunion select 'W_MCAL_CONFIG_G' as W_MCAL_CONFIG_G, count(*) from W_MCAL_CONFIG_Gunion select 'W_MCAL_CONTEXT_G' as W_MCAL_CONTEXT_G, count(*) from W_MCAL_CONTEXT_Gunion select 'W_MCAL_DAY_D' as W_MCAL_DAY_D, count(*) from W_MCAL_DAY_Dunion select 'W_MCAL_PERIOD_D' as W_MCAL_PERIOD_D, count(*) from W_MCAL_PERIOD_Dunion select 'W_MCAL_PERIOD_DS' as W_MCAL_PERIOD_DS, count(*) from W_MCAL_PERIOD _DSunion select 'W_MCAL_QTR_D' as W_MCAL_QTR_D, count(*) from W_MCAL_QTR_Dunion select 'W_MCAL_WEEK_D' as W_MCAL_WEEK_D, count(*) from W_MCAL_WEEK_Dunion select 'W_MCAL_YEAR_D' as W_MCAL_YEAR_D, count(*) from W_MCAL_YEAR_Dunion select 'W_MONTH_D' as W_MONTH_D, count(*) from W_MONTH_Dunion select 'W_MVMNT_TYPE_D' as W_MVMNT_TYPE_D, count(*) from W_MVMNT_TYPE_Dunion select 'W_MVMNT_TYPE_DS' as W_MVMNT_TYPE_DS, count(*) from W_MVMNT_TYPE_DSunion select 'W_PARAM_G' as W_PARAM_G, count(*) from W_PARAM_Gunion select 'W_PARTY_D' as W_PARTY_D, count(*) from W_PARTY_Dunion select 'W_PARTY_ORG_D' as W_PARTY_ORG_D, count(*) from W_PARTY_ORG_Dunion select 'W_PARTY_ORG_DS' as W_PARTY_ORG_DS, count(*) from W_PARTY_ORG_DSunion select 'W_PARTY_PER_D' as W_PARTY_PER_D, count(*) from W_PARTY_PER_Dunion select 'W_PAYMENT_METHOD_D' as W_PAYMENT_METHOD_D, count(*) from W_PAYMENT _METHOD_Dunion select 'W_PAYMENT_METHOD_DS' as W_PAYMENT_METHOD_DS, count(*) from W_PAYMENT_METHOD_DSunion select 'W_PAYMENT_TERMS_D' as W_PAYMENT_TERMS_D, count(*) from W_PAYMENT_TERMS_Dunion select 'W_PAYMENT_TERMS_DS' as W_PAYMENT_TERMS_DS, count(*) from W_PAYMENT _TERMS_DSunion select 'W_PRODUCT_D' as W_PRODUCT_D, count(*) from W_PRODUCT_Dunion select 'W_PRODUCT_DS' as W_PRODUCT_DS, count(*) from W_PRODUCT_DSunion select 'W_PRODUCT_XACT_A' as W_PRODUCT_XACT_A, count(*) from W_PRODUCT_XACT_Aunion select 'W_PRODUCT_XACT_F' as W_PRODUCT_XACT_F, count(*) from W_PRODUCT_XACT_Funion select 'W_PRODUCT_XACT_FS' as W_PRODUCT_XACT_FS, count(*) from W_PRODUCT_XACT_FSunion select 'W_PROD_CAT_DH' as W_PROD_CAT_DH, count(*) from W_PROD_CAT_DHunion select 'W_PROFIT_CENTER_D' as W_PROFIT_CENTER_D, count(*) from W_PROFIT_CENTER_Dunion select 'W_PROFIT_CENTER_DS' as W_PROFIT_CENTER_DS, count(*) from W_PROFIT_ CENTER_DSunion select 'W_PROJECT_D' as W_PROJECT_D, count(*) from W_PROJECT_Dunion select 'W_PROJECT_DH' as W_PROJECT_DH, count(*) from W_PROJECT_DHunion select 'W_PROJ_CLASSIFICATION_D' as W_PROJ_CLASSIFICATION_D, count(*) from W_PROJ_CLASSIFICATION_Dunion select 'W_QTR_D' as W_QTR_D, count(*) from W_QTR_Dunion select 'W_SALES_BACKLOG_HISTORY_F' as W_SALES_BACKLOG_HISTORY_F, count(*) from W_SALES_BACKLOG_HISTORY_Funion select 'W_SALES_BACKLOG_LINE_F' as W_SALES_BACKLOG_LINE_F, count(*) from W _SALES_BACKLOG_LINE_Funion select 'W_SALES_BOOKING_LINE_F' as W_SALES_BOOKING_LINE_F, count(*) from W _SALES_BOOKING_LINE_Funion select 'W_SALES_CYCLE_LINE_F' as W_SALES_CYCLE_LINE_F, count(*) from W_SALES_CYCLE_LINE_Funion select 'W_SALES_CYCLE_LINE_F_TMP' as W_SALES_CYCLE_LINE_F_TMP, count(*) fr
Related Search
We Need Your Support
Thank you for visiting our website and your interest in our free products and services. We are nonprofit website to share and download documents. To the running of this website, we need your help to support us.

Thanks to everyone for your continued support.

No, Thanks