ئhGAִ.Q 4) AND ^ ((Config_Classification.ClassName LIKE 'KAMCO') OR (Call.CallSubject2 LIKE 'KAMCO%')) AND ( (Configuration.Ref2 IS NOT NULL) AND (NOT (Call.CallSubject1 LIKE 'c-%')) AND (NOT (Call.CallSubject1 = 'SIMCARD')) AND (NOT (Call.CallSubject2 = 'NETWORK AUTOMATION')). AND ((Call.LogDatTim >= CONVERT(DATETIME, ' ', 102)) AND' (Call.LogDatTim < CONVERT(DATETIME, ' ', 102)))ORDER BY Call.CallNumber'No entries found in Quetzal for faults.Saving details. Please wait ...Insert into tFaultDetails" (CallNumber, FirstName, LastName,1 Ref2, CallSubject1, CallSubject2, CallSubject3,2 Logon, ConfigId, ConfigCallPrompt, SupportGroup,4 ResolutionCode1, ResolutionCode2, ResolutionCode3,) LogDatTim, AllDatTim, LastDatTim, SLT1, SLTUnique, LogonCode, ReportedDowntime, ShipTo,' EventCode, IthelpUser, EventDateTime,' IsCurrentEvent, TarFixWks, TarFixHrs,# TarFixMins, TarResWks, TarResHrs,# TarResMins, EventName, ServiceID,2 QuetzalDownTime, AvailabilityType, Availability,9 BatchID, BillingPeriod, PPTaken, AvailabilityTargetMet)+VALUES (:CallNumber, :FirstName, :LastName,5 :Ref2, :CallSubject1, :CallSubject2, :CallSubject3,6 :Logon, :ConfigId, :ConfigCallPrompt, :SupportGroup,7 :ResolutionCode1, :ResolutionCode2, :ResolutionCode3,- :LogDatTim, :AllDatTim, :LastDatTim, :SLT1, :SLTUnique, :LogonCode, :ReportedDowntime, :ShipTo,* :EventCode, :IthelpUser, :EventDateTime,* :IsCurrentEvent, :TarFixWks, :TarFixHrs,& :TarFixMins, :TarResWks, :TarResHrs,& :TarResMins, :EventName, :ServiceID,5 :QuetzalDownTime, :AvailabilityType, :Availability,= :BatchID, :BillingPeriod, :PPTaken, :AvailabilityTargetMet)BatchID BillingPeriodPPTakenIsCurrentEvent AvailabilityAvailabilityTargetMet TarFixWks TarFixHrs TarFixMins TarResWks TarResHrs TarResMins CallNumber FirstNameLastNameRef2 CallSubject1 CallSubject2 CallSubject3LogonConfigIdConfigCallPrompt SupportGroupResolutionCode1ResolutionCode2ResolutionCode3 LogDatTim AllDatTim LastDatTimSLT1 SLTUnique1 SLTUnique LogonCodeReportedDowntimeShipTo EventCode IthelpUser EventDateTime EventName ServiceIDQuetzalDownTimeAvailabilityTypeUPDATE tFaultDetails"SET ServiceClient = BT.Description#FROM (SELECT tBatchType.DescriptionFROM tBatchType7INNER JOIN tBatch ON tBatchType.ID = tBatch.BatchTypeIDWHERE tBatch.ID = ) AS BTWHERE tFaultDetails.BatchID = USVW3ۉ]]MUE3Uhd0d 0UER@DQ4XQ4EMtU싆Q4huhEU싆Q4Q43ۀ8W t@jf  uUEUjf L3ҸX>jf u UEjf L3ҸQuuuu MUER@4Q4TQ4EMpU싆Q4R@4Q4Q4Q4Q4X Q4| Q4EM U싆Q4 Q40 Q4h Q4R@ Q4 Q4 Q4 Q4P Q4 Q4 Q4 Q48 Q4h Q4 Q4 Q4 Q4$ Q4D Q4 Q4EM U싆Q4 Q4R@$Q4<Q4pQ4Q4hpuhEU싆Q4EMU싆Q4R@$Q4 Q48Q4Q4EMpU싆Q4hQ4EMU싆Q4R@$Q4Q4Q4Q4EMpU싆Q4hQ4EMU싆Q43ZYYdhE_^[]dbPPdata SELECT IDFROM tFaultDetailsWHERE BatchID = AND BillingPeriod LIKE ''AND PPTaken = 1$AND (PPTaken IS NULL OR PPTaken = 0)<No faults imported. Do you want to import the Fault Details?PFaults must be imported before proceeding, so import abandoned. Try again later.5Do you want to Reload the Fault Details from Quetzal?5Faults have already been processed. Import abandoned.UPDATE tDataCollectionSET Var02 = '100' WHERE tDataCollection.BatchID = SET Var02 = UPD.Var02"FROM (SELECT TmpDC.ID, TmpDC.Var02e FROM (SELECT TOP 10000 DC.ID, CAST(fd.Availability AS varchar) AS Var02, fd.ServiceID AS fdServiceID FROM tDataCollection dc] LEFT JOIN tFaultDetails fd ON ((dc.ServiceID = fd.ServiceID) AND (dc.BatchID = fd.BatchID)) WHERE dc.BatchID = ! ORDER BY fd.ServiceID) AS TmpDC, WHERE TmpDC.fdServiceID IS NOT NULL) AS UPD!WHERE tDataCollection.ID = UPD.IDINSERT INTO tDataCollection-(SequenceNo, ServiceID, ServiceType, TxnDate,% TxnTime, TransactionTypeID, GSTFlag,& AmountExGST, GSTAmount, AmountIncGST,) FromDate, ToDate, BatchID, Var01, Var02)3SELECT DC.SequenceNo, DC.ServiceID, DC.ServiceType,. DC.TxnDate, DC.TxnTime, DC.TransactionTypeID,4 DC.GSTFlag, (DC.AmountExGST * -1) AS "AmountExGST",$ (DC.GSTAmount * -1) AS "GSTAmount",* (DC.AmountIncGST * -1) AS "AmountIncGST",$ DC.FromDate, DC.ToDate, DC.BatchID, ('Refund') AS "Var01",, CAST(FD.Availability AS varchar) AS "Var02"FROM tDataCollection DC<LEFT JOIN tFaultDetails FD ON ((DC.ServiceID = FD.ServiceID) AND (DC.BatchID = FD.BatchID))WHERE DC.BatchID = IAND ((FD.AvailabilityTargetMet = NULL) OR (FD.AvailabilityTargetMet = 0)) UPDATE tBatch)SET TotalRevenue = BatchRate.TotalRevenue?FROM (SELECT Sum(tDataCollection.AmountExGST) AS "TotalRevenue"FROM tDataCollection) AS BatchRateWHERE tBatch.ID = #SET InvoiceNo = BatchRate.InvoiceNo$FROM (SELECT COUNT(*) AS "InvoiceNo"1AND tDataCollection.AmountExGST < 0) AS BatchRate)SET TotalCredits = BatchRate.TotalCredits?FROM (SELECT Sum(tDataCollection.AmountExGST) AS "TotalCredits"U3Uh%d0d 3ZYYdh,]Ã-my4 :h,`,`j l h<:h<: n hj  v n4 4x  D FH , n&j*J H                           j&$$  ( 4     D FH                              L< L L LL  LL L L L L L &L  &L  &L  &L  &L  &L  &L &>$`L  &L &>$`L  &L  &L  &L  &L  "L  "L  "L  &L  "L  "L  L  &L  "L  &L  "L  &L  &L  L  &L NJ:     j2 n*Jfffz |fp ruO<D FH:  , n&j&$, .$        D  , n*J      , n&  $J                , n&$J     j2 n*J    , n&, n*J    , n&, n*J p r' r ̐FH,,:<x:,4 , <P              "        j *  .,                             :(&,0&*****4jjjjjjjjjjjjRRRjRRHjRjLRjjH jU     P<XQOP,  <P *4.4*4  <     <                   <     P<    < <    < <\( rYL1VE4PpHH\p Mq778((p|ș!}!ȱ  a