Start Time : 12/10/2025 11:16:40 AM Loading iview.aspx before post back (get and set parameters) Get Iview Parameters Call to GetParams Web Service ASB XE3/32/64 DLL running [Compiled on 19/06/2015 12:09:20 AM] [File Version : 9.5.0.0]] [Product Version : 9.0][64 Bit - WebFix2] DB Manager created Current ASB DLL folder : E:\website\dmis\dmisscripts Connecting to project Dbx name = dmis ConnectionName = oracle DriverName = oracle GetDriverFunc = getSQLDriverORACLE LibraryName = E:\website\dmis\dmisscripts\dbxora.dll VendorLib = E:\website\dmis\dmisscripts\OCI.dll Database = dmis User_Name = dmis Select sysdate as sdt from dual Time elapsed = 15 SELECT * FROM AXPROPS WHERE NAME = 'app' Time elapsed = 16 SELECT Constraint_Name FROM AXCONSTRAINTS where 1=2 Time elapsed = 0 Connection to DB Successful Executing GetParams webservice ------------------------------ Received XML + dbOracledbxdmisdmisdc1d71bbb5c4d2a5e936db79ef10c19fdmisdd/mm/yyyy hh24:mi:ssadminlocaldmisactivedmis\100000falseselect ausername ||'-'|| ( usertype ) auname from axusers where username in (:username)tBlackfalse Validating Session select * from connections where sessionid = :sesid Time elapsed = 16 Application Variables and Values ax_evalcopy=T rolename=Patwari responsibilies=Patwari usrpatid=4521 urole=Patwari usrofcnm=ALL usrdeptnm=ALL usrofc=0 usrdept=0 usrdistid=14 usrpatnm=Akora usrilrnm=Kamediya usrtehnm=Deh usrdistnm=Nagaur usrpatwar=Akora usrrole=Patwari User Group Patwari User Roles Patwari Validate Session completed Sql : select props from iviews where lower(name)= :name order by blobno Paramval : farass ParamTYpe : c Param List : name select props from iviews where lower(name)= :name order by blobno Time elapsed = 0 Step5 CDS Param Name : usrdistnm CDS Param Type : c CDS Param Value : Nagaur usrdistnm=Nagaur Select SESSIONID from trn_reqdmgareahdr x1,trn_reqdmgareadtl x2 where x1.trn_reqdmgareahdrid = x2.trn_reqdmgareahdrid and nvl(x1.isseasonclose,'F') = 'F' and (DMDIST = :usrdistnm or DMDIST = 'ALL' OR :usrdistnm = 'ALL') group by SESSIONID order by SESSIONID usrdistnm=Nagaur usrdistnm=Nagaur Time elapsed = 16 CDS Record Count : 16 Evaluating usrdistnm usrdistnm = Nagaur Result = Nagaur Param Name : dist Param Type : C Param Value : Nagaur CDS Param Name : usrdistnm CDS Param Type : c CDS Param Value : Nagaur usrdistnm=Nagaur SELECT 'ALL' AS DISTRICTNAME,0 ord FROM dual where :usrdistnm = 'ALL' union Select X1.DISTNM DISTRICTNAME,1 ord from vw_tehsilvill x1 where (X1.DISTNM = :usrdistnm OR :usrdistnm = 'ALL') group by X1.DISTNM,x1.distid order by ord,DISTRICTNAME usrdistnm=Nagaur usrdistnm=Nagaur usrdistnm=Nagaur Time elapsed = 47 CDS Record Count : 1 Evaluating usrtehnm usrtehnm = Deh Result = Deh Param Name : teh Param Type : C Param Value : Deh CDS Param Name : usrtehnm CDS Param Type : c CDS Param Value : Deh usrtehnm=Deh CDS Param Name : dist CDS Param Type : c CDS Param Value : Nagaur dist=Nagaur SELECT 'ALL' AS TEHSILNM,0 ord FROM dual where :usrtehnm = 'ALL' union select X1.TEHSILNM as TEHSILNM, 1 ord from vw_tehsilvill x1 where (X1.TEHSILNM = :usrtehnm OR :usrtehnm = 'ALL') and x1.DISTNM = :dist group by X1.TEHSILNM,x1.TEHSILID order by ord,TEHSILNM usrtehnm=Deh usrtehnm=Deh usrtehnm=Deh dist=Nagaur Time elapsed = 62 CDS Record Count : 1 Evaluating usrpatnm usrpatnm = Akora Result = Akora Param Name : pat Param Type : C Param Value : Akora CDS Param Name : usrpatnm CDS Param Type : c CDS Param Value : Akora usrpatnm=Akora CDS Param Name : Dist CDS Param Type : c CDS Param Value : Nagaur Dist=Nagaur CDS Param Name : teh CDS Param Type : c CDS Param Value : Deh teh=Deh CDS Param Name : usrpatnm CDS Param Type : c CDS Param Value : Akora SELECT 'ALL' AS PATWARNM,0 ord FROM dual where :usrpatnm = 'ALL' union select X1.PATWARNM as Patwarname, 1 ord from vw_tehsilvill x1 where x1.DISTNM = :Dist and X1.TEHSILNM = :teh and (X1.PATWARNM = :usrpatnm OR :usrpatnm = 'ALL') group by X1.PATWARNM,X1.PATWARID order by ord,PATWARNM usrpatnm=Akora Dist=Nagaur teh=Deh usrpatnm=Akora usrpatnm=Akora Time elapsed = 46 CDS Record Count : 1 Select 'Aadhaar' srby from dual UNION ALL Select 'Account No' srby from dual Time elapsed = 15 CDS Record Count : 2 Evaluating {-} Error while evaluating - List index out of bounds (-1) Param Name : aad Param Type : C Param Value : Akora Result :Task1scodeSeason CodeCharacterFalsefalse0FalseFalseSelect2075-KHARIF2075-RABI2076-KHARIF2076-RABI-II2078-KHARIF2078-KHARIF-II2078-RABI-II2079-KHARIF2079-RABI2079-RABI-II2080-KHARIF2080-KHARIF-III2080-RABI2081-KHARIF2081-RABI2082-KHARIFTask1distDistrictCharacterFalseusrdistnmfalse0FalseFalseSelect~~teh,pat~~Nagaur1Task1tehTehsilCharacterFalseusrtehnmfalse0FalseFalseSelect~~pat~~Deh1Task1patPatwarCharacterFalseusrpatnmfalse0FalseFalseSelectAkora1Task1srbySearch ByCharacterFalsefalse0FalseFalseSelectAadhaarAccount NoTask1aadSearch ValueCharacterFalse{-}false0FalseFalseAccept GetParams webservice completed Closing connection # 1#Saving to log Param Type = c sessionid=2q2lli55pedfdvyxnd1tgrbf Param Type = c username=13495 Param Type = c calledon=10/12/2025 11:16:40 Param Type = c callfinished=10/12/2025 11:16:41 Param Type = n recordid=0 Param Type = c servicename=Getting IView Params Param Type = c serviceresult=success Param Type = n timetaken=1375 Param Type = n dbtimetaken=405 insert into axpertlog (sessionid,username,calledon,callfinished,structname,recordid,servicename,serviceresult,timetaken,dbtimetaken) values (:sessionid,:username,to_date(:calledon,'dd/mm/yyyy hh24:mi:ss'),to_date(:callfinished,'dd/mm/yyyy hh24:mi:ss'),null,:recordid,:servicename,:serviceresult,:timetaken,:dbtimetaken) Freeing AxProvider Resources Freeing DbManager Resources Loading and setting parameters components Loading and setting parameters components completed End Time : 12/10/2025 11:16:41 AM Loading iview.aspx after post back (get and load iview data) Get and Load Iviewdata Call to GetIView Web Service for page no 1 Call to GetIView Web Service for page no 1 Start Time 12/10/2025 11:16:42 AM ASB XE3/32/64 DLL running [Compiled on 19/06/2015 12:09:20 AM] [File Version : 9.5.0.0]] [Product Version : 9.0][64 Bit - WebFix2] DB Manager created Current ASB DLL folder : E:\website\dmis\dmisscripts Connecting to project Dbx name = dmis ConnectionName = oracle DriverName = oracle GetDriverFunc = getSQLDriverORACLE LibraryName = E:\website\dmis\dmisscripts\dbxora.dll VendorLib = E:\website\dmis\dmisscripts\OCI.dll Database = dmis User_Name = dmis Select sysdate as sdt from dual Time elapsed = 16 SELECT * FROM AXPROPS WHERE NAME = 'app' Time elapsed = 16 SELECT Constraint_Name FROM AXCONSTRAINTS where 1=2 Time elapsed = 15 Connection to DB Successful Executing GetIView webservice ----------------------------- Received XML : NagaurDehAkoraAkoradbOracledbxdmisdmisdc1d71bbb5c4d2a5e936db79ef10c19fdmisdd/mm/yyyy hh24:mi:ssadminlocaldmisactivedmis\100000falseselect ausername ||'-'|| ( usertype ) auname from axusers where username in (:username)tBlackfalse Validating Session select * from connections where sessionid = :sesid Time elapsed = 15 Application Variables and Values ax_evalcopy=T rolename=Patwari responsibilies=Patwari usrpatid=4521 urole=Patwari usrofcnm=ALL usrdeptnm=ALL usrofc=0 usrdept=0 usrdistid=14 usrpatnm=Akora usrilrnm=Kamediya usrtehnm=Deh usrdistnm=Nagaur usrpatwar=Akora usrrole=Patwari User Group Patwari User Roles Patwari Validate Session completed select name from iviews where blobno=1 and name in (SELECT SNAME FROM AXUSERACCESS WHERE RNAME IN ('Patwari') and lower(sname)='farass' and stype = 'i' ) Time elapsed = 16 Sql : select props from axuseraccess where lower(rname)= :rname and lower(sname)= :sname and stype = :stype order by blobno Paramval : patwari,farass,i ParamTYpe : ccc Param List : rname sname stype select props from axuseraccess where lower(rname)= :rname and lower(sname)= :sname and stype = :stype order by blobno Time elapsed = 15 Reading data from stream >>Reading defintion - farass Sql : select props from iviews where lower(name)= :name order by blobno Paramval : farass ParamTYpe : c Param List : name select props from iviews where lower(name)= :name order by blobno Time elapsed = 16 Step5 Evaluating dbrow Result = Evaluating dbrow Result = Initializing Report Preparing SQL statements Assigning values to IView parameters scode()= scode= srby()= srby= aad(c)=Akora aad=Akora srby()= aad(c)=Akora scode()= srby()= aad(c)=Akora srby()= aad(c)=Akora dist(c)=Nagaur dist=Nagaur dist(c)=Nagaur teh(c)=Deh teh=Deh teh(c)=Deh pat(c)=Akora pat=Akora pat(c)=Akora Creating Columns Creating trn_bulkdtlid Creating distnm Creating column1 Creating seasoncode Creating geodtl Creating reliefcategory Creating namedtl Creating mobile Creating aadhaar Creating acc_ifsc Creating amount Creating sanctionamt Creating as_no Creating demno Creating fs_no Creating billno Creating billdate Creating tvno Creating tvdate Creating orgnlfile Creating stat Creating repayremarks select count(*) recno from (select a.* , rownum rnum from ( SELECT TRN_BULKDTLID, SEASONCODE, DISTNM, GEODTL, NAMEDTL, MOBILE, AADHAAR, ACC_IFSC, AMOUNT, SANCTIONAMT, RELIEFCATEGORY, AS_NO, ST ||'
'||T2.STATUS STAT, FS_NO, DEMNO, BILLNO, BILLDATE, TVNO, TVDATE, ORGNLFILE, REPAYREMARKS FROM (SELECT a1.TRN_BULKDTLID, A1.SEASONCODE, E.DISTNM, 'District - ' || E.DISTNM || '
Tehsil - ' || A1.TEHSIL || '
Patwar - ' || E.PATWARNM || '
Village - ' || A1.VILLAGE geodtl, A1.NAME || '-' || A1.father_name namedtl, A1.MOBILE, A1.AADHAAR, a1.account_no || '-' || a1.IFSC_CODE acc_ifsc, a1.amount, A2.NEWSANAMT SANCTIONAMT, (SELECT Valuedesc FROM vw_lov rc WHERE rc.listcode = 'Reliefcategory' AND valuecode = a1.RELIEFCATEGORY) || '
' || A1.Farmer_category || ' - ' || CASE WHEN LOSS_CATEGORY = 33 THEN '33%-50%' WHEN LOSS_CATEGORY = 50 THEN '50%-75%' WHEN LOSS_CATEGORY = 75 THEN '75%-100%' ELSE '-' END reliefcategory, CASE WHEN NVL (A2.NEWSANAMT, 0) = 0 THEN 'Rejected' WHEN NVL (a1.amount, 0) = NVL (A2.NEWSANAMT, 0) THEN 'Approved' WHEN NVL (a1.amount, 0) > NVL (A2.NEWSANAMT, 0) THEN 'Partially Approved' END st, A2.AS_NO, a1.mststatusid stat, A2.FS_NO, A2.DEMNO, A2.REPAYREMARKS, X1.BILLNO, TRUNC (X1.BILLDATE) BILLDATE, X2.TVNO, X2.TVDATE, x2.ORGNLFILE, E.TEHSILNM, E.VILLNM FROM (SELECT * FROM trn_bulkdtl WHERE seasoncode = :scode AND ( (:srby = 'Aadhaar' AND AADHAAR = TO_NUMBER (TRIM (:aad))) OR (:srby = 'Account No' AND ACCOUNT_NO = TRIM (:aad)))) a1, trn_common_sanction a2, vw_geodtl e, trn_fsbillgeneration x1, TRN_TREASURYDTL x2 WHERE A1.VILLAGEID = E.VILLID AND A1.TRN_BULKDTLID = A2.TRN_BULKDTLID(+) AND A2.TRN_BULKDTLID = x1.TRN_BULKDTLID(+) and A2.FS_NO = x1.FS_NO(+) AND 0 < (SELECT COUNT (1) qty FROM (SELECT * FROM trn_bulkdtl WHERE seasoncode = :scode AND ( (:srby = 'Aadhaar' AND AADHAAR = TO_NUMBER (TRIM (:aad))) OR (:srby = 'Account No' AND ACCOUNT_NO = TRIM (:aad)))) x1, vw_geodtl x2 WHERE x1.villageid = x2.villid AND (x2.DISTNM = :dist OR :dist = 'ALL') AND (x2.TEHSILNM = :teh OR :teh = 'ALL') AND (x2.PATWARNM = :pat OR :pat = 'ALL')) AND x1.billno = x2.refno(+)) T1, (SELECT X1.MSTSTATUSID, X1.STATUS FROM mst_status x1, cm_modulehdr x2 WHERE x1.MODULENAME = x2.CM_MODULEHDRID(+) AND X2.MODNAME = 'Agriculture Input Subsidy') T2 WHERE T1.stat = T2.mststatusid(+) ORDER BY sanctionamt DESC, TEHSILNM, VILLNM )a) scode= srby= aad=Akora srby= aad=Akora scode= srby= aad=Akora srby= aad=Akora dist=Nagaur dist=Nagaur teh=Deh teh=Deh pat=Akora pat=Akora Time elapsed = 172 SELECT TRN_BULKDTLID, SEASONCODE, DISTNM, GEODTL, NAMEDTL, MOBILE, AADHAAR, ACC_IFSC, AMOUNT, SANCTIONAMT, RELIEFCATEGORY, AS_NO, ST ||'
'||T2.STATUS STAT, FS_NO, DEMNO, BILLNO, BILLDATE, TVNO, TVDATE, ORGNLFILE, REPAYREMARKS FROM (SELECT a1.TRN_BULKDTLID, A1.SEASONCODE, E.DISTNM, 'District - ' || E.DISTNM || '
Tehsil - ' || A1.TEHSIL || '
Patwar - ' || E.PATWARNM || '
Village - ' || A1.VILLAGE geodtl, A1.NAME || '-' || A1.father_name namedtl, A1.MOBILE, A1.AADHAAR, a1.account_no || '-' || a1.IFSC_CODE acc_ifsc, a1.amount, A2.NEWSANAMT SANCTIONAMT, (SELECT Valuedesc FROM vw_lov rc WHERE rc.listcode = 'Reliefcategory' AND valuecode = a1.RELIEFCATEGORY) || '
' || A1.Farmer_category || ' - ' || CASE WHEN LOSS_CATEGORY = 33 THEN '33%-50%' WHEN LOSS_CATEGORY = 50 THEN '50%-75%' WHEN LOSS_CATEGORY = 75 THEN '75%-100%' ELSE '-' END reliefcategory, CASE WHEN NVL (A2.NEWSANAMT, 0) = 0 THEN 'Rejected' WHEN NVL (a1.amount, 0) = NVL (A2.NEWSANAMT, 0) THEN 'Approved' WHEN NVL (a1.amount, 0) > NVL (A2.NEWSANAMT, 0) THEN 'Partially Approved' END st, A2.AS_NO, a1.mststatusid stat, A2.FS_NO, A2.DEMNO, A2.REPAYREMARKS, X1.BILLNO, TRUNC (X1.BILLDATE) BILLDATE, X2.TVNO, X2.TVDATE, x2.ORGNLFILE, E.TEHSILNM, E.VILLNM FROM (SELECT * FROM trn_bulkdtl WHERE seasoncode = :scode AND ( (:srby = 'Aadhaar' AND AADHAAR = TO_NUMBER (TRIM (:aad))) OR (:srby = 'Account No' AND ACCOUNT_NO = TRIM (:aad)))) a1, trn_common_sanction a2, vw_geodtl e, trn_fsbillgeneration x1, TRN_TREASURYDTL x2 WHERE A1.VILLAGEID = E.VILLID AND A1.TRN_BULKDTLID = A2.TRN_BULKDTLID(+) AND A2.TRN_BULKDTLID = x1.TRN_BULKDTLID(+) and A2.FS_NO = x1.FS_NO(+) AND 0 < (SELECT COUNT (1) qty FROM (SELECT * FROM trn_bulkdtl WHERE seasoncode = :scode AND ( (:srby = 'Aadhaar' AND AADHAAR = TO_NUMBER (TRIM (:aad))) OR (:srby = 'Account No' AND ACCOUNT_NO = TRIM (:aad)))) x1, vw_geodtl x2 WHERE x1.villageid = x2.villid AND (x2.DISTNM = :dist OR :dist = 'ALL') AND (x2.TEHSILNM = :teh OR :teh = 'ALL') AND (x2.PATWARNM = :pat OR :pat = 'ALL')) AND x1.billno = x2.refno(+)) T1, (SELECT X1.MSTSTATUSID, X1.STATUS FROM mst_status x1, cm_modulehdr x2 WHERE x1.MODULENAME = x2.CM_MODULEHDRID(+) AND X2.MODNAME = 'Agriculture Input Subsidy') T2 WHERE T1.stat = T2.mststatusid(+) ORDER BY sanctionamt DESC, TEHSILNM, VILLNM scode= srby= aad=Akora srby= aad=Akora scode= srby= aad=Akora srby= aad=Akora dist=Nagaur dist=Nagaur teh=Deh teh=Deh pat=Akora pat=Akora Time elapsed = 94 Time elapsed = 109 Copying result to grid Row 1 Evaluating column values trn_bulkdtlid = trn_bulkdtlid = distnm = distnm = column1 - evaluating expression dbrow = 1 column1 = 1 column1 = 1 seasoncode = seasoncode = geodtl = geodtl = reliefcategory = reliefcategory = namedtl = namedtl = mobile = mobile = aadhaar = aadhaar = acc_ifsc = acc_ifsc = amount = amount = sanctionamt = sanctionamt = as_no = as_no = demno = demno = fs_no = fs_no = billno = billno = billdate = billdate = tvno = tvno = tvdate = tvdate = orgnlfile = orgnlfile = stat = stat = repayremarks = repayremarks = Creating Row Row No1 Created Displaying columns Column Name : trn_bulkdtlid Column Value : Column Name : distnm Column Value : Column Name : column1 Column Value : 1 Column Name : seasoncode Column Value : Column Name : geodtl Column Value : Column Name : reliefcategory Column Value : Column Name : namedtl Column Value : Column Name : mobile Column Value : Column Name : aadhaar Column Value : Column Name : acc_ifsc Column Value : Column Name : amount Column Value : Column Name : sanctionamt Column Value : Column Name : as_no Column Value : Column Name : demno Column Value : Column Name : fs_no Column Value : Column Name : billno Column Value : Column Name : billdate Column Value : Column Name : tvno Column Value : Column Name : tvdate Column Value : Column Name : orgnlfile Column Value : Column Name : stat Column Value : Column Name : repayremarks Column Value : Rehiding column trn_bulkdtlid Rehiding column distnm Rehiding column column1 Rehiding column seasoncode Rehiding column geodtl Rehiding column reliefcategory Rehiding column namedtl Rehiding column mobile Rehiding column aadhaar Rehiding column acc_ifsc Rehiding column amount Rehiding column sanctionamt Rehiding column as_no Rehiding column demno Rehiding column fs_no Rehiding column billno Rehiding column billdate Rehiding column tvno Rehiding column tvdate Rehiding column orgnlfile Rehiding column stat Rehiding column repayremarks Storing subtotals Storing subtotals at : E:\website\dmis\dmisscripts\Axpert\2q2lli55pedfdvyxnd1tgrbf\farass.lst Time elapsed = 688 Total Time elapsed = 1235 Creating runtime menu Created runtime menu Creating Report Header/Footer Creating Report Header/Footer over Iview XML :

