SELECT PCMS_CHDOC_DATA.CH_DOC_ID,

              COUNT(PCMS_CHDOC_DATA_2.CH_DOC_ID) OVER (PARTITION BY PCMS_CHDOC_DATA.CH_DOC_ID) COUNT_ID,
              COUNT(PCMS_CHDOC_DATA.CH_DOC_ID) OVER () COUNT_ID_2,
              COUNT(PCMS_CHDOC_DATA_2.CH_DOC_ID) OVER () COUNT_ID_3,

              COUNT(PCMS_CHDOC_DATA.CH_DOC_ID) OVER (PARTITION BY PCMS_CHDOC_DATA_2.CH_DOC_ID) COUNT_ID_4,

              ROW_NUMBER() OVER (PARTITION BY PCMS_CHDOC_DATA.CH_DOC_ID ORDER BY PCMS_CHDOC_DATA_2.CH_DOC_ID) ROW_NUMBER,

                          DENSE_RANK () OVER (ORDER BY CONCAT(SUBSTR(PCMS_CHDOC_DATA.CH_DOC_TYPE, -1,1),

                                  DECODE(LENGTH(PCMS_CHDOC_DATA.CH_DOC_ID),
                           21, SUBSTR(PCMS_CHDOC_DATA.CH_DOC_ID, -6, 6),
                           18, CONCAT('000',SUBSTR(PCMS_CHDOC_DATA.CH_DOC_ID, -3, 3)),
                           17, CONCAT('0000',SUBSTR(PCMS_CHDOC_DATA.CH_DOC_ID, -2, 2)))))  AS MY_ROW,

             MAX(MY_ROW) AS MAX_MY_ROW,

              ROW_NUMBER() OVER (ORDER BY PCMS_CHDOC_DATA.CH_DOC_ID, PCMS_CHDOC_DATA_2.CH_DOC_ID) ROW_NUMBER_2,