DECLARE @P1 NVARCHAR(8)
        ,@P2 NVARCHAR(5)
        ,@P3 NVARCHAR(21)
        ,@P4 NVARCHAR(21)
        ,@P5 NVARCHAR(5)
        ,@P6 NVARCHAR(21)
        ,@P7 NVARCHAR(5)
        ,@P8 BIGINT
        ,@P9 NVARCHAR(21)
        ,@P10 NVARCHAR(5)
        ,@P11 BIGINT
        ,@P12 NVARCHAR(21)
        ,@P13 NVARCHAR(5)
        ,@P14 NVARCHAR(61)
        ,@P15 BIGINT
        ,@P16 NVARCHAR(8)
        ,@P17 BIGINT
        ,@P18 NVARCHAR(21)
        ,@P19 NVARCHAR(21)
        ,@P20 NVARCHAR(5)
        ,@P21 NVARCHAR(21)
        ,@P22 NVARCHAR(5)
        ,@P23 BIGINT
        ,@P24 NVARCHAR(21)
        ,@P25 NVARCHAR(5)
        ,@P26 BIGINT
        ,@P27 NVARCHAR(21)
        ,@P28 NVARCHAR(5)
        ,@P29 NVARCHAR(61)
        ,@P30 BIGINT
        ,@P31 NVARCHAR(8)
        ,@P32 BIGINT
        ,@P33 NVARCHAR(21)
        ,@P34 NVARCHAR(21)
        ,@P35 NVARCHAR(5)
        ,@P36 NVARCHAR(21)
        ,@P37 NVARCHAR(5)
        ,@P38 BIGINT
        ,@P39 NVARCHAR(21)
        ,@P40 NVARCHAR(5)
        ,@P41 BIGINT
        ,@P42 NVARCHAR(21)
        ,@P43 NVARCHAR(5)
        ,@P44 NVARCHAR(61)
        ,@P45 BIGINT
        ,@P46 NVARCHAR(8)
        ,@P47 NVARCHAR(21)
        ,@P48 NVARCHAR(21)
        ,@P49 NVARCHAR(5)
        ,@P50 NVARCHAR(21)
        ,@P51 NVARCHAR(5)
        ,@P52 BIGINT
        ,@P53 NVARCHAR(21)
        ,@P54 NVARCHAR(5)
        ,@P55 BIGINT
        ,@P56 NVARCHAR(21)
        ,@P57 NVARCHAR(5)
        ,@P58 NVARCHAR(61)
        ,@P59 BIGINT
        ,@P60 NVARCHAR(8)
        ,@P61 NVARCHAR(21)
        ,@P62 NVARCHAR(21)
        ,@P63 NVARCHAR(5)
        ,@P64 NVARCHAR(21)
        ,@P65 NVARCHAR(5)
        ,@P66 BIGINT
        ,@P67 NVARCHAR(21)
        ,@P68 NVARCHAR(5)
        ,@P69 BIGINT
        ,@P70 NVARCHAR(21)
        ,@P71 NVARCHAR(5)
        ,@P72 NVARCHAR(61)
        ,@P73 BIGINT
        ,@P74 NVARCHAR(21)
        ,@P75 NVARCHAR(21)
        ,@P76 NVARCHAR(5)
        ,@P77 NVARCHAR(21)
        ,@P78 NVARCHAR(5)
        ,@P79 BIGINT
        ,@P80 NVARCHAR(21)
        ,@P81 NVARCHAR(5)
        ,@P82 BIGINT
        ,@P83 NVARCHAR(21)
        ,@P84 NVARCHAR(5)
        ,@P85 NVARCHAR(61)
        ,@P86 NVARCHAR(21)
        ,@P87 NVARCHAR(21)
        ,@P88 NVARCHAR(5)
        ,@P89 NVARCHAR(21)
        ,@P90 NVARCHAR(5)
        ,@P91 BIGINT
        ,@P92 NVARCHAR(21)
        ,@P93 NVARCHAR(5)
        ,@P94 BIGINT
        ,@P95 NVARCHAR(21)
        ,@P96 NVARCHAR(5)
        ,@P97 NVARCHAR(61)
        ,@P98 NVARCHAR(21)
        ,@P99 NVARCHAR(21)
        ,@P100 NVARCHAR(5)
        ,@P101 NVARCHAR(21)
        ,@P102 NVARCHAR(5)
        ,@P103 BIGINT
        ,@P104 NVARCHAR(21)
        ,@P105 NVARCHAR(5)
        ,@P106 BIGINT
        ,@P107 NVARCHAR(21)
        ,@P108 NVARCHAR(5)
        ,@P109 NVARCHAR(21)
        ,@P110 NVARCHAR(21)
        ,@P111 NVARCHAR(5)
        ,@P112 NVARCHAR(21)
        ,@P113 NVARCHAR(5)
        ,@P114 BIGINT
        ,@P115 NVARCHAR(21)
        ,@P116 NVARCHAR(5)
        ,@P117 BIGINT
        ,@P118 NVARCHAR(21)
        ,@P119 NVARCHAR(21)
        ,@P120 NVARCHAR(21)
        ,@P121 NVARCHAR(5)
        ,@P122 NVARCHAR(21)
        ,@P123 NVARCHAR(5)
        ,@P124 BIGINT
        ,@P125 NVARCHAR(21)
        ,@P126 NVARCHAR(5)
        ,@P127 BIGINT
        ,@P128 NVARCHAR(21)
        ,@P129 NVARCHAR(21)
        ,@P130 NVARCHAR(5)
        ,@P131 NVARCHAR(21)
        ,@P132 NVARCHAR(5)
        ,@P133 BIGINT
        ,@P134 NVARCHAR(21)
        ,@P135 NVARCHAR(5)
        ,@P136 NVARCHAR(21)
        ,@P137 NVARCHAR(21)
        ,@P138 NVARCHAR(5)
        ,@P139 NVARCHAR(21)
        ,@P140 NVARCHAR(5)
        ,@P141 BIGINT
        ,@P142 NVARCHAR(21)
        ,@P143 NVARCHAR(21)
        ,@P144 NVARCHAR(21)
        ,@P145 NVARCHAR(5)
        ,@P146 NVARCHAR(21)
        ,@P147 NVARCHAR(5)
        ,@P148 BIGINT
        ,@P149 NVARCHAR(21)
        ,@P150 NVARCHAR(21)
        ,@P151 NVARCHAR(5)
        ,@P152 NVARCHAR(21)
        ,@P153 NVARCHAR(5)
        ,@P154 NVARCHAR(21)
        ,@P155 NVARCHAR(21)
        ,@P156 NVARCHAR(5)
        ,@P157 NVARCHAR(21)
        ,@P158 NVARCHAR(21)
        ,@P159 NVARCHAR(21)
        ,@P160 NVARCHAR(5)
        ,@P161 NVARCHAR(21)
        ,@P162 NVARCHAR(21)
        ,@P163 NVARCHAR(21)
        ,@P164 BIGINT
        ,@P165 BIGINT
        ,@P166 BIGINT

