the query which I'am struggling for is as below.
(@P1 bigint,@P2 bigint,@P3 bigint,@P4 bigint,@P5 bigint,@P6 bigint,@P7 bigint,@P8 bigint,@P9 nvarchar(5),@P10 nvarchar(21),@P11 numeric(32,16),@P12 int,@P13 int,
@P14 bigint,@P15 nvarchar(5),@P16 int,@P17 int,@P18 bigint,@P19 nvarchar(5),@P20 nvarchar(11),@P21 bigint,@P22 bigint,@P23 bigint,@P24 nvarchar(5),@P25 bigint,
@P26 nvarchar(5),@P27 bigint,@P28 bigint,@P29 bigint,@P30 bigint,@P31 bigint,@P32 bigint)
SELECT T1.SALESID,T1.LINENUM,T1.ITEMID,T1.SALESSTATUS,T1.DEL_LEDGERACCOUNT,T1.NAME,T1.EXTERNALITEMID,T1.TAXGROUP,T1.QTYORDERED,T1.SALESDELIVERNOW,
T1.REMAINSALESPHYSICAL,T1.REMAINSALESFINANCIAL,T1.COSTPRICE,T1.SALESPRICE,T1.CURRENCYCODE,T1.LINEPERCENT,T1.LINEDISC,T1.LINEAMOUNT,T1.CONFIRMEDDLV,
T1.RESERVATION,T1.SALESGROUP,T1.SALESUNIT,T1.DEL_DIMENSION,T1.DEL_DIMENSION2_,T1.DEL_DIMENSION3_,T1.DEL_DIMENSION4_,T1.DEL_DIMENSION5_,T1.PRICEUNIT,
T1.PROJTRANSID,T1.INVENTTRANSID,T1.CUSTGROUP,T1.CUSTACCOUNT,T1.DEL_INTERCOMPANYRETURNACTIONID,T1.SALESQTY,T1.SALESMARKUP,T1.INVENTDELIVERNOW,T1.MULTILNDISC,
T1.MULTILNPERCENT,T1.SALESTYPE,T1.BLOCKED,T1.COMPLETE,T1.REMAININVENTPHYSICAL,T1.TRANSACTIONCODE,T1.DEL_INTERCOMPANYRETURNACTIONTXT,T1.TAXITEMGROUP,
T1.TAXAUTOGENERATED,T1.UNDERDELIVERYPCT,T1.OVERDELIVERYPCT,T1.BARCODE,T1.BARCODETYPE,T1.INVENTREFTRANSID,T1.INVENTREFTYPE,T1.INVENTREFID,T1.INTERCOMPANYORIGIN,
T1.DEL_DELIVERYDATECONTROL,T1.ITEMBOMID,T1.ITEMROUTEID,T1.LINEHEADER,T1.SCRAP,T1.DEL_RETURNACTIONID,T1.DLVMODE,T1.INVENTTRANSIDRETURN,T1.PROJCATEGORYID,T1.PROJID,
T1.INVENTDIMID,T1.TRANSPORT,T1.STATPROCID,T1.PORT,T1.PROJLINEPROPERTYID,T1.RECEIPTDATEREQUESTED,T1.CUSTOMERLINENUM,T1.PACKINGUNITQTY,T1.PACKINGUNIT,
T1.INTERCOMPANYINVENTTRANSID,T1.REMAININVENTFINANCIAL,T1.DEL_DELIVERYADDRESS,T1.DELIVERYNAME,T1.DEL_DELIVERYSTREET,T1.DEL_DELIVERYZIPCODE,T1.DEL_DELIVERYCITY,
T1.DEL_DELIVERYCOUNTY,T1.DEL_DELIVERYSTATE,T1.DEL_DELIVERYCOUNTRYREGIONID,T1.DELIVERYTYPE,T1.CUSTOMERREF,T1.PURCHORDERFORMNUM,T1.RECEIPTDATECONFIRMED,
T1.DEL_BLANKETREFTRANSID,T1.STATTRIANGULARDEAL,T1.SHIPPINGDATEREQUESTED,T1.SHIPPINGDATECONFIRMED,T1.ADDRESSREFRECID,T1.ADDRESSREFTABLEID,T1.SERVICEORDERID,
T1.ITEMTAGGING,T1.CASETAGGING,T1.PALLETTAGGING,T1.LINEDELIVERYTYPE,T1.SHIPCARRIERID,T1.SHIPCARRIERACCOUNT,T1.SHIPCARRIERDLVTYPE,T1.SHIPCARRIERACCOUNTCODE,
T1.SALESCATEGORY,T1.DELIVERYDATECONTROLTYPE,T1.DEL_ATPINCLPLANNEDORDERS,T1.DEL_ATPTIMEFENCE,T1.ACTIVITYNUMBER,T1.LEDGERDIMENSION,T1.RETURNALLOWRESERVATION,
T1.MATCHINGAGREEMENTLINE,T1.SYSTEMENTRYSOURCE,T1.SYSTEMENTRYCHANGEPOLICY,T1.MANUALENTRYCHANGEPOLICY,T1.ITEMREPLACED,T1.RETURNDEADLINE,T1.EXPECTEDRETQTY,
T1.RETURNSTATUS,T1.RETURNARRIVALDATE,T1.RETURNCLOSEDDATE,T1.RETURNDISPOSITIONCODEID,T1.DELIVERYPOSTALADDRESS,T1.SHIPCARRIERPOSTALADDRESS,T1.SHIPCARRIERNAME,
T1.DEFAULTDIMENSION,T1.SOURCEDOCUMENTLINE,T1.STOCKEDPRODUCT,T1.ITEMPBAID,T1.PSAPROJPROPOSALQTY,T1.PSAPROJPROPOSALINVENTQTY,T1.PDSEXCLUDEFROMREBATE,T1.RETAILVARIANTID,
T1.DEL_HHTHANDHELDUSERID,T1.DEL_HHTTRANSTIME,T1.DEL_HHTTRANSDATE,T1.PDSBATCHATTRIBAUTORES,T1.PDSCWEXPECTEDRETQTY,T1.PDSCWINVENTDELIVERNOW,T1.PDSCWQTY,
T1.PDSCWREMAININVENTFINANCIAL,T1.PDSCWREMAININVENTPHYSICAL,T1.PDSITEMREBATEGROUPID,T1.PDSSAMELOT,T1.PDSSAMELOTOVERRIDE,T1.PSACONTRACTLINENUM,T1.DEL_INVENTDELIVERNOWCATCHWGT,
T1.DEL_PACKQTY,T1.DEL_PACKUNIT,T1.DEL_PDSCWSALESUNIT,T1.DEL_PDSMFGDEMANDFLAG,T1.DEL_REMAININVENTPHYSICALCATCHWGT,T1.DEL_REMAINSALESFINANCIALCATCHWGT,
T1.DEL_REMAINSALESPHYSICALCATCHWGT,T1.DEL_SALESDELIVERNOWCATCHWGT,T1.DEL_SALESQTYCATCHWGT,T1.DEL_UNITCATCHWGT,T1.BS_BLOCKED,T1.BS_BRANDID,T1.BS_CANCEL,
T1.BS_COLORID,T1.BS_DLVTERM,T1.BS_DPO,T1.BS_ETD,T1.BS_ISPOSTINGBYLINE,T1.BS_ITEMID,T1.BS_ITEMMENO,T1.BS_ITEMPRICETRANSRECID,T1.BS_LCNUMBER,T1.BS_LCREGDATE,
T1.BS_LINESTATUS,T1.BS_MODELNAME,T1.BS_OMBUSINESSUNITRECID,T1.BS_ORDERCOMMENT,T1.BS_ORDERREQUESTTYPE,T1.BS_ORDERTOCOMPANY,T1.BS_PAYMMODE,T1.BS_PLANDATE,
T1.BS_PONUMMBER,T1.BS_PRODGROUPID,T1.BS_PRODPOOLID,T1.BS_PRODREMARK,T1.BS_ROLLUNIT,T1.BS_SALESORIGINID,T1.BS_SALESQTY,T1.BS_SALESTYPE,T1.BS_SAMPLESTEP,
T1.BS_SPECID,T1.BS_STARTDATE,T1.BS_STYLENUMBER,T1.BS_SWATCHNO,T1.BS_SWATCHYN,T1.BS_TESTNUMBER,T1.BS_TYPEID,T1.BS_UNIT,T1.BS_BASECOLORID,T1.BS_REQUESTQTY,
T1.BS_SWATCHYNPROD,T1.BS_MNGPRODGROUP,T1.BS_SHIPSALESPRICE,T1.BS_SHIPLINEAMOUNT,T1.BS_ITEMNUMBERDESCTRIPTION,T1.BS_OLDSALESID,T1.BS_OLDSALESLINEID,T1.BS_PRNUMBER,
T1.BS_RECEIPTDATE,T1.BS_RECEIPTDATETZID,T1.BS_IMPORT,T1.BS_CANCELDATE,T1.BS_RECEIPTPERSON,T1.BS_SALESORIGINID1,T1.BS_CANCELDATETIME,T1.BS_CANCELDATETIMETZID,
T1.BS_REMAINCLOSE,T1.BS_REMAINQTY,T1.BS_REMAINCLOSEDATE,T1.BS_REMAINCLOSEDATETZID,T1.BS_REMAINCLOSEPERSON,T1.BS_SAMPLESTEPID,T1.BS_SWATCHCOLOR,T1.BS_BASECOMPANY,
T1.BS_TARGETCOMPANY,T1.BS_BASELINENUM,T1.BS_TARGETLINENUM,T1.BS_BASESALESID,T1.BS_TARGETSALESID,T1.BS_TRANSFERSTATUS,T1.BS_ORDERTYPE,T1.BS_FAILYN,T1.BS_OUTSOURCEPRICECODE,
T1.BS_DISCOUNT,T1.BS_DISUNITPRICE,T1.BS_PURCHASEYN,T1.BS_SQMPRICE,T1.BS_SQMQTY,T1.BS_AVAILQTY,T1.MODIFIEDDATETIME,T1.CREATEDDATETIME,T1.RECVERSION,T1.PARTITION,
T1.RECID,T2.SALESID,T2.SALESNAME,T2.RESERVATION,T2.CUSTACCOUNT,T2.INVOICEACCOUNT,T2.DELIVERYDATE,T2.DEL_DELIVERYADDRESS,T2.URL,T2.PURCHORDERFORMNUM,T2.DEL_SALESTAKER,
T2.SALESGROUP,T2.FREIGHTSLIPTYPE,T2.DOCUMENTSTATUS,T2.INTERCOMPANYORIGINALSALESID,T2.CURRENCYCODE,T2.PAYMENT,T2.CASHDISC,T2.TAXGROUP,T2.LINEDISC,T2.CUSTGROUP,T2.DISCPERCENT,
T2.INTERCOMPANYORIGINALCUSTACCOUNT,T2.DEL_DIMENSION,T2.DEL_DIMENSION2_,T2.DEL_DIMENSION3_,T2.DEL_DIMENSION4_,T2.DEL_DIMENSION5_,T2.PRICEGROUPID,T2.MULTILINEDISC,T2.ENDDISC,
T2.CUSTOMERREF,T2.LISTCODE,T2.DLVTERM,T2.DLVMODE,T2.PURCHID,T2.SALESSTATUS,T2.MARKUPGROUP,T2.SALESTYPE,T2.SALESPOOLID,T2.POSTINGPROFILE,T2.TRANSACTIONCODE,
T2.INTERCOMPANYAUTOCREATEORDERS,T2.INTERCOMPANYDIRECTDELIVERY,T2.INTERCOMPANYDIRECTDELIVERYORIG,T2.DEL_DELIVERYZIPCODE,T2.DEL_DELIVERYCOUNTY,T2.DEL_DELIVERYCOUNTRYREGIONID,
T2.SETTLEVOUCHER,T2.DEL_DELIVERYSTATE,T2.INTERCOMPANYALLOWINDIRECTCREATION,T2.INTERCOMPANYALLOWINDIRECTCREATIONORIG,T2.DELIVERYNAME,T2.ONETIMECUSTOMER,T2.COVSTATUS,
T2.COMMISSIONGROUP,T2.PAYMENTSCHED,T2.INTERCOMPANYORIGIN,T2.EMAIL,T2.FREIGHTZONE,T2.RETURNITEMNUM,T2.CASHDISCPERCENT,T2.CONTACTPERSONID,T2.DEADLINE,T2.PROJID,
T2.INVENTLOCATIONID,T2.ADDRESSREFTABLEID,T2.VATNUM,T2.PORT,T2.INCLTAX,T2.NUMBERSEQUENCEGROUP,T2.FIXEDEXCHRATE,T2.LANGUAGEID,T2.AUTOSUMMARYMODULETYPE,T2.SALESORIGINID,
T2.ESTIMATE,T2.TRANSPORT,T2.DEL_PRINTMODULETYPE,T2.PAYMMODE,T2.PAYMSPEC,T2.FIXEDDUEDATE,T2.DEL_DELIVERYCITY,T2.DEL_DELIVERYSTREET,T2.EXPORTREASON,T2.STATPROCID,
T2.INTERCOMPANYCOMPANYID,T2.INTERCOMPANYPURCHID,T2.INTERCOMPANYORDER,T2.DLVREASON,T2.QUOTATIONID,T2.DEL_DELIVERYDATECONTROL,T2.RECEIPTDATEREQUESTED,T2.RECEIPTDATECONFIRMED,
T2.SHIPPINGDATEREQUESTED,T2.SHIPPINGDATECONFIRMED,T2.ITEMTAGGING,T2.CASETAGGING,T2.PALLETTAGGING,T2.ADDRESSREFRECID,T2.CUSTINVOICEID,T2.INVENTSITEID,T2.DEFAULTDIMENSION,
T2.CREDITCARDCUSTREFID,T2.SHIPCARRIERACCOUNT,T2.SHIPCARRIERID,T2.SHIPCARRIERFUELSURCHARGE,T2.SHIPCARRIERBLINDSHIPMENT,T2.DEL_CREDITCARDPROCESSORTRANSACTIONID,
T2.SHIPCARRIERDELIVERYCONTACT,T2.CREDITCARDAPPROVALAMOUNT,T2.CREDITCARDAUTHORIZATION,T2.RETURNDEADLINE,T2.RETURNREPLACEMENTID,T2.RETURNSTATUS,T2.RETURNREASONCODEID,
T2.CREDITCARDAUTHORIZATIONERROR,T2.SHIPCARRIERACCOUNTCODE,T2.RETURNREPLACEMENTCREATED,T2.SHIPCARRIERDLVTYPE,T2.DEL_ATPINCLPLANNEDORDERS,T2.DEL_ATPTIMEFENCE,
T2.DELIVERYDATECONTROLTYPE,T2.SHIPCARRIEREXPEDITEDSHIPMENT,T2.SHIPCARRIERRESIDENTIAL,T2.MATCHINGAGREEMENT,T2.SYSTEMENTRYSOURCE,T2.SYSTEMENTRYCHANGEPOLICY,
T2.MANUALENTRYCHANGEPOLICY,T2.DELIVERYPOSTALADDRESS,T2.SHIPCARRIERPOSTALADDRESS,T2.SHIPCARRIERNAME,T2.WORKERSALESTAKER,T2.SOURCEDOCUMENTHEADER,T2.BANKDOCUMENTTYPE,
T2.DEL_CFDICREDITREFINVOICE_MX,T2.DEL_SALESRESPONSIBLE,T2.SALESUNITID,T2.SMMSALESAMOUNTTOTAL,T2.SMMCAMPAIGNID,T2.DEL_CUSTTRANSCONTROL_BR,T2.DEL_ONLINESTORERECID,
T2.DEL_ISRETAILSALE,T2.DEL_RBOSTATEMENTID,T2.DEL_RETAILPRDOCUMENT,T2.DEL_RETAILRETAILSTATUSTYPE,T2.DEL_RETAILPOSTEDPRID,T2.DEL_CONCESSIONCONTRACTID,T2.CASHDISCBASEDATE,
T2.CASHDISCBASEDAYS,T2.PDSBATCHATTRIBAUTORES,T2.PDSCUSTREBATEGROUPID,T2.PDSREBATEPROGRAMTMAGROUP,T2.WORKERSALESRESPONSIBLE,T2.DEL_OMINTERNALORGANIZATION,
T2.DEL_PDSREGIONCODE,T2.DEL_RETAILCHANNEL,T2.DEL_RETAILHOUROFDAY,T2.DEL_RETAILLOYALTYCARDID,T2.DEL_RETAILORDER,T2.DEL_RETAILPREPAYMENTOVERRIDDEN,
T2.DEL_RETAILREPLENISHMENTLOCATIONID,T2.DEL_RETAILSTOREID,T2.DEL_RETAILTERMINALID,T2.BS_BANKACCOUNTID,T2.BS_BRANDID,T2.BS_LCNUMBER,T2.BS_LCREGDATE,
T2.BS_OMBUSINESSUNITRECID,T2.BS_ORDERENTRYDATE,T2.BS_ORDERREQUESTTYPE,T2.BS_ORDERTOCOMPANY,T2.BS_PONUMMBER,T2.BS_BANKACCOUNT,T2.BS_OLDSALESID,T2.BS_SALESORDERCONFIRM,
T2.BS_CURRENCYTRADE,T2.BS_OMCOSTCENTER,T2.BS_OMCOSTCENTERNAME,T2.BS_CONSIGNEEID,T2.BS_ACCOUNTID,T2.BS_PRNUMBER,T2.BS_NOTIFYID,T2.BS_ORIGINALPO,T2.BS_PIPRINTTIME,
T2.BS_PIPRINTTIMETZID,T2.BS_PIPRINTUSER,T2.BS_PIPRINTYN,T2.BS_BSIEXCHRATE,T2.BS_BSIDISCRATE,T2.MODIFIEDDATETIME,T2.MODIFIEDBY,T2.CREATEDDATETIME,T2.CREATEDBY,
T2.RECVERSION,T2.PARTITION,T2.RECID,T3.INVENTDIMID,T3.INVENTBATCHID,T3.WMSLOCATIONID,T3.WMSPALLETID,T3.INVENTSERIALID,T3.INVENTLOCATIONID,T3.CONFIGID,T3.INVENTSIZEID,
T3.INVENTCOLORID,T3.INVENTSITEID,T3.INVENTSTYLEID,T3.MODIFIEDDATETIME,T3.RECVERSION,T3.PARTITION,T3.RECID,T4.KEY_,T4.VALUE,T4.NAME,T4.BS_BRANDLEVEL1ID,
T4.BS_BRANDLEVEL2ID,T4.PARTITION,T4.RECID,T5.ISSUSPENDED,T5.ITEMID,T5.ITEMNAME,T5.ITEMTYPECODE,T5.ITEMTYPENAME,T5.BS_HSCODE,T5.COUNTRYREGIONID,T5.BS_PRODNAMEREFID,
T5.REGIONNAME,T5.BS_OLDITEMID,T5.EDITABLE,T5.ITEMALIAS,T5.MODIFIEDDATETIME,T5.MODIFIEDBY,T5.CREATEDDATETIME,T5.CREATEDBY,T5.RECVERSION,T5.PARTITION,T5.RECID,
T6.DEVIATION,T6.ISSUSPENDED,T6.ITEMGROUPID,T6.SPECID,T6.SPECNAME,T6.THICKNESS,T6.THICKNESSUNITID,T6.WEIGHT,T6.WEIGHTUNITID,T6.WIDTH,T6.WIDTHUNITID,T6.ITEMTYPECODE,
T6.ITEMTYPENAME,T6.BS_ITEMTYPE,T6.BS_ITEMTYPE1,T6.BS_ITEMTYPE2,T6.BS_OLDSPECID,T6.EDITABLE,T6.MODIFIEDDATETIME,T6.MODIFIEDBY,T6.CREATEDDATETIME,T6.CREATEDBY,T6.RECVERSION,
T6.PARTITION,T6.RECID,T7.ADDITIONALCHARGE,T7.BASECOLORID,T7.COLORALIAS,T7.COLORID,T7.COLORNAME,T7.COLORTYPEID,T7.CURRENCY,T7.DEFAULTCOLOR,T7.ISSUSPENDED,T7.ITEMGROUPID,
T7.NOTIFY,T7.UNITID,T7.ITEMTYPECODE,T7.ITEMTYPENAME,T7.BS_OLDCOLORID,T7.EDITABLE,T7.MODIFIEDDATETIME,T7.MODIFIEDBY,T7.RECVERSION,T7.PARTITION,T7.RECID,T8.ADDITIONALCHARGE,
T8.CURRENCY,T8.DEFAULTTYPE,T8.ISSUSPENDED,T8.ITEMGROUPID,T8.NOTIFY,T8.TYPEID,T8.TYPENAME,T8.UNITID,T8.ITEMTYPECODE,T8.ITEMTYPENAME,T8.BS_OLDTYPEID,T8.EDITABLE,
T8.MODIFIEDDATETIME,T8.MODIFIEDBY,T8.RECVERSION,T8.PARTITION,T8.RECID,T9.DEL_ITEMGROUPID,T9.ITEMID,T9.DEL_ITEMNAME,T9.ITEMTYPE,T9.PURCHMODEL,T9.HEIGHT,T9.WIDTH,
T9.SALESMODEL,T9.COSTGROUPID,T9.REQGROUPID,T9.EPCMANAGER,T9.PRIMARYVENDORID,T9.NETWEIGHT,T9.DEPTH,T9.UNITVOLUME,T9.BOMUNITID,T9.ITEMPRICETOLERANCEGROUPID,T9.DENSITY,
T9.DEL_DIMENSION,T9.DEL_DIMENSION2_,T9.DEL_DIMENSION3_,T9.DEL_DIMENSION4_,T9.DEL_DIMENSION5_,T9.COSTMODEL,T9.USEALTITEMID,T9.ALTITEMID,T9.MATCHINGPOLICY,T9.INTRACODE,
T9.PRODFLUSHINGPRINCIP,T9.MINIMUMPALLETQUANTITY,T9.PBAITEMAUTOGENERATED,T9.WMSARRIVALHANDLINGTIME,T9.BOMMANUALRECEIPT,T9.DEL_STOPEXPLODE,T9.PHANTOM,T9.INTRAUNIT,
T9.BOMLEVEL,T9.BATCHNUMGROUPID,T9.AUTOREPORTFINISHED,T9.ORIGCOUNTRYREGIONID,T9.STATISTICSFACTOR,T9.ALTCONFIGID,T9.STANDARDCONFIGID,T9.PRODPOOLID,T9.PROPERTYID,
T9.ABCTIEUP,T9.ABCREVENUE,T9.ABCVALUE,T9.ABCCONTRIBUTIONMARGIN,T9.COMMISSIONGROUPID,T9.DEL_CONFIGURABLE,T9.SALESPERCENTMARKUP,T9.SALESCONTRIBUTIONRATIO,
T9.SALESPRICEMODELBASIC,T9.DEL_MINAVERAGESETTLE,T9.NAMEALIAS,T9.PRODGROUPID,T9.PROJCATEGORYID,T9.GROSSDEPTH,T9.GROSSWIDTH,T9.GROSSHEIGHT,T9.STANDARDPALLETQUANTITY,
T9.QTYPERLAYER,T9.SORTCODE,T9.DEL_CONFIGSIMILAR,T9.SERIALNUMGROUPID,T9.DEL_DIMGROUPID,T9.DEL_MODELGROUPID,T9.ITEMBUYERGROUPID,T9.TAXPACKAGINGQTY,T9.WMSPALLETTYPEID,
T9.ORIGSTATEID,T9.WMSPICKINGQTYTIME,T9.TARAWEIGHT,T9.PACKAGINGGROUPID,T9.SCRAPVAR,T9.SCRAPCONST,T9.STANDARDINVENTCOLORID,T9.STANDARDINVENTSIZEID,
T9.DEL_ITEMDIMCOMBINATIONAUTOCREATE,T9.ITEMDIMCOSTPRICE,T9.DEL_ITEMIDCOMPANY,T9.ALTINVENTSIZEID,T9.ALTINVENTCOLORID,T9.FORECASTDMPINCLUDE,T9.PRODUCT,
T9.PALLETTAGGING,T9.ITEMTAGGINGLEVEL,T9.DEFAULTDIMENSION,T9.BOMCALCGROUPID,T9.PBAITEMCONFIGURABLE,T9.PBAINVENTITEMGROUPID,T9.PBAHIDEDIALOG,T9.PBAHIDEAPPROVAL,
T9.PBAAUTOSTART,T9.PBAMANDATORYCONFIG,T9.PDSCWWMSSTANDARDPALLETQTY,T9.PDSCWWMSMINIMUMPALLETQTY,T9.PDSCWWMSQTYPERLAYER,T9.ALTINVENTSTYLEID,T9.PDSBASEATTRIBUTEID,
T9.PDSBESTBEFORE,T9.PDSFREIGHTALLOCATIONGROUPID,T9.PDSITEMREBATEGROUPID,T9.PDSPOTENCYATTRIBRECORDING,T9.PDSSHELFADVICE,T9.PDSSHELFLIFE,T9.PDSTARGETFACTOR,
T9.PDSVENDORCHECKITEM,T9.PMFPLANNINGITEMID,T9.PMFPRODUCTTYPE,T9.PMFYIELDPCT,T9.STANDARDINVENTSTYLEID,T9.DEL_ORIGCOUNTRYREGIONID,T9.DEL_PDSCHECKCATCHWEIGHT,
T9.DEL_PDSHAZARDOUS,T9.BS_COLORID,T9.BS_DEFAULTITEM,T9.BS_HSCODE,T9.BS_ITEMID,T9.BS_MASSDEV,T9.BS_PRODUCTIONFEATURE,T9.BS_SPECID,T9.BS_TYPEID,T9.BS_ITEMGROUP,
T9.BS_RESTRICEDITEM,T9.MODIFIEDDATETIME,T9.DEL_MODIFIEDTIME,T9.MODIFIEDBY,T9.CREATEDDATETIME,T9.DEL_CREATEDTIME,T9.CREATEDBY,T9.RECVERSION,T9.PARTITION,T9.RECID,
T10.NAME,T10.RECID,T10.RECVERSION,T10.INSTANCERELATIONTYPE,T10.RECVERSION,T10.RECID,T10.RECVERSION,T10.RECID,T10.RECVERSION,T10.RECID,
T11.ATTRNAME,T11.WORKERSALESRESPONSIBLE,T11.SALESID,T11.ENTITYINSTANCE,T11.PARTITION,T11.RECID,
T12.PERSON,T12.RECVERSION,T12.RECID,T13.DEL_SHADOW_DATAAREAID,
T13.DEL_RELATIONTYPENAME_OMINTERNALORG,T13.ORGANIZATIONTYPE,T13.DEL_OMOPERATINGUNIT_SHADOW_DATAAREAID,T13.OMOPERATINGUNITTYPE,T13.HCMWORKER,T13.OMOPERATINGUNITNUMBER,
T13.BS_ORDERREQUESTTYPE,T13.BS_LINESTATUS,T13.BS_ORDERTOCOMPANY,T13.BS_BRANDLEVEL1ID,T13.BS_BRANDLEVEL2ID,T13.MAV_EDITDATE,T13.PHONETICNAME,
T13.DEL_DIRORGBASE_SHADOW_DATAAREAID,T13.DUNSNUMBERRECID,T13.DEL_RELATIONTYPENAME_DIRORGANIZATIONBASE,T13.DEL_GENERATIONALSUFFIX,T13.NAME,T13.DEL_SALUTATION,
T13.DEL_PERSONNAMEORDER,T13.LANGUAGEID,T13.DEL_TYPE,T13.DEL_PREFIX,T13.DEL_PROFESSIONALSUFFIX,T13.DEL_DATAAREAID,T13.DEL_FIRSTNAME,T13.DEL_MIDDLENAME,
T13.DEL_LASTNAME,T13.DEL_PARTYID,T13.NAMEALIAS,T13.PARTYNUMBER,T13.DEL_ENTITYTYPE,T13.DEL_NAMESEQUENCE,T13.DEL_PHONETICNAME,T13.INSTANCERELATIONTYPE,T13.KNOWNAS,
T13.DEL_INSTANCERELATIONTYPENAME,T13.DEL_RELATIONTYPENAME,T13.PRIMARYADDRESSLOCATION,T13.PRIMARYCONTACTEMAIL,T13.PRIMARYCONTACTFAX,T13.PRIMARYCONTACTPHONE,
T13.PRIMARYCONTACTTELEX,T13.PRIMARYCONTACTURL,T13.MODIFIEDDATETIME,T13.MODIFIEDBY,T13.CREATEDDATETIME,T13.CREATEDBY,T13.RECVERSION,T13.RELATIONTYPE,T13.PARTITION,
T13.RECID,T14.NAME,T14.RECID,T14.RECVERSION,T14.INSTANCERELATIONTYPE,T14.RECVERSION,T14.RECID,T15.ITEMID,T15.ITEMDATAAREAID,T15.ITEMGROUPID,T15.ITEMGROUPDATAAREAID,
T15.RECVERSION,T15.PARTITION,T15.RECID,T3.SHA1HASH,T13.DEL_MEMO
FROM SALESLINE T1
CROSS JOIN SALESTABLE T2
CROSS JOIN INVENTDIM T3
CROSS JOIN DIMATTRIBUTEOMDEPARTMENT T4
LEFT OUTER JOIN BS_ITEM T5 ON ((T5.PARTITION=@P1) AND (T1.BS_ITEMID=T5.ITEMID))
LEFT OUTER JOIN BS_SPEC T6 ON ((T6.PARTITION=@P2) AND (T1.BS_SPECID=T6.SPECID))
LEFT OUTER JOIN BS_COLOR T7 ON ((T7.PARTITION=@P3) AND (T1.BS_COLORID=T7.COLORID))
LEFT OUTER JOIN BS_TYPE T8 ON ((T8.PARTITION=@P4) AND (T1.BS_TYPEID=T8.TYPEID))
CROSS JOIN INVENTTABLE T9
LEFT OUTER JOIN DIRPARTYTABLE T10 ON (((T10.PARTITION=@P5) AND (T1.BS_BRANDID=T10.RECID)) AND (T10.INSTANCERELATIONTYPE IN (2377) ))
CROSS JOIN BS_SALESRESPONSIBLEBU T11
LEFT OUTER JOIN HCMWORKER T12 ON ((T12.PARTITION=@P6) AND (T2.WORKERSALESRESPONSIBLE=T12.RECID))
CROSS JOIN DIRPARTYTABLE T13
LEFT OUTER JOIN DIRPARTYTABLE T14 ON (((T14.PARTITION=@P7) AND (T12.PERSON=T14.RECID)) AND (T14.INSTANCERELATIONTYPE IN (2975) ))
CROSS JOIN INVENTITEMGROUPITEM T15
WHERE (((T1.PARTITION=@P8) AND (T1.DATAAREAID=@P9)) AND (((T1.CUSTACCOUNT=@P10) AND (T1.REMAINSALESPHYSICAL>@P11))
AND ( NOT ((T1.BS_LINESTATUS=@P12)) AND NOT ((T1.BS_LINESTATUS=@P13)))))
AND (((T2.PARTITION=@P14) AND (T2.DATAAREAID=@P15)) AND (((T2.SALESSTATUS=@P16) AND NOT ((T2.BS_ORDERREQUESTTYPE=@P17))) AND (T1.SALESID=T2.SALESID)))
AND (((T3.PARTITION=@P18) AND (T3.DATAAREAID=@P19)) AND ((T3.INVENTSITEID=@P20) AND (T1.INVENTDIMID=T3.INVENTDIMID)))
AND (((T4.PARTITION=@P21) AND (T4.PARTITION#2=@P22)) AND (T1.BS_BRANDID=T4.KEY_))
AND (((T9.PARTITION=@P23) AND (T9.DATAAREAID=@P24)) AND (T1.ITEMID=T9.ITEMID))
AND (((((((T11.PARTITION=@P25) AND (T11.DATAAREAID=@P26)) AND (T11.PARTITION#2=@P27)) AND (T11.PARTITION#3=@P28))
AND (T11.PARTITION#4=@P29)) AND (T11.PARTITION#5=@P30))
AND (T2.SALESID=T11.SALESID)) AND (((T13.PARTITION=@P31)
AND (T11.ENTITYINSTANCE=T13.RECID)) AND (T13.INSTANCERELATIONTYPE IN (2377) ))
AND ((T15.PARTITION=@P32) AND ((T15.ITEMID=T9.ITEMID) AND (T15.ITEMDATAAREAID=T9.DATAAREAID)))
ORDER BY T1.SALESID,T1.LINENUM,T1.RECID,T3.PARTITION,
T3.DATAAREAID,T3.INVENTDIMID,T5.PARTITION,T5.ITEMID,T6.PARTITION,T6.SPECID,T7.PARTITION,T7.COLORID,T8.PARTITION,T8.TYPEID OPTION(FAST 3)
I want to find where the query is from in AOT.
