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)aaba*bca*b*cda*b*c*dea*b*c*d*eLanguageDecimalDigit 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 DatatypeCHARACTERCharNUMERICNumericDECIMALDecimalINTEGERIntegerSMALLINTIntegerFLOATFloatREALFloatDOUBLEDoubleDATEDateTIMETimeTIMESTAMPTimeStampVARCHARVarCharBIGINTInt64TINYINTInteger | 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)aaba*bca*b*cda*b*c*dea*b*c*d*eLanguageDecimalDigit 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 DatatypeCHARACTERCharNUMERICNumericDECIMALDecimalINTEGERIntegerSMALLINTIntegerFLOATFloatREALFloatDOUBLEDoubleDATEDateTIMETimeTIMESTAMPTimeStampVARCHARVarCharBIGINTInt64TINYINTInteger |
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)aaba*bca*b*cda*b*c*dea*b*c*d*eLanguageDecimalDigit 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 DatatypeCHARACTERCharNUMERICNumericDECIMALDecimalINTEGERIntegerSMALLINTIntegerFLOATFloatREALFloatDOUBLEDoubleDATEDateTIMETimeTIMESTAMPTimeStampVARCHARVarCharBIGINTInt64TINYINTInteger | 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)aaba*bca*b*cda*b*c*dea*b*c*d*eLanguageDecimalDigit 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 DatatypeCHARACTERCharNUMERICNumericDECIMALDecimalINTEGERIntegerSMALLINTIntegerFLOATFloatREALFloatDOUBLEDoubleDATEDateTIMETimeTIMESTAMPTimeStampVARCHARVarCharBIGINTInt64TINYINTInteger |
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)aaba*bca*b*cda*b*c*dea*b*c*d*eLanguageDecimalDigit 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 DatatypeCHARACTERCharNUMERICNumericDECIMALDecimalINTEGERIntegerSMALLINTIntegerFLOATFloatREALFloatDOUBLEDoubleDATEDateTIMETimeTIMESTAMPTimeStampVARCHARVarCharBIGINTInt64TINYINTInteger | 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)aaba*bca*b*cda*b*c*dea*b*c*d*eLanguageDecimalDigit 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 DatatypeCHARACTERCharNUMERICNumericDECIMALDecimalINTEGERIntegerSMALLINTIntegerFLOATFloatREALFloatDOUBLEDoubleDATEDateTIMETimeTIMESTAMPTimeStampVARCHARVarCharBIGINTInt64TINYINTInteger |
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)aaba*bca*b*cda*b*c*dea*b*c*d*eLanguageDecimalDigit 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 DatatypeCHARACTERCharNUMERICNumericDECIMALDecimalINTEGERIntegerSMALLINTIntegerFLOATFloatREALFloatDOUBLEDoubleDATEDateTIMETimeTIMESTAMPTimeStampVARCHARVarCharBIGINTInt64TINYINTInteger | 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)aaba*bca*b*cda*b*c*dea*b*c*d*eLanguageDecimalDigit 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 DatatypeCHARACTERCharNUMERICNumericDECIMALDecimalINTEGERIntegerSMALLINTIntegerFLOATFloatREALFloatDOUBLEDoubleDATEDateTIMETimeTIMESTAMPTimeStampVARCHARVarCharBIGINTInt64TINYINTInteger |
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)aaba*bca*b*cda*b*c*dea*b*c*d*eLanguageDecimalDigit 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 DatatypeCHARACTERCharNUMERICNumericDECIMALDecimalINTEGERIntegerSMALLINTIntegerFLOATFloatREALFloatDOUBLEDoubleDATEDateTIMETimeTIMESTAMPTimeStampVARCHARVarCharBIGINTInt64TINYINTInteger | 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)aaba*bca*b*cda*b*c*dea*b*c*d*eLanguageDecimalDigit 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 DatatypeCHARACTERCharNUMERICNumericDECIMALDecimalINTEGERIntegerSMALLINTIntegerFLOATFloatREALFloatDOUBLEDoubleDATEDateTIMETimeTIMESTAMPTimeStampVARCHARVarCharBIGINTInt64TINYINTInteger |
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)aaba*bca*b*cda*b*c*dea*b*c*d*eLanguageDecimalDigit 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 DatatypeCHARACTERCharNUMERICNumericDECIMALDecimalINTEGERIntegerSMALLINTIntegerFLOATFloatREALFloatDOUBLEDoubleDATEDateTIMETimeTIMESTAMPTimeStampVARCHARVarCharBIGINTInt64TINYINTInteger | 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)aaba*bca*b*cda*b*c*dea*b*c*d*eLanguageDecimalDigit 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 DatatypeCHARACTERCharNUMERICNumericDECIMALDecimalINTEGERIntegerSMALLINTIntegerFLOATFloatREALFloatDOUBLEDoubleDATEDateTIMETimeTIMESTAMPTimeStampVARCHARVarCharBIGINTInt64TINYINTInteger |
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)aaba*bca*b*cda*b*c*dea*b*c*d*eLanguageDecimalDigit 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 DatatypeCHARACTERCharNUMERICNumericDECIMALDecimalINTEGERIntegerSMALLINTIntegerFLOATFloatREALFloatDOUBLEDoubleDATEDateTIMETimeTIMESTAMPTimeStampVARCHARVarCharBIGINTInt64TINYINTInteger | 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)aaba*bca*b*cda*b*c*dea*b*c*d*eLanguageDecimalDigit 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 DatatypeCHARACTERCharNUMERICNumericDECIMALDecimalINTEGERIntegerSMALLINTIntegerFLOATFloatREALFloatDOUBLEDoubleDATEDateTIMETimeTIMESTAMPTimeStampVARCHARVarCharBIGINTInt64TINYINTInteger |
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)aaba*bca*b*cda*b*c*dea*b*c*d*eLanguageDecimalDigit 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 DatatypeCHARACTERCharNUMERICNumericDECIMALDecimalINTEGERIntegerSMALLINTIntegerFLOATFloatREALFloatDOUBLEDoubleDATEDateTIMETimeTIMESTAMPTimeStampVARCHARVarCharBIGINTInt64TINYINTInteger | 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)aaba*bca*b*cda*b*c*dea*b*c*d*eLanguageDecimalDigit 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 DatatypeCHARACTERCharNUMERICNumericDECIMALDecimalINTEGERIntegerSMALLINTIntegerFLOATFloatREALFloatDOUBLEDoubleDATEDateTIMETimeTIMESTAMPTimeStampVARCHARVarCharBIGINTInt64TINYINTInteger |
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)aaba*bca*b*cda*b*c*dea*b*c*d*eLanguageDecimalDigit 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 DatatypeCHARACTERCharNUMERICNumericDECIMALDecimalINTEGERIntegerSMALLINTIntegerFLOATFloatREALFloatDOUBLEDoubleDATEDateTIMETimeTIMESTAMPTimeStampVARCHARVarCharBIGINTInt64TINYINTInteger | 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)aaba*bca*b*cda*b*c*dea*b*c*d*eLanguageDecimalDigit 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 DatatypeCHARACTERCharNUMERICNumericDECIMALDecimalINTEGERIntegerSMALLINTIntegerFLOATFloatREALFloatDOUBLEDoubleDATEDateTIMETimeTIMESTAMPTimeStampVARCHARVarCharBIGINTInt64TINYINTInteger |
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)aaba*bca*b*cda*b*c*dea*b*c*d*eLanguageDecimalDigit 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 DatatypeCHARACTERCharNUMERICNumericDECIMALDecimalINTEGERIntegerSMALLINTIntegerFLOATFloatREALFloatDOUBLEDoubleDATEDateTIMETimeTIMESTAMPTimeStampVARCHARVarCharBIGINTInt64TINYINTInteger | 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)aaba*bca*b*cda*b*c*dea*b*c*d*eLanguageDecimalDigit 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 DatatypeCHARACTERCharNUMERICNumericDECIMALDecimalINTEGERIntegerSMALLINTIntegerFLOATFloatREALFloatDOUBLEDoubleDATEDateTIMETimeTIMESTAMPTimeStampVARCHARVarCharBIGINTInt64TINYINTInteger |
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)aaba*bca*b*cda*b*c*dea*b*c*d*eLanguageDecimalDigit 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 DatatypeCHARACTERCharNUMERICNumericDECIMALDecimalINTEGERIntegerSMALLINTIntegerFLOATFloatREALFloatDOUBLEDoubleDATEDateTIMETimeTIMESTAMPTimeStampVARCHARVarCharBIGINTInt64TINYINTInteger | 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)aaba*bca*b*cda*b*c*dea*b*c*d*eLanguageDecimalDigit 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 DatatypeCHARACTERCharNUMERICNumericDECIMALDecimalINTEGERIntegerSMALLINTIntegerFLOATFloatREALFloatDOUBLEDoubleDATEDateTIMETimeTIMESTAMPTimeStampVARCHARVarCharBIGINTInt64TINYINTInteger |
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)aaba*bca*b*cda*b*c*dea*b*c*d*eLanguageDecimalDigit 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 DatatypeCHARACTERCharNUMERICNumericDECIMALDecimalINTEGERIntegerSMALLINTIntegerFLOATFloatREALFloatDOUBLEDoubleDATEDateTIMETimeTIMESTAMPTimeStampVARCHARVarCharBIGINTInt64TINYINTInteger | 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)aaba*bca*b*cda*b*c*dea*b*c*d*eLanguageDecimalDigit 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 DatatypeCHARACTERCharNUMERICNumericDECIMALDecimalINTEGERIntegerSMALLINTIntegerFLOATFloatREALFloatDOUBLEDoubleDATEDateTIMETimeTIMESTAMPTimeStampVARCHARVarCharBIGINTInt64TINYINTInteger |
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)aaba*bca*b*cda*b*c*dea*b*c*d*eLanguageDecimalDigit 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 DatatypeCHARACTERCharNUMERICNumericDECIMALDecimalINTEGERIntegerSMALLINTIntegerFLOATFloatREALFloatDOUBLEDoubleDATEDateTIMETimeTIMESTAMPTimeStampVARCHARVarCharBIGINTInt64TINYINTInteger | 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)aaba*bca*b*cda*b*c*dea*b*c*d*eLanguageDecimalDigit 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 DatatypeCHARACTERCharNUMERICNumericDECIMALDecimalINTEGERIntegerSMALLINTIntegerFLOATFloatREALFloatDOUBLEDoubleDATEDateTIMETimeTIMESTAMPTimeStampVARCHARVarCharBIGINTInt64TINYINTInteger |
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)aaba*bca*b*cda*b*c*dea*b*c*d*eLanguageDecimalDigit 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 DatatypeCHARACTERCharNUMERICNumericDECIMALDecimalINTEGERIntegerSMALLINTIntegerFLOATFloatREALFloatDOUBLEDoubleDATEDateTIMETimeTIMESTAMPTimeStampVARCHARVarCharBIGINTInt64TINYINTInteger | 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)aaba*bca*b*cda*b*c*dea*b*c*d*eLanguageDecimalDigit 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 DatatypeCHARACTERCharNUMERICNumericDECIMALDecimalINTEGERIntegerSMALLINTIntegerFLOATFloatREALFloatDOUBLEDoubleDATEDateTIMETimeTIMESTAMPTimeStampVARCHARVarCharBIGINTInt64TINYINTInteger |
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)aaba*bca*b*cda*b*c*dea*b*c*d*eLanguageDecimalDigit 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 DatatypeCHARACTERCharNUMERICNumericDECIMALDecimalINTEGERIntegerSMALLINTIntegerFLOATFloatREALFloatDOUBLEDoubleDATEDateTIMETimeTIMESTAMPTimeStampVARCHARVarCharBIGINTInt64TINYINTInteger | 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)aaba*bca*b*cda*b*c*dea*b*c*d*eLanguageDecimalDigit 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 DatatypeCHARACTERCharNUMERICNumericDECIMALDecimalINTEGERIntegerSMALLINTIntegerFLOATFloatREALFloatDOUBLEDoubleDATEDateTIMETimeTIMESTAMPTimeStampVARCHARVarCharBIGINTInt64TINYINTInteger |