SELECT T1.ITEMID
        ,T1.ITEMTYPE
        ,T1.PURCHMODEL
        ,T1.HEIGHT
        ,T1.WIDTH
        ,T1.SALESMODEL
        ,T1.COSTGROUPID
        ,T1.REQGROUPID
        ,T1.EPCMANAGER
        ,T1.PRIMARYVENDORID
        ,T1.NETWEIGHT
        ,T1.DEPTH
        ,T1.UNITVOLUME
        ,T1.BOMUNITID
        ,T1.ITEMPRICETOLERANCEGROUPID
        ,T1.DENSITY
        ,T1.COSTMODEL
        ,T1.USEALTITEMID
        ,T1.ALTITEMID
        ,T1.MATCHINGPOLICY
        ,T1.INTRACODE
        ,T1.PRODFLUSHINGPRINCIP
        ,T1.MINIMUMPALLETQUANTITY
        ,T1.PBAITEMAUTOGENERATED
        ,T1.WMSARRIVALHANDLINGTIME
        ,T1.BOMMANUALRECEIPT
        ,T1.PHANTOM
        ,T1.INTRAUNIT
        ,T1.BOMLEVEL
        ,T1.BATCHNUMGROUPID
        ,T1.AUTOREPORTFINISHED
        ,T1.ORIGCOUNTRYREGIONID
        ,T1.STATISTICSFACTOR
        ,T1.ALTCONFIGID
        ,T1.STANDARDCONFIGID
        ,T1.PRODPOOLID
        ,T1.PROPERTYID
        ,T1.ABCTIEUP
        ,T1.ABCREVENUE
        ,T1.ABCVALUE
        ,T1.ABCCONTRIBUTIONMARGIN
        ,T1.COMMISSIONGROUPID
        ,T1.SALESPERCENTMARKUP
        ,T1.SALESCONTRIBUTIONRATIO
        ,T1.SALESPRICEMODELBASIC
        ,T1.NAMEALIAS
        ,T1.PRODGROUPID
        ,T1.PROJCATEGORYID
        ,T1.GROSSDEPTH
        ,T1.GROSSWIDTH
        ,T1.GROSSHEIGHT
        ,T1.STANDARDPALLETQUANTITY
        ,T1.QTYPERLAYER
        ,T1.SORTCODE
        ,T1.SERIALNUMGROUPID
        ,T1.ITEMBUYERGROUPID
        ,T1.TAXPACKAGINGQTY
        ,T1.WMSPALLETTYPEID
        ,T1.ORIGSTATEID
        ,T1.WMSPICKINGQTYTIME
        ,T1.TARAWEIGHT
        ,T1.PACKAGINGGROUPID
        ,T1.SCRAPVAR
        ,T1.SCRAPCONST
        ,T1.STANDARDINVENTCOLORID
        ,T1.STANDARDINVENTSIZEID
        ,T1.ITEMDIMCOSTPRICE
        ,T1.ALTINVENTSIZEID
        ,T1.ALTINVENTCOLORID
        ,T1.FORECASTDMPINCLUDE
        ,T1.PRODUCT
        ,T1.DEFAULTDIMENSION
        ,T1.FISCALLIFOAVOIDCALC
        ,T1.FISCALLIFONORMALVALUE
        ,T1.FISCALLIFONORMALVALUECALC
        ,T1.BOMCALCGROUPID
        ,T1.INVENTFISCALLIFOGROUP
        ,T1.NGPCODESTABLE_FR
        ,T1.ORIGCOUNTYID
        ,T1.PBAITEMCONFIGURABLE
        ,T1.PBAINVENTITEMGROUPID
        ,T1.PBAHIDEDIALOG
        ,T1.PBAHIDEAPPROVAL
        ,T1.PBAAUTOSTART
        ,T1.PBAMANDATORYCONFIG
        ,T1.PMFYIELDPCT
        ,T1.PMFPLANNINGITEMID
        ,T1.PMFPRODUCTTYPE
        ,T1.PDSFREIGHTALLOCATIONGROUPID
        ,T1.PDSITEMREBATEGROUPID
        ,T1.PDSVENDORCHECKITEM
        ,T1.ADUSURFACEAREA
        ,T1.ADUINTERNALPALLET
        ,T1.ADULABELPACKAGE
        ,T1.ADULABELPALLET
        ,T1.ADUNEWPRODUCT
        ,T1.ADUBOMMEASUREAREA
        ,T1.ADUBOMMEASUREAREAFORMULA
        ,T1.ADUBOMMEASURECOEFFICIENT
        ,T1.ADUBOMMEASUREPERIMETER
        ,T1.ADUSURFACEMASS
        ,T1.ADUSURFACETREATMENT
        ,T1.ADUSHIPONPALLET
        ,T1.MODIFIEDDATETIME
        ,T1.CREATEDDATETIME
        ,T1.RECVERSION
        ,T1.RECID
        ,T2.ITEMDATAAREAID
        ,T2.MODELGROUPID
        ,T2.ITEMID
        ,T2.MODELGROUPDATAAREAID
        ,T2.RECVERSION
        ,T2.RECID
        ,T3.ITEMID
        ,T3.ITEMDATAAREAID
        ,T3.ITEMGROUPID
        ,T3.ITEMGROUPDATAAREAID
        ,T3.RECVERSION
        ,T3.RECID
        ,T4.TRACKINGDIMENSIONGROUP
        ,T4.ITEMID
        ,T4.ITEMDATAAREAID
        ,T4.RECVERSION
        ,T4.RECID
        ,T5.STORAGEDIMENSIONGROUP
        ,T5.ITEMID
        ,T5.ITEMDATAAREAID
        ,T5.RECVERSION
        ,T5.RECID
        ,T6.INSTANCERELATIONTYPE
        ,T6.DISPLAYPRODUCTNUMBER
        ,T6.SEARCHNAME
        ,T6.PRODUCTTYPE
        ,T6.RECVERSION
        ,T6.RELATIONTYPE
        ,T6.RECID
        ,T7.VARIANTCONFIGURATIONTECHNOLOGY
        ,T7.RECVERSION
        ,T7.RELATIONTYPE
        ,T7.RECID
        ,T8.RECVERSION
        ,T8.RELATIONTYPE
        ,T8.RECID
        ,T9.PRODUCTMASTER
        ,T9.RECVERSION
        ,T9.RELATIONTYPE
        ,T9.RECID
        ,T10.PRODUCTDIMENSIONGROUP
        ,T10.PRODUCT
        ,T10.RECID
        ,T10.RECVERSION
        ,T11.NAME
        ,T11.PRODUCT
        ,T11.LANGUAGEID
        ,T11.RECID
        ,T11.RECVERSION
        ,T12.NAME
        ,T12.RECID
        ,T12.RECVERSION
