10/7/2025 12:47:27 PM
G:\STHCHANNELMANAGER\/LogFile/resBookingSpa.txt
step 1     SELECT isnull(TARIFF_DISC_PER,0)as TARIFFDISCPER ,isnull(TARIFF_DISC_AMT,0) as TARIFFDISCAMT ,CONVERT(varchar(6), ARRIVAL_DT, 12) as DateFormate ,convert(varchar ,ARRIVAL_DT,23) as ARRIVAL_DT,* FROM FO_RESERVE WHERE COMPANY_ID='WS' AND r_no='927'
Date :10/7/2025 12:47:27 PM
step 2  SELECT RESERVE_NO, STRING_AGG(GUEST_NM, '# ') AS vSPA_G_NM_All, STRING_AGG(GUEST_TITLE_ID, '# ') AS vSPA_GTit_All, STRING_AGG(C2_N1, '# ') AS vSPA_GF_NM_All, STRING_AGG(C2_N2, '#') AS vSPA_GL_NM_All, STRING_AGG(G_ID, '# ') AS SPA_Guest_ID_All from  FO_RESERVE_DET  WHERE COMPANY_ID='WS' AND RESERVE_NO='1293' GROUP BY RESERVE_NO Date :10/7/2025 12:47:27 PM
step 3   Select PK_Id from FO_ROOM_TYPE_TARIFF where Company_Id ='WS' and Room_Ty_Id ='MGK' and Rate_Ty_Id ='S07' and Currency_Id='RS'  And '251120' >= FROM_DT And '251120' <= TO_DT  AND D_IND IS NULL Date :10/7/2025 12:47:27 PM
step 4  Select * from AAFO0M0120 Where Company_Id ='WS' and  P_Id in ('S07','')Date :10/7/2025 12:47:27 PM
step 5  Date :10/7/2025 12:47:27 PM
step 6  INSERT INTO AAFO0M0121(CH_D,COMPANY_ID,C_IND,P_ID,RT_C3,IT_NM,S_No,RT_C2,C_UR,RT_RM,C_BY,B_IND,H_IND,SR_NO,P_IND,CH_TY,R_IND,R_NO,IT_ID,Q_TY,RT_C1,U_By,RT_A) VALUES ('0','WS',NULL,'S07',NULL,'WELLBEING','2',NULL,'RS','0.000','0270',NULL,'P','1',NULL,'02','1','1293','WEL','1',NULL,'0270','0.000')Date :10/7/2025 12:47:27 PM
step 8  INSERT INTO AAFO0M0279(COMPANY_ID,C_IND,RES_IND,P_ID,RT_C3,IT_NM,RT_C1,RESER_NO,C_UR,PS_NO,S_DT,RT_C2,SR_NO,B_IND,CH_TY,R_IND,IT_ID,S_NO,D_P,E_DT,RT_A) VALUES ('WS',NULL,'R','S07',NULL,'WELLBEING',NULL,'1293','RS','2',NULL,NULL,'1',NULL,'02','1','WEL','1','1',NULL,'0.000')Date :10/7/2025 12:47:27 PM
step 9  1Date :10/7/2025 12:47:27 PM
step 11  SELECT TOP 1 P_ID  FROM AAFO0M0121 WHERE COMPANY_ID='WS' AND R_NO='1293'Date :10/7/2025 12:47:27 PM
step 12  SELECT distinct P_ID  FROM AAFO0M0121 WHERE COMPANY_ID='WS' AND R_NO='1293'Date :10/7/2025 12:47:27 PM
step 13  Date :10/7/2025 12:47:27 PM
step vGArrDt   2025-11-20Date :10/7/2025 12:47:27 PM
step14  SELECT * FROM AAFO0M0086 WHERE Company_ID='WS' AND FO_P_ID='S07' AND R_Ty_ID='MGK'  AND Currency_ID='RS' AND  '2025-11-20' BETWEEN WEF AND Valid_Upto Date :10/7/2025 12:47:27 PM
 Step 1 fnCreate_SPASELECT isnull(U2_IND,0) as  U2_IND,isnull(Y1_IND,0) as Y1_IND  FROM MMSP0M0400 WHERE Company_ID='W1'Date :10/7/2025 12:47:27 PM
