KB227097: How to Remove an Option From the "Send" Drop Down List for an E-mail Alert Subscription Using MicroStrategy Web SDK

• Strategy

When creating an E-mail Alert Subscription, users have the option to select different ways on including the data in the e-mail by changing the selection in the "Send" drop down list. This technical note provides steps to remove options for E-mail Alert Subscriptions

When creating an E-mail Alert Subscription, users have the option to select different ways on including the data in the e-mail by changing the selection in the "Send" drop down list. This technical note provides steps to remove options for E-mail Alert Subscriptions.

Before Customization:

After Customization:

Using the Web Customization Editor:

Launch the Web Customization Editor
Navigate to Application Settings > Strategy Web Configuration > Styles
Right-mouse click Styles and select Create Transform to launch the Transfrom Creation Wizard.
Click .. next to the Source folder text field to select the src folder under the Strategy Project and click OK.
Select AlertEditorTransform as the superclass of your custom transform.
Provide the rest of the necessary information and click Next
Select voidRenderEditorContents(MarkupOutput out) and click Next.

Add the following code to the renderEditorContents method:


   public void renderEditorContents (MarkupOutput out){
    	MarkupOutput newOutput = WebBeanFactory.getInstance().newMarkupOutput();
    	super.renderEditorContents(newOutput);
    	String newOutputString = newOutput.getCopyAsString();
        //if this option is not selected by default
    	newOutputString = newOutputString.replace("<option value=\"1,1,0\">Link to history list in email</option>", "");
        //if this option is selected by default
        //newOutputString = newOutputString.replace("<option selected=\"1\" value=\"1,1,0\">Link to history list in email</option>", "");
    	System.out.println("editor");
    	out.append(newOutputString);
    }

Save the changes
Navigate to Strategy Web Configuration > Styles
If you want to remove the option when you right click a metric in a report and create the Alert Subscription, double click AlertsReportEditorStyle.
Click Change button for Transform and change it to the new transform created in the previous steps.
Save the changes
If you want to remove the option from an existing Alert Subscription by going to the My Subscriptions page and clicking the Edit button, double click AlertsSubscriptionEditStyle
Repeat steps 12 and 13.
Restart your Web Server

The value for the other options are shown in this table:

