SELECT 

    pmds008,

    pmaal004,

    to_char(pmds001, 'yyyy-mm-dd')  pmds001,

    pmdsdocno,

    pmds000,

    decode(pmds011, 1, '1:一般采购', 2, '2:委外采购')  pmds011,

    CASE 

        WHEN substr(pmdt001, 4, 5) = 'PM120' THEN '采购单-期初'

        WHEN substr(pmdt001, 4, 5) = 'PM121' THEN '采购单'

        WHEN substr(pmdt001, 4, 5) = 'PM124' THEN '手工样采购单'

        WHEN substr(pmdt001, 4, 5) = 'PM125' THEN '换货采购单'

        WHEN substr(pmdt001, 4, 5) = 'PM130' THEN '委外采购单-期初'

        WHEN substr(pmdt001, 4, 5) = 'PM131' THEN '委外采购单--取核价'

        WHEN substr(pmdt001, 4, 5) = '' THEN '无'

        WHEN substr(pmdt001, 4, 5) = 'PM132' THEN '委外采购单--0单价'

        ELSE NULL

    END  lx,

    pmdtseq,

    pmdt001,

    pmdl002,

    ooag011,

    cz,

    pmdt006,

    imaal003,

    imaal004,

    pmdt009,

    oocql004,

    pmdt020,

    pmdt019,

    pmdt046,

    oodbl004,

    pmdt037,

    pmdt036,

    pmdt038,

    pmdt039,

    pmdt047,

    pmds006,

    pmdb050,

    imaa017,

    pmdl044,

    pmdp003  请购单号,

    pmda002  请购人工号,

    oofa011  请购人姓名,

    pmda003  部门编号,

    ooefl003  部门名称,

    pmdt036  单价

FROM (

    SELECT 

        a.pmds008,

        c.pmaal004,

        a.pmds001,

        a.pmdsdocno,

        a.pmds000,

        a.pmds011,

        b.pmdt001,

        b.pmdtseq,

        b.pmdt006,

        b.pmdt009,

        b.pmdt020,

        b.pmdt019,

        b.pmdt046,

        b.pmdt037,

        b.pmdt036,

        b.pmdt038,

        b.pmdt039,

        b.pmdt047,

        a.pmds006,

        pmdb050,

        d.imaa017,

        pmdl002,

        pmdl044,

        pmdp003,

        pmda002,

        oofa011,

        pmda003,

        ooefl003,

        e.oodbl004,

        f.oocql004,

        d.cz,

        imaal003,

        imaal004,

        ooag011,

        ROW_NUMBER() OVER (PARTITION BY pmdp003 ORDER BY a.pmds008, a.pmdsdocno, b.pmdt001)  rn

    FROM 

        pmds_t a

    JOIN 

        pmdt_t b

    ON 

        b.pmdtent = a.pmdsent

        AND b.pmdtsite = a.pmdssite

        AND b.pmdtdocno = a.pmdsdocno

    JOIN 

        pmaal_t c

    ON 

        pmaalent = pmdsent

        AND pmaal001 = pmds008

        AND pmaal002 = 'zh_CN'

    LEFT JOIN 

        BASIC料件001 d

    ON 

        d.ent = b.pmdtent

        AND site = '100'

        AND d.imaa001 = b.pmdt006

    LEFT JOIN 

        oodbl_t e

    ON 

        oodblent = pmdtent

        AND oodbl002 = pmdt046

        AND oodbl003 = 'zh_CN'

    LEFT JOIN 

        oocql_t f

    ON 

        f.oocqlent = pmdtent

        AND f.oocql002 = pmdt009

        AND f.oocql003 = 'zh_CN'

    LEFT JOIN 

        pmdl_t

    ON 

        pmdlent = pmdtent

        AND pmdlsite = pmdtsite

        AND pmdldocno = pmdt001

    LEFT JOIN 

        pmdp_t

    ON 

        pmdpdocno = pmdldocno

        AND pmdpent = '88'

        AND pmdpsite = '100'

        and b.pmdt006 = pmdp001

    LEFT JOIN 

        pmda_t

    ON 

        pmdp003 = pmdadocno

        AND pmdaent = '88'

        AND pmdasite = '100'

    LEFT JOIN 

        oofa_t

    ON 

        oofa003 = pmda002

        AND oofaent = '88'

        AND oofastus = 'Y'

    LEFT JOIN 

        ooefl_t

    ON 

        pmda003 = ooefl001

        AND ooeflent = '88'

        AND ooefl002 = 'zh_CN'

    LEFT JOIN 

        pmdb_t

    ON 

        pmdadocno = pmdbdocno

    and pmdp001 = pmdb004

    LEFT JOIN 

        ooag_t

    ON 

        ooagent = pmdlent

        AND ooag001 = pmdl002

    WHERE 

        pmdsent = 88

        AND pmdssite = '100'

        AND pmdsstus = 'S'

       AND pmds001 >= TO_DATE('${过账日期起}', 'yyyy-mm-dd')

       AND pmds001 <= TO_DATE('${过账日期止}', 'yyyy-mm-dd')

       AND pmdt036 BETWEEN TO_NUMBER('${单价起}') AND TO_NUMBER('${单价止}')

) subquery

WHERE 

    rn = 1

ORDER BY 

    pmds008, pmdsdocno, pmdt001

 decode(pmds011, 1, '1:一般采购', 2, '2:委外采购')  pmds011,

    CASE 

        WHEN substr(pmdt001, 4, 5) = 'PM120' THEN '采购单-期初'

        WHEN substr(pmdt001, 4, 5) = 'PM121' THEN '采购单'

        WHEN substr(pmdt001, 4, 5) = 'PM124' THEN '手工样采购单'

        WHEN substr(pmdt001, 4, 5) = 'PM125' THEN '换货采购单'

        WHEN substr(pmdt001, 4, 5) = 'PM130' THEN '委外采购单-期初'

        WHEN substr(pmdt001, 4, 5) = 'PM131' THEN '委外采购单--取核价'

        WHEN substr(pmdt001, 4, 5) = '' THEN '无'

        WHEN substr(pmdt001, 4, 5) = 'PM132' THEN '委外采购单--0单价'

        ELSE NULL

    END  lx,

为什么我表头加的这个筛选条件没实现呢