Step 2 fnCreate_SPA SELECT * FROM MMSP0M0030 WHERE company_id='W1' AND cm_id=2840 AND gs_cat='G'Date :10/7/2025 12:47:27 PM
Step 3 fnCreate_SPA SELECT in_id FROM mmsp0m0103 WHERE company_id='W1' AND c_ind=1Date :10/7/2025 12:47:27 PM
Step 4SELECT guest_nm,Guest_title_Id,P1_Nm,O1_Nm,Add1,Add2,Add3,place,pin_cd,res_tel,email,mobile,dob,anniv_dt,SPOUCE_NM,OCCUPATION,LIKES_NARRATION,DISLIKES_NARRATION,country_id,Gend_ID,d1_id,isnull(Guest_Ty_ID,'') as Guest_Ty_ID,A14_Id,B14_Id,Df_1,Df_2,Df_3 FROM FO_GUEST WHERE Company_ID='WS' AND Guest_Id=2840Date :10/7/2025 12:47:27 PM
Step 6 fnCreate_SPAFalseDate :10/7/2025 12:47:27 PM
Step 7 fnCreate_SPAINSERT INTO MMSP0M0030(Rs_T,GS_Tl_Id,Add2,GS_NM,Ct_ID,Cn_Pr,Cn_Tl,SP_NM,GS_NM1,Company_id,DOA,CM_id,LK_NR,Gend_ID,m_ind,Em,Cn_Ds,HT_NR,U_By,mb,Pn,J_NR,C_By,K_IND,U_Dt,DB,GS_cat,GS_Id,GS_N,Add3,C_Dt,Pl,Add1) VALUES ('+917447782591','MR','','Deepak','',NULL,NULL,'','Mistry','W1','','2840','','M','1','revenuemanager@thecorinthianspune.com',NULL,'','S07,','+917447782591','          ','','S07,','3','2025/10/07 12:47:27','','G','1042','Mistry,Deepak','','2025/10/07 12:47:27','','')Date :10/7/2025 12:47:27 PM
step15   SELECT IN_GST_IND, k_Tax, OTH_CLB_APPL, COMMON_INTFC_IND, D_IND FROM MST_COMPANY WHERE Company_ID = 'WS' Date :10/7/2025 12:47:27 PM
step16   SELECT * FROM MMSP0M0111  WHERE COMPANY_ID='W1' and o_id='01' and d_no ='927'Date :10/7/2025 12:47:27 PM
spaResNo  SELECT * FROM MMSP0M0024 WHERE COMPANY_ID = 'W1' AND O_ID = '01' AND R_TY = 'D'Date :10/7/2025 12:47:27 PM
spaResNo  UPDATE MMSP0M0024 SET S_N = 635 WHERE COMPANY_ID = 'W1' AND O_ID = '01' AND R_TY = 'D'Date :10/7/2025 12:47:27 PM
step17  INSERT INTO MMSP0M0111(D_NO,U_DT,O_ID,C_BY,COMPANY_ID,U_BY,C_DT) VALUES ('635','2025/10/07 12:47:27','01','S07,','W1','STH','2025/10/07 12:47:27')Date :10/7/2025 12:47:27 PM
step19  SELECT S_CMP_ID,S_OUT_ID,S_P_ID,S_PR_ID FROM AAFO0M0086 WHERE Company_ID='WS' AND FO_P_ID='S07' AND R_Ty_ID='MGK' AND Currency_ID='RS' AND '2025/10/07 12:47:27' BETWEEN WEF AND Valid_UptoDate :10/7/2025 12:47:27 PM
spaResNo  SELECT * FROM MMSP0M0024 WHERE COMPANY_ID = 'W1' AND O_ID = '01' AND R_TY = 'R'Date :10/7/2025 12:47:27 PM
spaResNo  UPDATE MMSP0M0024 SET S_N = 17499 WHERE COMPANY_ID = 'W1' AND O_ID = '01' AND R_TY = 'R'Date :10/7/2025 12:47:27 PM
step16   select r_no from mmsp0m0001 where company_id='W1' and o_id='01'  and R_no ='17499'Date :10/7/2025 12:47:27 PM
step22  Select Top 1 TR_ID from MMSP0M0107 where COMPANY_ID='W1'  AND O_ID='01' And PK_ID='S7'Date :10/7/2025 12:47:27 PM
step23  SELECT TR_ID,TR_NM,TR_D,TR_P  FROM MMSP0M0104  WHERE COMPANY_ID='W1'  AND O_ID='01'And TR_ID='AB   'Date :10/7/2025 12:47:27 PM
step24  SELECT Sum(IsNull(Pr_Am,0)) Amt,Max(Ch_Ty) Ch_Ty   FROM MMSP0M0301   WHERE COMPANY_ID='W1' AND PR_LS='06'  AND  O_ID='01' And Ty_ID='P'  and tr_id='S7'  and isnull(ch_ty,0)<>0 Date :10/7/2025 12:47:27 PM
step25  SELECT A_8  FROM MMSP0M0305 WHERE COMPANY_ID='W1' AND PR_ID='06'  AND O_ID='01'Date :10/7/2025 12:47:27 PM
B_Ind   Select B_Ind from MMSP0M0106 where COMPANY_ID='W1' and pk_id='S7' And O_ID='01' Date :10/7/2025 12:47:27 PM
step27  INSERT INTO MMSP0M0001(R_FOR,COMPANY_ID,C_BY,T_DT,U_DT,ST_TS,C_DT,GS_ID,rv_id,DAY_RT_IND,T_TM,pk_am,sp_pr,P_X,pr_id,GS_NM,PKG_CNT,F_TM,PR_C,D_NO,GS_LN,R_No,P_ID,T_ID,GS_FN,O_ID,U_BY,CH_TY) VALUES ('P','W1','S07,','2025-11-20','2025/10/07 12:47:27','8','2025/10/07 12:47:27','1042','PS ','2','13:05',NULL,NULL,'2','06','Deepak,Mistry','1','12:00',NULL,'635','Mistry','17499','S7','AB   ','Deepak','01','STH','1')Date :10/7/2025 12:47:27 PM
step28  1Date :10/7/2025 12:47:27 PM
step30  INSERT INTO MMSP0M0002(A_IND,THR_ID,O_ID,S1_TM,E_TM,COMPANY_ID,E1_TM,S_TM,R_NO) VALUES ('0',' ','01','13:05','12:00','W1','13:05','12:00','17499')Date :10/7/2025 12:47:27 PM
step31  1Date :10/7/2025 12:47:27 PM
step33  INSERT INTO MMSP0M0003(S_NO,GS_FN,GS_ID,O_ID,COMPANY_ID,GS_LN,GS_TL,GS_NM,D_NO) VALUES ('1','Deepak','2840','01','W1','Mistry','00','Deepak,Mistry','17499')Date :10/7/2025 12:47:27 PM
step34  1Date :10/7/2025 12:47:27 PM
step36  SELECT * FROM MMSP0M0990 WHERE Company_ID='W1' And O_ID='01' And D_No='635' And T_Dt='2025-11-20' And PK_ID='S7'Date :10/7/2025 12:47:27 PM
step37  INSERT INTO MMSP0M0990(COMPANY_ID,NET_AMT,PR_ID,D_NO,AMT,U_BY,PK_ID,PK_Qty,T_DT,U_DT,DS_PR,O_ID,C_BY,C_DT,DS_AM,DY_NO,RT) VALUES ('W1','11000','06','635','11000','STH','S7','1','2025-11-20','2025/10/07 12:47:27',NULL,'01','S07,','2025/10/07 12:47:27',NULL,'4868','11000')Date :10/7/2025 12:47:27 PM
step38  1Date :10/7/2025 12:47:27 PM
step19  SELECT S_CMP_ID,S_OUT_ID,S_P_ID,S_PR_ID FROM AAFO0M0086 WHERE Company_ID='WS' AND FO_P_ID='S07' AND R_Ty_ID='MGK' AND Currency_ID='RS' AND '2025/10/07 12:47:27' BETWEEN WEF AND Valid_UptoDate :10/7/2025 12:47:27 PM
spaResNo  SELECT * FROM MMSP0M0024 WHERE COMPANY_ID = 'W1' AND O_ID = '01' AND R_TY = 'R'Date :10/7/2025 12:47:27 PM
spaResNo  UPDATE MMSP0M0024 SET S_N = 17500 WHERE COMPANY_ID = 'W1' AND O_ID = '01' AND R_TY = 'R'Date :10/7/2025 12:47:27 PM
step16   select r_no from mmsp0m0001 where company_id='W1' and o_id='01'  and R_no ='17500'Date :10/7/2025 12:47:27 PM
step22  Select Top 1 TR_ID from MMSP0M0107 where COMPANY_ID='W1'  AND O_ID='01' And PK_ID='S7'Date :10/7/2025 12:47:27 PM
step23  SELECT TR_ID,TR_NM,TR_D,TR_P  FROM MMSP0M0104  WHERE COMPANY_ID='W1'  AND O_ID='01'And TR_ID='AB   'Date :10/7/2025 12:47:27 PM
step24  SELECT Sum(IsNull(Pr_Am,0)) Amt,Max(Ch_Ty) Ch_Ty   FROM MMSP0M0301   WHERE COMPANY_ID='W1' AND PR_LS='06'  AND  O_ID='01' And Ty_ID='P'  and tr_id='S7'  and isnull(ch_ty,0)<>0 Date :10/7/2025 12:47:27 PM
step25  SELECT A_8  FROM MMSP0M0305 WHERE COMPANY_ID='W1' AND PR_ID='06'  AND O_ID='01'Date :10/7/2025 12:47:27 PM
B_Ind   Select B_Ind from MMSP0M0106 where COMPANY_ID='W1' and pk_id='S7' And O_ID='01' Date :10/7/2025 12:47:27 PM
step27  INSERT INTO MMSP0M0001(R_FOR,COMPANY_ID,C_BY,T_DT,U_DT,ST_TS,C_DT,GS_ID,rv_id,DAY_RT_IND,T_TM,pk_am,sp_pr,P_X,pr_id,GS_NM,PKG_CNT,F_TM,PR_C,D_NO,GS_LN,R_No,P_ID,T_ID,GS_FN,O_ID,U_BY,CH_TY) VALUES ('P','W1','S07,','2025-11-21','2025/10/07 12:47:27','8','2025/10/07 12:47:27','1042','PS ','2','13:05',NULL,NULL,'2','06','Deepak,Mistry','1','12:00',NULL,'635','Mistry','17500','S7','AB   ','Deepak','01','STH','1')Date :10/7/2025 12:47:27 PM
step28  1Date :10/7/2025 12:47:27 PM
step30  INSERT INTO MMSP0M0002(A_IND,THR_ID,O_ID,S1_TM,E_TM,COMPANY_ID,E1_TM,S_TM,R_NO) VALUES ('0',' ','01','13:05','12:00','W1','13:05','12:00','17500')Date :10/7/2025 12:47:27 PM
step31  1Date :10/7/2025 12:47:27 PM
step33  INSERT INTO MMSP0M0003(S_NO,GS_FN,GS_ID,O_ID,COMPANY_ID,GS_LN,GS_TL,GS_NM,D_NO) VALUES ('1','Deepak','2840','01','W1','Mistry','00','Deepak,Mistry','17500')Date :10/7/2025 12:47:27 PM
step34  1Date :10/7/2025 12:47:27 PM
step36  SELECT * FROM MMSP0M0990 WHERE Company_ID='W1' And O_ID='01' And D_No='635' And T_Dt='2025-11-21' And PK_ID='S7'Date :10/7/2025 12:47:27 PM
step37  INSERT INTO MMSP0M0990(COMPANY_ID,NET_AMT,PR_ID,D_NO,AMT,U_BY,PK_ID,PK_Qty,T_DT,U_DT,DS_PR,O_ID,C_BY,C_DT,DS_AM,DY_NO,RT) VALUES ('W1','11000','06','635','11000','STH','S7','1','2025-11-21','2025/10/07 12:47:27',NULL,'01','S07,','2025/10/07 12:47:27',NULL,'4869','11000')Date :10/7/2025 12:47:27 PM
step38  1Date :10/7/2025 12:47:27 PM
step19  SELECT S_CMP_ID,S_OUT_ID,S_P_ID,S_PR_ID FROM AAFO0M0086 WHERE Company_ID='WS' AND FO_P_ID='S07' AND R_Ty_ID='MGK' AND Currency_ID='RS' AND '2025/10/07 12:47:27' BETWEEN WEF AND Valid_UptoDate :10/7/2025 12:47:27 PM
spaResNo  SELECT * FROM MMSP0M0024 WHERE COMPANY_ID = 'W1' AND O_ID = '01' AND R_TY = 'R'Date :10/7/2025 12:47:27 PM
spaResNo  UPDATE MMSP0M0024 SET S_N = 17501 WHERE COMPANY_ID = 'W1' AND O_ID = '01' AND R_TY = 'R'Date :10/7/2025 12:47:27 PM
step16   select r_no from mmsp0m0001 where company_id='W1' and o_id='01'  and R_no ='17501'Date :10/7/2025 12:47:27 PM
step22  Select Top 1 TR_ID from MMSP0M0107 where COMPANY_ID='W1'  AND O_ID='01' And PK_ID='S7'Date :10/7/2025 12:47:27 PM
step23  SELECT TR_ID,TR_NM,TR_D,TR_P  FROM MMSP0M0104  WHERE COMPANY_ID='W1'  AND O_ID='01'And TR_ID='AB   'Date :10/7/2025 12:47:27 PM
step24  SELECT Sum(IsNull(Pr_Am,0)) Amt,Max(Ch_Ty) Ch_Ty   FROM MMSP0M0301   WHERE COMPANY_ID='W1' AND PR_LS='06'  AND  O_ID='01' And Ty_ID='P'  and tr_id='S7'  and isnull(ch_ty,0)<>0 Date :10/7/2025 12:47:27 PM
step25  SELECT A_8  FROM MMSP0M0305 WHERE COMPANY_ID='W1' AND PR_ID='06'  AND O_ID='01'Date :10/7/2025 12:47:27 PM
B_Ind   Select B_Ind from MMSP0M0106 where COMPANY_ID='W1' and pk_id='S7' And O_ID='01' Date :10/7/2025 12:47:27 PM
step27  INSERT INTO MMSP0M0001(R_FOR,COMPANY_ID,C_BY,T_DT,U_DT,ST_TS,C_DT,GS_ID,rv_id,DAY_RT_IND,T_TM,pk_am,sp_pr,P_X,pr_id,GS_NM,PKG_CNT,F_TM,PR_C,D_NO,GS_LN,R_No,P_ID,T_ID,GS_FN,O_ID,U_BY,CH_TY) VALUES ('P','W1','S07,','2025-11-22','2025/10/07 12:47:27','8','2025/10/07 12:47:27','1042','PS ','2','13:05',NULL,NULL,'2','06','Deepak,Mistry','1','12:00',NULL,'635','Mistry','17501','S7','AB   ','Deepak','01','STH','1')Date :10/7/2025 12:47:27 PM
step28  1Date :10/7/2025 12:47:27 PM
step30  INSERT INTO MMSP0M0002(A_IND,THR_ID,O_ID,S1_TM,E_TM,COMPANY_ID,E1_TM,S_TM,R_NO) VALUES ('0',' ','01','13:05','12:00','W1','13:05','12:00','17501')Date :10/7/2025 12:47:27 PM
step31  1Date :10/7/2025 12:47:27 PM
step33  INSERT INTO MMSP0M0003(S_NO,GS_FN,GS_ID,O_ID,COMPANY_ID,GS_LN,GS_TL,GS_NM,D_NO) VALUES ('1','Deepak','2840','01','W1','Mistry','00','Deepak,Mistry','17501')Date :10/7/2025 12:47:27 PM
step34  1Date :10/7/2025 12:47:27 PM
step36  SELECT * FROM MMSP0M0990 WHERE Company_ID='W1' And O_ID='01' And D_No='635' And T_Dt='2025-11-22' And PK_ID='S7'Date :10/7/2025 12:47:27 PM
step37  INSERT INTO MMSP0M0990(COMPANY_ID,NET_AMT,PR_ID,D_NO,AMT,U_BY,PK_ID,PK_Qty,T_DT,U_DT,DS_PR,O_ID,C_BY,C_DT,DS_AM,DY_NO,RT) VALUES ('W1','11000','06','635','11000','STH','S7','1','2025-11-22','2025/10/07 12:47:27',NULL,'01','S07,','2025/10/07 12:47:27',NULL,'4870','11000')Date :10/7/2025 12:47:27 PM
step38  1Date :10/7/2025 12:47:27 PM
step19  SELECT S_CMP_ID,S_OUT_ID,S_P_ID,S_PR_ID FROM AAFO0M0086 WHERE Company_ID='WS' AND FO_P_ID='S07' AND R_Ty_ID='MGK' AND Currency_ID='RS' AND '2025/10/07 12:47:27' BETWEEN WEF AND Valid_UptoDate :10/7/2025 12:47:27 PM
spaResNo  SELECT * FROM MMSP0M0024 WHERE COMPANY_ID = 'W1' AND O_ID = '01' AND R_TY = 'R'Date :10/7/2025 12:47:27 PM
spaResNo  UPDATE MMSP0M0024 SET S_N = 17502 WHERE COMPANY_ID = 'W1' AND O_ID = '01' AND R_TY = 'R'Date :10/7/2025 12:47:27 PM
step16   select r_no from mmsp0m0001 where company_id='W1' and o_id='01'  and R_no ='17502'Date :10/7/2025 12:47:27 PM
step22  Select Top 1 TR_ID from MMSP0M0107 where COMPANY_ID='W1'  AND O_ID='01' And PK_ID='S7'Date :10/7/2025 12:47:27 PM
step23  SELECT TR_ID,TR_NM,TR_D,TR_P  FROM MMSP0M0104  WHERE COMPANY_ID='W1'  AND O_ID='01'And TR_ID='AB   'Date :10/7/2025 12:47:27 PM
step24  SELECT Sum(IsNull(Pr_Am,0)) Amt,Max(Ch_Ty) Ch_Ty   FROM MMSP0M0301   WHERE COMPANY_ID='W1' AND PR_LS='06'  AND  O_ID='01' And Ty_ID='P'  and tr_id='S7'  and isnull(ch_ty,0)<>0 Date :10/7/2025 12:47:27 PM
step25  SELECT A_8  FROM MMSP0M0305 WHERE COMPANY_ID='W1' AND PR_ID='06'  AND O_ID='01'Date :10/7/2025 12:47:27 PM
B_Ind   Select B_Ind from MMSP0M0106 where COMPANY_ID='W1' and pk_id='S7' And O_ID='01' Date :10/7/2025 12:47:27 PM
step27  INSERT INTO MMSP0M0001(R_FOR,COMPANY_ID,C_BY,T_DT,U_DT,ST_TS,C_DT,GS_ID,rv_id,DAY_RT_IND,T_TM,pk_am,sp_pr,P_X,pr_id,GS_NM,PKG_CNT,F_TM,PR_C,D_NO,GS_LN,R_No,P_ID,T_ID,GS_FN,O_ID,U_BY,CH_TY) VALUES ('P','W1','S07,','2025-11-23','2025/10/07 12:47:27','8','2025/10/07 12:47:27','1042','PS ','2','13:05',NULL,NULL,'2','06','Deepak,Mistry','1','12:00',NULL,'635','Mistry','17502','S7','AB   ','Deepak','01','STH','1')Date :10/7/2025 12:47:27 PM
step28  1Date :10/7/2025 12:47:27 PM
step30  INSERT INTO MMSP0M0002(A_IND,THR_ID,O_ID,S1_TM,E_TM,COMPANY_ID,E1_TM,S_TM,R_NO) VALUES ('0',' ','01','13:05','12:00','W1','13:05','12:00','17502')Date :10/7/2025 12:47:27 PM
step31  1Date :10/7/2025 12:47:27 PM
step33  INSERT INTO MMSP0M0003(S_NO,GS_FN,GS_ID,O_ID,COMPANY_ID,GS_LN,GS_TL,GS_NM,D_NO) VALUES ('1','Deepak','2840','01','W1','Mistry','00','Deepak,Mistry','17502')Date :10/7/2025 12:47:27 PM
step34  1Date :10/7/2025 12:47:27 PM
step36  SELECT * FROM MMSP0M0990 WHERE Company_ID='W1' And O_ID='01' And D_No='635' And T_Dt='2025-11-23' And PK_ID='S7'Date :10/7/2025 12:47:27 PM
step37  INSERT INTO MMSP0M0990(COMPANY_ID,NET_AMT,PR_ID,D_NO,AMT,U_BY,PK_ID,PK_Qty,T_DT,U_DT,DS_PR,O_ID,C_BY,C_DT,DS_AM,DY_NO,RT) VALUES ('W1','11000','06','635','11000','STH','S7','1','2025-11-23','2025/10/07 12:47:27',NULL,'01','S07,','2025/10/07 12:47:27',NULL,'4871','11000')Date :10/7/2025 12:47:27 PM
step38  1Date :10/7/2025 12:47:27 PM
step19  SELECT S_CMP_ID,S_OUT_ID,S_P_ID,S_PR_ID FROM AAFO0M0086 WHERE Company_ID='WS' AND FO_P_ID='S07' AND R_Ty_ID='MGK' AND Currency_ID='RS' AND '2025/10/07 12:47:27' BETWEEN WEF AND Valid_UptoDate :10/7/2025 12:47:27 PM
spaResNo  SELECT * FROM MMSP0M0024 WHERE COMPANY_ID = 'W1' AND O_ID = '01' AND R_TY = 'R'Date :10/7/2025 12:47:27 PM
spaResNo  UPDATE MMSP0M0024 SET S_N = 17503 WHERE COMPANY_ID = 'W1' AND O_ID = '01' AND R_TY = 'R'Date :10/7/2025 12:47:27 PM
step16   select r_no from mmsp0m0001 where company_id='W1' and o_id='01'  and R_no ='17503'Date :10/7/2025 12:47:27 PM
step22  Select Top 1 TR_ID from MMSP0M0107 where COMPANY_ID='W1'  AND O_ID='01' And PK_ID='S7'Date :10/7/2025 12:47:27 PM
step23  SELECT TR_ID,TR_NM,TR_D,TR_P  FROM MMSP0M0104  WHERE COMPANY_ID='W1'  AND O_ID='01'And TR_ID='AB   'Date :10/7/2025 12:47:27 PM
step24  SELECT Sum(IsNull(Pr_Am,0)) Amt,Max(Ch_Ty) Ch_Ty   FROM MMSP0M0301   WHERE COMPANY_ID='W1' AND PR_LS='06'  AND  O_ID='01' And Ty_ID='P'  and tr_id='S7'  and isnull(ch_ty,0)<>0 Date :10/7/2025 12:47:27 PM
step25  SELECT A_8  FROM MMSP0M0305 WHERE COMPANY_ID='W1' AND PR_ID='06'  AND O_ID='01'Date :10/7/2025 12:47:27 PM
B_Ind   Select B_Ind from MMSP0M0106 where COMPANY_ID='W1' and pk_id='S7' And O_ID='01' Date :10/7/2025 12:47:27 PM
step27  INSERT INTO MMSP0M0001(R_FOR,COMPANY_ID,C_BY,T_DT,U_DT,ST_TS,C_DT,GS_ID,rv_id,DAY_RT_IND,T_TM,pk_am,sp_pr,P_X,pr_id,GS_NM,PKG_CNT,F_TM,PR_C,D_NO,GS_LN,R_No,P_ID,T_ID,GS_FN,O_ID,U_BY,CH_TY) VALUES ('P','W1','S07,','2025-11-24','2025/10/07 12:47:27','8','2025/10/07 12:47:27','1042','PS ','2','13:05',NULL,NULL,'2','06','Deepak,Mistry','1','12:00',NULL,'635','Mistry','17503','S7','AB   ','Deepak','01','STH','1')Date :10/7/2025 12:47:27 PM
step28  1Date :10/7/2025 12:47:27 PM
step30  INSERT INTO MMSP0M0002(A_IND,THR_ID,O_ID,S1_TM,E_TM,COMPANY_ID,E1_TM,S_TM,R_NO) VALUES ('0',' ','01','13:05','12:00','W1','13:05','12:00','17503')Date :10/7/2025 12:47:27 PM
step31  1Date :10/7/2025 12:47:27 PM
step33  INSERT INTO MMSP0M0003(S_NO,GS_FN,GS_ID,O_ID,COMPANY_ID,GS_LN,GS_TL,GS_NM,D_NO) VALUES ('1','Deepak','2840','01','W1','Mistry','00','Deepak,Mistry','17503')Date :10/7/2025 12:47:27 PM
step34  1Date :10/7/2025 12:47:27 PM
step36  SELECT * FROM MMSP0M0990 WHERE Company_ID='W1' And O_ID='01' And D_No='635' And T_Dt='2025-11-24' And PK_ID='S7'Date :10/7/2025 12:47:27 PM
step37  INSERT INTO MMSP0M0990(COMPANY_ID,NET_AMT,PR_ID,D_NO,AMT,U_BY,PK_ID,PK_Qty,T_DT,U_DT,DS_PR,O_ID,C_BY,C_DT,DS_AM,DY_NO,RT) VALUES ('W1','11000','06','635','11000','STH','S7','1','2025-11-24','2025/10/07 12:47:27',NULL,'01','S07,','2025/10/07 12:47:27',NULL,'4872','11000')Date :10/7/2025 12:47:27 PM
step38  1Date :10/7/2025 12:47:27 PM
step19  SELECT S_CMP_ID,S_OUT_ID,S_P_ID,S_PR_ID FROM AAFO0M0086 WHERE Company_ID='WS' AND FO_P_ID='S07' AND R_Ty_ID='MGK' AND Currency_ID='RS' AND '2025/10/07 12:47:27' BETWEEN WEF AND Valid_UptoDate :10/7/2025 12:47:27 PM
spaResNo  SELECT * FROM MMSP0M0024 WHERE COMPANY_ID = 'W1' AND O_ID = '01' AND R_TY = 'R'Date :10/7/2025 12:47:27 PM
spaResNo  UPDATE MMSP0M0024 SET S_N = 17504 WHERE COMPANY_ID = 'W1' AND O_ID = '01' AND R_TY = 'R'Date :10/7/2025 12:47:27 PM
step16   select r_no from mmsp0m0001 where company_id='W1' and o_id='01'  and R_no ='17504'Date :10/7/2025 12:47:27 PM
step22  Select Top 1 TR_ID from MMSP0M0107 where COMPANY_ID='W1'  AND O_ID='01' And PK_ID='S7'Date :10/7/2025 12:47:27 PM
step23  SELECT TR_ID,TR_NM,TR_D,TR_P  FROM MMSP0M0104  WHERE COMPANY_ID='W1'  AND O_ID='01'And TR_ID='AB   'Date :10/7/2025 12:47:27 PM
step24  SELECT Sum(IsNull(Pr_Am,0)) Amt,Max(Ch_Ty) Ch_Ty   FROM MMSP0M0301   WHERE COMPANY_ID='W1' AND PR_LS='06'  AND  O_ID='01' And Ty_ID='P'  and tr_id='S7'  and isnull(ch_ty,0)<>0 Date :10/7/2025 12:47:27 PM
step25  SELECT A_8  FROM MMSP0M0305 WHERE COMPANY_ID='W1' AND PR_ID='06'  AND O_ID='01'Date :10/7/2025 12:47:27 PM
B_Ind   Select B_Ind from MMSP0M0106 where COMPANY_ID='W1' and pk_id='S7' And O_ID='01' Date :10/7/2025 12:47:27 PM
step27  INSERT INTO MMSP0M0001(R_FOR,COMPANY_ID,C_BY,T_DT,U_DT,ST_TS,C_DT,GS_ID,rv_id,DAY_RT_IND,T_TM,pk_am,sp_pr,P_X,pr_id,GS_NM,PKG_CNT,F_TM,PR_C,D_NO,GS_LN,R_No,P_ID,T_ID,GS_FN,O_ID,U_BY,CH_TY) VALUES ('P','W1','S07,','2025-11-25','2025/10/07 12:47:27','8','2025/10/07 12:47:27','1042','PS ','2','13:05',NULL,NULL,'2','06','Deepak,Mistry','1','12:00',NULL,'635','Mistry','17504','S7','AB   ','Deepak','01','STH','1')Date :10/7/2025 12:47:27 PM
step28  1Date :10/7/2025 12:47:27 PM
step30  INSERT INTO MMSP0M0002(A_IND,THR_ID,O_ID,S1_TM,E_TM,COMPANY_ID,E1_TM,S_TM,R_NO) VALUES ('0',' ','01','13:05','12:00','W1','13:05','12:00','17504')Date :10/7/2025 12:47:27 PM
step31  1Date :10/7/2025 12:47:27 PM
step33  INSERT INTO MMSP0M0003(S_NO,GS_FN,GS_ID,O_ID,COMPANY_ID,GS_LN,GS_TL,GS_NM,D_NO) VALUES ('1','Deepak','2840','01','W1','Mistry','00','Deepak,Mistry','17504')Date :10/7/2025 12:47:27 PM
step34  1Date :10/7/2025 12:47:27 PM
step36  SELECT * FROM MMSP0M0990 WHERE Company_ID='W1' And O_ID='01' And D_No='635' And T_Dt='2025-11-25' And PK_ID='S7'Date :10/7/2025 12:47:27 PM
step37  INSERT INTO MMSP0M0990(COMPANY_ID,NET_AMT,PR_ID,D_NO,AMT,U_BY,PK_ID,PK_Qty,T_DT,U_DT,DS_PR,O_ID,C_BY,C_DT,DS_AM,DY_NO,RT) VALUES ('W1','11000','06','635','11000','STH','S7','1','2025-11-25','2025/10/07 12:47:27',NULL,'01','S07,','2025/10/07 12:47:27',NULL,'4873','11000')Date :10/7/2025 12:47:27 PM
step38  1Date :10/7/2025 12:47:27 PM
step19  SELECT S_CMP_ID,S_OUT_ID,S_P_ID,S_PR_ID FROM AAFO0M0086 WHERE Company_ID='WS' AND FO_P_ID='S07' AND R_Ty_ID='MGK' AND Currency_ID='RS' AND '2025/10/07 12:47:27' BETWEEN WEF AND Valid_UptoDate :10/7/2025 12:47:27 PM
spaResNo  SELECT * FROM MMSP0M0024 WHERE COMPANY_ID = 'W1' AND O_ID = '01' AND R_TY = 'R'Date :10/7/2025 12:47:27 PM
spaResNo  UPDATE MMSP0M0024 SET S_N = 17505 WHERE COMPANY_ID = 'W1' AND O_ID = '01' AND R_TY = 'R'Date :10/7/2025 12:47:27 PM
step16   select r_no from mmsp0m0001 where company_id='W1' and o_id='01'  and R_no ='17505'Date :10/7/2025 12:47:27 PM
step22  Select Top 1 TR_ID from MMSP0M0107 where COMPANY_ID='W1'  AND O_ID='01' And PK_ID='S7'Date :10/7/2025 12:47:27 PM
step23  SELECT TR_ID,TR_NM,TR_D,TR_P  FROM MMSP0M0104  WHERE COMPANY_ID='W1'  AND O_ID='01'And TR_ID='AB   'Date :10/7/2025 12:47:27 PM
step24  SELECT Sum(IsNull(Pr_Am,0)) Amt,Max(Ch_Ty) Ch_Ty   FROM MMSP0M0301   WHERE COMPANY_ID='W1' AND PR_LS='06'  AND  O_ID='01' And Ty_ID='P'  and tr_id='S7'  and isnull(ch_ty,0)<>0 Date :10/7/2025 12:47:27 PM
step25  SELECT A_8  FROM MMSP0M0305 WHERE COMPANY_ID='W1' AND PR_ID='06'  AND O_ID='01'Date :10/7/2025 12:47:27 PM
B_Ind   Select B_Ind from MMSP0M0106 where COMPANY_ID='W1' and pk_id='S7' And O_ID='01' Date :10/7/2025 12:47:27 PM
step27  INSERT INTO MMSP0M0001(R_FOR,COMPANY_ID,C_BY,T_DT,U_DT,ST_TS,C_DT,GS_ID,rv_id,DAY_RT_IND,T_TM,pk_am,sp_pr,P_X,pr_id,GS_NM,PKG_CNT,F_TM,PR_C,D_NO,GS_LN,R_No,P_ID,T_ID,GS_FN,O_ID,U_BY,CH_TY) VALUES ('P','W1','S07,','2025-11-26','2025/10/07 12:47:27','8','2025/10/07 12:47:27','1042','PS ','2','13:05',NULL,NULL,'2','06','Deepak,Mistry','1','12:00',NULL,'635','Mistry','17505','S7','AB   ','Deepak','01','STH','1')Date :10/7/2025 12:47:27 PM
step28  1Date :10/7/2025 12:47:27 PM
step30  INSERT INTO MMSP0M0002(A_IND,THR_ID,O_ID,S1_TM,E_TM,COMPANY_ID,E1_TM,S_TM,R_NO) VALUES ('0',' ','01','13:05','12:00','W1','13:05','12:00','17505')Date :10/7/2025 12:47:27 PM
step31  1Date :10/7/2025 12:47:27 PM
step33  INSERT INTO MMSP0M0003(S_NO,GS_FN,GS_ID,O_ID,COMPANY_ID,GS_LN,GS_TL,GS_NM,D_NO) VALUES ('1','Deepak','2840','01','W1','Mistry','00','Deepak,Mistry','17505')Date :10/7/2025 12:47:27 PM
step34  1Date :10/7/2025 12:47:27 PM
step36  SELECT * FROM MMSP0M0990 WHERE Company_ID='W1' And O_ID='01' And D_No='635' And T_Dt='2025-11-26' And PK_ID='S7'Date :10/7/2025 12:47:27 PM
step37  INSERT INTO MMSP0M0990(COMPANY_ID,NET_AMT,PR_ID,D_NO,AMT,U_BY,PK_ID,PK_Qty,T_DT,U_DT,DS_PR,O_ID,C_BY,C_DT,DS_AM,DY_NO,RT) VALUES ('W1','11000','06','635','11000','STH','S7','1','2025-11-26','2025/10/07 12:47:27',NULL,'01','S07,','2025/10/07 12:47:27',NULL,'4874','11000')Date :10/7/2025 12:47:27 PM
step38  1Date :10/7/2025 12:47:27 PM
step39  UPDATE FO_Reserve SET GUEST1_TITLE_ID= 'MR',EMAIL= 'revenuemanager@thecorinthianspune.com',SP_Res_No= '17505',DOB= NULL,SP_Cmp_ID= 'W1',Dyn1_ID= '635',SP_O_ID= '01',MOBILE= '+917447782591' WHERE Company_ID='WS' AND Reserve_No='1293'Date :10/7/2025 12:47:27 PM
step41  1Date :10/7/2025 12:47:27 PM
SucessDate :10/7/2025 12:47:27 PM
step 1     SELECT isnull(TARIFF_DISC_PER,0)as TARIFFDISCPER ,isnull(TARIFF_DISC_AMT,0) as TARIFFDISCAMT ,CONVERT(varchar(6), ARRIVAL_DT, 12) as DateFormate ,convert(varchar ,ARRIVAL_DT,23) as ARRIVAL_DT,* FROM FO_RESERVE WHERE COMPANY_ID='WS' AND r_no='928'Date :10/7/2025 12:50:27 PM
step 2  SELECT RESERVE_NO, STRING_AGG(GUEST_NM, '# ') AS vSPA_G_NM_All, STRING_AGG(GUEST_TITLE_ID, '# ') AS vSPA_GTit_All, STRING_AGG(C2_N1, '# ') AS vSPA_GF_NM_All, STRING_AGG(C2_N2, '#') AS vSPA_GL_NM_All, STRING_AGG(G_ID, '# ') AS SPA_Guest_ID_All from  FO_RESERVE_DET  WHERE COMPANY_ID='WS' AND RESERVE_NO='1294' GROUP BY RESERVE_NO Date :10/7/2025 12:50:27 PM
step 3   Select PK_Id from FO_ROOM_TYPE_TARIFF where Company_Id ='WS' and Room_Ty_Id ='MGK' and Rate_Ty_Id ='I07' and Currency_Id='RS'  And '251026' >= FROM_DT And '251026' <= TO_DT  AND D_IND IS NULL Date :10/7/2025 12:50:27 PM
step 4  Select * from AAFO0M0120 Where Company_Id ='WS' and  P_Id in ('I07','')Date :10/7/2025 12:50:27 PM
step 5  Date :10/7/2025 12:50:27 PM
step 6  INSERT INTO AAFO0M0121(CH_D,COMPANY_ID,C_IND,P_ID,RT_C3,IT_NM,S_No,RT_C2,C_UR,RT_RM,C_BY,B_IND,H_IND,SR_NO,P_IND,CH_TY,R_IND,R_NO,IT_ID,Q_TY,RT_C1,U_By,RT_A) VALUES ('0','WS',NULL,'I07',NULL,'WELLBEING','2',NULL,'RS','0.000','0270',NULL,'P','1',NULL,'02','1','1294','WEL','1',NULL,'0270','0.000')Date :10/7/2025 12:50:27 PM
step 8  INSERT INTO AAFO0M0279(COMPANY_ID,C_IND,RES_IND,P_ID,RT_C3,IT_NM,RT_C1,RESER_NO,C_UR,PS_NO,S_DT,RT_C2,SR_NO,B_IND,CH_TY,R_IND,IT_ID,S_NO,D_P,E_DT,RT_A) VALUES ('WS',NULL,'R','I07',NULL,'WELLBEING',NULL,'1294','RS','2',NULL,NULL,'1',NULL,'02','1','WEL','1','1',NULL,'0.000')Date :10/7/2025 12:50:27 PM
step 9  1Date :10/7/2025 12:50:27 PM
step 11  SELECT TOP 1 P_ID  FROM AAFO0M0121 WHERE COMPANY_ID='WS' AND R_NO='1294'Date :10/7/2025 12:50:27 PM
step 12  SELECT distinct P_ID  FROM AAFO0M0121 WHERE COMPANY_ID='WS' AND R_NO='1294'Date :10/7/2025 12:50:27 PM
step 13  Date :10/7/2025 12:50:27 PM
step vGArrDt   2025-10-26Date :10/7/2025 12:50:27 PM
step14  SELECT * FROM AAFO0M0086 WHERE Company_ID='WS' AND FO_P_ID='I07' AND R_Ty_ID='MGK'  AND Currency_ID='RS' AND  '2025-10-26' BETWEEN WEF AND Valid_Upto Date :10/7/2025 12:50:27 PM
 Step 1 fnCreate_SPASELECT isnull(U2_IND,0) as  U2_IND,isnull(Y1_IND,0) as Y1_IND  FROM MMSP0M0400 WHERE Company_ID='W1'Date :10/7/2025 12:50:27 PM