select a11.MONTH_ID MONTH_ID, sum(a11.TOT_COST) WJXBFS1 from MNTH_CATEGORY_SLS a11 where a11.MONTH_ID in (200001, 200002, 200003) group by a11.MONTH_ID into temp MD000 with no log select a11.MONTH_ID MONTH_ID, sum(a11.UNITS_RECEIVED) WJXBFS1 from INVENTORY_ORDERS a11 where a11.MONTH_ID in (200001, 200002) group by a11.MONTH_ID into temp MD001 with no log select pa2.MONTH_ID MONTH_ID, a11.MONTH_DESC MONTH_DESC, (NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) WJXBFS1 from MD001 pa2, outer MD000 pa1, LU_MONTH a11 where pa2.MONTH_ID = pa1.MONTH_ID and pa2.MONTH_ID = a11.MONTH_ID and ((NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) > 600000.0) M1Running product (M1)aababcabcdabcdeabcdeLanguageDecimalDigit grouping e.g. 1 Million in English = 1,000,000Short dateAfrikaans.,yyyy/MM/ddCatalan,.dd/MM/yyyyDanish,.dd-MM-yyyyDutch,.d-M-yyyyEnglish (UK).,dd/MM/yyyyEnglish (US).,M/d/yyyyFinnish,spaced.M.yyyyFrench (France),spacedd/MM/yyyyFrench (Canada),spaceyyyy-MM-ddGerman,.dd.MM.yyyyItalian,.dd/MM/yyyyNorwegian,spacedd.MM.yyyyPortuguese (Portugal),.dd-MM-yyyyPortuguese (Brazil),.d/M/yyyySpanish (International),.dd/MM/yyyySpanish (Mexico).,dd/MM/yyyySwedish,spaceyyyy-MM-ddLanguageDecimalDigit grouping e.g. 1 Million in English = 1,000,000Short dateArabic.,dd/MM/yyyyBelarusian,spacedd.MM.yyyyChinese.,yyyy-M-dChinese (Hong Kong).,d/M/yyyyCroatian,.d.M.yyyyCzech,spaced.M.yyyyEstonian,spacedd.MM.yyyyGeorgian,spacedd.MM.yyyyGreek,.d/M/yyyyHebrew.,dd/MM/yyyyHindi.,dd-MM-yyyyHungarian,spaceyyyy. MM. dd.Indonesian,.dd/MM/yyyyJapanese.,yyyy/MM/ddKorean.,yyyy-MM-ddLatvian,spaceyyyy.MM.dd.Lithuanian,.yyyy.MM.ddMacedonian,.dd.MM.yyyyPolish,spaceyyyy-MM-ddRomanian,.dd.MM.yyyyRussian,spacedd.MM.yyyySerbian,.d.M.yyyySlovak,spaced. M. yyyySlovenian,.d.M.yyyyThai.,d/M/yyyyTurkish,.dd.MM.yyyyUkrainian,spacedd.MM.yyyyUrdu.,dd/MM/yyyyVietnamese,.dd/MM/yyyyImpala DatatypeMSTR DatatypeCHARACTERCharNUMERICNumericDECIMALDecimalINTEGERIntegerSMALLINTIntegerFLOATFloatREALFloatDOUBLEDoubleDATEDateTIMETimeTIMESTAMPTimeStampVARCHARVarCharBIGINTInt64TINYINTIntegerKeysDescriptionAlt-0153™Alt-0174®Alt-0169©Alt-0137‰Alt-251√Alt-236∞Alt-243≤Alt-242≥Alt-13♪Alt-14♫Alt-23↨Alt-24↑Alt-25↓Alt-26→Alt-27←Data in email0,0,1Data in email and to history list0,1,1Data and link to history list in email1,1,1Link to history list in email1,1,0	select a11.MONTH_ID MONTH_ID, sum(a11.TOT_COST) WJXBFS1 from MNTH_CATEGORY_SLS a11 where a11.MONTH_ID in (200001, 200002, 200003) group by a11.MONTH_ID into temp MD000 with no log select a11.MONTH_ID MONTH_ID, sum(a11.UNITS_RECEIVED) WJXBFS1 from INVENTORY_ORDERS a11 where a11.MONTH_ID in (200001, 200002) group by a11.MONTH_ID into temp MD001 with no log select pa2.MONTH_ID MONTH_ID, a11.MONTH_DESC MONTH_DESC, (NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) WJXBFS1 from MD001 pa2, outer MD000 pa1, LU_MONTH a11 where pa2.MONTH_ID = pa1.MONTH_ID and pa2.MONTH_ID = a11.MONTH_ID and ((NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) > 600000.0) M1Running product (M1)aababcabcdabcdeabcdeLanguageDecimalDigit grouping e.g. 1 Million in English = 1,000,000Short dateAfrikaans.,yyyy/MM/ddCatalan,.dd/MM/yyyyDanish,.dd-MM-yyyyDutch,.d-M-yyyyEnglish (UK).,dd/MM/yyyyEnglish (US).,M/d/yyyyFinnish,spaced.M.yyyyFrench (France),spacedd/MM/yyyyFrench (Canada),spaceyyyy-MM-ddGerman,.dd.MM.yyyyItalian,.dd/MM/yyyyNorwegian,spacedd.MM.yyyyPortuguese (Portugal),.dd-MM-yyyyPortuguese (Brazil),.d/M/yyyySpanish (International),.dd/MM/yyyySpanish (Mexico).,dd/MM/yyyySwedish,spaceyyyy-MM-ddLanguageDecimalDigit grouping e.g. 1 Million in English = 1,000,000Short dateArabic.,dd/MM/yyyyBelarusian,spacedd.MM.yyyyChinese.,yyyy-M-dChinese (Hong Kong).,d/M/yyyyCroatian,.d.M.yyyyCzech,spaced.M.yyyyEstonian,spacedd.MM.yyyyGeorgian,spacedd.MM.yyyyGreek,.d/M/yyyyHebrew.,dd/MM/yyyyHindi.,dd-MM-yyyyHungarian,spaceyyyy. MM. dd.Indonesian,.dd/MM/yyyyJapanese.,yyyy/MM/ddKorean.,yyyy-MM-ddLatvian,spaceyyyy.MM.dd.Lithuanian,.yyyy.MM.ddMacedonian,.dd.MM.yyyyPolish,spaceyyyy-MM-ddRomanian,.dd.MM.yyyyRussian,spacedd.MM.yyyySerbian,.d.M.yyyySlovak,spaced. M. yyyySlovenian,.d.M.yyyyThai.,d/M/yyyyTurkish,.dd.MM.yyyyUkrainian,spacedd.MM.yyyyUrdu.,dd/MM/yyyyVietnamese,.dd/MM/yyyyImpala DatatypeMSTR DatatypeCHARACTERCharNUMERICNumericDECIMALDecimalINTEGERIntegerSMALLINTIntegerFLOATFloatREALFloatDOUBLEDoubleDATEDateTIMETimeTIMESTAMPTimeStampVARCHARVarCharBIGINTInt64TINYINTIntegerKeysDescriptionAlt-0153™Alt-0174®Alt-0169©Alt-0137‰Alt-251√Alt-236∞Alt-243≤Alt-242≥Alt-13♪Alt-14♫Alt-23↨Alt-24↑Alt-25↓Alt-26→Alt-27←Data in email0,0,1Data in email and to history list0,1,1Data and link to history list in email1,1,1Link to history list in email1,1,0
select a11.MONTH_ID MONTH_ID, sum(a11.TOT_COST) WJXBFS1 from MNTH_CATEGORY_SLS a11 where a11.MONTH_ID in (200001, 200002, 200003) group by a11.MONTH_ID into temp MD000 with no log select a11.MONTH_ID MONTH_ID, sum(a11.UNITS_RECEIVED) WJXBFS1 from INVENTORY_ORDERS a11 where a11.MONTH_ID in (200001, 200002) group by a11.MONTH_ID into temp MD001 with no log select pa2.MONTH_ID MONTH_ID, a11.MONTH_DESC MONTH_DESC, (NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) WJXBFS1 from MD001 pa2, outer MD000 pa1, LU_MONTH a11 where pa2.MONTH_ID = pa1.MONTH_ID and pa2.MONTH_ID = a11.MONTH_ID and ((NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) > 600000.0) M1Running product (M1)aababcabcdabcdeabcdeLanguageDecimalDigit grouping e.g. 1 Million in English = 1,000,000Short dateAfrikaans.,yyyy/MM/ddCatalan,.dd/MM/yyyyDanish,.dd-MM-yyyyDutch,.d-M-yyyyEnglish (UK).,dd/MM/yyyyEnglish (US).,M/d/yyyyFinnish,spaced.M.yyyyFrench (France),spacedd/MM/yyyyFrench (Canada),spaceyyyy-MM-ddGerman,.dd.MM.yyyyItalian,.dd/MM/yyyyNorwegian,spacedd.MM.yyyyPortuguese (Portugal),.dd-MM-yyyyPortuguese (Brazil),.d/M/yyyySpanish (International),.dd/MM/yyyySpanish (Mexico).,dd/MM/yyyySwedish,spaceyyyy-MM-ddLanguageDecimalDigit grouping e.g. 1 Million in English = 1,000,000Short dateArabic.,dd/MM/yyyyBelarusian,spacedd.MM.yyyyChinese.,yyyy-M-dChinese (Hong Kong).,d/M/yyyyCroatian,.d.M.yyyyCzech,spaced.M.yyyyEstonian,spacedd.MM.yyyyGeorgian,spacedd.MM.yyyyGreek,.d/M/yyyyHebrew.,dd/MM/yyyyHindi.,dd-MM-yyyyHungarian,spaceyyyy. MM. dd.Indonesian,.dd/MM/yyyyJapanese.,yyyy/MM/ddKorean.,yyyy-MM-ddLatvian,spaceyyyy.MM.dd.Lithuanian,.yyyy.MM.ddMacedonian,.dd.MM.yyyyPolish,spaceyyyy-MM-ddRomanian,.dd.MM.yyyyRussian,spacedd.MM.yyyySerbian,.d.M.yyyySlovak,spaced. M. yyyySlovenian,.d.M.yyyyThai.,d/M/yyyyTurkish,.dd.MM.yyyyUkrainian,spacedd.MM.yyyyUrdu.,dd/MM/yyyyVietnamese,.dd/MM/yyyyImpala DatatypeMSTR DatatypeCHARACTERCharNUMERICNumericDECIMALDecimalINTEGERIntegerSMALLINTIntegerFLOATFloatREALFloatDOUBLEDoubleDATEDateTIMETimeTIMESTAMPTimeStampVARCHARVarCharBIGINTInt64TINYINTIntegerKeysDescriptionAlt-0153™Alt-0174®Alt-0169©Alt-0137‰Alt-251√Alt-236∞Alt-243≤Alt-242≥Alt-13♪Alt-14♫Alt-23↨Alt-24↑Alt-25↓Alt-26→Alt-27←Data in email0,0,1Data in email and to history list0,1,1Data and link to history list in email1,1,1Link to history list in email1,1,0	select a11.MONTH_ID MONTH_ID, sum(a11.TOT_COST) WJXBFS1 from MNTH_CATEGORY_SLS a11 where a11.MONTH_ID in (200001, 200002, 200003) group by a11.MONTH_ID into temp MD000 with no log select a11.MONTH_ID MONTH_ID, sum(a11.UNITS_RECEIVED) WJXBFS1 from INVENTORY_ORDERS a11 where a11.MONTH_ID in (200001, 200002) group by a11.MONTH_ID into temp MD001 with no log select pa2.MONTH_ID MONTH_ID, a11.MONTH_DESC MONTH_DESC, (NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) WJXBFS1 from MD001 pa2, outer MD000 pa1, LU_MONTH a11 where pa2.MONTH_ID = pa1.MONTH_ID and pa2.MONTH_ID = a11.MONTH_ID and ((NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) > 600000.0) M1Running product (M1)aababcabcdabcdeabcdeLanguageDecimalDigit grouping e.g. 1 Million in English = 1,000,000Short dateAfrikaans.,yyyy/MM/ddCatalan,.dd/MM/yyyyDanish,.dd-MM-yyyyDutch,.d-M-yyyyEnglish (UK).,dd/MM/yyyyEnglish (US).,M/d/yyyyFinnish,spaced.M.yyyyFrench (France),spacedd/MM/yyyyFrench (Canada),spaceyyyy-MM-ddGerman,.dd.MM.yyyyItalian,.dd/MM/yyyyNorwegian,spacedd.MM.yyyyPortuguese (Portugal),.dd-MM-yyyyPortuguese (Brazil),.d/M/yyyySpanish (International),.dd/MM/yyyySpanish (Mexico).,dd/MM/yyyySwedish,spaceyyyy-MM-ddLanguageDecimalDigit grouping e.g. 1 Million in English = 1,000,000Short dateArabic.,dd/MM/yyyyBelarusian,spacedd.MM.yyyyChinese.,yyyy-M-dChinese (Hong Kong).,d/M/yyyyCroatian,.d.M.yyyyCzech,spaced.M.yyyyEstonian,spacedd.MM.yyyyGeorgian,spacedd.MM.yyyyGreek,.d/M/yyyyHebrew.,dd/MM/yyyyHindi.,dd-MM-yyyyHungarian,spaceyyyy. MM. dd.Indonesian,.dd/MM/yyyyJapanese.,yyyy/MM/ddKorean.,yyyy-MM-ddLatvian,spaceyyyy.MM.dd.Lithuanian,.yyyy.MM.ddMacedonian,.dd.MM.yyyyPolish,spaceyyyy-MM-ddRomanian,.dd.MM.yyyyRussian,spacedd.MM.yyyySerbian,.d.M.yyyySlovak,spaced. M. yyyySlovenian,.d.M.yyyyThai.,d/M/yyyyTurkish,.dd.MM.yyyyUkrainian,spacedd.MM.yyyyUrdu.,dd/MM/yyyyVietnamese,.dd/MM/yyyyImpala DatatypeMSTR DatatypeCHARACTERCharNUMERICNumericDECIMALDecimalINTEGERIntegerSMALLINTIntegerFLOATFloatREALFloatDOUBLEDoubleDATEDateTIMETimeTIMESTAMPTimeStampVARCHARVarCharBIGINTInt64TINYINTIntegerKeysDescriptionAlt-0153™Alt-0174®Alt-0169©Alt-0137‰Alt-251√Alt-236∞Alt-243≤Alt-242≥Alt-13♪Alt-14♫Alt-23↨Alt-24↑Alt-25↓Alt-26→Alt-27←Data in email0,0,1Data in email and to history list0,1,1Data and link to history list in email1,1,1Link to history list in email1,1,0
select a11.MONTH_ID MONTH_ID, sum(a11.TOT_COST) WJXBFS1 from MNTH_CATEGORY_SLS a11 where a11.MONTH_ID in (200001, 200002, 200003) group by a11.MONTH_ID into temp MD000 with no log select a11.MONTH_ID MONTH_ID, sum(a11.UNITS_RECEIVED) WJXBFS1 from INVENTORY_ORDERS a11 where a11.MONTH_ID in (200001, 200002) group by a11.MONTH_ID into temp MD001 with no log select pa2.MONTH_ID MONTH_ID, a11.MONTH_DESC MONTH_DESC, (NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) WJXBFS1 from MD001 pa2, outer MD000 pa1, LU_MONTH a11 where pa2.MONTH_ID = pa1.MONTH_ID and pa2.MONTH_ID = a11.MONTH_ID and ((NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) > 600000.0) M1Running product (M1)aababcabcdabcdeabcdeLanguageDecimalDigit grouping e.g. 1 Million in English = 1,000,000Short dateAfrikaans.,yyyy/MM/ddCatalan,.dd/MM/yyyyDanish,.dd-MM-yyyyDutch,.d-M-yyyyEnglish (UK).,dd/MM/yyyyEnglish (US).,M/d/yyyyFinnish,spaced.M.yyyyFrench (France),spacedd/MM/yyyyFrench (Canada),spaceyyyy-MM-ddGerman,.dd.MM.yyyyItalian,.dd/MM/yyyyNorwegian,spacedd.MM.yyyyPortuguese (Portugal),.dd-MM-yyyyPortuguese (Brazil),.d/M/yyyySpanish (International),.dd/MM/yyyySpanish (Mexico).,dd/MM/yyyySwedish,spaceyyyy-MM-ddLanguageDecimalDigit grouping e.g. 1 Million in English = 1,000,000Short dateArabic.,dd/MM/yyyyBelarusian,spacedd.MM.yyyyChinese.,yyyy-M-dChinese (Hong Kong).,d/M/yyyyCroatian,.d.M.yyyyCzech,spaced.M.yyyyEstonian,spacedd.MM.yyyyGeorgian,spacedd.MM.yyyyGreek,.d/M/yyyyHebrew.,dd/MM/yyyyHindi.,dd-MM-yyyyHungarian,spaceyyyy. MM. dd.Indonesian,.dd/MM/yyyyJapanese.,yyyy/MM/ddKorean.,yyyy-MM-ddLatvian,spaceyyyy.MM.dd.Lithuanian,.yyyy.MM.ddMacedonian,.dd.MM.yyyyPolish,spaceyyyy-MM-ddRomanian,.dd.MM.yyyyRussian,spacedd.MM.yyyySerbian,.d.M.yyyySlovak,spaced. M. yyyySlovenian,.d.M.yyyyThai.,d/M/yyyyTurkish,.dd.MM.yyyyUkrainian,spacedd.MM.yyyyUrdu.,dd/MM/yyyyVietnamese,.dd/MM/yyyyImpala DatatypeMSTR DatatypeCHARACTERCharNUMERICNumericDECIMALDecimalINTEGERIntegerSMALLINTIntegerFLOATFloatREALFloatDOUBLEDoubleDATEDateTIMETimeTIMESTAMPTimeStampVARCHARVarCharBIGINTInt64TINYINTIntegerKeysDescriptionAlt-0153™Alt-0174®Alt-0169©Alt-0137‰Alt-251√Alt-236∞Alt-243≤Alt-242≥Alt-13♪Alt-14♫Alt-23↨Alt-24↑Alt-25↓Alt-26→Alt-27←Data in email0,0,1Data in email and to history list0,1,1Data and link to history list in email1,1,1Link to history list in email1,1,0	select a11.MONTH_ID MONTH_ID, sum(a11.TOT_COST) WJXBFS1 from MNTH_CATEGORY_SLS a11 where a11.MONTH_ID in (200001, 200002, 200003) group by a11.MONTH_ID into temp MD000 with no log select a11.MONTH_ID MONTH_ID, sum(a11.UNITS_RECEIVED) WJXBFS1 from INVENTORY_ORDERS a11 where a11.MONTH_ID in (200001, 200002) group by a11.MONTH_ID into temp MD001 with no log select pa2.MONTH_ID MONTH_ID, a11.MONTH_DESC MONTH_DESC, (NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) WJXBFS1 from MD001 pa2, outer MD000 pa1, LU_MONTH a11 where pa2.MONTH_ID = pa1.MONTH_ID and pa2.MONTH_ID = a11.MONTH_ID and ((NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) > 600000.0) M1Running product (M1)aababcabcdabcdeabcdeLanguageDecimalDigit grouping e.g. 1 Million in English = 1,000,000Short dateAfrikaans.,yyyy/MM/ddCatalan,.dd/MM/yyyyDanish,.dd-MM-yyyyDutch,.d-M-yyyyEnglish (UK).,dd/MM/yyyyEnglish (US).,M/d/yyyyFinnish,spaced.M.yyyyFrench (France),spacedd/MM/yyyyFrench (Canada),spaceyyyy-MM-ddGerman,.dd.MM.yyyyItalian,.dd/MM/yyyyNorwegian,spacedd.MM.yyyyPortuguese (Portugal),.dd-MM-yyyyPortuguese (Brazil),.d/M/yyyySpanish (International),.dd/MM/yyyySpanish (Mexico).,dd/MM/yyyySwedish,spaceyyyy-MM-ddLanguageDecimalDigit grouping e.g. 1 Million in English = 1,000,000Short dateArabic.,dd/MM/yyyyBelarusian,spacedd.MM.yyyyChinese.,yyyy-M-dChinese (Hong Kong).,d/M/yyyyCroatian,.d.M.yyyyCzech,spaced.M.yyyyEstonian,spacedd.MM.yyyyGeorgian,spacedd.MM.yyyyGreek,.d/M/yyyyHebrew.,dd/MM/yyyyHindi.,dd-MM-yyyyHungarian,spaceyyyy. MM. dd.Indonesian,.dd/MM/yyyyJapanese.,yyyy/MM/ddKorean.,yyyy-MM-ddLatvian,spaceyyyy.MM.dd.Lithuanian,.yyyy.MM.ddMacedonian,.dd.MM.yyyyPolish,spaceyyyy-MM-ddRomanian,.dd.MM.yyyyRussian,spacedd.MM.yyyySerbian,.d.M.yyyySlovak,spaced. M. yyyySlovenian,.d.M.yyyyThai.,d/M/yyyyTurkish,.dd.MM.yyyyUkrainian,spacedd.MM.yyyyUrdu.,dd/MM/yyyyVietnamese,.dd/MM/yyyyImpala DatatypeMSTR DatatypeCHARACTERCharNUMERICNumericDECIMALDecimalINTEGERIntegerSMALLINTIntegerFLOATFloatREALFloatDOUBLEDoubleDATEDateTIMETimeTIMESTAMPTimeStampVARCHARVarCharBIGINTInt64TINYINTIntegerKeysDescriptionAlt-0153™Alt-0174®Alt-0169©Alt-0137‰Alt-251√Alt-236∞Alt-243≤Alt-242≥Alt-13♪Alt-14♫Alt-23↨Alt-24↑Alt-25↓Alt-26→Alt-27←Data in email0,0,1Data in email and to history list0,1,1Data and link to history list in email1,1,1Link to history list in email1,1,0
select a11.MONTH_ID MONTH_ID, sum(a11.TOT_COST) WJXBFS1 from MNTH_CATEGORY_SLS a11 where a11.MONTH_ID in (200001, 200002, 200003) group by a11.MONTH_ID into temp MD000 with no log select a11.MONTH_ID MONTH_ID, sum(a11.UNITS_RECEIVED) WJXBFS1 from INVENTORY_ORDERS a11 where a11.MONTH_ID in (200001, 200002) group by a11.MONTH_ID into temp MD001 with no log select pa2.MONTH_ID MONTH_ID, a11.MONTH_DESC MONTH_DESC, (NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) WJXBFS1 from MD001 pa2, outer MD000 pa1, LU_MONTH a11 where pa2.MONTH_ID = pa1.MONTH_ID and pa2.MONTH_ID = a11.MONTH_ID and ((NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) > 600000.0) M1Running product (M1)aababcabcdabcdeabcdeLanguageDecimalDigit grouping e.g. 1 Million in English = 1,000,000Short dateAfrikaans.,yyyy/MM/ddCatalan,.dd/MM/yyyyDanish,.dd-MM-yyyyDutch,.d-M-yyyyEnglish (UK).,dd/MM/yyyyEnglish (US).,M/d/yyyyFinnish,spaced.M.yyyyFrench (France),spacedd/MM/yyyyFrench (Canada),spaceyyyy-MM-ddGerman,.dd.MM.yyyyItalian,.dd/MM/yyyyNorwegian,spacedd.MM.yyyyPortuguese (Portugal),.dd-MM-yyyyPortuguese (Brazil),.d/M/yyyySpanish (International),.dd/MM/yyyySpanish (Mexico).,dd/MM/yyyySwedish,spaceyyyy-MM-ddLanguageDecimalDigit grouping e.g. 1 Million in English = 1,000,000Short dateArabic.,dd/MM/yyyyBelarusian,spacedd.MM.yyyyChinese.,yyyy-M-dChinese (Hong Kong).,d/M/yyyyCroatian,.d.M.yyyyCzech,spaced.M.yyyyEstonian,spacedd.MM.yyyyGeorgian,spacedd.MM.yyyyGreek,.d/M/yyyyHebrew.,dd/MM/yyyyHindi.,dd-MM-yyyyHungarian,spaceyyyy. MM. dd.Indonesian,.dd/MM/yyyyJapanese.,yyyy/MM/ddKorean.,yyyy-MM-ddLatvian,spaceyyyy.MM.dd.Lithuanian,.yyyy.MM.ddMacedonian,.dd.MM.yyyyPolish,spaceyyyy-MM-ddRomanian,.dd.MM.yyyyRussian,spacedd.MM.yyyySerbian,.d.M.yyyySlovak,spaced. M. yyyySlovenian,.d.M.yyyyThai.,d/M/yyyyTurkish,.dd.MM.yyyyUkrainian,spacedd.MM.yyyyUrdu.,dd/MM/yyyyVietnamese,.dd/MM/yyyyImpala DatatypeMSTR DatatypeCHARACTERCharNUMERICNumericDECIMALDecimalINTEGERIntegerSMALLINTIntegerFLOATFloatREALFloatDOUBLEDoubleDATEDateTIMETimeTIMESTAMPTimeStampVARCHARVarCharBIGINTInt64TINYINTIntegerKeysDescriptionAlt-0153™Alt-0174®Alt-0169©Alt-0137‰Alt-251√Alt-236∞Alt-243≤Alt-242≥Alt-13♪Alt-14♫Alt-23↨Alt-24↑Alt-25↓Alt-26→Alt-27←Data in email0,0,1Data in email and to history list0,1,1Data and link to history list in email1,1,1Link to history list in email1,1,0	select a11.MONTH_ID MONTH_ID, sum(a11.TOT_COST) WJXBFS1 from MNTH_CATEGORY_SLS a11 where a11.MONTH_ID in (200001, 200002, 200003) group by a11.MONTH_ID into temp MD000 with no log select a11.MONTH_ID MONTH_ID, sum(a11.UNITS_RECEIVED) WJXBFS1 from INVENTORY_ORDERS a11 where a11.MONTH_ID in (200001, 200002) group by a11.MONTH_ID into temp MD001 with no log select pa2.MONTH_ID MONTH_ID, a11.MONTH_DESC MONTH_DESC, (NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) WJXBFS1 from MD001 pa2, outer MD000 pa1, LU_MONTH a11 where pa2.MONTH_ID = pa1.MONTH_ID and pa2.MONTH_ID = a11.MONTH_ID and ((NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) > 600000.0) M1Running product (M1)aababcabcdabcdeabcdeLanguageDecimalDigit grouping e.g. 1 Million in English = 1,000,000Short dateAfrikaans.,yyyy/MM/ddCatalan,.dd/MM/yyyyDanish,.dd-MM-yyyyDutch,.d-M-yyyyEnglish (UK).,dd/MM/yyyyEnglish (US).,M/d/yyyyFinnish,spaced.M.yyyyFrench (France),spacedd/MM/yyyyFrench (Canada),spaceyyyy-MM-ddGerman,.dd.MM.yyyyItalian,.dd/MM/yyyyNorwegian,spacedd.MM.yyyyPortuguese (Portugal),.dd-MM-yyyyPortuguese (Brazil),.d/M/yyyySpanish (International),.dd/MM/yyyySpanish (Mexico).,dd/MM/yyyySwedish,spaceyyyy-MM-ddLanguageDecimalDigit grouping e.g. 1 Million in English = 1,000,000Short dateArabic.,dd/MM/yyyyBelarusian,spacedd.MM.yyyyChinese.,yyyy-M-dChinese (Hong Kong).,d/M/yyyyCroatian,.d.M.yyyyCzech,spaced.M.yyyyEstonian,spacedd.MM.yyyyGeorgian,spacedd.MM.yyyyGreek,.d/M/yyyyHebrew.,dd/MM/yyyyHindi.,dd-MM-yyyyHungarian,spaceyyyy. MM. dd.Indonesian,.dd/MM/yyyyJapanese.,yyyy/MM/ddKorean.,yyyy-MM-ddLatvian,spaceyyyy.MM.dd.Lithuanian,.yyyy.MM.ddMacedonian,.dd.MM.yyyyPolish,spaceyyyy-MM-ddRomanian,.dd.MM.yyyyRussian,spacedd.MM.yyyySerbian,.d.M.yyyySlovak,spaced. M. yyyySlovenian,.d.M.yyyyThai.,d/M/yyyyTurkish,.dd.MM.yyyyUkrainian,spacedd.MM.yyyyUrdu.,dd/MM/yyyyVietnamese,.dd/MM/yyyyImpala DatatypeMSTR DatatypeCHARACTERCharNUMERICNumericDECIMALDecimalINTEGERIntegerSMALLINTIntegerFLOATFloatREALFloatDOUBLEDoubleDATEDateTIMETimeTIMESTAMPTimeStampVARCHARVarCharBIGINTInt64TINYINTIntegerKeysDescriptionAlt-0153™Alt-0174®Alt-0169©Alt-0137‰Alt-251√Alt-236∞Alt-243≤Alt-242≥Alt-13♪Alt-14♫Alt-23↨Alt-24↑Alt-25↓Alt-26→Alt-27←Data in email0,0,1Data in email and to history list0,1,1Data and link to history list in email1,1,1Link to history list in email1,1,0

