PLMB1890 => IN ARRAY 사용

<query id="PLMB1890Service.selectBlockList" mappingStyle="upper">
            <statement>
            <![CDATA[
             /* PLMB1890Service.selectBlockList */
             SELECT
                  A.*
               FROM( SELECT TRIM(PROJ_NO) AS PROJ_NO,BLK_CD,MAT_NO, QTY
                       FROM PLMTB_INST_MBOM_MA T1,
                            PLMTB_MBOM T2
                      WHERE T1.BOM_ID  = T2.BOM_ID
                        AND ROWNUM < 20
                        AND TRIM(T2.PROJ_NO) IN (
                           #foreach ($PV in $piv)
                            #if ($velocityCount == 1 )
                                '$PV.SHIP'
                            #else
                                , '$PV.SHIP'
                            #end
                          #end
                              
                        ) ) P
                      PIVOT ( COUNT(QTY) FOR PROJ_NO IN ( 
                      #foreach ($PV in $piv)
                            #if ($velocityCount == 1 )
                                $PV.SHIP
                            #else
                                , $PV.SHIP, '' AS CHK$PV.SHIP
                            #end
                      #end) ) A
               ORDER BY BLK_CD,MAT_NO
            ]]>
            </statement>
        </query>