Step 2 fnCreate_SPA SELECT * FROM MMSP0M0030 WHERE company_id='W1' AND cm_id=563 AND gs_cat='G'Date :10/7/2025 12:50:27 PM
Step 3 fnCreate_SPA SELECT in_id FROM mmsp0m0103 WHERE company_id='W1' AND c_ind=1Date :10/7/2025 12:50:27 PM
Step 4SELECT guest_nm,Guest_title_Id,P1_Nm,O1_Nm,Add1,Add2,Add3,place,pin_cd,res_tel,email,mobile,dob,anniv_dt,SPOUCE_NM,OCCUPATION,LIKES_NARRATION,DISLIKES_NARRATION,country_id,Gend_ID,d1_id,isnull(Guest_Ty_ID,'') as Guest_Ty_ID,A14_Id,B14_Id,Df_1,Df_2,Df_3 FROM FO_GUEST WHERE Company_ID='WS' AND Guest_Id=563Date :10/7/2025 12:50:27 PM
Step 6 fnCreate_SPAFalseDate :10/7/2025 12:50:27 PM
Step 7 fnCreate_SPAINSERT INTO MMSP0M0030(Rs_T,GS_Tl_Id,Add2,GS_NM,Ct_ID,Cn_Pr,Cn_Tl,SP_NM,GS_NM1,Company_id,DOA,CM_id,LK_NR,Gend_ID,m_ind,Em,Cn_Ds,HT_NR,U_By,mb,Pn,J_NR,C_By,K_IND,U_Dt,DB,GS_cat,GS_Id,GS_N,Add3,C_Dt,Pl,Add1) VALUES ('+919881828486','MR','','Deepak','',NULL,NULL,'','Chakre','W1','','563','','M','1','deepak.chakre@swastikwellbeing.com',NULL,'','I07,','+919881828486','411002    ','','I07,','3','2025/10/07 12:50:27','','G','1043','Chakre,Deepak','','2025/10/07 12:50:27','PUNE - 411002','')Date :10/7/2025 12:50:27 PM
step15   SELECT IN_GST_IND, k_Tax, OTH_CLB_APPL, COMMON_INTFC_IND, D_IND FROM MST_COMPANY WHERE Company_ID = 'WS' Date :10/7/2025 12:50:27 PM
step16   SELECT * FROM MMSP0M0111  WHERE COMPANY_ID='W1' and o_id='01' and d_no ='928'Date :10/7/2025 12:50:27 PM
spaResNo  SELECT * FROM MMSP0M0024 WHERE COMPANY_ID = 'W1' AND O_ID = '01' AND R_TY = 'D'Date :10/7/2025 12:50:27 PM
spaResNo  UPDATE MMSP0M0024 SET S_N = 636 WHERE COMPANY_ID = 'W1' AND O_ID = '01' AND R_TY = 'D'Date :10/7/2025 12:50:27 PM
step17  INSERT INTO MMSP0M0111(D_NO,U_DT,O_ID,C_BY,COMPANY_ID,U_BY,C_DT) VALUES ('636','2025/10/07 12:50:27','01','I07,','W1','STH','2025/10/07 12:50:27')Date :10/7/2025 12:50:27 PM
step19  SELECT S_CMP_ID,S_OUT_ID,S_P_ID,S_PR_ID FROM AAFO0M0086 WHERE Company_ID='WS' AND FO_P_ID='I07' AND R_Ty_ID='MGK' AND Currency_ID='RS' AND '2025/10/07 12:50:27' BETWEEN WEF AND Valid_UptoDate :10/7/2025 12:50:27 PM
spaResNo  SELECT * FROM MMSP0M0024 WHERE COMPANY_ID = 'W1' AND O_ID = '01' AND R_TY = 'R'Date :10/7/2025 12:50:27 PM
spaResNo  UPDATE MMSP0M0024 SET S_N = 17506 WHERE COMPANY_ID = 'W1' AND O_ID = '01' AND R_TY = 'R'Date :10/7/2025 12:50:27 PM
step16   select r_no from mmsp0m0001 where company_id='W1' and o_id='01'  and R_no ='17506'Date :10/7/2025 12:50:27 PM
step22  Select Top 1 TR_ID from MMSP0M0107 where COMPANY_ID='W1'  AND O_ID='01' And PK_ID='I7'Date :10/7/2025 12:50:27 PM
step23  SELECT TR_ID,TR_NM,TR_D,TR_P  FROM MMSP0M0104  WHERE COMPANY_ID='W1'  AND O_ID='01'And TR_ID='AB   'Date :10/7/2025 12:50:27 PM
step24  SELECT Sum(IsNull(Pr_Am,0)) Amt,Max(Ch_Ty) Ch_Ty   FROM MMSP0M0301   WHERE COMPANY_ID='W1' AND PR_LS='06'  AND  O_ID='01' And Ty_ID='P'  and tr_id='I7'  and isnull(ch_ty,0)<>0 Date :10/7/2025 12:50:27 PM
step25  SELECT A_8  FROM MMSP0M0305 WHERE COMPANY_ID='W1' AND PR_ID='06'  AND O_ID='01'Date :10/7/2025 12:50:27 PM
B_Ind   Select B_Ind from MMSP0M0106 where COMPANY_ID='W1' and pk_id='I7' And O_ID='01' Date :10/7/2025 12:50:27 PM
step27  INSERT INTO MMSP0M0001(R_FOR,COMPANY_ID,C_BY,T_DT,U_DT,ST_TS,C_DT,GS_ID,rv_id,DAY_RT_IND,T_TM,pk_am,sp_pr,P_X,pr_id,GS_NM,PKG_CNT,F_TM,PR_C,D_NO,GS_LN,R_No,P_ID,T_ID,GS_FN,O_ID,U_BY,CH_TY) VALUES ('P','W1','I07,','2025-10-26','2025/10/07 12:50:27','8','2025/10/07 12:50:27','1043','PS ','2','13:05',NULL,NULL,'2','06','Deepak,Chakre','1','12:00',NULL,'636','Chakre','17506','I7','AB   ','Deepak','01','STH','1')Date :10/7/2025 12:50:27 PM
step28  1Date :10/7/2025 12:50:27 PM
step30  INSERT INTO MMSP0M0002(A_IND,THR_ID,O_ID,S1_TM,E_TM,COMPANY_ID,E1_TM,S_TM,R_NO) VALUES ('0',' ','01','13:05','12:00','W1','13:05','12:00','17506')Date :10/7/2025 12:50:27 PM
step31  1Date :10/7/2025 12:50:27 PM
step33  INSERT INTO MMSP0M0003(S_NO,GS_FN,GS_ID,O_ID,COMPANY_ID,GS_LN,GS_TL,GS_NM,D_NO) VALUES ('1','Deepak','563','01','W1','Chakre','00','Deepak,Chakre','17506')Date :10/7/2025 12:50:27 PM
step34  1Date :10/7/2025 12:50:27 PM
step36  SELECT * FROM MMSP0M0990 WHERE Company_ID='W1' And O_ID='01' And D_No='636' And T_Dt='2025-10-26' And PK_ID='I7'Date :10/7/2025 12:50:27 PM
step37  INSERT INTO MMSP0M0990(COMPANY_ID,NET_AMT,PR_ID,D_NO,AMT,U_BY,PK_ID,PK_Qty,T_DT,U_DT,DS_PR,O_ID,C_BY,C_DT,DS_AM,DY_NO,RT) VALUES ('W1','11000','06','636','11000','STH','I7','1','2025-10-26','2025/10/07 12:50:27',NULL,'01','I07,','2025/10/07 12:50:27',NULL,'4875','11000')Date :10/7/2025 12:50:27 PM
step38  1Date :10/7/2025 12:50:27 PM
step19  SELECT S_CMP_ID,S_OUT_ID,S_P_ID,S_PR_ID FROM AAFO0M0086 WHERE Company_ID='WS' AND FO_P_ID='I07' AND R_Ty_ID='MGK' AND Currency_ID='RS' AND '2025/10/07 12:50:27' BETWEEN WEF AND Valid_UptoDate :10/7/2025 12:50:27 PM
spaResNo  SELECT * FROM MMSP0M0024 WHERE COMPANY_ID = 'W1' AND O_ID = '01' AND R_TY = 'R'Date :10/7/2025 12:50:27 PM
spaResNo  UPDATE MMSP0M0024 SET S_N = 17507 WHERE COMPANY_ID = 'W1' AND O_ID = '01' AND R_TY = 'R'Date :10/7/2025 12:50:27 PM
step16   select r_no from mmsp0m0001 where company_id='W1' and o_id='01'  and R_no ='17507'Date :10/7/2025 12:50:27 PM
step22  Select Top 1 TR_ID from MMSP0M0107 where COMPANY_ID='W1'  AND O_ID='01' And PK_ID='I7'Date :10/7/2025 12:50:27 PM
step23  SELECT TR_ID,TR_NM,TR_D,TR_P  FROM MMSP0M0104  WHERE COMPANY_ID='W1'  AND O_ID='01'And TR_ID='AB   'Date :10/7/2025 12:50:27 PM
step24  SELECT Sum(IsNull(Pr_Am,0)) Amt,Max(Ch_Ty) Ch_Ty   FROM MMSP0M0301   WHERE COMPANY_ID='W1' AND PR_LS='06'  AND  O_ID='01' And Ty_ID='P'  and tr_id='I7'  and isnull(ch_ty,0)<>0 Date :10/7/2025 12:50:27 PM
step25  SELECT A_8  FROM MMSP0M0305 WHERE COMPANY_ID='W1' AND PR_ID='06'  AND O_ID='01'Date :10/7/2025 12:50:27 PM
B_Ind   Select B_Ind from MMSP0M0106 where COMPANY_ID='W1' and pk_id='I7' And O_ID='01' Date :10/7/2025 12:50:27 PM
step27  INSERT INTO MMSP0M0001(R_FOR,COMPANY_ID,C_BY,T_DT,U_DT,ST_TS,C_DT,GS_ID,rv_id,DAY_RT_IND,T_TM,pk_am,sp_pr,P_X,pr_id,GS_NM,PKG_CNT,F_TM,PR_C,D_NO,GS_LN,R_No,P_ID,T_ID,GS_FN,O_ID,U_BY,CH_TY) VALUES ('P','W1','I07,','2025-10-27','2025/10/07 12:50:27','8','2025/10/07 12:50:27','1043','PS ','2','13:05',NULL,NULL,'2','06','Deepak,Chakre','1','12:00',NULL,'636','Chakre','17507','I7','AB   ','Deepak','01','STH','1')Date :10/7/2025 12:50:27 PM
step28  1Date :10/7/2025 12:50:27 PM
step30  INSERT INTO MMSP0M0002(A_IND,THR_ID,O_ID,S1_TM,E_TM,COMPANY_ID,E1_TM,S_TM,R_NO) VALUES ('0',' ','01','13:05','12:00','W1','13:05','12:00','17507')Date :10/7/2025 12:50:27 PM
step31  1Date :10/7/2025 12:50:27 PM
step33  INSERT INTO MMSP0M0003(S_NO,GS_FN,GS_ID,O_ID,COMPANY_ID,GS_LN,GS_TL,GS_NM,D_NO) VALUES ('1','Deepak','563','01','W1','Chakre','00','Deepak,Chakre','17507')Date :10/7/2025 12:50:27 PM
step34  1Date :10/7/2025 12:50:27 PM
step36  SELECT * FROM MMSP0M0990 WHERE Company_ID='W1' And O_ID='01' And D_No='636' And T_Dt='2025-10-27' And PK_ID='I7'Date :10/7/2025 12:50:27 PM
step37  INSERT INTO MMSP0M0990(COMPANY_ID,NET_AMT,PR_ID,D_NO,AMT,U_BY,PK_ID,PK_Qty,T_DT,U_DT,DS_PR,O_ID,C_BY,C_DT,DS_AM,DY_NO,RT) VALUES ('W1','11000','06','636','11000','STH','I7','1','2025-10-27','2025/10/07 12:50:27',NULL,'01','I07,','2025/10/07 12:50:27',NULL,'4876','11000')Date :10/7/2025 12:50:27 PM
step38  1Date :10/7/2025 12:50:27 PM
step19  SELECT S_CMP_ID,S_OUT_ID,S_P_ID,S_PR_ID FROM AAFO0M0086 WHERE Company_ID='WS' AND FO_P_ID='I07' AND R_Ty_ID='MGK' AND Currency_ID='RS' AND '2025/10/07 12:50:27' BETWEEN WEF AND Valid_UptoDate :10/7/2025 12:50:27 PM
spaResNo  SELECT * FROM MMSP0M0024 WHERE COMPANY_ID = 'W1' AND O_ID = '01' AND R_TY = 'R'Date :10/7/2025 12:50:27 PM
spaResNo  UPDATE MMSP0M0024 SET S_N = 17508 WHERE COMPANY_ID = 'W1' AND O_ID = '01' AND R_TY = 'R'Date :10/7/2025 12:50:27 PM
step16   select r_no from mmsp0m0001 where company_id='W1' and o_id='01'  and R_no ='17508'Date :10/7/2025 12:50:27 PM
step22  Select Top 1 TR_ID from MMSP0M0107 where COMPANY_ID='W1'  AND O_ID='01' And PK_ID='I7'Date :10/7/2025 12:50:27 PM
step23  SELECT TR_ID,TR_NM,TR_D,TR_P  FROM MMSP0M0104  WHERE COMPANY_ID='W1'  AND O_ID='01'And TR_ID='AB   'Date :10/7/2025 12:50:27 PM
step24  SELECT Sum(IsNull(Pr_Am,0)) Amt,Max(Ch_Ty) Ch_Ty   FROM MMSP0M0301   WHERE COMPANY_ID='W1' AND PR_LS='06'  AND  O_ID='01' And Ty_ID='P'  and tr_id='I7'  and isnull(ch_ty,0)<>0 Date :10/7/2025 12:50:27 PM
step25  SELECT A_8  FROM MMSP0M0305 WHERE COMPANY_ID='W1' AND PR_ID='06'  AND O_ID='01'Date :10/7/2025 12:50:27 PM
B_Ind   Select B_Ind from MMSP0M0106 where COMPANY_ID='W1' and pk_id='I7' And O_ID='01' Date :10/7/2025 12:50:27 PM
step27  INSERT INTO MMSP0M0001(R_FOR,COMPANY_ID,C_BY,T_DT,U_DT,ST_TS,C_DT,GS_ID,rv_id,DAY_RT_IND,T_TM,pk_am,sp_pr,P_X,pr_id,GS_NM,PKG_CNT,F_TM,PR_C,D_NO,GS_LN,R_No,P_ID,T_ID,GS_FN,O_ID,U_BY,CH_TY) VALUES ('P','W1','I07,','2025-10-28','2025/10/07 12:50:27','8','2025/10/07 12:50:27','1043','PS ','2','13:05',NULL,NULL,'2','06','Deepak,Chakre','1','12:00',NULL,'636','Chakre','17508','I7','AB   ','Deepak','01','STH','1')Date :10/7/2025 12:50:27 PM
step28  1Date :10/7/2025 12:50:27 PM
step30  INSERT INTO MMSP0M0002(A_IND,THR_ID,O_ID,S1_TM,E_TM,COMPANY_ID,E1_TM,S_TM,R_NO) VALUES ('0',' ','01','13:05','12:00','W1','13:05','12:00','17508')Date :10/7/2025 12:50:27 PM
step31  1Date :10/7/2025 12:50:27 PM
step33  INSERT INTO MMSP0M0003(S_NO,GS_FN,GS_ID,O_ID,COMPANY_ID,GS_LN,GS_TL,GS_NM,D_NO) VALUES ('1','Deepak','563','01','W1','Chakre','00','Deepak,Chakre','17508')Date :10/7/2025 12:50:27 PM
step34  1Date :10/7/2025 12:50:27 PM
step36  SELECT * FROM MMSP0M0990 WHERE Company_ID='W1' And O_ID='01' And D_No='636' And T_Dt='2025-10-28' And PK_ID='I7'Date :10/7/2025 12:50:27 PM
step37  INSERT INTO MMSP0M0990(COMPANY_ID,NET_AMT,PR_ID,D_NO,AMT,U_BY,PK_ID,PK_Qty,T_DT,U_DT,DS_PR,O_ID,C_BY,C_DT,DS_AM,DY_NO,RT) VALUES ('W1','11000','06','636','11000','STH','I7','1','2025-10-28','2025/10/07 12:50:27',NULL,'01','I07,','2025/10/07 12:50:27',NULL,'4877','11000')Date :10/7/2025 12:50:27 PM
step38  1Date :10/7/2025 12:50:27 PM
step19  SELECT S_CMP_ID,S_OUT_ID,S_P_ID,S_PR_ID FROM AAFO0M0086 WHERE Company_ID='WS' AND FO_P_ID='I07' AND R_Ty_ID='MGK' AND Currency_ID='RS' AND '2025/10/07 12:50:27' BETWEEN WEF AND Valid_UptoDate :10/7/2025 12:50:27 PM
spaResNo  SELECT * FROM MMSP0M0024 WHERE COMPANY_ID = 'W1' AND O_ID = '01' AND R_TY = 'R'Date :10/7/2025 12:50:27 PM
spaResNo  UPDATE MMSP0M0024 SET S_N = 17509 WHERE COMPANY_ID = 'W1' AND O_ID = '01' AND R_TY = 'R'Date :10/7/2025 12:50:27 PM
step16   select r_no from mmsp0m0001 where company_id='W1' and o_id='01'  and R_no ='17509'Date :10/7/2025 12:50:27 PM
step22  Select Top 1 TR_ID from MMSP0M0107 where COMPANY_ID='W1'  AND O_ID='01' And PK_ID='I7'Date :10/7/2025 12:50:27 PM
step23  SELECT TR_ID,TR_NM,TR_D,TR_P  FROM MMSP0M0104  WHERE COMPANY_ID='W1'  AND O_ID='01'And TR_ID='AB   'Date :10/7/2025 12:50:27 PM
step24  SELECT Sum(IsNull(Pr_Am,0)) Amt,Max(Ch_Ty) Ch_Ty   FROM MMSP0M0301   WHERE COMPANY_ID='W1' AND PR_LS='06'  AND  O_ID='01' And Ty_ID='P'  and tr_id='I7'  and isnull(ch_ty,0)<>0 Date :10/7/2025 12:50:27 PM
step25  SELECT A_8  FROM MMSP0M0305 WHERE COMPANY_ID='W1' AND PR_ID='06'  AND O_ID='01'Date :10/7/2025 12:50:27 PM
B_Ind   Select B_Ind from MMSP0M0106 where COMPANY_ID='W1' and pk_id='I7' And O_ID='01' Date :10/7/2025 12:50:27 PM
step27  INSERT INTO MMSP0M0001(R_FOR,COMPANY_ID,C_BY,T_DT,U_DT,ST_TS,C_DT,GS_ID,rv_id,DAY_RT_IND,T_TM,pk_am,sp_pr,P_X,pr_id,GS_NM,PKG_CNT,F_TM,PR_C,D_NO,GS_LN,R_No,P_ID,T_ID,GS_FN,O_ID,U_BY,CH_TY) VALUES ('P','W1','I07,','2025-10-29','2025/10/07 12:50:27','8','2025/10/07 12:50:27','1043','PS ','2','13:05',NULL,NULL,'2','06','Deepak,Chakre','1','12:00',NULL,'636','Chakre','17509','I7','AB   ','Deepak','01','STH','1')Date :10/7/2025 12:50:27 PM
step28  1Date :10/7/2025 12:50:27 PM
step30  INSERT INTO MMSP0M0002(A_IND,THR_ID,O_ID,S1_TM,E_TM,COMPANY_ID,E1_TM,S_TM,R_NO) VALUES ('0',' ','01','13:05','12:00','W1','13:05','12:00','17509')Date :10/7/2025 12:50:27 PM
step31  1Date :10/7/2025 12:50:27 PM
step33  INSERT INTO MMSP0M0003(S_NO,GS_FN,GS_ID,O_ID,COMPANY_ID,GS_LN,GS_TL,GS_NM,D_NO) VALUES ('1','Deepak','563','01','W1','Chakre','00','Deepak,Chakre','17509')Date :10/7/2025 12:50:27 PM
step34  1Date :10/7/2025 12:50:27 PM
step36  SELECT * FROM MMSP0M0990 WHERE Company_ID='W1' And O_ID='01' And D_No='636' And T_Dt='2025-10-29' And PK_ID='I7'Date :10/7/2025 12:50:27 PM
step37  INSERT INTO MMSP0M0990(COMPANY_ID,NET_AMT,PR_ID,D_NO,AMT,U_BY,PK_ID,PK_Qty,T_DT,U_DT,DS_PR,O_ID,C_BY,C_DT,DS_AM,DY_NO,RT) VALUES ('W1','11000','06','636','11000','STH','I7','1','2025-10-29','2025/10/07 12:50:27',NULL,'01','I07,','2025/10/07 12:50:27',NULL,'4878','11000')Date :10/7/2025 12:50:27 PM
step38  1Date :10/7/2025 12:50:27 PM
step19  SELECT S_CMP_ID,S_OUT_ID,S_P_ID,S_PR_ID FROM AAFO0M0086 WHERE Company_ID='WS' AND FO_P_ID='I07' AND R_Ty_ID='MGK' AND Currency_ID='RS' AND '2025/10/07 12:50:27' BETWEEN WEF AND Valid_UptoDate :10/7/2025 12:50:27 PM
spaResNo  SELECT * FROM MMSP0M0024 WHERE COMPANY_ID = 'W1' AND O_ID = '01' AND R_TY = 'R'Date :10/7/2025 12:50:27 PM
spaResNo  UPDATE MMSP0M0024 SET S_N = 17510 WHERE COMPANY_ID = 'W1' AND O_ID = '01' AND R_TY = 'R'Date :10/7/2025 12:50:27 PM
step16   select r_no from mmsp0m0001 where company_id='W1' and o_id='01'  and R_no ='17510'Date :10/7/2025 12:50:27 PM
step22  Select Top 1 TR_ID from MMSP0M0107 where COMPANY_ID='W1'  AND O_ID='01' And PK_ID='I7'Date :10/7/2025 12:50:27 PM
step23  SELECT TR_ID,TR_NM,TR_D,TR_P  FROM MMSP0M0104  WHERE COMPANY_ID='W1'  AND O_ID='01'And TR_ID='AB   'Date :10/7/2025 12:50:27 PM
step24  SELECT Sum(IsNull(Pr_Am,0)) Amt,Max(Ch_Ty) Ch_Ty   FROM MMSP0M0301   WHERE COMPANY_ID='W1' AND PR_LS='06'  AND  O_ID='01' And Ty_ID='P'  and tr_id='I7'  and isnull(ch_ty,0)<>0 Date :10/7/2025 12:50:27 PM
step25  SELECT A_8  FROM MMSP0M0305 WHERE COMPANY_ID='W1' AND PR_ID='06'  AND O_ID='01'Date :10/7/2025 12:50:27 PM
B_Ind   Select B_Ind from MMSP0M0106 where COMPANY_ID='W1' and pk_id='I7' And O_ID='01' Date :10/7/2025 12:50:27 PM
step27  INSERT INTO MMSP0M0001(R_FOR,COMPANY_ID,C_BY,T_DT,U_DT,ST_TS,C_DT,GS_ID,rv_id,DAY_RT_IND,T_TM,pk_am,sp_pr,P_X,pr_id,GS_NM,PKG_CNT,F_TM,PR_C,D_NO,GS_LN,R_No,P_ID,T_ID,GS_FN,O_ID,U_BY,CH_TY) VALUES ('P','W1','I07,','2025-10-30','2025/10/07 12:50:27','8','2025/10/07 12:50:27','1043','PS ','2','13:05',NULL,NULL,'2','06','Deepak,Chakre','1','12:00',NULL,'636','Chakre','17510','I7','AB   ','Deepak','01','STH','1')Date :10/7/2025 12:50:27 PM
step28  1Date :10/7/2025 12:50:27 PM
step30  INSERT INTO MMSP0M0002(A_IND,THR_ID,O_ID,S1_TM,E_TM,COMPANY_ID,E1_TM,S_TM,R_NO) VALUES ('0',' ','01','13:05','12:00','W1','13:05','12:00','17510')Date :10/7/2025 12:50:27 PM
step31  1Date :10/7/2025 12:50:27 PM
step33  INSERT INTO MMSP0M0003(S_NO,GS_FN,GS_ID,O_ID,COMPANY_ID,GS_LN,GS_TL,GS_NM,D_NO) VALUES ('1','Deepak','563','01','W1','Chakre','00','Deepak,Chakre','17510')Date :10/7/2025 12:50:27 PM
step34  1Date :10/7/2025 12:50:27 PM
step36  SELECT * FROM MMSP0M0990 WHERE Company_ID='W1' And O_ID='01' And D_No='636' And T_Dt='2025-10-30' And PK_ID='I7'Date :10/7/2025 12:50:27 PM
step37  INSERT INTO MMSP0M0990(COMPANY_ID,NET_AMT,PR_ID,D_NO,AMT,U_BY,PK_ID,PK_Qty,T_DT,U_DT,DS_PR,O_ID,C_BY,C_DT,DS_AM,DY_NO,RT) VALUES ('W1','11000','06','636','11000','STH','I7','1','2025-10-30','2025/10/07 12:50:27',NULL,'01','I07,','2025/10/07 12:50:27',NULL,'4879','11000')Date :10/7/2025 12:50:27 PM
step38  1Date :10/7/2025 12:50:27 PM
step19  SELECT S_CMP_ID,S_OUT_ID,S_P_ID,S_PR_ID FROM AAFO0M0086 WHERE Company_ID='WS' AND FO_P_ID='I07' AND R_Ty_ID='MGK' AND Currency_ID='RS' AND '2025/10/07 12:50:27' BETWEEN WEF AND Valid_UptoDate :10/7/2025 12:50:27 PM
spaResNo  SELECT * FROM MMSP0M0024 WHERE COMPANY_ID = 'W1' AND O_ID = '01' AND R_TY = 'R'Date :10/7/2025 12:50:27 PM
spaResNo  UPDATE MMSP0M0024 SET S_N = 17511 WHERE COMPANY_ID = 'W1' AND O_ID = '01' AND R_TY = 'R'Date :10/7/2025 12:50:27 PM
step16   select r_no from mmsp0m0001 where company_id='W1' and o_id='01'  and R_no ='17511'Date :10/7/2025 12:50:27 PM
step22  Select Top 1 TR_ID from MMSP0M0107 where COMPANY_ID='W1'  AND O_ID='01' And PK_ID='I7'Date :10/7/2025 12:50:27 PM
step23  SELECT TR_ID,TR_NM,TR_D,TR_P  FROM MMSP0M0104  WHERE COMPANY_ID='W1'  AND O_ID='01'And TR_ID='AB   'Date :10/7/2025 12:50:27 PM
step24  SELECT Sum(IsNull(Pr_Am,0)) Amt,Max(Ch_Ty) Ch_Ty   FROM MMSP0M0301   WHERE COMPANY_ID='W1' AND PR_LS='06'  AND  O_ID='01' And Ty_ID='P'  and tr_id='I7'  and isnull(ch_ty,0)<>0 Date :10/7/2025 12:50:27 PM
step25  SELECT A_8  FROM MMSP0M0305 WHERE COMPANY_ID='W1' AND PR_ID='06'  AND O_ID='01'Date :10/7/2025 12:50:27 PM
B_Ind   Select B_Ind from MMSP0M0106 where COMPANY_ID='W1' and pk_id='I7' And O_ID='01' Date :10/7/2025 12:50:27 PM
step27  INSERT INTO MMSP0M0001(R_FOR,COMPANY_ID,C_BY,T_DT,U_DT,ST_TS,C_DT,GS_ID,rv_id,DAY_RT_IND,T_TM,pk_am,sp_pr,P_X,pr_id,GS_NM,PKG_CNT,F_TM,PR_C,D_NO,GS_LN,R_No,P_ID,T_ID,GS_FN,O_ID,U_BY,CH_TY) VALUES ('P','W1','I07,','2025-10-31','2025/10/07 12:50:27','8','2025/10/07 12:50:27','1043','PS ','2','13:05',NULL,NULL,'2','06','Deepak,Chakre','1','12:00',NULL,'636','Chakre','17511','I7','AB   ','Deepak','01','STH','1')Date :10/7/2025 12:50:27 PM
step28  1Date :10/7/2025 12:50:27 PM
step30  INSERT INTO MMSP0M0002(A_IND,THR_ID,O_ID,S1_TM,E_TM,COMPANY_ID,E1_TM,S_TM,R_NO) VALUES ('0',' ','01','13:05','12:00','W1','13:05','12:00','17511')Date :10/7/2025 12:50:27 PM
step31  1Date :10/7/2025 12:50:27 PM
step33  INSERT INTO MMSP0M0003(S_NO,GS_FN,GS_ID,O_ID,COMPANY_ID,GS_LN,GS_TL,GS_NM,D_NO) VALUES ('1','Deepak','563','01','W1','Chakre','00','Deepak,Chakre','17511')Date :10/7/2025 12:50:27 PM
step34  1Date :10/7/2025 12:50:27 PM
step36  SELECT * FROM MMSP0M0990 WHERE Company_ID='W1' And O_ID='01' And D_No='636' And T_Dt='2025-10-31' And PK_ID='I7'Date :10/7/2025 12:50:27 PM
step37  INSERT INTO MMSP0M0990(COMPANY_ID,NET_AMT,PR_ID,D_NO,AMT,U_BY,PK_ID,PK_Qty,T_DT,U_DT,DS_PR,O_ID,C_BY,C_DT,DS_AM,DY_NO,RT) VALUES ('W1','11000','06','636','11000','STH','I7','1','2025-10-31','2025/10/07 12:50:27',NULL,'01','I07,','2025/10/07 12:50:27',NULL,'4880','11000')Date :10/7/2025 12:50:27 PM
step38  1Date :10/7/2025 12:50:27 PM
step19  SELECT S_CMP_ID,S_OUT_ID,S_P_ID,S_PR_ID FROM AAFO0M0086 WHERE Company_ID='WS' AND FO_P_ID='I07' AND R_Ty_ID='MGK' AND Currency_ID='RS' AND '2025/10/07 12:50:27' BETWEEN WEF AND Valid_UptoDate :10/7/2025 12:50:27 PM
spaResNo  SELECT * FROM MMSP0M0024 WHERE COMPANY_ID = 'W1' AND O_ID = '01' AND R_TY = 'R'Date :10/7/2025 12:50:27 PM
spaResNo  UPDATE MMSP0M0024 SET S_N = 17512 WHERE COMPANY_ID = 'W1' AND O_ID = '01' AND R_TY = 'R'Date :10/7/2025 12:50:27 PM
step16   select r_no from mmsp0m0001 where company_id='W1' and o_id='01'  and R_no ='17512'Date :10/7/2025 12:50:27 PM
step22  Select Top 1 TR_ID from MMSP0M0107 where COMPANY_ID='W1'  AND O_ID='01' And PK_ID='I7'Date :10/7/2025 12:50:27 PM
step23  SELECT TR_ID,TR_NM,TR_D,TR_P  FROM MMSP0M0104  WHERE COMPANY_ID='W1'  AND O_ID='01'And TR_ID='AB   'Date :10/7/2025 12:50:27 PM
step24  SELECT Sum(IsNull(Pr_Am,0)) Amt,Max(Ch_Ty) Ch_Ty   FROM MMSP0M0301   WHERE COMPANY_ID='W1' AND PR_LS='06'  AND  O_ID='01' And Ty_ID='P'  and tr_id='I7'  and isnull(ch_ty,0)<>0 Date :10/7/2025 12:50:27 PM
step25  SELECT A_8  FROM MMSP0M0305 WHERE COMPANY_ID='W1' AND PR_ID='06'  AND O_ID='01'Date :10/7/2025 12:50:27 PM
B_Ind   Select B_Ind from MMSP0M0106 where COMPANY_ID='W1' and pk_id='I7' And O_ID='01' Date :10/7/2025 12:50:27 PM
step27  INSERT INTO MMSP0M0001(R_FOR,COMPANY_ID,C_BY,T_DT,U_DT,ST_TS,C_DT,GS_ID,rv_id,DAY_RT_IND,T_TM,pk_am,sp_pr,P_X,pr_id,GS_NM,PKG_CNT,F_TM,PR_C,D_NO,GS_LN,R_No,P_ID,T_ID,GS_FN,O_ID,U_BY,CH_TY) VALUES ('P','W1','I07,','2025-11-01','2025/10/07 12:50:27','8','2025/10/07 12:50:27','1043','PS ','2','13:05',NULL,NULL,'2','06','Deepak,Chakre','1','12:00',NULL,'636','Chakre','17512','I7','AB   ','Deepak','01','STH','1')Date :10/7/2025 12:50:27 PM
step28  1Date :10/7/2025 12:50:27 PM
step30  INSERT INTO MMSP0M0002(A_IND,THR_ID,O_ID,S1_TM,E_TM,COMPANY_ID,E1_TM,S_TM,R_NO) VALUES ('0',' ','01','13:05','12:00','W1','13:05','12:00','17512')Date :10/7/2025 12:50:27 PM
step31  1Date :10/7/2025 12:50:27 PM
step33  INSERT INTO MMSP0M0003(S_NO,GS_FN,GS_ID,O_ID,COMPANY_ID,GS_LN,GS_TL,GS_NM,D_NO) VALUES ('1','Deepak','563','01','W1','Chakre','00','Deepak,Chakre','17512')Date :10/7/2025 12:50:27 PM
step34  1Date :10/7/2025 12:50:27 PM
step36  SELECT * FROM MMSP0M0990 WHERE Company_ID='W1' And O_ID='01' And D_No='636' And T_Dt='2025-11-01' And PK_ID='I7'Date :10/7/2025 12:50:27 PM
step37  INSERT INTO MMSP0M0990(COMPANY_ID,NET_AMT,PR_ID,D_NO,AMT,U_BY,PK_ID,PK_Qty,T_DT,U_DT,DS_PR,O_ID,C_BY,C_DT,DS_AM,DY_NO,RT) VALUES ('W1','11000','06','636','11000','STH','I7','1','2025-11-01','2025/10/07 12:50:27',NULL,'01','I07,','2025/10/07 12:50:27',NULL,'4881','11000')Date :10/7/2025 12:50:27 PM
step38  1Date :10/7/2025 12:50:27 PM
step39  UPDATE FO_Reserve SET GUEST1_TITLE_ID= 'MR',EMAIL= 'deepak.chakre@swastikwellbeing.com',SP_Res_No= '17512',DOB= NULL,SP_Cmp_ID= 'W1',Dyn1_ID= '636',SP_O_ID= '01',MOBILE= '+919881828486' WHERE Company_ID='WS' AND Reserve_No='1294'Date :10/7/2025 12:50:27 PM
step41  1Date :10/7/2025 12:50:27 PM
SucessDate :10/7/2025 12:50:27 PM
step 1     SELECT isnull(TARIFF_DISC_PER,0)as TARIFFDISCPER ,isnull(TARIFF_DISC_AMT,0) as TARIFFDISCAMT ,CONVERT(varchar(6), ARRIVAL_DT, 12) as DateFormate ,convert(varchar ,ARRIVAL_DT,23) as ARRIVAL_DT,* FROM FO_RESERVE WHERE COMPANY_ID='WS' AND r_no='929'Date :10/7/2025 5:14:35 PM
step 2  SELECT RESERVE_NO, STRING_AGG(GUEST_NM, '# ') AS vSPA_G_NM_All, STRING_AGG(GUEST_TITLE_ID, '# ') AS vSPA_GTit_All, STRING_AGG(C2_N1, '# ') AS vSPA_GF_NM_All, STRING_AGG(C2_N2, '#') AS vSPA_GL_NM_All, STRING_AGG(G_ID, '# ') AS SPA_Guest_ID_All from  FO_RESERVE_DET  WHERE COMPANY_ID='WS' AND RESERVE_NO='1295' GROUP BY RESERVE_NO Date :10/7/2025 5:14:35 PM
step 3   Select PK_Id from FO_ROOM_TYPE_TARIFF where Company_Id ='WS' and Room_Ty_Id ='KGK' and Rate_Ty_Id ='T02' and Currency_Id='RS'  And '251007' >= FROM_DT And '251007' <= TO_DT  AND D_IND IS NULL Date :10/7/2025 5:14:35 PM
step 4  Select * from AAFO0M0120 Where Company_Id ='WS' and  P_Id in ('T02','')Date :10/7/2025 5:14:35 PM
step 5  Date :10/7/2025 5:14:35 PM
step 6  INSERT INTO AAFO0M0121(CH_D,COMPANY_ID,C_IND,P_ID,RT_C3,IT_NM,S_No,RT_C2,C_UR,RT_RM,C_BY,B_IND,H_IND,SR_NO,P_IND,CH_TY,R_IND,R_NO,IT_ID,Q_TY,RT_C1,U_By,RT_A) VALUES ('0','WS',NULL,'T02',NULL,'WELLBEING','2',NULL,'RS','0.000','0270',NULL,'P','1',NULL,'02','1','1295','WEL','1',NULL,'0270','0.000')Date :10/7/2025 5:14:35 PM
step 8  INSERT INTO AAFO0M0279(COMPANY_ID,C_IND,RES_IND,P_ID,RT_C3,IT_NM,RT_C1,RESER_NO,C_UR,PS_NO,S_DT,RT_C2,SR_NO,B_IND,CH_TY,R_IND,IT_ID,S_NO,D_P,E_DT,RT_A) VALUES ('WS',NULL,'R','T02',NULL,'WELLBEING',NULL,'1295','RS','2',NULL,NULL,'1',NULL,'02','1','WEL','1','1',NULL,'0.000')Date :10/7/2025 5:14:35 PM
step 9  1Date :10/7/2025 5:14:35 PM
step 11  SELECT TOP 1 P_ID  FROM AAFO0M0121 WHERE COMPANY_ID='WS' AND R_NO='1295'Date :10/7/2025 5:14:35 PM
step 12  SELECT distinct P_ID  FROM AAFO0M0121 WHERE COMPANY_ID='WS' AND R_NO='1295'Date :10/7/2025 5:14:35 PM
step 13  Date :10/7/2025 5:14:35 PM
step vGArrDt   2025-10-07Date :10/7/2025 5:14:35 PM
step14  SELECT * FROM AAFO0M0086 WHERE Company_ID='WS' AND FO_P_ID='T02' AND R_Ty_ID='KGK'  AND Currency_ID='RS' AND  '2025-10-07' BETWEEN WEF AND Valid_Upto Date :10/7/2025 5:14:35 PM
 Step 1 fnCreate_SPASELECT isnull(U2_IND,0) as  U2_IND,isnull(Y1_IND,0) as Y1_IND  FROM MMSP0M0400 WHERE Company_ID='W1'Date :10/7/2025 5:14:35 PM