The example provided in this document is provided “as-is” and user has read the following customization warning:
ADDITIONAL INFORMATION:
The Strategy SDK allows you to customize several Strategy products and extend and integrate the Strategy business intelligence functionality into other applications. However, before changing the way Strategy products look or behave, it is helpful to understand how the application is built. For more information regarding the Strategy products or the process of customizing Strategy products, please refer to Strategy Developer Zone (https://developer.microstrategy.com).
To access the Strategy Developer Zone, you must have access to the Strategy Knowledge Base, you must have purchased the Strategy SDK, and you must be current on your Strategy maintenance agreement. If you are a US-based business and believe that you satisfy all three of these conditions but you do not have access to the Strategy Developer Zone, please contact Strategy Technical Support at support@microstrategy.com or at (703) 848-8700. If you are an international business, please contact Strategy Technical Support at the appropriate email address or phone number found at https://www.microstrategy.com/us/services/support/contact.
CUSTOMIZATION WARNING:
This customization is provided as a convenience to Strategy users and is only directly applicable to the version stated. While this code may apply to other releases directly, Strategy Technical Support makes no guarantees that the code provided will apply to any future or previous builds. In the event of a code change in future builds, Strategy Technical Support makes no guarantee that an updated version of this particular customization will be provided. In the event of a code change in future builds, Strategy may not be able to provide additional code on this matter even though this customization is provided at this time for this specific build. For enhancements to this customization or to incorporate similar functionality into other versions, contact your Account Executive to inquire about Strategy Consulting assistance.

RELATED ARTICLES:
KB221863: How to Remove Send Drop Down Options When Sending an E-mail Subscription after Report Execution using MicroStrategy Web SDK 9.4.1
KB221840: How to Remove Send Drop Down Options for Send Now Subscription Using MicroStrategy Web SDK 9.4.1

Comment

0 comments

Details

Knowledge Article

Published:

March 31, 2017

Last Updated:

April 21, 2021

public void renderEditorContents (MarkupOutput out){ MarkupOutput newOutput = WebBeanFactory.getInstance().newMarkupOutput(); super.renderEditorContents(newOutput); String newOutputString = newOutput.getCopyAsString(); //if this option is not selected by default newOutputString = newOutputString.replace("<option value=\"1,1,0\">Link to history list in email</option>", ""); //if this option is selected by default //newOutputString = newOutputString.replace("<option selected=\"1\" value=\"1,1,0\">Link to history list in email</option>", ""); System.out.println("editor"); out.append(newOutputString); }

select a11.MONTH_ID MONTH_ID, sum(a11.TOT_COST) WJXBFS1 from MNTH_CATEGORY_SLS a11 where a11.MONTH_ID in (200001, 200002, 200003) group by a11.MONTH_ID into temp MD000 with no log select a11.MONTH_ID MONTH_ID, sum(a11.UNITS_RECEIVED) WJXBFS1 from INVENTORY_ORDERS a11 where a11.MONTH_ID in (200001, 200002) group by a11.MONTH_ID into temp MD001 with no log select pa2.MONTH_ID MONTH_ID, a11.MONTH_DESC MONTH_DESC, (NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) WJXBFS1 from MD001 pa2, outer MD000 pa1, LU_MONTH a11 where pa2.MONTH_ID = pa1.MONTH_ID and pa2.MONTH_ID = a11.MONTH_ID and ((NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) > 600000.0) M1Running product (M1)aababcabcdabcdeabcdeLanguageDecimalDigit grouping e.g. 1 Million in English = 1,000,000Short dateAfrikaans.,yyyy/MM/ddCatalan,.dd/MM/yyyyDanish,.dd-MM-yyyyDutch,.d-M-yyyyEnglish (UK).,dd/MM/yyyyEnglish (US).,M/d/yyyyFinnish,spaced.M.yyyyFrench (France),spacedd/MM/yyyyFrench (Canada),spaceyyyy-MM-ddGerman,.dd.MM.yyyyItalian,.dd/MM/yyyyNorwegian,spacedd.MM.yyyyPortuguese (Portugal),.dd-MM-yyyyPortuguese (Brazil),.d/M/yyyySpanish (International),.dd/MM/yyyySpanish (Mexico).,dd/MM/yyyySwedish,spaceyyyy-MM-ddLanguageDecimalDigit grouping e.g. 1 Million in English = 1,000,000Short dateArabic.,dd/MM/yyyyBelarusian,spacedd.MM.yyyyChinese.,yyyy-M-dChinese (Hong Kong).,d/M/yyyyCroatian,.d.M.yyyyCzech,spaced.M.yyyyEstonian,spacedd.MM.yyyyGeorgian,spacedd.MM.yyyyGreek,.d/M/yyyyHebrew.,dd/MM/yyyyHindi.,dd-MM-yyyyHungarian,spaceyyyy. MM. dd.Indonesian,.dd/MM/yyyyJapanese.,yyyy/MM/ddKorean.,yyyy-MM-ddLatvian,spaceyyyy.MM.dd.Lithuanian,.yyyy.MM.ddMacedonian,.dd.MM.yyyyPolish,spaceyyyy-MM-ddRomanian,.dd.MM.yyyyRussian,spacedd.MM.yyyySerbian,.d.M.yyyySlovak,spaced. M. yyyySlovenian,.d.M.yyyyThai.,d/M/yyyyTurkish,.dd.MM.yyyyUkrainian,spacedd.MM.yyyyUrdu.,dd/MM/yyyyVietnamese,.dd/MM/yyyyImpala DatatypeMSTR DatatypeCHARACTERCharNUMERICNumericDECIMALDecimalINTEGERIntegerSMALLINTIntegerFLOATFloatREALFloatDOUBLEDoubleDATEDateTIMETimeTIMESTAMPTimeStampVARCHARVarCharBIGINTInt64TINYINTIntegerKeysDescriptionAlt-0153™Alt-0174®Alt-0169©Alt-0137‰Alt-251√Alt-236∞Alt-243≤Alt-242≥Alt-13♪Alt-14♫Alt-23↨Alt-24↑Alt-25↓Alt-26→Alt-27←Data in email0,0,1Data in email and to history list0,1,1Data and link to history list in email1,1,1Link to history list in email1,1,0	select a11.MONTH_ID MONTH_ID, sum(a11.TOT_COST) WJXBFS1 from MNTH_CATEGORY_SLS a11 where a11.MONTH_ID in (200001, 200002, 200003) group by a11.MONTH_ID into temp MD000 with no log select a11.MONTH_ID MONTH_ID, sum(a11.UNITS_RECEIVED) WJXBFS1 from INVENTORY_ORDERS a11 where a11.MONTH_ID in (200001, 200002) group by a11.MONTH_ID into temp MD001 with no log select pa2.MONTH_ID MONTH_ID, a11.MONTH_DESC MONTH_DESC, (NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) WJXBFS1 from MD001 pa2, outer MD000 pa1, LU_MONTH a11 where pa2.MONTH_ID = pa1.MONTH_ID and pa2.MONTH_ID = a11.MONTH_ID and ((NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) > 600000.0) M1Running product (M1)aababcabcdabcdeabcdeLanguageDecimalDigit grouping e.g. 1 Million in English = 1,000,000Short dateAfrikaans.,yyyy/MM/ddCatalan,.dd/MM/yyyyDanish,.dd-MM-yyyyDutch,.d-M-yyyyEnglish (UK).,dd/MM/yyyyEnglish (US).,M/d/yyyyFinnish,spaced.M.yyyyFrench (France),spacedd/MM/yyyyFrench (Canada),spaceyyyy-MM-ddGerman,.dd.MM.yyyyItalian,.dd/MM/yyyyNorwegian,spacedd.MM.yyyyPortuguese (Portugal),.dd-MM-yyyyPortuguese (Brazil),.d/M/yyyySpanish (International),.dd/MM/yyyySpanish (Mexico).,dd/MM/yyyySwedish,spaceyyyy-MM-ddLanguageDecimalDigit grouping e.g. 1 Million in English = 1,000,000Short dateArabic.,dd/MM/yyyyBelarusian,spacedd.MM.yyyyChinese.,yyyy-M-dChinese (Hong Kong).,d/M/yyyyCroatian,.d.M.yyyyCzech,spaced.M.yyyyEstonian,spacedd.MM.yyyyGeorgian,spacedd.MM.yyyyGreek,.d/M/yyyyHebrew.,dd/MM/yyyyHindi.,dd-MM-yyyyHungarian,spaceyyyy. MM. dd.Indonesian,.dd/MM/yyyyJapanese.,yyyy/MM/ddKorean.,yyyy-MM-ddLatvian,spaceyyyy.MM.dd.Lithuanian,.yyyy.MM.ddMacedonian,.dd.MM.yyyyPolish,spaceyyyy-MM-ddRomanian,.dd.MM.yyyyRussian,spacedd.MM.yyyySerbian,.d.M.yyyySlovak,spaced. M. yyyySlovenian,.d.M.yyyyThai.,d/M/yyyyTurkish,.dd.MM.yyyyUkrainian,spacedd.MM.yyyyUrdu.,dd/MM/yyyyVietnamese,.dd/MM/yyyyImpala DatatypeMSTR DatatypeCHARACTERCharNUMERICNumericDECIMALDecimalINTEGERIntegerSMALLINTIntegerFLOATFloatREALFloatDOUBLEDoubleDATEDateTIMETimeTIMESTAMPTimeStampVARCHARVarCharBIGINTInt64TINYINTIntegerKeysDescriptionAlt-0153™Alt-0174®Alt-0169©Alt-0137‰Alt-251√Alt-236∞Alt-243≤Alt-242≥Alt-13♪Alt-14♫Alt-23↨Alt-24↑Alt-25↓Alt-26→Alt-27←Data in email0,0,1Data in email and to history list0,1,1Data and link to history list in email1,1,1Link to history list in email1,1,0
select a11.MONTH_ID MONTH_ID, sum(a11.TOT_COST) WJXBFS1 from MNTH_CATEGORY_SLS a11 where a11.MONTH_ID in (200001, 200002, 200003) group by a11.MONTH_ID into temp MD000 with no log select a11.MONTH_ID MONTH_ID, sum(a11.UNITS_RECEIVED) WJXBFS1 from INVENTORY_ORDERS a11 where a11.MONTH_ID in (200001, 200002) group by a11.MONTH_ID into temp MD001 with no log select pa2.MONTH_ID MONTH_ID, a11.MONTH_DESC MONTH_DESC, (NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) WJXBFS1 from MD001 pa2, outer MD000 pa1, LU_MONTH a11 where pa2.MONTH_ID = pa1.MONTH_ID and pa2.MONTH_ID = a11.MONTH_ID and ((NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) > 600000.0) M1Running product (M1)aababcabcdabcdeabcdeLanguageDecimalDigit grouping e.g. 1 Million in English = 1,000,000Short dateAfrikaans.,yyyy/MM/ddCatalan,.dd/MM/yyyyDanish,.dd-MM-yyyyDutch,.d-M-yyyyEnglish (UK).,dd/MM/yyyyEnglish (US).,M/d/yyyyFinnish,spaced.M.yyyyFrench (France),spacedd/MM/yyyyFrench (Canada),spaceyyyy-MM-ddGerman,.dd.MM.yyyyItalian,.dd/MM/yyyyNorwegian,spacedd.MM.yyyyPortuguese (Portugal),.dd-MM-yyyyPortuguese (Brazil),.d/M/yyyySpanish (International),.dd/MM/yyyySpanish (Mexico).,dd/MM/yyyySwedish,spaceyyyy-MM-ddLanguageDecimalDigit grouping e.g. 1 Million in English = 1,000,000Short dateArabic.,dd/MM/yyyyBelarusian,spacedd.MM.yyyyChinese.,yyyy-M-dChinese (Hong Kong).,d/M/yyyyCroatian,.d.M.yyyyCzech,spaced.M.yyyyEstonian,spacedd.MM.yyyyGeorgian,spacedd.MM.yyyyGreek,.d/M/yyyyHebrew.,dd/MM/yyyyHindi.,dd-MM-yyyyHungarian,spaceyyyy. MM. dd.Indonesian,.dd/MM/yyyyJapanese.,yyyy/MM/ddKorean.,yyyy-MM-ddLatvian,spaceyyyy.MM.dd.Lithuanian,.yyyy.MM.ddMacedonian,.dd.MM.yyyyPolish,spaceyyyy-MM-ddRomanian,.dd.MM.yyyyRussian,spacedd.MM.yyyySerbian,.d.M.yyyySlovak,spaced. M. yyyySlovenian,.d.M.yyyyThai.,d/M/yyyyTurkish,.dd.MM.yyyyUkrainian,spacedd.MM.yyyyUrdu.,dd/MM/yyyyVietnamese,.dd/MM/yyyyImpala DatatypeMSTR DatatypeCHARACTERCharNUMERICNumericDECIMALDecimalINTEGERIntegerSMALLINTIntegerFLOATFloatREALFloatDOUBLEDoubleDATEDateTIMETimeTIMESTAMPTimeStampVARCHARVarCharBIGINTInt64TINYINTIntegerKeysDescriptionAlt-0153™Alt-0174®Alt-0169©Alt-0137‰Alt-251√Alt-236∞Alt-243≤Alt-242≥Alt-13♪Alt-14♫Alt-23↨Alt-24↑Alt-25↓Alt-26→Alt-27←Data in email0,0,1Data in email and to history list0,1,1Data and link to history list in email1,1,1Link to history list in email1,1,0	select a11.MONTH_ID MONTH_ID, sum(a11.TOT_COST) WJXBFS1 from MNTH_CATEGORY_SLS a11 where a11.MONTH_ID in (200001, 200002, 200003) group by a11.MONTH_ID into temp MD000 with no log select a11.MONTH_ID MONTH_ID, sum(a11.UNITS_RECEIVED) WJXBFS1 from INVENTORY_ORDERS a11 where a11.MONTH_ID in (200001, 200002) group by a11.MONTH_ID into temp MD001 with no log select pa2.MONTH_ID MONTH_ID, a11.MONTH_DESC MONTH_DESC, (NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) WJXBFS1 from MD001 pa2, outer MD000 pa1, LU_MONTH a11 where pa2.MONTH_ID = pa1.MONTH_ID and pa2.MONTH_ID = a11.MONTH_ID and ((NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) > 600000.0) M1Running product (M1)aababcabcdabcdeabcdeLanguageDecimalDigit grouping e.g. 1 Million in English = 1,000,000Short dateAfrikaans.,yyyy/MM/ddCatalan,.dd/MM/yyyyDanish,.dd-MM-yyyyDutch,.d-M-yyyyEnglish (UK).,dd/MM/yyyyEnglish (US).,M/d/yyyyFinnish,spaced.M.yyyyFrench (France),spacedd/MM/yyyyFrench (Canada),spaceyyyy-MM-ddGerman,.dd.MM.yyyyItalian,.dd/MM/yyyyNorwegian,spacedd.MM.yyyyPortuguese (Portugal),.dd-MM-yyyyPortuguese (Brazil),.d/M/yyyySpanish (International),.dd/MM/yyyySpanish (Mexico).,dd/MM/yyyySwedish,spaceyyyy-MM-ddLanguageDecimalDigit grouping e.g. 1 Million in English = 1,000,000Short dateArabic.,dd/MM/yyyyBelarusian,spacedd.MM.yyyyChinese.,yyyy-M-dChinese (Hong Kong).,d/M/yyyyCroatian,.d.M.yyyyCzech,spaced.M.yyyyEstonian,spacedd.MM.yyyyGeorgian,spacedd.MM.yyyyGreek,.d/M/yyyyHebrew.,dd/MM/yyyyHindi.,dd-MM-yyyyHungarian,spaceyyyy. MM. dd.Indonesian,.dd/MM/yyyyJapanese.,yyyy/MM/ddKorean.,yyyy-MM-ddLatvian,spaceyyyy.MM.dd.Lithuanian,.yyyy.MM.ddMacedonian,.dd.MM.yyyyPolish,spaceyyyy-MM-ddRomanian,.dd.MM.yyyyRussian,spacedd.MM.yyyySerbian,.d.M.yyyySlovak,spaced. M. yyyySlovenian,.d.M.yyyyThai.,d/M/yyyyTurkish,.dd.MM.yyyyUkrainian,spacedd.MM.yyyyUrdu.,dd/MM/yyyyVietnamese,.dd/MM/yyyyImpala DatatypeMSTR DatatypeCHARACTERCharNUMERICNumericDECIMALDecimalINTEGERIntegerSMALLINTIntegerFLOATFloatREALFloatDOUBLEDoubleDATEDateTIMETimeTIMESTAMPTimeStampVARCHARVarCharBIGINTInt64TINYINTIntegerKeysDescriptionAlt-0153™Alt-0174®Alt-0169©Alt-0137‰Alt-251√Alt-236∞Alt-243≤Alt-242≥Alt-13♪Alt-14♫Alt-23↨Alt-24↑Alt-25↓Alt-26→Alt-27←Data in email0,0,1Data in email and to history list0,1,1Data and link to history list in email1,1,1Link to history list in email1,1,0
select a11.MONTH_ID MONTH_ID, sum(a11.TOT_COST) WJXBFS1 from MNTH_CATEGORY_SLS a11 where a11.MONTH_ID in (200001, 200002, 200003) group by a11.MONTH_ID into temp MD000 with no log select a11.MONTH_ID MONTH_ID, sum(a11.UNITS_RECEIVED) WJXBFS1 from INVENTORY_ORDERS a11 where a11.MONTH_ID in (200001, 200002) group by a11.MONTH_ID into temp MD001 with no log select pa2.MONTH_ID MONTH_ID, a11.MONTH_DESC MONTH_DESC, (NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) WJXBFS1 from MD001 pa2, outer MD000 pa1, LU_MONTH a11 where pa2.MONTH_ID = pa1.MONTH_ID and pa2.MONTH_ID = a11.MONTH_ID and ((NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) > 600000.0) M1Running product (M1)aababcabcdabcdeabcdeLanguageDecimalDigit grouping e.g. 1 Million in English = 1,000,000Short dateAfrikaans.,yyyy/MM/ddCatalan,.dd/MM/yyyyDanish,.dd-MM-yyyyDutch,.d-M-yyyyEnglish (UK).,dd/MM/yyyyEnglish (US).,M/d/yyyyFinnish,spaced.M.yyyyFrench (France),spacedd/MM/yyyyFrench (Canada),spaceyyyy-MM-ddGerman,.dd.MM.yyyyItalian,.dd/MM/yyyyNorwegian,spacedd.MM.yyyyPortuguese (Portugal),.dd-MM-yyyyPortuguese (Brazil),.d/M/yyyySpanish (International),.dd/MM/yyyySpanish (Mexico).,dd/MM/yyyySwedish,spaceyyyy-MM-ddLanguageDecimalDigit grouping e.g. 1 Million in English = 1,000,000Short dateArabic.,dd/MM/yyyyBelarusian,spacedd.MM.yyyyChinese.,yyyy-M-dChinese (Hong Kong).,d/M/yyyyCroatian,.d.M.yyyyCzech,spaced.M.yyyyEstonian,spacedd.MM.yyyyGeorgian,spacedd.MM.yyyyGreek,.d/M/yyyyHebrew.,dd/MM/yyyyHindi.,dd-MM-yyyyHungarian,spaceyyyy. MM. dd.Indonesian,.dd/MM/yyyyJapanese.,yyyy/MM/ddKorean.,yyyy-MM-ddLatvian,spaceyyyy.MM.dd.Lithuanian,.yyyy.MM.ddMacedonian,.dd.MM.yyyyPolish,spaceyyyy-MM-ddRomanian,.dd.MM.yyyyRussian,spacedd.MM.yyyySerbian,.d.M.yyyySlovak,spaced. M. yyyySlovenian,.d.M.yyyyThai.,d/M/yyyyTurkish,.dd.MM.yyyyUkrainian,spacedd.MM.yyyyUrdu.,dd/MM/yyyyVietnamese,.dd/MM/yyyyImpala DatatypeMSTR DatatypeCHARACTERCharNUMERICNumericDECIMALDecimalINTEGERIntegerSMALLINTIntegerFLOATFloatREALFloatDOUBLEDoubleDATEDateTIMETimeTIMESTAMPTimeStampVARCHARVarCharBIGINTInt64TINYINTIntegerKeysDescriptionAlt-0153™Alt-0174®Alt-0169©Alt-0137‰Alt-251√Alt-236∞Alt-243≤Alt-242≥Alt-13♪Alt-14♫Alt-23↨Alt-24↑Alt-25↓Alt-26→Alt-27←Data in email0,0,1Data in email and to history list0,1,1Data and link to history list in email1,1,1Link to history list in email1,1,0	select a11.MONTH_ID MONTH_ID, sum(a11.TOT_COST) WJXBFS1 from MNTH_CATEGORY_SLS a11 where a11.MONTH_ID in (200001, 200002, 200003) group by a11.MONTH_ID into temp MD000 with no log select a11.MONTH_ID MONTH_ID, sum(a11.UNITS_RECEIVED) WJXBFS1 from INVENTORY_ORDERS a11 where a11.MONTH_ID in (200001, 200002) group by a11.MONTH_ID into temp MD001 with no log select pa2.MONTH_ID MONTH_ID, a11.MONTH_DESC MONTH_DESC, (NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) WJXBFS1 from MD001 pa2, outer MD000 pa1, LU_MONTH a11 where pa2.MONTH_ID = pa1.MONTH_ID and pa2.MONTH_ID = a11.MONTH_ID and ((NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) > 600000.0) M1Running product (M1)aababcabcdabcdeabcdeLanguageDecimalDigit grouping e.g. 1 Million in English = 1,000,000Short dateAfrikaans.,yyyy/MM/ddCatalan,.dd/MM/yyyyDanish,.dd-MM-yyyyDutch,.d-M-yyyyEnglish (UK).,dd/MM/yyyyEnglish (US).,M/d/yyyyFinnish,spaced.M.yyyyFrench (France),spacedd/MM/yyyyFrench (Canada),spaceyyyy-MM-ddGerman,.dd.MM.yyyyItalian,.dd/MM/yyyyNorwegian,spacedd.MM.yyyyPortuguese (Portugal),.dd-MM-yyyyPortuguese (Brazil),.d/M/yyyySpanish (International),.dd/MM/yyyySpanish (Mexico).,dd/MM/yyyySwedish,spaceyyyy-MM-ddLanguageDecimalDigit grouping e.g. 1 Million in English = 1,000,000Short dateArabic.,dd/MM/yyyyBelarusian,spacedd.MM.yyyyChinese.,yyyy-M-dChinese (Hong Kong).,d/M/yyyyCroatian,.d.M.yyyyCzech,spaced.M.yyyyEstonian,spacedd.MM.yyyyGeorgian,spacedd.MM.yyyyGreek,.d/M/yyyyHebrew.,dd/MM/yyyyHindi.,dd-MM-yyyyHungarian,spaceyyyy. MM. dd.Indonesian,.dd/MM/yyyyJapanese.,yyyy/MM/ddKorean.,yyyy-MM-ddLatvian,spaceyyyy.MM.dd.Lithuanian,.yyyy.MM.ddMacedonian,.dd.MM.yyyyPolish,spaceyyyy-MM-ddRomanian,.dd.MM.yyyyRussian,spacedd.MM.yyyySerbian,.d.M.yyyySlovak,spaced. M. yyyySlovenian,.d.M.yyyyThai.,d/M/yyyyTurkish,.dd.MM.yyyyUkrainian,spacedd.MM.yyyyUrdu.,dd/MM/yyyyVietnamese,.dd/MM/yyyyImpala DatatypeMSTR DatatypeCHARACTERCharNUMERICNumericDECIMALDecimalINTEGERIntegerSMALLINTIntegerFLOATFloatREALFloatDOUBLEDoubleDATEDateTIMETimeTIMESTAMPTimeStampVARCHARVarCharBIGINTInt64TINYINTIntegerKeysDescriptionAlt-0153™Alt-0174®Alt-0169©Alt-0137‰Alt-251√Alt-236∞Alt-243≤Alt-242≥Alt-13♪Alt-14♫Alt-23↨Alt-24↑Alt-25↓Alt-26→Alt-27←Data in email0,0,1Data in email and to history list0,1,1Data and link to history list in email1,1,1Link to history list in email1,1,0
select a11.MONTH_ID MONTH_ID, sum(a11.TOT_COST) WJXBFS1 from MNTH_CATEGORY_SLS a11 where a11.MONTH_ID in (200001, 200002, 200003) group by a11.MONTH_ID into temp MD000 with no log select a11.MONTH_ID MONTH_ID, sum(a11.UNITS_RECEIVED) WJXBFS1 from INVENTORY_ORDERS a11 where a11.MONTH_ID in (200001, 200002) group by a11.MONTH_ID into temp MD001 with no log select pa2.MONTH_ID MONTH_ID, a11.MONTH_DESC MONTH_DESC, (NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) WJXBFS1 from MD001 pa2, outer MD000 pa1, LU_MONTH a11 where pa2.MONTH_ID = pa1.MONTH_ID and pa2.MONTH_ID = a11.MONTH_ID and ((NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) > 600000.0) M1Running product (M1)aababcabcdabcdeabcdeLanguageDecimalDigit grouping e.g. 1 Million in English = 1,000,000Short dateAfrikaans.,yyyy/MM/ddCatalan,.dd/MM/yyyyDanish,.dd-MM-yyyyDutch,.d-M-yyyyEnglish (UK).,dd/MM/yyyyEnglish (US).,M/d/yyyyFinnish,spaced.M.yyyyFrench (France),spacedd/MM/yyyyFrench (Canada),spaceyyyy-MM-ddGerman,.dd.MM.yyyyItalian,.dd/MM/yyyyNorwegian,spacedd.MM.yyyyPortuguese (Portugal),.dd-MM-yyyyPortuguese (Brazil),.d/M/yyyySpanish (International),.dd/MM/yyyySpanish (Mexico).,dd/MM/yyyySwedish,spaceyyyy-MM-ddLanguageDecimalDigit grouping e.g. 1 Million in English = 1,000,000Short dateArabic.,dd/MM/yyyyBelarusian,spacedd.MM.yyyyChinese.,yyyy-M-dChinese (Hong Kong).,d/M/yyyyCroatian,.d.M.yyyyCzech,spaced.M.yyyyEstonian,spacedd.MM.yyyyGeorgian,spacedd.MM.yyyyGreek,.d/M/yyyyHebrew.,dd/MM/yyyyHindi.,dd-MM-yyyyHungarian,spaceyyyy. MM. dd.Indonesian,.dd/MM/yyyyJapanese.,yyyy/MM/ddKorean.,yyyy-MM-ddLatvian,spaceyyyy.MM.dd.Lithuanian,.yyyy.MM.ddMacedonian,.dd.MM.yyyyPolish,spaceyyyy-MM-ddRomanian,.dd.MM.yyyyRussian,spacedd.MM.yyyySerbian,.d.M.yyyySlovak,spaced. M. yyyySlovenian,.d.M.yyyyThai.,d/M/yyyyTurkish,.dd.MM.yyyyUkrainian,spacedd.MM.yyyyUrdu.,dd/MM/yyyyVietnamese,.dd/MM/yyyyImpala DatatypeMSTR DatatypeCHARACTERCharNUMERICNumericDECIMALDecimalINTEGERIntegerSMALLINTIntegerFLOATFloatREALFloatDOUBLEDoubleDATEDateTIMETimeTIMESTAMPTimeStampVARCHARVarCharBIGINTInt64TINYINTIntegerKeysDescriptionAlt-0153™Alt-0174®Alt-0169©Alt-0137‰Alt-251√Alt-236∞Alt-243≤Alt-242≥Alt-13♪Alt-14♫Alt-23↨Alt-24↑Alt-25↓Alt-26→Alt-27←Data in email0,0,1Data in email and to history list0,1,1Data and link to history list in email1,1,1Link to history list in email1,1,0	select a11.MONTH_ID MONTH_ID, sum(a11.TOT_COST) WJXBFS1 from MNTH_CATEGORY_SLS a11 where a11.MONTH_ID in (200001, 200002, 200003) group by a11.MONTH_ID into temp MD000 with no log select a11.MONTH_ID MONTH_ID, sum(a11.UNITS_RECEIVED) WJXBFS1 from INVENTORY_ORDERS a11 where a11.MONTH_ID in (200001, 200002) group by a11.MONTH_ID into temp MD001 with no log select pa2.MONTH_ID MONTH_ID, a11.MONTH_DESC MONTH_DESC, (NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) WJXBFS1 from MD001 pa2, outer MD000 pa1, LU_MONTH a11 where pa2.MONTH_ID = pa1.MONTH_ID and pa2.MONTH_ID = a11.MONTH_ID and ((NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) > 600000.0) M1Running product (M1)aababcabcdabcdeabcdeLanguageDecimalDigit grouping e.g. 1 Million in English = 1,000,000Short dateAfrikaans.,yyyy/MM/ddCatalan,.dd/MM/yyyyDanish,.dd-MM-yyyyDutch,.d-M-yyyyEnglish (UK).,dd/MM/yyyyEnglish (US).,M/d/yyyyFinnish,spaced.M.yyyyFrench (France),spacedd/MM/yyyyFrench (Canada),spaceyyyy-MM-ddGerman,.dd.MM.yyyyItalian,.dd/MM/yyyyNorwegian,spacedd.MM.yyyyPortuguese (Portugal),.dd-MM-yyyyPortuguese (Brazil),.d/M/yyyySpanish (International),.dd/MM/yyyySpanish (Mexico).,dd/MM/yyyySwedish,spaceyyyy-MM-ddLanguageDecimalDigit grouping e.g. 1 Million in English = 1,000,000Short dateArabic.,dd/MM/yyyyBelarusian,spacedd.MM.yyyyChinese.,yyyy-M-dChinese (Hong Kong).,d/M/yyyyCroatian,.d.M.yyyyCzech,spaced.M.yyyyEstonian,spacedd.MM.yyyyGeorgian,spacedd.MM.yyyyGreek,.d/M/yyyyHebrew.,dd/MM/yyyyHindi.,dd-MM-yyyyHungarian,spaceyyyy. MM. dd.Indonesian,.dd/MM/yyyyJapanese.,yyyy/MM/ddKorean.,yyyy-MM-ddLatvian,spaceyyyy.MM.dd.Lithuanian,.yyyy.MM.ddMacedonian,.dd.MM.yyyyPolish,spaceyyyy-MM-ddRomanian,.dd.MM.yyyyRussian,spacedd.MM.yyyySerbian,.d.M.yyyySlovak,spaced. M. yyyySlovenian,.d.M.yyyyThai.,d/M/yyyyTurkish,.dd.MM.yyyyUkrainian,spacedd.MM.yyyyUrdu.,dd/MM/yyyyVietnamese,.dd/MM/yyyyImpala DatatypeMSTR DatatypeCHARACTERCharNUMERICNumericDECIMALDecimalINTEGERIntegerSMALLINTIntegerFLOATFloatREALFloatDOUBLEDoubleDATEDateTIMETimeTIMESTAMPTimeStampVARCHARVarCharBIGINTInt64TINYINTIntegerKeysDescriptionAlt-0153™Alt-0174®Alt-0169©Alt-0137‰Alt-251√Alt-236∞Alt-243≤Alt-242≥Alt-13♪Alt-14♫Alt-23↨Alt-24↑Alt-25↓Alt-26→Alt-27←Data in email0,0,1Data in email and to history list0,1,1Data and link to history list in email1,1,1Link to history list in email1,1,0

select a11.MONTH_ID MONTH_ID, sum(a11.TOT_COST) WJXBFS1 from MNTH_CATEGORY_SLS a11 where a11.MONTH_ID in (200001, 200002, 200003) group by a11.MONTH_ID into temp MD000 with no log select a11.MONTH_ID MONTH_ID, sum(a11.UNITS_RECEIVED) WJXBFS1 from INVENTORY_ORDERS a11 where a11.MONTH_ID in (200001, 200002) group by a11.MONTH_ID into temp MD001 with no log select pa2.MONTH_ID MONTH_ID, a11.MONTH_DESC MONTH_DESC, (NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) WJXBFS1 from MD001 pa2, outer MD000 pa1, LU_MONTH a11 where pa2.MONTH_ID = pa1.MONTH_ID and pa2.MONTH_ID = a11.MONTH_ID and ((NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) > 600000.0) M1Running product (M1)aababcabcdabcdeabcdeLanguageDecimalDigit grouping e.g. 1 Million in English = 1,000,000Short dateAfrikaans.,yyyy/MM/ddCatalan,.dd/MM/yyyyDanish,.dd-MM-yyyyDutch,.d-M-yyyyEnglish (UK).,dd/MM/yyyyEnglish (US).,M/d/yyyyFinnish,spaced.M.yyyyFrench (France),spacedd/MM/yyyyFrench (Canada),spaceyyyy-MM-ddGerman,.dd.MM.yyyyItalian,.dd/MM/yyyyNorwegian,spacedd.MM.yyyyPortuguese (Portugal),.dd-MM-yyyyPortuguese (Brazil),.d/M/yyyySpanish (International),.dd/MM/yyyySpanish (Mexico).,dd/MM/yyyySwedish,spaceyyyy-MM-ddLanguageDecimalDigit grouping e.g. 1 Million in English = 1,000,000Short dateArabic.,dd/MM/yyyyBelarusian,spacedd.MM.yyyyChinese.,yyyy-M-dChinese (Hong Kong).,d/M/yyyyCroatian,.d.M.yyyyCzech,spaced.M.yyyyEstonian,spacedd.MM.yyyyGeorgian,spacedd.MM.yyyyGreek,.d/M/yyyyHebrew.,dd/MM/yyyyHindi.,dd-MM-yyyyHungarian,spaceyyyy. MM. dd.Indonesian,.dd/MM/yyyyJapanese.,yyyy/MM/ddKorean.,yyyy-MM-ddLatvian,spaceyyyy.MM.dd.Lithuanian,.yyyy.MM.ddMacedonian,.dd.MM.yyyyPolish,spaceyyyy-MM-ddRomanian,.dd.MM.yyyyRussian,spacedd.MM.yyyySerbian,.d.M.yyyySlovak,spaced. M. yyyySlovenian,.d.M.yyyyThai.,d/M/yyyyTurkish,.dd.MM.yyyyUkrainian,spacedd.MM.yyyyUrdu.,dd/MM/yyyyVietnamese,.dd/MM/yyyyImpala DatatypeMSTR DatatypeCHARACTERCharNUMERICNumericDECIMALDecimalINTEGERIntegerSMALLINTIntegerFLOATFloatREALFloatDOUBLEDoubleDATEDateTIMETimeTIMESTAMPTimeStampVARCHARVarCharBIGINTInt64TINYINTIntegerKeysDescriptionAlt-0153™Alt-0174®Alt-0169©Alt-0137‰Alt-251√Alt-236∞Alt-243≤Alt-242≥Alt-13♪Alt-14♫Alt-23↨Alt-24↑Alt-25↓Alt-26→Alt-27←Data in email0,0,1Data in email and to history list0,1,1Data and link to history list in email1,1,1Link to history list in email1,1,0	select a11.MONTH_ID MONTH_ID, sum(a11.TOT_COST) WJXBFS1 from MNTH_CATEGORY_SLS a11 where a11.MONTH_ID in (200001, 200002, 200003) group by a11.MONTH_ID into temp MD000 with no log select a11.MONTH_ID MONTH_ID, sum(a11.UNITS_RECEIVED) WJXBFS1 from INVENTORY_ORDERS a11 where a11.MONTH_ID in (200001, 200002) group by a11.MONTH_ID into temp MD001 with no log select pa2.MONTH_ID MONTH_ID, a11.MONTH_DESC MONTH_DESC, (NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) WJXBFS1 from MD001 pa2, outer MD000 pa1, LU_MONTH a11 where pa2.MONTH_ID = pa1.MONTH_ID and pa2.MONTH_ID = a11.MONTH_ID and ((NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) > 600000.0) M1Running product (M1)aababcabcdabcdeabcdeLanguageDecimalDigit grouping e.g. 1 Million in English = 1,000,000Short dateAfrikaans.,yyyy/MM/ddCatalan,.dd/MM/yyyyDanish,.dd-MM-yyyyDutch,.d-M-yyyyEnglish (UK).,dd/MM/yyyyEnglish (US).,M/d/yyyyFinnish,spaced.M.yyyyFrench (France),spacedd/MM/yyyyFrench (Canada),spaceyyyy-MM-ddGerman,.dd.MM.yyyyItalian,.dd/MM/yyyyNorwegian,spacedd.MM.yyyyPortuguese (Portugal),.dd-MM-yyyyPortuguese (Brazil),.d/M/yyyySpanish (International),.dd/MM/yyyySpanish (Mexico).,dd/MM/yyyySwedish,spaceyyyy-MM-ddLanguageDecimalDigit grouping e.g. 1 Million in English = 1,000,000Short dateArabic.,dd/MM/yyyyBelarusian,spacedd.MM.yyyyChinese.,yyyy-M-dChinese (Hong Kong).,d/M/yyyyCroatian,.d.M.yyyyCzech,spaced.M.yyyyEstonian,spacedd.MM.yyyyGeorgian,spacedd.MM.yyyyGreek,.d/M/yyyyHebrew.,dd/MM/yyyyHindi.,dd-MM-yyyyHungarian,spaceyyyy. MM. dd.Indonesian,.dd/MM/yyyyJapanese.,yyyy/MM/ddKorean.,yyyy-MM-ddLatvian,spaceyyyy.MM.dd.Lithuanian,.yyyy.MM.ddMacedonian,.dd.MM.yyyyPolish,spaceyyyy-MM-ddRomanian,.dd.MM.yyyyRussian,spacedd.MM.yyyySerbian,.d.M.yyyySlovak,spaced. M. yyyySlovenian,.d.M.yyyyThai.,d/M/yyyyTurkish,.dd.MM.yyyyUkrainian,spacedd.MM.yyyyUrdu.,dd/MM/yyyyVietnamese,.dd/MM/yyyyImpala DatatypeMSTR DatatypeCHARACTERCharNUMERICNumericDECIMALDecimalINTEGERIntegerSMALLINTIntegerFLOATFloatREALFloatDOUBLEDoubleDATEDateTIMETimeTIMESTAMPTimeStampVARCHARVarCharBIGINTInt64TINYINTIntegerKeysDescriptionAlt-0153™Alt-0174®Alt-0169©Alt-0137‰Alt-251√Alt-236∞Alt-243≤Alt-242≥Alt-13♪Alt-14♫Alt-23↨Alt-24↑Alt-25↓Alt-26→Alt-27←Data in email0,0,1Data in email and to history list0,1,1Data and link to history list in email1,1,1Link to history list in email1,1,0
select a11.MONTH_ID MONTH_ID, sum(a11.TOT_COST) WJXBFS1 from MNTH_CATEGORY_SLS a11 where a11.MONTH_ID in (200001, 200002, 200003) group by a11.MONTH_ID into temp MD000 with no log select a11.MONTH_ID MONTH_ID, sum(a11.UNITS_RECEIVED) WJXBFS1 from INVENTORY_ORDERS a11 where a11.MONTH_ID in (200001, 200002) group by a11.MONTH_ID into temp MD001 with no log select pa2.MONTH_ID MONTH_ID, a11.MONTH_DESC MONTH_DESC, (NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) WJXBFS1 from MD001 pa2, outer MD000 pa1, LU_MONTH a11 where pa2.MONTH_ID = pa1.MONTH_ID and pa2.MONTH_ID = a11.MONTH_ID and ((NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) > 600000.0) M1Running product (M1)aababcabcdabcdeabcdeLanguageDecimalDigit grouping e.g. 1 Million in English = 1,000,000Short dateAfrikaans.,yyyy/MM/ddCatalan,.dd/MM/yyyyDanish,.dd-MM-yyyyDutch,.d-M-yyyyEnglish (UK).,dd/MM/yyyyEnglish (US).,M/d/yyyyFinnish,spaced.M.yyyyFrench (France),spacedd/MM/yyyyFrench (Canada),spaceyyyy-MM-ddGerman,.dd.MM.yyyyItalian,.dd/MM/yyyyNorwegian,spacedd.MM.yyyyPortuguese (Portugal),.dd-MM-yyyyPortuguese (Brazil),.d/M/yyyySpanish (International),.dd/MM/yyyySpanish (Mexico).,dd/MM/yyyySwedish,spaceyyyy-MM-ddLanguageDecimalDigit grouping e.g. 1 Million in English = 1,000,000Short dateArabic.,dd/MM/yyyyBelarusian,spacedd.MM.yyyyChinese.,yyyy-M-dChinese (Hong Kong).,d/M/yyyyCroatian,.d.M.yyyyCzech,spaced.M.yyyyEstonian,spacedd.MM.yyyyGeorgian,spacedd.MM.yyyyGreek,.d/M/yyyyHebrew.,dd/MM/yyyyHindi.,dd-MM-yyyyHungarian,spaceyyyy. MM. dd.Indonesian,.dd/MM/yyyyJapanese.,yyyy/MM/ddKorean.,yyyy-MM-ddLatvian,spaceyyyy.MM.dd.Lithuanian,.yyyy.MM.ddMacedonian,.dd.MM.yyyyPolish,spaceyyyy-MM-ddRomanian,.dd.MM.yyyyRussian,spacedd.MM.yyyySerbian,.d.M.yyyySlovak,spaced. M. yyyySlovenian,.d.M.yyyyThai.,d/M/yyyyTurkish,.dd.MM.yyyyUkrainian,spacedd.MM.yyyyUrdu.,dd/MM/yyyyVietnamese,.dd/MM/yyyyImpala DatatypeMSTR DatatypeCHARACTERCharNUMERICNumericDECIMALDecimalINTEGERIntegerSMALLINTIntegerFLOATFloatREALFloatDOUBLEDoubleDATEDateTIMETimeTIMESTAMPTimeStampVARCHARVarCharBIGINTInt64TINYINTIntegerKeysDescriptionAlt-0153™Alt-0174®Alt-0169©Alt-0137‰Alt-251√Alt-236∞Alt-243≤Alt-242≥Alt-13♪Alt-14♫Alt-23↨Alt-24↑Alt-25↓Alt-26→Alt-27←Data in email0,0,1Data in email and to history list0,1,1Data and link to history list in email1,1,1Link to history list in email1,1,0	select a11.MONTH_ID MONTH_ID, sum(a11.TOT_COST) WJXBFS1 from MNTH_CATEGORY_SLS a11 where a11.MONTH_ID in (200001, 200002, 200003) group by a11.MONTH_ID into temp MD000 with no log select a11.MONTH_ID MONTH_ID, sum(a11.UNITS_RECEIVED) WJXBFS1 from INVENTORY_ORDERS a11 where a11.MONTH_ID in (200001, 200002) group by a11.MONTH_ID into temp MD001 with no log select pa2.MONTH_ID MONTH_ID, a11.MONTH_DESC MONTH_DESC, (NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) WJXBFS1 from MD001 pa2, outer MD000 pa1, LU_MONTH a11 where pa2.MONTH_ID = pa1.MONTH_ID and pa2.MONTH_ID = a11.MONTH_ID and ((NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) > 600000.0) M1Running product (M1)aababcabcdabcdeabcdeLanguageDecimalDigit grouping e.g. 1 Million in English = 1,000,000Short dateAfrikaans.,yyyy/MM/ddCatalan,.dd/MM/yyyyDanish,.dd-MM-yyyyDutch,.d-M-yyyyEnglish (UK).,dd/MM/yyyyEnglish (US).,M/d/yyyyFinnish,spaced.M.yyyyFrench (France),spacedd/MM/yyyyFrench (Canada),spaceyyyy-MM-ddGerman,.dd.MM.yyyyItalian,.dd/MM/yyyyNorwegian,spacedd.MM.yyyyPortuguese (Portugal),.dd-MM-yyyyPortuguese (Brazil),.d/M/yyyySpanish (International),.dd/MM/yyyySpanish (Mexico).,dd/MM/yyyySwedish,spaceyyyy-MM-ddLanguageDecimalDigit grouping e.g. 1 Million in English = 1,000,000Short dateArabic.,dd/MM/yyyyBelarusian,spacedd.MM.yyyyChinese.,yyyy-M-dChinese (Hong Kong).,d/M/yyyyCroatian,.d.M.yyyyCzech,spaced.M.yyyyEstonian,spacedd.MM.yyyyGeorgian,spacedd.MM.yyyyGreek,.d/M/yyyyHebrew.,dd/MM/yyyyHindi.,dd-MM-yyyyHungarian,spaceyyyy. MM. dd.Indonesian,.dd/MM/yyyyJapanese.,yyyy/MM/ddKorean.,yyyy-MM-ddLatvian,spaceyyyy.MM.dd.Lithuanian,.yyyy.MM.ddMacedonian,.dd.MM.yyyyPolish,spaceyyyy-MM-ddRomanian,.dd.MM.yyyyRussian,spacedd.MM.yyyySerbian,.d.M.yyyySlovak,spaced. M. yyyySlovenian,.d.M.yyyyThai.,d/M/yyyyTurkish,.dd.MM.yyyyUkrainian,spacedd.MM.yyyyUrdu.,dd/MM/yyyyVietnamese,.dd/MM/yyyyImpala DatatypeMSTR DatatypeCHARACTERCharNUMERICNumericDECIMALDecimalINTEGERIntegerSMALLINTIntegerFLOATFloatREALFloatDOUBLEDoubleDATEDateTIMETimeTIMESTAMPTimeStampVARCHARVarCharBIGINTInt64TINYINTIntegerKeysDescriptionAlt-0153™Alt-0174®Alt-0169©Alt-0137‰Alt-251√Alt-236∞Alt-243≤Alt-242≥Alt-13♪Alt-14♫Alt-23↨Alt-24↑Alt-25↓Alt-26→Alt-27←Data in email0,0,1Data in email and to history list0,1,1Data and link to history list in email1,1,1Link to history list in email1,1,0
select a11.MONTH_ID MONTH_ID, sum(a11.TOT_COST) WJXBFS1 from MNTH_CATEGORY_SLS a11 where a11.MONTH_ID in (200001, 200002, 200003) group by a11.MONTH_ID into temp MD000 with no log select a11.MONTH_ID MONTH_ID, sum(a11.UNITS_RECEIVED) WJXBFS1 from INVENTORY_ORDERS a11 where a11.MONTH_ID in (200001, 200002) group by a11.MONTH_ID into temp MD001 with no log select pa2.MONTH_ID MONTH_ID, a11.MONTH_DESC MONTH_DESC, (NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) WJXBFS1 from MD001 pa2, outer MD000 pa1, LU_MONTH a11 where pa2.MONTH_ID = pa1.MONTH_ID and pa2.MONTH_ID = a11.MONTH_ID and ((NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) > 600000.0) M1Running product (M1)aababcabcdabcdeabcdeLanguageDecimalDigit grouping e.g. 1 Million in English = 1,000,000Short dateAfrikaans.,yyyy/MM/ddCatalan,.dd/MM/yyyyDanish,.dd-MM-yyyyDutch,.d-M-yyyyEnglish (UK).,dd/MM/yyyyEnglish (US).,M/d/yyyyFinnish,spaced.M.yyyyFrench (France),spacedd/MM/yyyyFrench (Canada),spaceyyyy-MM-ddGerman,.dd.MM.yyyyItalian,.dd/MM/yyyyNorwegian,spacedd.MM.yyyyPortuguese (Portugal),.dd-MM-yyyyPortuguese (Brazil),.d/M/yyyySpanish (International),.dd/MM/yyyySpanish (Mexico).,dd/MM/yyyySwedish,spaceyyyy-MM-ddLanguageDecimalDigit grouping e.g. 1 Million in English = 1,000,000Short dateArabic.,dd/MM/yyyyBelarusian,spacedd.MM.yyyyChinese.,yyyy-M-dChinese (Hong Kong).,d/M/yyyyCroatian,.d.M.yyyyCzech,spaced.M.yyyyEstonian,spacedd.MM.yyyyGeorgian,spacedd.MM.yyyyGreek,.d/M/yyyyHebrew.,dd/MM/yyyyHindi.,dd-MM-yyyyHungarian,spaceyyyy. MM. dd.Indonesian,.dd/MM/yyyyJapanese.,yyyy/MM/ddKorean.,yyyy-MM-ddLatvian,spaceyyyy.MM.dd.Lithuanian,.yyyy.MM.ddMacedonian,.dd.MM.yyyyPolish,spaceyyyy-MM-ddRomanian,.dd.MM.yyyyRussian,spacedd.MM.yyyySerbian,.d.M.yyyySlovak,spaced. M. yyyySlovenian,.d.M.yyyyThai.,d/M/yyyyTurkish,.dd.MM.yyyyUkrainian,spacedd.MM.yyyyUrdu.,dd/MM/yyyyVietnamese,.dd/MM/yyyyImpala DatatypeMSTR DatatypeCHARACTERCharNUMERICNumericDECIMALDecimalINTEGERIntegerSMALLINTIntegerFLOATFloatREALFloatDOUBLEDoubleDATEDateTIMETimeTIMESTAMPTimeStampVARCHARVarCharBIGINTInt64TINYINTIntegerKeysDescriptionAlt-0153™Alt-0174®Alt-0169©Alt-0137‰Alt-251√Alt-236∞Alt-243≤Alt-242≥Alt-13♪Alt-14♫Alt-23↨Alt-24↑Alt-25↓Alt-26→Alt-27←Data in email0,0,1Data in email and to history list0,1,1Data and link to history list in email1,1,1Link to history list in email1,1,0	select a11.MONTH_ID MONTH_ID, sum(a11.TOT_COST) WJXBFS1 from MNTH_CATEGORY_SLS a11 where a11.MONTH_ID in (200001, 200002, 200003) group by a11.MONTH_ID into temp MD000 with no log select a11.MONTH_ID MONTH_ID, sum(a11.UNITS_RECEIVED) WJXBFS1 from INVENTORY_ORDERS a11 where a11.MONTH_ID in (200001, 200002) group by a11.MONTH_ID into temp MD001 with no log select pa2.MONTH_ID MONTH_ID, a11.MONTH_DESC MONTH_DESC, (NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) WJXBFS1 from MD001 pa2, outer MD000 pa1, LU_MONTH a11 where pa2.MONTH_ID = pa1.MONTH_ID and pa2.MONTH_ID = a11.MONTH_ID and ((NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) > 600000.0) M1Running product (M1)aababcabcdabcdeabcdeLanguageDecimalDigit grouping e.g. 1 Million in English = 1,000,000Short dateAfrikaans.,yyyy/MM/ddCatalan,.dd/MM/yyyyDanish,.dd-MM-yyyyDutch,.d-M-yyyyEnglish (UK).,dd/MM/yyyyEnglish (US).,M/d/yyyyFinnish,spaced.M.yyyyFrench (France),spacedd/MM/yyyyFrench (Canada),spaceyyyy-MM-ddGerman,.dd.MM.yyyyItalian,.dd/MM/yyyyNorwegian,spacedd.MM.yyyyPortuguese (Portugal),.dd-MM-yyyyPortuguese (Brazil),.d/M/yyyySpanish (International),.dd/MM/yyyySpanish (Mexico).,dd/MM/yyyySwedish,spaceyyyy-MM-ddLanguageDecimalDigit grouping e.g. 1 Million in English = 1,000,000Short dateArabic.,dd/MM/yyyyBelarusian,spacedd.MM.yyyyChinese.,yyyy-M-dChinese (Hong Kong).,d/M/yyyyCroatian,.d.M.yyyyCzech,spaced.M.yyyyEstonian,spacedd.MM.yyyyGeorgian,spacedd.MM.yyyyGreek,.d/M/yyyyHebrew.,dd/MM/yyyyHindi.,dd-MM-yyyyHungarian,spaceyyyy. MM. dd.Indonesian,.dd/MM/yyyyJapanese.,yyyy/MM/ddKorean.,yyyy-MM-ddLatvian,spaceyyyy.MM.dd.Lithuanian,.yyyy.MM.ddMacedonian,.dd.MM.yyyyPolish,spaceyyyy-MM-ddRomanian,.dd.MM.yyyyRussian,spacedd.MM.yyyySerbian,.d.M.yyyySlovak,spaced. M. yyyySlovenian,.d.M.yyyyThai.,d/M/yyyyTurkish,.dd.MM.yyyyUkrainian,spacedd.MM.yyyyUrdu.,dd/MM/yyyyVietnamese,.dd/MM/yyyyImpala DatatypeMSTR DatatypeCHARACTERCharNUMERICNumericDECIMALDecimalINTEGERIntegerSMALLINTIntegerFLOATFloatREALFloatDOUBLEDoubleDATEDateTIMETimeTIMESTAMPTimeStampVARCHARVarCharBIGINTInt64TINYINTIntegerKeysDescriptionAlt-0153™Alt-0174®Alt-0169©Alt-0137‰Alt-251√Alt-236∞Alt-243≤Alt-242≥Alt-13♪Alt-14♫Alt-23↨Alt-24↑Alt-25↓Alt-26→Alt-27←Data in email0,0,1Data in email and to history list0,1,1Data and link to history list in email1,1,1Link to history list in email1,1,0
select a11.MONTH_ID MONTH_ID, sum(a11.TOT_COST) WJXBFS1 from MNTH_CATEGORY_SLS a11 where a11.MONTH_ID in (200001, 200002, 200003) group by a11.MONTH_ID into temp MD000 with no log select a11.MONTH_ID MONTH_ID, sum(a11.UNITS_RECEIVED) WJXBFS1 from INVENTORY_ORDERS a11 where a11.MONTH_ID in (200001, 200002) group by a11.MONTH_ID into temp MD001 with no log select pa2.MONTH_ID MONTH_ID, a11.MONTH_DESC MONTH_DESC, (NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) WJXBFS1 from MD001 pa2, outer MD000 pa1, LU_MONTH a11 where pa2.MONTH_ID = pa1.MONTH_ID and pa2.MONTH_ID = a11.MONTH_ID and ((NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) > 600000.0) M1Running product (M1)aababcabcdabcdeabcdeLanguageDecimalDigit grouping e.g. 1 Million in English = 1,000,000Short dateAfrikaans.,yyyy/MM/ddCatalan,.dd/MM/yyyyDanish,.dd-MM-yyyyDutch,.d-M-yyyyEnglish (UK).,dd/MM/yyyyEnglish (US).,M/d/yyyyFinnish,spaced.M.yyyyFrench (France),spacedd/MM/yyyyFrench (Canada),spaceyyyy-MM-ddGerman,.dd.MM.yyyyItalian,.dd/MM/yyyyNorwegian,spacedd.MM.yyyyPortuguese (Portugal),.dd-MM-yyyyPortuguese (Brazil),.d/M/yyyySpanish (International),.dd/MM/yyyySpanish (Mexico).,dd/MM/yyyySwedish,spaceyyyy-MM-ddLanguageDecimalDigit grouping e.g. 1 Million in English = 1,000,000Short dateArabic.,dd/MM/yyyyBelarusian,spacedd.MM.yyyyChinese.,yyyy-M-dChinese (Hong Kong).,d/M/yyyyCroatian,.d.M.yyyyCzech,spaced.M.yyyyEstonian,spacedd.MM.yyyyGeorgian,spacedd.MM.yyyyGreek,.d/M/yyyyHebrew.,dd/MM/yyyyHindi.,dd-MM-yyyyHungarian,spaceyyyy. MM. dd.Indonesian,.dd/MM/yyyyJapanese.,yyyy/MM/ddKorean.,yyyy-MM-ddLatvian,spaceyyyy.MM.dd.Lithuanian,.yyyy.MM.ddMacedonian,.dd.MM.yyyyPolish,spaceyyyy-MM-ddRomanian,.dd.MM.yyyyRussian,spacedd.MM.yyyySerbian,.d.M.yyyySlovak,spaced. M. yyyySlovenian,.d.M.yyyyThai.,d/M/yyyyTurkish,.dd.MM.yyyyUkrainian,spacedd.MM.yyyyUrdu.,dd/MM/yyyyVietnamese,.dd/MM/yyyyImpala DatatypeMSTR DatatypeCHARACTERCharNUMERICNumericDECIMALDecimalINTEGERIntegerSMALLINTIntegerFLOATFloatREALFloatDOUBLEDoubleDATEDateTIMETimeTIMESTAMPTimeStampVARCHARVarCharBIGINTInt64TINYINTIntegerKeysDescriptionAlt-0153™Alt-0174®Alt-0169©Alt-0137‰Alt-251√Alt-236∞Alt-243≤Alt-242≥Alt-13♪Alt-14♫Alt-23↨Alt-24↑Alt-25↓Alt-26→Alt-27←Data in email0,0,1Data in email and to history list0,1,1Data and link to history list in email1,1,1Link to history list in email1,1,0	select a11.MONTH_ID MONTH_ID, sum(a11.TOT_COST) WJXBFS1 from MNTH_CATEGORY_SLS a11 where a11.MONTH_ID in (200001, 200002, 200003) group by a11.MONTH_ID into temp MD000 with no log select a11.MONTH_ID MONTH_ID, sum(a11.UNITS_RECEIVED) WJXBFS1 from INVENTORY_ORDERS a11 where a11.MONTH_ID in (200001, 200002) group by a11.MONTH_ID into temp MD001 with no log select pa2.MONTH_ID MONTH_ID, a11.MONTH_DESC MONTH_DESC, (NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) WJXBFS1 from MD001 pa2, outer MD000 pa1, LU_MONTH a11 where pa2.MONTH_ID = pa1.MONTH_ID and pa2.MONTH_ID = a11.MONTH_ID and ((NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) > 600000.0) M1Running product (M1)aababcabcdabcdeabcdeLanguageDecimalDigit grouping e.g. 1 Million in English = 1,000,000Short dateAfrikaans.,yyyy/MM/ddCatalan,.dd/MM/yyyyDanish,.dd-MM-yyyyDutch,.d-M-yyyyEnglish (UK).,dd/MM/yyyyEnglish (US).,M/d/yyyyFinnish,spaced.M.yyyyFrench (France),spacedd/MM/yyyyFrench (Canada),spaceyyyy-MM-ddGerman,.dd.MM.yyyyItalian,.dd/MM/yyyyNorwegian,spacedd.MM.yyyyPortuguese (Portugal),.dd-MM-yyyyPortuguese (Brazil),.d/M/yyyySpanish (International),.dd/MM/yyyySpanish (Mexico).,dd/MM/yyyySwedish,spaceyyyy-MM-ddLanguageDecimalDigit grouping e.g. 1 Million in English = 1,000,000Short dateArabic.,dd/MM/yyyyBelarusian,spacedd.MM.yyyyChinese.,yyyy-M-dChinese (Hong Kong).,d/M/yyyyCroatian,.d.M.yyyyCzech,spaced.M.yyyyEstonian,spacedd.MM.yyyyGeorgian,spacedd.MM.yyyyGreek,.d/M/yyyyHebrew.,dd/MM/yyyyHindi.,dd-MM-yyyyHungarian,spaceyyyy. MM. dd.Indonesian,.dd/MM/yyyyJapanese.,yyyy/MM/ddKorean.,yyyy-MM-ddLatvian,spaceyyyy.MM.dd.Lithuanian,.yyyy.MM.ddMacedonian,.dd.MM.yyyyPolish,spaceyyyy-MM-ddRomanian,.dd.MM.yyyyRussian,spacedd.MM.yyyySerbian,.d.M.yyyySlovak,spaced. M. yyyySlovenian,.d.M.yyyyThai.,d/M/yyyyTurkish,.dd.MM.yyyyUkrainian,spacedd.MM.yyyyUrdu.,dd/MM/yyyyVietnamese,.dd/MM/yyyyImpala DatatypeMSTR DatatypeCHARACTERCharNUMERICNumericDECIMALDecimalINTEGERIntegerSMALLINTIntegerFLOATFloatREALFloatDOUBLEDoubleDATEDateTIMETimeTIMESTAMPTimeStampVARCHARVarCharBIGINTInt64TINYINTIntegerKeysDescriptionAlt-0153™Alt-0174®Alt-0169©Alt-0137‰Alt-251√Alt-236∞Alt-243≤Alt-242≥Alt-13♪Alt-14♫Alt-23↨Alt-24↑Alt-25↓Alt-26→Alt-27←Data in email0,0,1Data in email and to history list0,1,1Data and link to history list in email1,1,1Link to history list in email1,1,0