FROM INVENTTABLE T1
LEFT JOIN INVENTMODELGROUPITEM T2 ON (
               (T1.ITEMID = T2.ITEMID)
               AND (T1.DATAAREAID = T2.ITEMDATAAREAID)
               )
LEFT JOIN INVENTITEMGROUPITEM T3 ON (
               (T1.ITEMID = T3.ITEMID)
               AND (T1.DATAAREAID = T3.ITEMDATAAREAID)
               )
LEFT JOIN ECORESTRACKINGDIMENSIONGROUPITEM T4 ON (
               (T1.ITEMID = T4.ITEMID)
               AND (T1.DATAAREAID = T4.ITEMDATAAREAID)
               )
LEFT JOIN ECORESSTORAGEDIMENSIONGROUPITEM T5 ON (
               (T1.ITEMID = T5.ITEMID)
               AND (T1.DATAAREAID = T5.ITEMDATAAREAID)
               )
CROSS JOIN ECORESPRODUCT T6
LEFT JOIN ECORESPRODUCTMASTER T7 ON (T6.RECID = T7.RECID)
LEFT JOIN ECORESDISTINCTPRODUCT T8 ON (T6.RECID = T8.RECID)
LEFT JOIN ECORESDISTINCTPRODUCTVARIANT T9 ON (T8.RECID = T9.RECID)
LEFT JOIN ECORESPRODUCTDIMENSIONGROUPPRODUCT T10 ON (T7.RECID = T10.PRODUCT)
LEFT JOIN ECORESPRODUCTTRANSLATION T11 ON (
               (T11.LANGUAGEID = @P1)
               AND (T6.RECID = T11.PRODUCT)
               )