Step 2 fnCreate_SPA SELECT * FROM MMSP0M0030 WHERE company_id='W1' AND cm_id=481 AND gs_cat='G'Date :10/7/2025 5:14:35 PM
Step 3 fnCreate_SPA SELECT in_id FROM mmsp0m0103 WHERE company_id='W1' AND c_ind=1Date :10/7/2025 5:14:35 PM
Step 4SELECT guest_nm,Guest_title_Id,P1_Nm,O1_Nm,Add1,Add2,Add3,place,pin_cd,res_tel,email,mobile,dob,anniv_dt,SPOUCE_NM,OCCUPATION,LIKES_NARRATION,DISLIKES_NARRATION,country_id,Gend_ID,d1_id,isnull(Guest_Ty_ID,'') as Guest_Ty_ID,A14_Id,B14_Id,Df_1,Df_2,Df_3 FROM FO_GUEST WHERE Company_ID='WS' AND Guest_Id=481Date :10/7/2025 5:14:35 PM
Step 6 fnCreate_SPAFalseDate :10/7/2025 5:14:35 PM
Step 7 fnCreate_SPAINSERT INTO MMSP0M0030(Rs_T,GS_Tl_Id,Add2,GS_NM,Ct_ID,Cn_Pr,Cn_Tl,SP_NM,GS_NM1,Company_id,DOA,CM_id,LK_NR,Gend_ID,m_ind,Em,Cn_Ds,HT_NR,U_By,mb,Pn,J_NR,C_By,K_IND,U_Dt,DB,GS_cat,GS_Id,GS_N,Add3,C_Dt,Pl,Add1) VALUES ('+919819099192','MR','','Rajesh','',NULL,NULL,'','Srinivas','W1','','481','','M','1','rajesh.srinivas@swastikwellbeing.com',NULL,'','T02,','+919819099192','          ','','T02,','3','2025/10/07 17:14:35','','G','1044','Srinivas,Rajesh','','2025/10/07 17:14:35','Pune','')Date :10/7/2025 5:14:35 PM
step15   SELECT IN_GST_IND, k_Tax, OTH_CLB_APPL, COMMON_INTFC_IND, D_IND FROM MST_COMPANY WHERE Company_ID = 'WS' Date :10/7/2025 5:14:35 PM
step16   SELECT * FROM MMSP0M0111  WHERE COMPANY_ID='W1' and o_id='01' and d_no ='929'Date :10/7/2025 5:14:35 PM
spaResNo  SELECT * FROM MMSP0M0024 WHERE COMPANY_ID = 'W1' AND O_ID = '01' AND R_TY = 'D'Date :10/7/2025 5:14:35 PM
spaResNo  UPDATE MMSP0M0024 SET S_N = 637 WHERE COMPANY_ID = 'W1' AND O_ID = '01' AND R_TY = 'D'Date :10/7/2025 5:14:35 PM
step17  INSERT INTO MMSP0M0111(D_NO,U_DT,O_ID,C_BY,COMPANY_ID,U_BY,C_DT) VALUES ('637','2025/10/07 17:14:35','01','T02,','W1','STH','2025/10/07 17:14:35')Date :10/7/2025 5:14:35 PM
step19  SELECT S_CMP_ID,S_OUT_ID,S_P_ID,S_PR_ID FROM AAFO0M0086 WHERE Company_ID='WS' AND FO_P_ID='T02' AND R_Ty_ID='KGK' AND Currency_ID='RS' AND '2025/10/07 17:14:35' BETWEEN WEF AND Valid_UptoDate :10/7/2025 5:14:35 PM
spaResNo  SELECT * FROM MMSP0M0024 WHERE COMPANY_ID = 'W1' AND O_ID = '01' AND R_TY = 'R'Date :10/7/2025 5:14:35 PM
spaResNo  UPDATE MMSP0M0024 SET S_N = 17585 WHERE COMPANY_ID = 'W1' AND O_ID = '01' AND R_TY = 'R'Date :10/7/2025 5:14:35 PM
step16   select r_no from mmsp0m0001 where company_id='W1' and o_id='01'  and R_no ='17585'Date :10/7/2025 5:14:35 PM
step22  Select Top 1 TR_ID from MMSP0M0107 where COMPANY_ID='W1'  AND O_ID='01' And PK_ID='T2'Date :10/7/2025 5:14:35 PM
step23  SELECT TR_ID,TR_NM,TR_D,TR_P  FROM MMSP0M0104  WHERE COMPANY_ID='W1'  AND O_ID='01'And TR_ID='AB   'Date :10/7/2025 5:14:35 PM
step24  SELECT Sum(IsNull(Pr_Am,0)) Amt,Max(Ch_Ty) Ch_Ty   FROM MMSP0M0301   WHERE COMPANY_ID='W1' AND PR_LS='06'  AND  O_ID='01' And Ty_ID='P'  and tr_id='T2'  and isnull(ch_ty,0)<>0 Date :10/7/2025 5:14:35 PM
step25  SELECT A_8  FROM MMSP0M0305 WHERE COMPANY_ID='W1' AND PR_ID='06'  AND O_ID='01'Date :10/7/2025 5:14:35 PM
B_Ind   Select B_Ind from MMSP0M0106 where COMPANY_ID='W1' and pk_id='T2' And O_ID='01' Date :10/7/2025 5:14:35 PM
step27  INSERT INTO MMSP0M0001(R_FOR,COMPANY_ID,C_BY,T_DT,U_DT,ST_TS,C_DT,GS_ID,rv_id,DAY_RT_IND,T_TM,pk_am,sp_pr,P_X,pr_id,GS_NM,PKG_CNT,F_TM,PR_C,D_NO,GS_LN,R_No,P_ID,T_ID,GS_FN,O_ID,U_BY,CH_TY) VALUES ('P','W1','T02,','2025-10-07','2025/10/07 17:14:35','8','2025/10/07 17:14:35','1044','PS ','2','13:05',NULL,NULL,'1','06','Rajesh,Srinivas','1','12:00',NULL,'637','Srinivas','17585','T2','AB   ','Rajesh','01','STH','1')Date :10/7/2025 5:14:35 PM
step28  1Date :10/7/2025 5:14:35 PM
step30  INSERT INTO MMSP0M0002(A_IND,THR_ID,O_ID,S1_TM,E_TM,COMPANY_ID,E1_TM,S_TM,R_NO) VALUES ('0',' ','01','13:05','12:00','W1','13:05','12:00','17585')Date :10/7/2025 5:14:35 PM
step31  1Date :10/7/2025 5:14:35 PM
step33  INSERT INTO MMSP0M0003(S_NO,GS_FN,GS_ID,O_ID,COMPANY_ID,GS_LN,GS_TL,GS_NM,D_NO) VALUES ('1','Rajesh','481','01','W1','Srinivas','00','Rajesh,Srinivas','17585')Date :10/7/2025 5:14:35 PM
step34  1Date :10/7/2025 5:14:35 PM
step36  SELECT * FROM MMSP0M0990 WHERE Company_ID='W1' And O_ID='01' And D_No='637' And T_Dt='2025-10-07' And PK_ID='T2'Date :10/7/2025 5:14:35 PM
step37  INSERT INTO MMSP0M0990(COMPANY_ID,NET_AMT,PR_ID,D_NO,AMT,U_BY,PK_ID,PK_Qty,T_DT,U_DT,DS_PR,O_ID,C_BY,C_DT,DS_AM,DY_NO,RT) VALUES ('W1','11000','06','637','11000','STH','T2','1','2025-10-07','2025/10/07 17:14:35',NULL,'01','T02,','2025/10/07 17:14:35',NULL,'4923','11000')Date :10/7/2025 5:14:35 PM
step38  1Date :10/7/2025 5:14:35 PM
step19  SELECT S_CMP_ID,S_OUT_ID,S_P_ID,S_PR_ID FROM AAFO0M0086 WHERE Company_ID='WS' AND FO_P_ID='T02' AND R_Ty_ID='KGK' AND Currency_ID='RS' AND '2025/10/07 17:14:35' BETWEEN WEF AND Valid_UptoDate :10/7/2025 5:14:35 PM
spaResNo  SELECT * FROM MMSP0M0024 WHERE COMPANY_ID = 'W1' AND O_ID = '01' AND R_TY = 'R'Date :10/7/2025 5:14:35 PM
spaResNo  UPDATE MMSP0M0024 SET S_N = 17586 WHERE COMPANY_ID = 'W1' AND O_ID = '01' AND R_TY = 'R'Date :10/7/2025 5:14:35 PM
step16   select r_no from mmsp0m0001 where company_id='W1' and o_id='01'  and R_no ='17586'Date :10/7/2025 5:14:35 PM
step22  Select Top 1 TR_ID from MMSP0M0107 where COMPANY_ID='W1'  AND O_ID='01' And PK_ID='T2'Date :10/7/2025 5:14:35 PM
step23  SELECT TR_ID,TR_NM,TR_D,TR_P  FROM MMSP0M0104  WHERE COMPANY_ID='W1'  AND O_ID='01'And TR_ID='AB   'Date :10/7/2025 5:14:35 PM
step24  SELECT Sum(IsNull(Pr_Am,0)) Amt,Max(Ch_Ty) Ch_Ty   FROM MMSP0M0301   WHERE COMPANY_ID='W1' AND PR_LS='06'  AND  O_ID='01' And Ty_ID='P'  and tr_id='T2'  and isnull(ch_ty,0)<>0 Date :10/7/2025 5:14:35 PM
step25  SELECT A_8  FROM MMSP0M0305 WHERE COMPANY_ID='W1' AND PR_ID='06'  AND O_ID='01'Date :10/7/2025 5:14:35 PM
B_Ind   Select B_Ind from MMSP0M0106 where COMPANY_ID='W1' and pk_id='T2' And O_ID='01' Date :10/7/2025 5:14:35 PM
step27  INSERT INTO MMSP0M0001(R_FOR,COMPANY_ID,C_BY,T_DT,U_DT,ST_TS,C_DT,GS_ID,rv_id,DAY_RT_IND,T_TM,pk_am,sp_pr,P_X,pr_id,GS_NM,PKG_CNT,F_TM,PR_C,D_NO,GS_LN,R_No,P_ID,T_ID,GS_FN,O_ID,U_BY,CH_TY) VALUES ('P','W1','T02,','2025-10-08','2025/10/07 17:14:35','8','2025/10/07 17:14:35','1044','PS ','2','13:05',NULL,NULL,'1','06','Rajesh,Srinivas','1','12:00',NULL,'637','Srinivas','17586','T2','AB   ','Rajesh','01','STH','1')Date :10/7/2025 5:14:35 PM
step28  1Date :10/7/2025 5:14:35 PM
step30  INSERT INTO MMSP0M0002(A_IND,THR_ID,O_ID,S1_TM,E_TM,COMPANY_ID,E1_TM,S_TM,R_NO) VALUES ('0',' ','01','13:05','12:00','W1','13:05','12:00','17586')Date :10/7/2025 5:14:35 PM
step31  1Date :10/7/2025 5:14:35 PM
step33  INSERT INTO MMSP0M0003(S_NO,GS_FN,GS_ID,O_ID,COMPANY_ID,GS_LN,GS_TL,GS_NM,D_NO) VALUES ('1','Rajesh','481','01','W1','Srinivas','00','Rajesh,Srinivas','17586')Date :10/7/2025 5:14:35 PM
step34  1Date :10/7/2025 5:14:35 PM
step36  SELECT * FROM MMSP0M0990 WHERE Company_ID='W1' And O_ID='01' And D_No='637' And T_Dt='2025-10-08' And PK_ID='T2'Date :10/7/2025 5:14:35 PM
step37  INSERT INTO MMSP0M0990(COMPANY_ID,NET_AMT,PR_ID,D_NO,AMT,U_BY,PK_ID,PK_Qty,T_DT,U_DT,DS_PR,O_ID,C_BY,C_DT,DS_AM,DY_NO,RT) VALUES ('W1','11000','06','637','11000','STH','T2','1','2025-10-08','2025/10/07 17:14:35',NULL,'01','T02,','2025/10/07 17:14:35',NULL,'4924','11000')Date :10/7/2025 5:14:35 PM
step38  1Date :10/7/2025 5:14:35 PM
step39  UPDATE FO_Reserve SET GUEST1_TITLE_ID= 'MR',EMAIL= 'rajesh.srinivas@swastikwellbeing.com',SP_Res_No= '17586',DOB= NULL,SP_Cmp_ID= 'W1',Dyn1_ID= '637',SP_O_ID= '01',MOBILE= '+919819099192' WHERE Company_ID='WS' AND Reserve_No='1295'Date :10/7/2025 5:14:35 PM
step41  1Date :10/7/2025 5:14:35 PM
SucessDate :10/7/2025 5:14:35 PM
step 1     SELECT isnull(TARIFF_DISC_PER,0)as TARIFFDISCPER ,isnull(TARIFF_DISC_AMT,0) as TARIFFDISCAMT ,CONVERT(varchar(6), ARRIVAL_DT, 12) as DateFormate ,convert(varchar ,ARRIVAL_DT,23) as ARRIVAL_DT,* FROM FO_RESERVE WHERE COMPANY_ID='WS' AND r_no='940'Date :10/9/2025 11:50:08 AM
step 2  SELECT RESERVE_NO, STRING_AGG(GUEST_NM, '# ') AS vSPA_G_NM_All, STRING_AGG(GUEST_TITLE_ID, '# ') AS vSPA_GTit_All, STRING_AGG(C2_N1, '# ') AS vSPA_GF_NM_All, STRING_AGG(C2_N2, '#') AS vSPA_GL_NM_All, STRING_AGG(G_ID, '# ') AS SPA_Guest_ID_All from  FO_RESERVE_DET  WHERE COMPANY_ID='WS' AND RESERVE_NO='1306' GROUP BY RESERVE_NO Date :10/9/2025 11:50:08 AM
step 3   Select PK_Id from FO_ROOM_TYPE_TARIFF where Company_Id ='WS' and Room_Ty_Id ='KGK' and Rate_Ty_Id ='T02' and Currency_Id='RS'  And '251128' >= FROM_DT And '251128' <= TO_DT  AND D_IND IS NULL Date :10/9/2025 11:50:08 AM
step 4  Select * from AAFO0M0120 Where Company_Id ='WS' and  P_Id in ('T02','')Date :10/9/2025 11:50:08 AM
step 5  Date :10/9/2025 11:50:08 AM
step 6  INSERT INTO AAFO0M0121(CH_D,COMPANY_ID,C_IND,P_ID,RT_C3,IT_NM,S_No,RT_C2,C_UR,RT_RM,C_BY,B_IND,H_IND,SR_NO,P_IND,CH_TY,R_IND,R_NO,IT_ID,Q_TY,RT_C1,U_By,RT_A) VALUES ('0','WS',NULL,'T02',NULL,'WELLBEING','2',NULL,'RS','0.000','0270',NULL,'P','1',NULL,'02','1','1306','WEL','1',NULL,'0270','0.000')Date :10/9/2025 11:50:08 AM
step 8  INSERT INTO AAFO0M0279(COMPANY_ID,C_IND,RES_IND,P_ID,RT_C3,IT_NM,RT_C1,RESER_NO,C_UR,PS_NO,S_DT,RT_C2,SR_NO,B_IND,CH_TY,R_IND,IT_ID,S_NO,D_P,E_DT,RT_A) VALUES ('WS',NULL,'R','T02',NULL,'WELLBEING',NULL,'1306','RS','2',NULL,NULL,'1',NULL,'02','1','WEL','1','1',NULL,'0.000')Date :10/9/2025 11:50:08 AM
step 9  1Date :10/9/2025 11:50:08 AM
step 11  SELECT TOP 1 P_ID  FROM AAFO0M0121 WHERE COMPANY_ID='WS' AND R_NO='1306'Date :10/9/2025 11:50:08 AM
step 12  SELECT distinct P_ID  FROM AAFO0M0121 WHERE COMPANY_ID='WS' AND R_NO='1306'Date :10/9/2025 11:50:08 AM
step 13  Date :10/9/2025 11:50:08 AM
step vGArrDt   2025-11-28Date :10/9/2025 11:50:08 AM
step14  SELECT * FROM AAFO0M0086 WHERE Company_ID='WS' AND FO_P_ID='T02' AND R_Ty_ID='KGK'  AND Currency_ID='RS' AND  '2025-11-28' BETWEEN WEF AND Valid_Upto Date :10/9/2025 11:50:08 AM
 Step 1 fnCreate_SPASELECT isnull(U2_IND,0) as  U2_IND,isnull(Y1_IND,0) as Y1_IND  FROM MMSP0M0400 WHERE Company_ID='W1'Date :10/9/2025 11:50:08 AM