Farmer Assistance Report New

axrowtypeaxp__fontdetailstrn_bulkdtliddistnmSr. No.Season CodeDistrict-Tehsil-VillageRelief-Farmer-Loss CategoryName-Father NameMobileAadhaarA/C No.-IFSCApplied AmountSanction AmountAS No.Demand NoFS No.Bill NoBill DatetvnotvdateorgnlfileStatusRepay Remarks1trn_bulkdtlid,Arial,8,f,f,f,f,clBlack~distnm,Arial,8,f,f,f,f,clBlack~column1,Arial,8,f,f,f,f,clBlack~seasoncode,Arial,8,f,f,f,f,clBlack~geodtl,Arial,8,f,f,f,f,clBlack~reliefcategory,Arial,8,f,f,f,f,clBlack~namedtl,Arial,8,f,f,f,f,clBlack~mobile,Arial,8,f,f,f,f,clBlack~aadhaar,Arial,8,f,f,f,f,clBlack~acc_ifsc,Arial,8,f,f,f,f,clBlack~amount,Arial,8,f,f,f,f,clBlack~sanctionamt,Arial,8,f,f,f,f,clBlack~as_no,Arial,8,f,f,f,f,clBlack~demno,Arial,8,f,f,f,f,clBlack~fs_no,Arial,8,f,f,f,f,clBlack~billno,Arial,8,f,f,f,f,clBlack~billdate,Arial,8,f,f,f,f,clBlack~tvno,Arial,8,f,f,f,f,clBlack~tvdate,Arial,8,f,f,f,f,clBlack~orgnlfile,Arial,8,f,f,f,f,clBlack~stat,Arial,8,f,f,f,f,clBlack~repayremarks,Arial,8,f,f,f,f,clBlack1 GetIView webservice completed Closing connection # 1#Saving to log Param Type = c sessionid=2q2lli55pedfdvyxnd1tgrbf Param Type = c username=13495 Param Type = c calledon=10/12/2025 11:16:42 Param Type = c callfinished=10/12/2025 11:16:44 Param Type = c structname=farass Param Type = n recordid=0 Param Type = c servicename=Get IView Param Type = c serviceresult=success Param Type = n timetaken=2140 Param Type = n dbtimetaken=531 insert into axpertlog (sessionid,username,calledon,callfinished,structname,recordid,servicename,serviceresult,timetaken,dbtimetaken) values (:sessionid,:username,to_date(:calledon,'dd/mm/yyyy hh24:mi:ss'),to_date(:callfinished,'dd/mm/yyyy hh24:mi:ss'),:structname,:recordid,:servicename,:serviceresult,:timetaken,:dbtimetaken) Freeing AxProvider Resources Freeing DbManager Resources Setting Iview components Binding data to grid completed End Time : 12/10/2025 11:16:44 AM Loading iview.aspx after post back (get and load iview data) Get and Load Iviewdata Call to GetIView Web Service for page no 1 Call to GetIView Web Service for page no 1 Start Time 12/10/2025 11:17:06 AM ASB XE3/32/64 DLL running [Compiled on 19/06/2015 12:09:20 AM] [File Version : 9.5.0.0]] [Product Version : 9.0][64 Bit - WebFix2] DB Manager created Current ASB DLL folder : E:\website\dmis\dmisscripts Connecting to project Dbx name = dmis ConnectionName = oracle DriverName = oracle GetDriverFunc = getSQLDriverORACLE LibraryName = E:\website\dmis\dmisscripts\dbxora.dll VendorLib = E:\website\dmis\dmisscripts\OCI.dll Database = dmis User_Name = dmis Select sysdate as sdt from dual Time elapsed = 16 SELECT * FROM AXPROPS WHERE NAME = 'app' Time elapsed = 15 SELECT Constraint_Name FROM AXCONSTRAINTS where 1=2 Time elapsed = 0 Connection to DB Successful Executing GetIView webservice ----------------------------- Received XML : 2082-KHARIFNagaurDehAkoraAadhaar262524474872dbOracledbxdmisdmisdc1d71bbb5c4d2a5e936db79ef10c19fdmisdd/mm/yyyy hh24:mi:ssadminlocaldmisactivedmis\100000falseselect ausername ||'-'|| ( usertype ) auname from axusers where username in (:username)tBlackfalse Validating Session select * from connections where sessionid = :sesid Time elapsed = 0 Application Variables and Values ax_evalcopy=T rolename=Patwari responsibilies=Patwari usrpatid=4521 urole=Patwari usrofcnm=ALL usrdeptnm=ALL usrofc=0 usrdept=0 usrdistid=14 usrpatnm=Akora usrilrnm=Kamediya usrtehnm=Deh usrdistnm=Nagaur usrpatwar=Akora usrrole=Patwari User Group Patwari User Roles Patwari Validate Session completed select name from iviews where blobno=1 and name in (SELECT SNAME FROM AXUSERACCESS WHERE RNAME IN ('Patwari') and lower(sname)='farass' and stype = 'i' ) Time elapsed = 0 Sql : select props from axuseraccess where lower(rname)= :rname and lower(sname)= :sname and stype = :stype order by blobno Paramval : patwari,farass,i ParamTYpe : ccc Param List : rname sname stype select props from axuseraccess where lower(rname)= :rname and lower(sname)= :sname and stype = :stype order by blobno Time elapsed = 0 Reading data from stream >>Reading defintion - farass Sql : select props from iviews where lower(name)= :name order by blobno Paramval : farass ParamTYpe : c Param List : name select props from iviews where lower(name)= :name order by blobno Time elapsed = 0 Step5 Evaluating dbrow Result = Evaluating dbrow Result = Initializing Report Preparing SQL statements Assigning values to IView parameters scode(c)=2082-KHARIF scode=2082-KHARIF srby(c)=Aadhaar srby=Aadhaar aad(c)=262524474872 aad=262524474872 srby(c)=Aadhaar aad(c)=262524474872 scode(c)=2082-KHARIF srby(c)=Aadhaar aad(c)=262524474872 srby(c)=Aadhaar aad(c)=262524474872 dist(c)=Nagaur dist=Nagaur dist(c)=Nagaur teh(c)=Deh teh=Deh teh(c)=Deh pat(c)=Akora pat=Akora pat(c)=Akora Creating Columns Creating trn_bulkdtlid Creating distnm Creating column1 Creating seasoncode Creating geodtl Creating reliefcategory Creating namedtl Creating mobile Creating aadhaar Creating acc_ifsc Creating amount Creating sanctionamt Creating as_no Creating demno Creating fs_no Creating billno Creating billdate Creating tvno Creating tvdate Creating orgnlfile Creating stat Creating repayremarks select count(*) recno from (select a.* , rownum rnum from ( SELECT TRN_BULKDTLID, SEASONCODE, DISTNM, GEODTL, NAMEDTL, MOBILE, AADHAAR, ACC_IFSC, AMOUNT, SANCTIONAMT, RELIEFCATEGORY, AS_NO, ST ||'
'||T2.STATUS STAT, FS_NO, DEMNO, BILLNO, BILLDATE, TVNO, TVDATE, ORGNLFILE, REPAYREMARKS FROM (SELECT a1.TRN_BULKDTLID, A1.SEASONCODE, E.DISTNM, 'District - ' || E.DISTNM || '
Tehsil - ' || A1.TEHSIL || '
Patwar - ' || E.PATWARNM || '
Village - ' || A1.VILLAGE geodtl, A1.NAME || '-' || A1.father_name namedtl, A1.MOBILE, A1.AADHAAR, a1.account_no || '-' || a1.IFSC_CODE acc_ifsc, a1.amount, A2.NEWSANAMT SANCTIONAMT, (SELECT Valuedesc FROM vw_lov rc WHERE rc.listcode = 'Reliefcategory' AND valuecode = a1.RELIEFCATEGORY) || '
' || A1.Farmer_category || ' - ' || CASE WHEN LOSS_CATEGORY = 33 THEN '33%-50%' WHEN LOSS_CATEGORY = 50 THEN '50%-75%' WHEN LOSS_CATEGORY = 75 THEN '75%-100%' ELSE '-' END reliefcategory, CASE WHEN NVL (A2.NEWSANAMT, 0) = 0 THEN 'Rejected' WHEN NVL (a1.amount, 0) = NVL (A2.NEWSANAMT, 0) THEN 'Approved' WHEN NVL (a1.amount, 0) > NVL (A2.NEWSANAMT, 0) THEN 'Partially Approved' END st, A2.AS_NO, a1.mststatusid stat, A2.FS_NO, A2.DEMNO, A2.REPAYREMARKS, X1.BILLNO, TRUNC (X1.BILLDATE) BILLDATE, X2.TVNO, X2.TVDATE, x2.ORGNLFILE, E.TEHSILNM, E.VILLNM FROM (SELECT * FROM trn_bulkdtl WHERE seasoncode = :scode AND ( (:srby = 'Aadhaar' AND AADHAAR = TO_NUMBER (TRIM (:aad))) OR (:srby = 'Account No' AND ACCOUNT_NO = TRIM (:aad)))) a1, trn_common_sanction a2, vw_geodtl e, trn_fsbillgeneration x1, TRN_TREASURYDTL x2 WHERE A1.VILLAGEID = E.VILLID AND A1.TRN_BULKDTLID = A2.TRN_BULKDTLID(+) AND A2.TRN_BULKDTLID = x1.TRN_BULKDTLID(+) and A2.FS_NO = x1.FS_NO(+) AND 0 < (SELECT COUNT (1) qty FROM (SELECT * FROM trn_bulkdtl WHERE seasoncode = :scode AND ( (:srby = 'Aadhaar' AND AADHAAR = TO_NUMBER (TRIM (:aad))) OR (:srby = 'Account No' AND ACCOUNT_NO = TRIM (:aad)))) x1, vw_geodtl x2 WHERE x1.villageid = x2.villid AND (x2.DISTNM = :dist OR :dist = 'ALL') AND (x2.TEHSILNM = :teh OR :teh = 'ALL') AND (x2.PATWARNM = :pat OR :pat = 'ALL')) AND x1.billno = x2.refno(+)) T1, (SELECT X1.MSTSTATUSID, X1.STATUS FROM mst_status x1, cm_modulehdr x2 WHERE x1.MODULENAME = x2.CM_MODULEHDRID(+) AND X2.MODNAME = 'Agriculture Input Subsidy') T2 WHERE T1.stat = T2.mststatusid(+) ORDER BY sanctionamt DESC, TEHSILNM, VILLNM )a) scode=2082-KHARIF srby=Aadhaar aad=262524474872 srby=Aadhaar aad=262524474872 scode=2082-KHARIF srby=Aadhaar aad=262524474872 srby=Aadhaar aad=262524474872 dist=Nagaur dist=Nagaur teh=Deh teh=Deh pat=Akora pat=Akora Time elapsed = 12203 select * from (select a.* , rownum axrnum from ( SELECT TRN_BULKDTLID, SEASONCODE, DISTNM, GEODTL, NAMEDTL, MOBILE, AADHAAR, ACC_IFSC, AMOUNT, SANCTIONAMT, RELIEFCATEGORY, AS_NO, ST ||'
'||T2.STATUS STAT, FS_NO, DEMNO, BILLNO, BILLDATE, TVNO, TVDATE, ORGNLFILE, REPAYREMARKS FROM (SELECT a1.TRN_BULKDTLID, A1.SEASONCODE, E.DISTNM, 'District - ' || E.DISTNM || '
Tehsil - ' || A1.TEHSIL || '
Patwar - ' || E.PATWARNM || '
Village - ' || A1.VILLAGE geodtl, A1.NAME || '-' || A1.father_name namedtl, A1.MOBILE, A1.AADHAAR, a1.account_no || '-' || a1.IFSC_CODE acc_ifsc, a1.amount, A2.NEWSANAMT SANCTIONAMT, (SELECT Valuedesc FROM vw_lov rc WHERE rc.listcode = 'Reliefcategory' AND valuecode = a1.RELIEFCATEGORY) || '
' || A1.Farmer_category || ' - ' || CASE WHEN LOSS_CATEGORY = 33 THEN '33%-50%' WHEN LOSS_CATEGORY = 50 THEN '50%-75%' WHEN LOSS_CATEGORY = 75 THEN '75%-100%' ELSE '-' END reliefcategory, CASE WHEN NVL (A2.NEWSANAMT, 0) = 0 THEN 'Rejected' WHEN NVL (a1.amount, 0) = NVL (A2.NEWSANAMT, 0) THEN 'Approved' WHEN NVL (a1.amount, 0) > NVL (A2.NEWSANAMT, 0) THEN 'Partially Approved' END st, A2.AS_NO, a1.mststatusid stat, A2.FS_NO, A2.DEMNO, A2.REPAYREMARKS, X1.BILLNO, TRUNC (X1.BILLDATE) BILLDATE, X2.TVNO, X2.TVDATE, x2.ORGNLFILE, E.TEHSILNM, E.VILLNM FROM (SELECT * FROM trn_bulkdtl WHERE seasoncode = :scode AND ( (:srby = 'Aadhaar' AND AADHAAR = TO_NUMBER (TRIM (:aad))) OR (:srby = 'Account No' AND ACCOUNT_NO = TRIM (:aad)))) a1, trn_common_sanction a2, vw_geodtl e, trn_fsbillgeneration x1, TRN_TREASURYDTL x2 WHERE A1.VILLAGEID = E.VILLID AND A1.TRN_BULKDTLID = A2.TRN_BULKDTLID(+) AND A2.TRN_BULKDTLID = x1.TRN_BULKDTLID(+) and A2.FS_NO = x1.FS_NO(+) AND 0 < (SELECT COUNT (1) qty FROM (SELECT * FROM trn_bulkdtl WHERE seasoncode = :scode AND ( (:srby = 'Aadhaar' AND AADHAAR = TO_NUMBER (TRIM (:aad))) OR (:srby = 'Account No' AND ACCOUNT_NO = TRIM (:aad)))) x1, vw_geodtl x2 WHERE x1.villageid = x2.villid AND (x2.DISTNM = :dist OR :dist = 'ALL') AND (x2.TEHSILNM = :teh OR :teh = 'ALL') AND (x2.PATWARNM = :pat OR :pat = 'ALL')) AND x1.billno = x2.refno(+)) T1, (SELECT X1.MSTSTATUSID, X1.STATUS FROM mst_status x1, cm_modulehdr x2 WHERE x1.MODULENAME = x2.CM_MODULEHDRID(+) AND X2.MODNAME = 'Agriculture Input Subsidy') T2 WHERE T1.stat = T2.mststatusid(+) ORDER BY sanctionamt DESC, TEHSILNM, VILLNM )a ) where axrnum between 1 and 200 scode=2082-KHARIF srby=Aadhaar aad=262524474872 srby=Aadhaar aad=262524474872 scode=2082-KHARIF srby=Aadhaar aad=262524474872 srby=Aadhaar aad=262524474872 dist=Nagaur dist=Nagaur teh=Deh teh=Deh pat=Akora pat=Akora Time elapsed = 6324 Time elapsed = 6324 Copying result to grid Row 1 Evaluating column values trn_bulkdtlid = 24522620 trn_bulkdtlid = 24522620 distnm = Nagaur distnm = Nagaur column1 - evaluating expression dbrow = 1 column1 = 1 column1 = 1 seasoncode = 2082-KHARIF seasoncode = 2082-KHARIF geodtl = District - Nagaur
Tehsil - Deh
Patwar - Akora
Village - Dodoo geodtl = District - Nagaur
Tehsil - Deh
Patwar - Akora
Village - Dodoo reliefcategory = Irrigated
Other Than SMF - 50%-75% reliefcategory = Irrigated
Other Than SMF - 50%-75% namedtl = Birama Ram-Ganesh Ram namedtl = Birama Ram-Ganesh Ram mobile = 0 mobile = 0 aadhaar = 262524474872 aadhaar = 262524474872 acc_ifsc = 21058035815-RMGB0001058 acc_ifsc = 21058035815-RMGB0001058 amount = 34000 amount = 34000 sanctionamt = sanctionamt = as_no = as_no = demno = demno = fs_no = fs_no = billno = billno = billdate = billdate = tvno = tvno = tvdate = tvdate = orgnlfile = orgnlfile = stat = Rejected
Pending at Tehsildar for Verification stat = Rejected
Pending at Tehsildar for Verification repayremarks = repayremarks = Creating Row Row No1 Created Displaying columns Column Name : trn_bulkdtlid Column Value : 24522620 Column Name : distnm Column Value : Nagaur Column Name : column1 Column Value : 1 Column Name : seasoncode Column Value : 2082-KHARIF Column Name : geodtl Column Value : District - Nagaur
Tehsil - Deh
Patwar - Akora
Village - Dodoo Column Name : reliefcategory Column Value : Irrigated
Other Than SMF - 50%-75% Column Name : namedtl Column Value : Birama Ram-Ganesh Ram Column Name : mobile Column Value : 0 Column Name : aadhaar Column Value : 262524474872 Column Name : acc_ifsc Column Value : 21058035815-RMGB0001058 Column Name : amount Column Value : 34000 Column Name : sanctionamt Column Value : Column Name : as_no Column Value : Column Name : demno Column Value : Column Name : fs_no Column Value : Column Name : billno Column Value : Column Name : billdate Column Value : Column Name : tvno Column Value : Column Name : tvdate Column Value : Column Name : orgnlfile Column Value : Column Name : stat Column Value : Rejected
Pending at Tehsildar for Verification Column Name : repayremarks Column Value : Rehiding column trn_bulkdtlid Rehiding column distnm Rehiding column column1 Rehiding column seasoncode Rehiding column geodtl Rehiding column reliefcategory Rehiding column namedtl Rehiding column mobile Rehiding column aadhaar Rehiding column acc_ifsc Rehiding column amount Rehiding column sanctionamt Rehiding column as_no Rehiding column demno Rehiding column fs_no Rehiding column billno Rehiding column billdate Rehiding column tvno Rehiding column tvdate Rehiding column orgnlfile Rehiding column stat Rehiding column repayremarks Storing subtotals Storing subtotals at : E:\website\dmis\dmisscripts\Axpert\2q2lli55pedfdvyxnd1tgrbf\farass.lst Time elapsed = 641 Total Time elapsed = 19511 Creating runtime menu Created runtime menu Creating Report Header/Footer Creating Report Header/Footer over Iview XML :

Farmer Assistance Report New