LEFT JOIN ECORESPRODUCTDIMENSIONGROUP T12 ON (T10.PRODUCTDIMENSIONGROUP = T12.RECID)
WHERE (
               (T1.DATAAREAID = @P2)
               AND (
                       (
                               (
                                      (
                                              (
                                                     (
                                                             (
                                                                     (
                                                                            (
                                                                                    (
                                                                                        (
                                                                                            (
                                                                                                   (
                                                                                                           (
                                                                                                                   (
                                                                                                                          (
                                                                                                                           (
                                                                                                                                 (
                                                                                                                                       (
                                                                                                                                             (
                                                                                                                                                   (
                                                                                                                                                         (
                                                                                                                                                               (
                                                                                                                                                                     (
                                                                                                                                                                          (
                                                                                                                                                                                (
                                                                                                                                                                                      (
                                                                                                                                                                                            (
                                                                                                                                                                                                  (
                                                                                                                                                                                                        (
                                                                                                                                                                                                              (
                                                                                                                                                                                                                    (
                                                                                                                                                                                                                         (
                                                                                                                                                                                                                               (
                                                                                                                                                                                                                                     (T1.ITEMID = @P3)
                                                                                                                                                                                                                                     AND (T2.ITEMID = @P4)
                                                                                                                                                                                                                                     )
                                                                                                                                                                                                                               AND (T2.ITEMDATAAREAID = @P5)
                                                                                                                                                                                                                               )
                                                                                                                                                                                                                         AND (T3.ITEMID = @P6)
                                                                                                                                                                                                                         )
                                                                                                                                                                                                                    AND (T3.ITEMDATAAREAID = @P7)
                                                                                                                                                                                                                    )
                                                                                                                                                                                                              AND (T4.TRACKINGDIMENSIONGROUP = @P8)
                                                                                                                                                                                                              )
                                                                                                                                                                                                        AND (T4.ITEMID = @P9)
                                                                                                                                                                                                        )
                                                                                                                                                                                                  AND (T4.ITEMDATAAREAID = @P10)
                                                                                                                                                                                                  )
                                                                                                                                                                                            AND (T5.STORAGEDIMENSIONGROUP = @P11)
                                                                                                                                                                                             )
                                                                                                                                                                                      AND (T5.ITEMID = @P12)
                                                                                                                                                                                      )
                                                                                                                                                                                AND (T5.ITEMDATAAREAID = @P13)
                                                                                                                                                                                )
                                                                                                                                                                          AND (T6.DISPLAYPRODUCTNUMBER = @P14)
                                                                                                                                                                          )
                                                                                                                                                                     AND (T10.PRODUCT IS NULL)
                                                                                                                                                                     )
                                                                                                                                                               AND (T11.PRODUCT = @P15)
                                                                                                                                                               )
                                                                                                                                                         AND (T11.LANGUAGEID = @P16)
                                                                                                                                                         )
                                                                                                                                                   AND (T12.NAME IS NULL)
                                                                                                                                                   )
                                                                                                                                             AND (T6.RECID = @P17)
                                                                                                                                             )
                                                                                                                                       AND (T12.RECID IS NULL)
                                                                                                                                       )
                                                                                                                                 OR (
                                                                                                                                       (
                                                                                                                                             (
                                                                                                                                                   (
                                                                                                                                                         (
                                                                                                                                                               (
                                                                                                                                                                     (
                                                                                                                                                                          (
                                                                                                                                                                                (
                                                                                                                                                                                      (
                                                                                                                                                                                            (
                                                                                                                                                                                                  (
                                                                                                                                                                                                       (
                                                                                                                                                                                                              (
                                                                                                                                                                                                                    (
                                                                                                                                                                                                                         (
                                                                                                                                                                                                                               (T1.ITEMID = @P18)
                                                                                                                                                                                                                               AND (T2.ITEMID = @P19)
                                                                                                                                                                                                                               )
                                                                                                                                                                                                                         AND (T2.ITEMDATAAREAID = @P20)
                                                                                                                                                                                                                         )
                                                                                                                                                                                                                    AND (T3.ITEMID = @P21)
                                                                                                                                                                                                                    )
                                                                                                                                                                                                              AND (T3.ITEMDATAAREAID = @P22)
                                                                                                                                                                                                              )
                                                                                                                                                                                                        AND (T4.TRACKINGDIMENSIONGROUP = @P23)
                                                                                                                                                                                                        )
                                                                                                                                                                                                  AND (T4.ITEMID = @P24)
                                                                                                                                                                                                  )
                                                                                                                                                                                            AND (T4.ITEMDATAAREAID = @P25)
                                                                                                                                                                                            )
                                                                                                                                                                                      AND (T5.STORAGEDIMENSIONGROUP = @P26)
                                                                                                                                                                                      )
                                                                                                                                                                                AND (T5.ITEMID = @P27)
                                                                                                                                                                                )
                                                                                                                                                                           AND (T5.ITEMDATAAREAID = @P28)
                                                                                                                                                                          )
                                                                                                                                                                     AND (T6.DISPLAYPRODUCTNUMBER = @P29)
                                                                                                                                                                     )
                                                                                                                                                               AND (T10.PRODUCT IS NULL)
                                                                                                                                                               )
                                                                                                                                                        AND (T11.PRODUCT = @P30)
                                                                                                                                                         )
                                                                                                                                                   AND (T11.LANGUAGEID = @P31)
                                                                                                                                                   )
                                                                                                                                             AND (T12.NAME IS NULL)
                                                                                                                                             )
                                                                                                                                       AND (T6.RECID > @P32)
                                                                                                                                       )
                                                                                                                                 )
                                                                                                                           OR (
                                                                                                                                 (
                                                                                                                                       (
                                                                                                                                             (
                                                                                                                                                   (
                                                                                                                                                         (
                                                                                                                                                               (
                                                                                                                                                                     (
                                                                                                                                                                          (
                                                                                                                                                                                 (
                                                                                                                                                                                      (
                                                                                                                                                                                            (
                                                                                                                                                                                                  (
                                                                                                                                                                                                        (
                                                                                                                                                                                                              (
                                                                                                                                                                                                                    (T1.ITEMID = @P33)
                                                                                                                                                                                                                   AND (T2.ITEMID = @P34)
                                                                                                                                                                                                                    )
                                                                                                                                                                                                              AND (T2.ITEMDATAAREAID = @P35)
                                                                                                                                                                                                              )
                                                                                                                                                                                                        AND (T3.ITEMID = @P36)
                                                                                                                                                                                                        )
                                                                                                                                                                                                  AND (T3.ITEMDATAAREAID = @P37)
                                                                                                                                                                                                  )
                                                                                                                                                                                            AND (T4.TRACKINGDIMENSIONGROUP = @P38)
                                                                                                                                                                                            )
                                                                                                                                                                                      AND (T4.ITEMID = @P39)
                                                                                                                                                                                      )
                                                                                                                                                                                AND (T4.ITEMDATAAREAID = @P40)
                                                                                                                                                                                )
                                                                                                                                                                          AND (T5.STORAGEDIMENSIONGROUP = @P41)
                                                                                                                                                                          )
                                                                                                                                                                     AND (T5.ITEMID = @P42)
                                                                                                                                                                     )
                                                                                                                                                               AND (T5.ITEMDATAAREAID = @P43)
                                                                                                                                                               )
                                                                                                                                                         AND (T6.DISPLAYPRODUCTNUMBER = @P44)
                                                                                                                                                         )
                                                                                                                                                   AND (T10.PRODUCT IS NULL)
                                                                                                                                                   )
                                                                                                                                             AND (T11.PRODUCT = @P45)
                                                                                                                                             )
                                                                                                                                       AND (T11.LANGUAGEID = @P46)
                                                                                                                                       )
                                                                                                                                 AND NOT ((T12.NAME IS NULL))
                                                                                                                                 )
                                                                                                                           )
                                                                                                                          OR (
                                                                                                                            (
                                                                                                                                 (
                                                                                                                                       (
                                                                                                                                             (
                                                                                                                                                   (
                                                                                                                                                         (
                                                                                                                                                               (
                                                                                                                                                                     (
                                                                                                                                                                          (
                                                                                                                                                                                (
                                                                                                                                                                                      (
                                                                                                                                                                                            (
                                                                                                                                                                                                  (
                                                                                                                                                                                                        (T1.ITEMID = @P47)
                                                                                                                                                                                                        AND (T2.ITEMID = @P48)
                                                                                                                                                                                                        )
                                                                                                                                                                                                  AND (T2.ITEMDATAAREAID = @P49)
                                                                                                                                                                                                  )
                                                                                                                                                                                            AND (T3.ITEMID = @P50)
                                                                                                                                                                                            )
                                                                                                                                                                                      AND (T3.ITEMDATAAREAID = @P51)
                                                                                                                                                                                      )
                                                                                                                                                                                AND (T4.TRACKINGDIMENSIONGROUP = @P52)
                                                                                                                                                                                )
                                                                                                                                                                          AND (T4.ITEMID = @P53)
                                                                                                                                                                          )
                                                                                                                                                                     AND (T4.ITEMDATAAREAID = @P54)
                                                                                                                                                                     )
                                                                                                                                                               AND (T5.STORAGEDIMENSIONGROUP = @P55)
                                                                                                                                                               )
                                                                                                                                                         AND (T5.ITEMID = @P56)
                                                                                                                                                         )
                                                                                                                                                   AND (T5.ITEMDATAAREAID = @P57)
                                                                                                                                                   )
                                                                                                                                             AND (T6.DISPLAYPRODUCTNUMBER = @P58)
                                                                                                                                             )
                                                                                                                                       AND (T10.PRODUCT IS NULL)
                                                                                                                                       )
                                                                                                                                 AND (T11.PRODUCT = @P59)
                                                                                                                                 )
                                                                                                                           AND (T11.LANGUAGEID > @P60)
                                                                                                                           )
                                                                                                                          )
                                                                                                                   OR (
                                                                                                                          (
                                                                                                                           (
                                                                                                                                 (
                                                                                                                                       (
                                                                                                                                             (
                                                                                                                                                   (
                                                                                                                                                         (
                                                                                                                                                               (
                                                                                                                                                                     (
                                                                                                                                                                          (
                                                                                                                                                                                 (
                                                                                                                                                                                      (
                                                                                                                                                                                            (T1.ITEMID = @P61)
                                                                                                                                                                                            AND (T2.ITEMID = @P62)
                                                                                                                                                                                            )
                                                                                                                                                                                      AND (T2.ITEMDATAAREAID = @P63)
                                                                                                                                                                                      )
                                                                                                                                                                                AND (T3.ITEMID = @P64)
                                                                                                                                                                                )
                                                                                                                                                                          AND (T3.ITEMDATAAREAID = @P65)
                                                                                                                                                                          )
                                                                                                                                                                     AND (T4.TRACKINGDIMENSIONGROUP = @P66)
                                                                                                                                                                     )
                                                                                                                                                               AND (T4.ITEMID = @P67)
                                                                                                                                                               )
                                                                                                                                                         AND (T4.ITEMDATAAREAID = @P68)
                                                                                                                                                         )
                                                                                                                                                   AND (T5.STORAGEDIMENSIONGROUP = @P69)
                                                                                                                                                   )
                                                                                                                                              AND (T5.ITEMID = @P70)
                                                                                                                                             )
                                                                                                                                       AND (T5.ITEMDATAAREAID = @P71)
                                                                                                                                       )
                                                                                                                                 AND (T6.DISPLAYPRODUCTNUMBER = @P72)
                                                                                                                                 )
                                                                                                                           AND (T10.PRODUCT IS NULL)
                                                                                                                           )
                                                                                                                          AND (T11.PRODUCT > @P73)
                                                                                                                          )
                                                                                                                   )
                                                                                                           OR (
                                                                                                                   (
                                                                                                                          (
                                                                                                                           (
                                                                                                                                 (
                                                                                                                                       (
                                                                                                                                             (
                                                                                                                                                   (
                                                                                                                                                         (
                                                                                                                                                               (
                                                                                                                                                                     (
                                                                                                                                                                          (
                                                                                                                                                                                (T1.ITEMID = @P74)
                                                                                                                                                                                AND (T2.ITEMID = @P75)
                                                                                                                                                                                )
                                                                                                                                                                           AND (T2.ITEMDATAAREAID = @P76)
                                                                                                                                                                          )
                                                                                                                                                                     AND (T3.ITEMID = @P77)
                                                                                                                                                                     )
                                                                                                                                                               AND (T3.ITEMDATAAREAID = @P78)
                                                                                                                                                               )
                                                                                                                                                         AND (T4.TRACKINGDIMENSIONGROUP = @P79)
                                                                                                                                                         )
                                                                                                                                                   AND (T4.ITEMID = @P80)
                                                                                                                                                   )
                                                                                                                                             AND (T4.ITEMDATAAREAID = @P81)
                                                                                                                                             )
                                                                                                                                       AND (T5.STORAGEDIMENSIONGROUP = @P82)
                                                                                                                                       )
                                                                                                                                 AND (T5.ITEMID = @P83)
                                                                                                                                 )
                                                                                                                           AND (T5.ITEMDATAAREAID = @P84)
                                                                                                                           )
                                                                                                                          AND (T6.DISPLAYPRODUCTNUMBER = @P85)
                                                                                                                          )
                                                                                                                   AND NOT ((T10.PRODUCT IS NULL))
                                                                                                                   )
                                                                                                           )
                                                                                                   OR (
                                                                                                           (
                                                                                                                   (
                                                                                                                          (
                                                                                                                           (
                                                                                                                                 (
                                                                                                                                       (
                                                                                                                                             (
                                                                                                                                                   (
                                                                                                                                                         (
                                                                                                                                                               (
                                                                                                                                                                     (T1.ITEMID = @P86)
                                                                                                                                                                     AND (T2.ITEMID = @P87)
                                                                                                                                                                     )
                                                                                                                                                               AND (T2.ITEMDATAAREAID = @P88)
                                                                                                                                                               )
                                                                                                                                                         AND (T3.ITEMID = @P89)
                                                                                                                                                         )
                                                                                                                                                   AND (T3.ITEMDATAAREAID = @P90)
                                                                                                                                                   )
                                                                                                                                             AND (T4.TRACKINGDIMENSIONGROUP = @P91)
                                                                                                                                             )
                                                                                                                                       AND (T4.ITEMID = @P92)
                                                                                                                                       )
                                                                                                                                 AND (T4.ITEMDATAAREAID = @P93)
                                                                                                                                 )
                                                                                                                           AND (T5.STORAGEDIMENSIONGROUP = @P94)
                                                                                                                           )
                                                                                                                          AND (T5.ITEMID = @P95)
                                                                                                                          )
                                                                                                                   AND (T5.ITEMDATAAREAID = @P96)
                                                                                                                   )
                                                                                                           AND (T6.DISPLAYPRODUCTNUMBER > @P97)
                                                                                                           )
                                                                                                   )
                                                                                            OR (
                                                                                                   (
                                                                                                           (
                                                                                                                   (
                                                                                                                          (
                                                                                                                           (
                                                                                                                                 (
                                                                                                                                        (
                                                                                                                                             (
                                                                                                                                                   (
                                                                                                                                                         (T1.ITEMID = @P98)
                                                                                                                                                         AND (T2.ITEMID = @P99)
                                                                                                                                                         )
                                                                                                                                                   AND (T2.ITEMDATAAREAID = @P100)
                                                                                                                                                   )
                                                                                                                                             AND (T3.ITEMID = @P101)
                                                                                                                                             )
                                                                                                                                       AND (T3.ITEMDATAAREAID = @P102)
                                                                                                                                       )
                                                                                                                                 AND (T4.TRACKINGDIMENSIONGROUP = @P103)
                                                                                                                                 )
                                                                                                                           AND (T4.ITEMID = @P104)
                                                                                                                           )
                                                                                                                          AND (T4.ITEMDATAAREAID = @P105)
                                                                                                                          )
                                                                                                                   AND (T5.STORAGEDIMENSIONGROUP = @P106)
                                                                                                                   )
                                                                                                           AND (T5.ITEMID = @P107)
                                                                                                           )
                                                                                                   AND (T5.ITEMDATAAREAID > @P108)
                                                                                                   )
                                                                                            )
                                                                                       OR (
                                                                                            (
                                                                                                   (
                                                                                                           (
                                                                                                                   (
                                                                                                                          (
                                                                                                                           (
                                                                                                                                 (
                                                                                                                                       (
                                                                                                                                             (T1.ITEMID = @P109)
                                                                                                                                             AND (T2.ITEMID = @P110)
                                                                                                                                             )
                                                                                                                                       AND (T2.ITEMDATAAREAID = @P111)
                                                                                                                                       )
                                                                                                                                 AND (T3.ITEMID = @P112)
                                                                                                                                 )
                                                                                                                           AND (T3.ITEMDATAAREAID = @P113)
                                                                                                                           )
                                                                                                                          AND (T4.TRACKINGDIMENSIONGROUP = @P114)
                                                                                                                          )
                                                                                                                   AND (T4.ITEMID = @P115)
                                                                                                                   )
                                                                                                           AND (T4.ITEMDATAAREAID = @P116)
                                                                                                           )
                                                                                                   AND (T5.STORAGEDIMENSIONGROUP = @P117)
                                                                                                   )
                                                                                            AND (T5.ITEMID > @P118)
                                                                                            )
                                                                                        )
                                                                                    OR (
                                                                                        (
                                                                                            (
                                                                                                   (
                                                                                                           (
                                                                                                                   (
                                                                                                                          (
                                                                                                                           (
                                                                                                                                 (T1.ITEMID = @P119)
                                                                                                                                 AND (T2.ITEMID = @P120)
                                                                                                                                 )
                                                                                                                           AND (T2.ITEMDATAAREAID = @P121)
                                                                                                                           )
                                                                                                                          AND (T3.ITEMID = @P122)
                                                                                                                          )
                                                                                                                   AND (T3.ITEMDATAAREAID = @P123)
                                                                                                                   )
                                                                                                           AND (T4.TRACKINGDIMENSIONGROUP = @P124)
                                                                                                           )
                                                                                                   AND (T4.ITEMID = @P125)
                                                                                                   )
                                                                                            AND (T4.ITEMDATAAREAID = @P126)
                                                                                            )
                                                                                      AND (T5.STORAGEDIMENSIONGROUP > @P127)
                                                                                        )
                                                                                    )
                                                                            OR (
                                                                                    (
                                                                                        (
                                                                                            (
                                                                                                   (
                                                                                                           (
                                                                                                                   (
                                                                                                                          (T1.ITEMID = @P128)
                                                                                                                          AND (T2.ITEMID = @P129)
                                                                                                                          )
                                                                                                                   AND (T2.ITEMDATAAREAID = @P130)
                                                                                                                   )
                                                                                                           AND (T3.ITEMID = @P131)
                                                                                                           )
                                                                                                   AND (T3.ITEMDATAAREAID = @P132)
                                                                                                   )
                                                                                            AND (T4.TRACKINGDIMENSIONGROUP = @P133)
                                                                                            )
                                                                                     AND (T4.ITEMID = @P134)
                                                                                        )
                                                                                    AND (T4.ITEMDATAAREAID > @P135)
                                                                                    )
                                                                            )
                                                                     OR (
                                                                            (
                                                                                    (
                                                                                        (
                                                                                            (
                                                                                                   (
                                                                                                           (T1.ITEMID = @P136)
                                                                                                           AND (T2.ITEMID = @P137)
                                                                                                           )
                                                                                                   AND (T2.ITEMDATAAREAID = @P138)
                                                                                                   )
                                                                                            AND (T3.ITEMID = @P139)
                                                                                            )
                                                                                      AND (T3.ITEMDATAAREAID = @P140)
                                                                                        )
                                                                                    AND (T4.TRACKINGDIMENSIONGROUP = @P141)
                                                                                    )
                                                                            AND (T4.ITEMID > @P142)
                                                                            )
                                                                     )
                                                             OR (
                                                                     (
                                                                            (
                                                                                    (
                                                                                        (
                                                                                            (T1.ITEMID = @P143)
                                                                                            AND (T2.ITEMID = @P144)
                                                                                            )
                                                                                      AND (T2.ITEMDATAAREAID = @P145)
                                                                                        )
                                                                                    AND (T3.ITEMID = @P146)
                                                                                    )
                                                                            AND (T3.ITEMDATAAREAID = @P147)
                                                                            )
                                                                     AND (T4.TRACKINGDIMENSIONGROUP > @P148)
                                                                     )
                                                             )
                                                     OR (
                                                             (
                                                                     (
                                                                            (
                                                                                    (T1.ITEMID = @P149)
                                                                                    AND (T2.ITEMID = @P150)
                                                                                    )
                                                                            AND (T2.ITEMDATAAREAID = @P151)
                                                                            )
                                                                     AND (T3.ITEMID = @P152)
                                                                     )
                                                             AND (T3.ITEMDATAAREAID > @P153)
                                                             )
                                                     )
                                              OR (
                                                     (
                                                             (
                                                                     (T1.ITEMID = @P154)
                                                                     AND (T2.ITEMID = @P155)
                                                                     )
                                                             AND (T2.ITEMDATAAREAID = @P156)
                                                             )
                                                     AND (T3.ITEMID > @P157)
                                                     )
                                              )
                                      OR (
                                              (
                                                     (T1.ITEMID = @P158)
                                                     AND (T2.ITEMID = @P159)
                                                     )
                                              AND (T2.ITEMDATAAREAID > @P160)
                                              )
                                      )
                               OR (
                                      (T1.ITEMID = @P161)
                                      AND (T2.ITEMID > @P162)
                                      )
                               )
                       OR (T1.ITEMID > @P163)
                       )
               )
        AND (
               (
                       T6.INSTANCERELATIONTYPE IN (
                               @P164
                               ,@P165
                               ,@P166
                               )
                       )
               AND (T1.PRODUCT = T6.RECID)
               )
ORDER BY T1.ITEMID
        ,T2.ITEMID
        ,T2.ITEMDATAAREAID
        ,T3.ITEMID
        ,T3.ITEMDATAAREAID
        ,T4.TRACKINGDIMENSIONGROUP
        ,T4.ITEMID
        ,T4.ITEMDATAAREAID
        ,T5.STORAGEDIMENSIONGROUP
        ,T5.ITEMID
        ,T5.ITEMDATAAREAID
        ,T6.DISPLAYPRODUCTNUMBER
        ,T10.PRODUCT
        ,T11.PRODUCT
        ,T11.LANGUAGEID
        ,T12.NAME
        ,T6.RECID
        ,T12.RECID