Step 2 fnCreate_SPA SELECT * FROM MMSP0M0030 WHERE company_id='W1' AND cm_id=563 AND gs_cat='G'Date :10/9/2025 11:50:08 AM
Step 3 fnCreate_SPA SELECT in_id FROM mmsp0m0103 WHERE company_id='W1' AND c_ind=1Date :10/9/2025 11:50:08 AM
Step 4SELECT guest_nm,Guest_title_Id,P1_Nm,O1_Nm,Add1,Add2,Add3,place,pin_cd,res_tel,email,mobile,dob,anniv_dt,SPOUCE_NM,OCCUPATION,LIKES_NARRATION,DISLIKES_NARRATION,country_id,Gend_ID,d1_id,isnull(Guest_Ty_ID,'') as Guest_Ty_ID,A14_Id,B14_Id,Df_1,Df_2,Df_3 FROM FO_GUEST WHERE Company_ID='WS' AND Guest_Id=563Date :10/9/2025 11:50:08 AM
Step 6 fnCreate_SPAFalseDate :10/9/2025 11:50:08 AM
Step 7 fnCreate_SPAINSERT INTO MMSP0M0030(Rs_T,GS_Tl_Id,Add2,GS_NM,Ct_ID,Cn_Pr,Cn_Tl,SP_NM,GS_NM1,Company_id,DOA,CM_id,LK_NR,Gend_ID,m_ind,Em,Cn_Ds,HT_NR,U_By,mb,Pn,J_NR,C_By,K_IND,U_Dt,DB,GS_cat,GS_Id,GS_N,Add3,C_Dt,Pl,Add1) VALUES ('+919881828486','MR','','Deepak','',NULL,NULL,'','Chakre','W1','','563','','M','1','deepak.chakre@swastikwellbeing.com',NULL,'','T02,','+919881828486','411002    ','','T02,','3','2025/10/09 11:50:07','','G','1050','Chakre,Deepak','','2025/10/09 11:50:07','PUNE - 411002','')Date :10/9/2025 11:50:08 AM
step15   SELECT IN_GST_IND, k_Tax, OTH_CLB_APPL, COMMON_INTFC_IND, D_IND FROM MST_COMPANY WHERE Company_ID = 'WS' Date :10/9/2025 11:50:08 AM
step16   SELECT * FROM MMSP0M0111  WHERE COMPANY_ID='W1' and o_id='01' and d_no ='940'Date :10/9/2025 11:50:08 AM
spaResNo  SELECT * FROM MMSP0M0024 WHERE COMPANY_ID = 'W1' AND O_ID = '01' AND R_TY = 'D'Date :10/9/2025 11:50:08 AM
spaResNo  UPDATE MMSP0M0024 SET S_N = 642 WHERE COMPANY_ID = 'W1' AND O_ID = '01' AND R_TY = 'D'Date :10/9/2025 11:50:08 AM
step17  INSERT INTO MMSP0M0111(D_NO,U_DT,O_ID,C_BY,COMPANY_ID,U_BY,C_DT) VALUES ('642','2025/10/09 11:50:07','01','T02,','W1','STH','2025/10/09 11:50:07')Date :10/9/2025 11:50:08 AM
step19  SELECT S_CMP_ID,S_OUT_ID,S_P_ID,S_PR_ID FROM AAFO0M0086 WHERE Company_ID='WS' AND FO_P_ID='T02' AND R_Ty_ID='KGK' AND Currency_ID='RS' AND '2025/10/09 11:50:07' BETWEEN WEF AND Valid_UptoDate :10/9/2025 11:50:08 AM
spaResNo  SELECT * FROM MMSP0M0024 WHERE COMPANY_ID = 'W1' AND O_ID = '01' AND R_TY = 'R'Date :10/9/2025 11:50:08 AM
spaResNo  UPDATE MMSP0M0024 SET S_N = 17771 WHERE COMPANY_ID = 'W1' AND O_ID = '01' AND R_TY = 'R'Date :10/9/2025 11:50:08 AM
step16   select r_no from mmsp0m0001 where company_id='W1' and o_id='01'  and R_no ='17771'Date :10/9/2025 11:50:08 AM
step22  Select Top 1 TR_ID from MMSP0M0107 where COMPANY_ID='W1'  AND O_ID='01' And PK_ID='T2'Date :10/9/2025 11:50:08 AM
step23  SELECT TR_ID,TR_NM,TR_D,TR_P  FROM MMSP0M0104  WHERE COMPANY_ID='W1'  AND O_ID='01'And TR_ID='AB   'Date :10/9/2025 11:50:08 AM
step24  SELECT Sum(IsNull(Pr_Am,0)) Amt,Max(Ch_Ty) Ch_Ty   FROM MMSP0M0301   WHERE COMPANY_ID='W1' AND PR_LS='06'  AND  O_ID='01' And Ty_ID='P'  and tr_id='T2'  and isnull(ch_ty,0)<>0 Date :10/9/2025 11:50:08 AM
step25  SELECT A_8  FROM MMSP0M0305 WHERE COMPANY_ID='W1' AND PR_ID='06'  AND O_ID='01'Date :10/9/2025 11:50:08 AM
B_Ind   Select B_Ind from MMSP0M0106 where COMPANY_ID='W1' and pk_id='T2' And O_ID='01' Date :10/9/2025 11:50:08 AM
step27  INSERT INTO MMSP0M0001(R_FOR,COMPANY_ID,C_BY,T_DT,U_DT,ST_TS,C_DT,GS_ID,rv_id,DAY_RT_IND,T_TM,pk_am,sp_pr,P_X,pr_id,GS_NM,PKG_CNT,F_TM,PR_C,D_NO,GS_LN,R_No,P_ID,T_ID,GS_FN,O_ID,U_BY,CH_TY) VALUES ('P','W1','T02,','2025-11-28','2025/10/09 11:50:07','8','2025/10/09 11:50:07','1050','PS ','2','13:05',NULL,NULL,'1','06','Deepak,Chakre','1','12:00',NULL,'642','Chakre','17771','T2','AB   ','Deepak','01','STH','1')Date :10/9/2025 11:50:08 AM
step28  1Date :10/9/2025 11:50:08 AM
step30  INSERT INTO MMSP0M0002(A_IND,THR_ID,O_ID,S1_TM,E_TM,COMPANY_ID,E1_TM,S_TM,R_NO) VALUES ('0',' ','01','13:05','12:00','W1','13:05','12:00','17771')Date :10/9/2025 11:50:08 AM
step31  1Date :10/9/2025 11:50:08 AM
step33  INSERT INTO MMSP0M0003(S_NO,GS_FN,GS_ID,O_ID,COMPANY_ID,GS_LN,GS_TL,GS_NM,D_NO) VALUES ('1','Deepak','563','01','W1','Chakre','00','Deepak,Chakre','17771')Date :10/9/2025 11:50:08 AM
step34  1Date :10/9/2025 11:50:08 AM
step36  SELECT * FROM MMSP0M0990 WHERE Company_ID='W1' And O_ID='01' And D_No='642' And T_Dt='2025-11-28' And PK_ID='T2'Date :10/9/2025 11:50:08 AM
step37  INSERT INTO MMSP0M0990(COMPANY_ID,NET_AMT,PR_ID,D_NO,AMT,U_BY,PK_ID,PK_Qty,T_DT,U_DT,DS_PR,O_ID,C_BY,C_DT,DS_AM,DY_NO,RT) VALUES ('W1','11000','06','642','11000','STH','T2','1','2025-11-28','2025/10/09 11:50:07',NULL,'01','T02,','2025/10/09 11:50:07',NULL,'5012','11000')Date :10/9/2025 11:50:08 AM
step38  1Date :10/9/2025 11:50:08 AM
step19  SELECT S_CMP_ID,S_OUT_ID,S_P_ID,S_PR_ID FROM AAFO0M0086 WHERE Company_ID='WS' AND FO_P_ID='T02' AND R_Ty_ID='KGK' AND Currency_ID='RS' AND '2025/10/09 11:50:07' BETWEEN WEF AND Valid_UptoDate :10/9/2025 11:50:08 AM
spaResNo  SELECT * FROM MMSP0M0024 WHERE COMPANY_ID = 'W1' AND O_ID = '01' AND R_TY = 'R'Date :10/9/2025 11:50:08 AM
spaResNo  UPDATE MMSP0M0024 SET S_N = 17772 WHERE COMPANY_ID = 'W1' AND O_ID = '01' AND R_TY = 'R'Date :10/9/2025 11:50:08 AM
step16   select r_no from mmsp0m0001 where company_id='W1' and o_id='01'  and R_no ='17772'Date :10/9/2025 11:50:08 AM
step22  Select Top 1 TR_ID from MMSP0M0107 where COMPANY_ID='W1'  AND O_ID='01' And PK_ID='T2'Date :10/9/2025 11:50:08 AM
step23  SELECT TR_ID,TR_NM,TR_D,TR_P  FROM MMSP0M0104  WHERE COMPANY_ID='W1'  AND O_ID='01'And TR_ID='AB   'Date :10/9/2025 11:50:08 AM
step24  SELECT Sum(IsNull(Pr_Am,0)) Amt,Max(Ch_Ty) Ch_Ty   FROM MMSP0M0301   WHERE COMPANY_ID='W1' AND PR_LS='06'  AND  O_ID='01' And Ty_ID='P'  and tr_id='T2'  and isnull(ch_ty,0)<>0 Date :10/9/2025 11:50:08 AM
step25  SELECT A_8  FROM MMSP0M0305 WHERE COMPANY_ID='W1' AND PR_ID='06'  AND O_ID='01'Date :10/9/2025 11:50:08 AM
B_Ind   Select B_Ind from MMSP0M0106 where COMPANY_ID='W1' and pk_id='T2' And O_ID='01' Date :10/9/2025 11:50:08 AM
step27  INSERT INTO MMSP0M0001(R_FOR,COMPANY_ID,C_BY,T_DT,U_DT,ST_TS,C_DT,GS_ID,rv_id,DAY_RT_IND,T_TM,pk_am,sp_pr,P_X,pr_id,GS_NM,PKG_CNT,F_TM,PR_C,D_NO,GS_LN,R_No,P_ID,T_ID,GS_FN,O_ID,U_BY,CH_TY) VALUES ('P','W1','T02,','2025-11-29','2025/10/09 11:50:07','8','2025/10/09 11:50:07','1050','PS ','2','13:05',NULL,NULL,'1','06','Deepak,Chakre','1','12:00',NULL,'642','Chakre','17772','T2','AB   ','Deepak','01','STH','1')Date :10/9/2025 11:50:08 AM
step28  1Date :10/9/2025 11:50:08 AM
step30  INSERT INTO MMSP0M0002(A_IND,THR_ID,O_ID,S1_TM,E_TM,COMPANY_ID,E1_TM,S_TM,R_NO) VALUES ('0',' ','01','13:05','12:00','W1','13:05','12:00','17772')Date :10/9/2025 11:50:08 AM
step31  1Date :10/9/2025 11:50:08 AM
step33  INSERT INTO MMSP0M0003(S_NO,GS_FN,GS_ID,O_ID,COMPANY_ID,GS_LN,GS_TL,GS_NM,D_NO) VALUES ('1','Deepak','563','01','W1','Chakre','00','Deepak,Chakre','17772')Date :10/9/2025 11:50:08 AM
step34  1Date :10/9/2025 11:50:08 AM
step36  SELECT * FROM MMSP0M0990 WHERE Company_ID='W1' And O_ID='01' And D_No='642' And T_Dt='2025-11-29' And PK_ID='T2'Date :10/9/2025 11:50:08 AM
step37  INSERT INTO MMSP0M0990(COMPANY_ID,NET_AMT,PR_ID,D_NO,AMT,U_BY,PK_ID,PK_Qty,T_DT,U_DT,DS_PR,O_ID,C_BY,C_DT,DS_AM,DY_NO,RT) VALUES ('W1','11000','06','642','11000','STH','T2','1','2025-11-29','2025/10/09 11:50:07',NULL,'01','T02,','2025/10/09 11:50:07',NULL,'5013','11000')Date :10/9/2025 11:50:08 AM
step38  1Date :10/9/2025 11:50:08 AM
step39  UPDATE FO_Reserve SET GUEST1_TITLE_ID= 'MR',EMAIL= 'deepak.chakre@swastikwellbeing.com',SP_Res_No= '17772',DOB= NULL,SP_Cmp_ID= 'W1',Dyn1_ID= '642',SP_O_ID= '01',MOBILE= '+919881828486' WHERE Company_ID='WS' AND Reserve_No='1306'Date :10/9/2025 11:50:08 AM
step41  1Date :10/9/2025 11:50:08 AM
Sucess