openiview-dev-cldocume --------------------------------------------------- Calling Function - Call Params Plus Access Structure Config - GetParams Session ID - fevgag5szj4b24cs5phvx0ut Current User - rekhancia Inputs - IView Name : cldocume Output - Success --cldocume ParamXML : Task1pfinancialyearFinancial YearCharacterfalsetrueselect a.financialyear_code from financial_years a where a.cancel = 'F' and a.active = 'T' order by a.createdon desc 0truefalseSelect325false2024-252023-24Task1pfundcodeFund CodeCharacterfalse{PMS}true Select distinct a1.fund_code from fund_scheme_details a1 where a1.cancel = 'F' and a1.active = 'T' order by 1 0truefalseSelectpschemecode,preporttype325falseAIF1PMSTask1pschemecodeScheme CodeCharacterfalse{Intrinsic}trueselect a.scheme_code from fund_scheme_details a where a.fund_code = :pfundcode and a.active = 'T' and a.cancel = 'F' order by 1 0truefalseSelectpreporttype325falseFloaterIntrinsicTask1preporttypeReport TypeCharacterfalse{Transaction Report}trueselect unnest(string_to_array(b.report_type, ',')) as reporttype from fund_scheme_details b where b.fund_code = :pfundcode and b.scheme_code = :pschemecode order by 1 0truefalseSelect325falseCapital Gain ReportPerformance ReportTransaction ReportTask1mAxpAttachmentPathGlobal File PathCharacterfalseAxpAttachmentPathtrue0truefalseAccept325trueTask1paxusergroupUser RolesCharacterfalseusergrouptrue0truefalseAcceptpclientname325falseTask1pusernameUser NameCharacterfalseusernametrue0truefalseAcceptpclientname325falseTask1pclientnameClient NameCharacterfalsetrueselect a.client_name as choice from client_details a where a.active = 'T' and a.cancel = 'F' and (a.primary_emailid = :pusername or lower( :paxusergroup ) like '%default%' or lower( :paxusergroup ) like '%trustlineadmin%') union select 'ALL' as choice from dual order by 10truefalseSelect325falseA R ChitraAkhil VishwanathamALLAmitabh PrasadAnjalidevi RAnnapoorna JAnudita PrasadAravamudhan RajeshAravindan RAruna AruldassB S VijayanandBalaji DhandapaniBalaraman Kuppuswamy Jt Suguna BalaramanBharat TannaC V KamathCorporate testingDeepa Deepak DesaiEshwari Ravindran Ashok KumarGomathi UlaganathanGovind Krishnan Jt Chitra GovindInbaraj RajakumarJanardhanan ShankarJayalakshmi TKalyan Raman Bangalore Janakiraman Jt Nishita Meenakshi KumarKosala Raman Bangalore JanakiramanKrithiga RameshKumaran KandasamyLakshmi PrabhaManohar ChandrasekharMathew K EraliMythri AssociatesN A SomasundariN Rajadurai Jt Mahalakshmi BNaithrav SrinivasanNaozer Cusrow DalalNaozer Cusrow Dalal 1Padmapriya V Jt Sathyanarayanan N BPadmashri KodivalasaPallipattu Srinivasa Lakshmi Narasa ReddyPradeep C RPranav Aditya C P Jt Vikram Adithya C PPrasad Venkatesh BhattPravin Damodar Karve Jt Vaishali Pravin KarveR JayasowmyaRamamurthy PRamanan CRamesh Babu C GS Aramuthan HUFS G Anjana ShankarS N Damani Realty Investors LLPSaravanan Krishnamoorthy MusuvathiShanmugavalli ChandrasekaranSridevi Prasanna Jt Prasanna RamanujamSrikanth NSrikanth NarasimhanSrinivas Mani KolipakkamSrinivasa Raghavan SSubbulakshmi VagulaparananSubhadip SarkarSukanya Misra Jt Praphulla MisraT K Govinda RajanThirukkumaran NagarajanUsha Ratnakumari RajakumarVenkat Ravi ShankarVenkata Raghavan S K AccessControl : StructureXML : cldocumeClient Documents 0true0falsefalseEnabledfalsefalseselect rowfalsefalsefalsecldocumefalseCenterCenter1falsefalse0falsefalsefalsefalseclskyblue[Tahoma,9,clBlack,,True,False,False,False][Tahoma,8,clBlack,,True,False,False,False][Tahoma,8,clBlack,,True,False,False,False]$00F3AFA0[Tahoma,8,clBlack,,True,False,False,False]$00EEF1F2$00E2E8E91810ClassicNonefalsefalseif documents_uploadsid = 0 OpenPage({PageTsdocup},{financialyear_code=:financial_yearcode~fund_code=:mfundcode~scheme_code=:scheme_code~report_type=:lov_description~notation=:notation~subreport_type~sub_report_type},{P},{T})else LoadFormAndData({docup},{docid=:docid},{P},{T}) end if listmaterial-iconsvideo_labelmaterial-iconsimport_contactsmaterial-iconsremove_red_eyematerial-iconssearchmaterial-iconsreceiptmaterial-iconsTask1selecta1.documents_segregationid recordid,:pfinancialyear as financial_yearcode,a2.date_published, a2.financialyear_code, a2.fund_code as mfundcode, :mAxpAttachmentPath as axpfilepath_documentupload,a1.axpfile_documentupload,'<span class="material-icons material-icons-style" style="color:#2b4da1">download</span>' as filedocumentupload, a2.docid as docid, a1.miles_account_code, a1.client_code||'-'||a3.client_name as client_code, a1.ucc_code, a3.title, a3.client_name,a2.fund_code, a2.scheme_code, a2.report_type, a2.subreport_type, a2.notation, a2.fincode, :mAxpAttachmentPath as AxZIPFilePath, a1.axpfile_documentupload as AxZIPFiles, concat(a1.miles_account_code, '-', a2.report_type ,'-', current_date) as AxZipFileName,a2.document_shortdescription, 'devipriya@agile-labs.com' as Axp_EMailFrom,a3.primary_emailid as Axp_EMailTo,concat('TrustLine UAT App : ','FY ', a2.fincode,' ', a2.notation, ' ', a2.subreport_type,' ', a2.scheme_code) as Axp_EMailSub,a3.secondary_emailid as Axp_EMailCC,a3.cc_mailid1 as Axp_EMailBCC ,(select concat(replace(caption, ' ', '_'), '_', replace(name, 'HP', ''), '.html') as htmlfilename from axpages where lower(caption) = lower('emailrepTransactionreport') and name like 'HP%') as AxpEmailTemplate,'Email' as Emailfrom documents_segregation a1, (select a2.*, a3.financialyear_code as fincode, a3.financialyear_startdate, a3.financialyear_enddatefrom documents_uploads a2, financial_years a3wherea2.cancel = 'F' and a2.active = 'T' and ((current_date BETWEEN a2.validity_datefrom and a2.validity_dateto) or (a2.validity_datefrom <= current_date and a2.validity_dateto is null))and ( :pfundcode like '%'|| a2.fund_code||'%' ) and ( :pschemecode like '%'|| a2.scheme_code||'%') and ( :preporttype like '%'|| a2.report_type||'%')and a2.financialyear_code = a3.financial_yearsidand a3.financialyear_code = :pfinancialyear) a2, client_details a3where a1.docid = a2.documents_uploadsid and a1.client_code = a3.client_codeand a2.cancel = 'F' and a1.active = 'T' and lower(a1.client_code) not like 'invalid%'and (a3.primary_emailid = :pusername or lower( :paxusergroup ) like '%default%' or lower( :paxusergroup ) like '%trustlineadmin%') and (a3.client_name = :pclientname or :pclientname = 'ALL') order by a1.miles_account_code,a2.date_published descreportsqlTask1pfinancialyearFinancial YearCharacterfalsetrueselect a.financialyear_code from financial_years a where a.cancel = 'F' and a.active = 'T' order by a.createdon desc 0truefalseSelect325falseTask1pfundcodeFund CodeCharacterfalse{PMS}true Select distinct a1.fund_code from fund_scheme_details a1 where a1.cancel = 'F' and a1.active = 'T' order by 1 0truefalseSelectpschemecode,preporttype325falseTask1pschemecodeScheme CodeCharacterfalse{Intrinsic}trueselect a.scheme_code from fund_scheme_details a where a.fund_code = :pfundcode and a.active = 'T' and a.cancel = 'F' order by 1 0truefalseSelectpreporttype325falseTask1preporttypeReport TypeCharacterfalse{Transaction Report}trueselect unnest(string_to_array(b.report_type, ',')) as reporttype from fund_scheme_details b where b.fund_code = :pfundcode and b.scheme_code = :pschemecode order by 1 0truefalseSelect325falseTask1mAxpAttachmentPathGlobal File PathCharacterfalseAxpAttachmentPathtrue0truefalseAccept325trueTask1paxusergroupUser RolesCharacterfalseusergrouptrue0truefalseAcceptpclientname325falseTask1pusernameUser NameCharacterfalseusernametrue0truefalseAcceptpclientname325falseTask1pclientnameClient NameCharacterfalsetrueselect a.client_name as choice from client_details a where a.active = 'T' and a.cancel = 'F' and (a.primary_emailid = :pusername or lower( :paxusergroup ) like '%default%' or lower( :paxusergroup ) like '%trustlineadmin%') union select 'ALL' as choice from dual order by 10truefalseSelect325falsefinancial_yearcodeFinancial YearTask1Character0falsetruetruefalsefalsefalseClwindow[Arial,8,clBlack,,False,False,False,False]Lefttruefalse79false0financialyear_codeFinancial YearTask1Numeric0falsefalsetruefalsefalsefalseClwindow[Arial,8,clBlack,,False,False,False,False]Righttruefalse111false0miles_account_codeMILES Account CodeTask1Character0falsetruetruefalsefalsefalseClwindow[Arial,8,clBlack,,False,False,False,False]Lefttruefalse85false0ucc_codeUCC CodeTask1Character0falsetruefalsefalsefalsefalseClwindow[Arial,8,clBlack,,False,False,False,False]Lefttruefalse119false0client_codeClient Code/NameTask1Character0falsetruetruefalsefalsefalseClwindow[Arial,8,clBlack,,False,False,False,False]Lefttruefalse269false0fund_codeFund CodeTask1Character0falsetruetruefalsefalsefalseClwindow[Arial,8,clBlack,,False,False,False,False]Lefttruefalse79false0scheme_codeScheme NameTask1Character0falsetruefalsefalsefalsefalseClwindow[Arial,8,clBlack,,False,False,False,False]Lefttruefalse98false0report_typeReport TypeTask1Character0falsetruetruefalsefalsefalseClwindow[Arial,8,clBlack,,False,False,False,False]Lefttruefalse143false0subreport_typeSub Report TypeTask1Character0falsetruetruefalsefalsefalseClwindow[Arial,8,clBlack,,False,False,False,False]Lefttruefalse160false0document_shortdescriptionReport DescriptionTask1Character0falsetruefalsefalsefalsefalseClwindow[Arial,8,clBlack,,False,False,False,False]Lefttruefalse429false0axpfile_documentuploadDownloadTask1Character0falsetruefalsefalsefalsefalseClwindow[Arial,8,clBlack,,False,False,False,False]Lefttruefalse69false0client_nameClient NameTask1Character0falsetruefalsefalsefalsefalseClwindow[Arial,8,clBlack,,False,False,False,False]Lefttruefalse217false0mfundcodemfundcodeTask1Character0falsetruetruefalsefalsefalseClwindow[Arial,8,clBlack,,False,False,False,False]Lefttruefalse80false0docidDocument#Task1Character0falsetruetruefalsefalsefalseClwindow[Arial,8,clBlack,,False,False,False,False]Centertruefalse150false0axzipfilepathaxzipfilepathTask1Character0falsetruetruefalsefalsefalseClwindow[Arial,8,clBlack,,False,False,False,False]Lefttruefalse82false0axzipfilesaxzipfilesTask1Character0falsetruetruefalsefalsefalseClwindow[Arial,8,clBlack,,False,False,False,False]Lefttruefalse70false0axzipfilenameaxzipfilenameTask1Character0falsetruetruefalsefalsefalseClwindow[Arial,8,clBlack,,False,False,False,False]Lefttruefalse88false0recordidrecordidTask1Numeric0falsefalsetruefalsefalsefalseClwindow[Arial,8,clBlack,,False,False,False,False]Righttruefalse67false0date_publishedPublished OnTask1Date/Time0falsetruefalsefalsefalsefalseClwindow[Arial,8,clBlack,,False,False,False,False]Lefttruefalse92false0axpfilepath_documentuploadaxpfilepath_documentuploadTask1Character0falsetruetruefalsefalsefalseClwindow[Arial,8,clBlack,,False,False,False,False]Lefttruefalse184false0filedocumentuploadfiledocumentuploadTask1Character0falsetruetruefalsefalsefalseClwindow[Arial,8,clBlack,,False,False,False,False]Lefttruefalse128false0axp_emailfromaxp_emailfromTask1Character0falsetruetruefalsefalsefalseClwindow[Arial,8,clBlack,,False,False,False,False]Lefttruefalse94false0axp_emailtoaxp_emailtoTask1Character0falsetruetruefalsefalsefalseClwindow[Arial,8,clBlack,,False,False,False,False]Lefttruefalse83false0axp_emailsubaxp_emailsubTask1Character0falsetruetruefalsefalsefalseClwindow[Arial,8,clBlack,,False,False,False,False]Lefttruefalse86false0axp_emailccaxp_emailccTask1Character0falsetruetruefalsefalsefalseClwindow[Arial,8,clBlack,,False,False,False,False]Lefttruefalse83false0axp_emailbccaxp_emailbccTask1Character0falsetruetruefalsefalsefalseClwindow[Arial,8,clBlack,,False,False,False,False]Lefttruefalse86false0axpemailtemplateaxpemailtemplateTask1Character0falsetruetruefalsefalsefalseClwindow[Arial,8,clBlack,,False,False,False,False]Lefttruefalse176false0emailEmailTask1Character0falsetruefalsefalsefalsefalseClwindow[Arial,8,clBlack,,False,False,False,False]Lefttruefalse47false0<a2>title</a2><a3>title</a3><a1>Task1</a1><a4>Character</a4><a5>0</a5><a6></a6><a7>false</a7><a8>true</a8><a21>true</a21><a13>false</a13><a10>false</a10><a11>false</a11><a12>Clwindow</a12><a9>[Arial,8,clBlack,,False,False,False,False]</a9><a14>Left</a14><a15>true</a15><a16>false</a16><a17>80</a17><a18></a18><a19>false</a19><a53></a53><a54></a54><a55></a55><a58></a58><a59></a59><a61>0</a61><a62></a62><a69 masking=""></a69>notationnotationTask1Character0falsetruetruefalsefalsefalseClwindow[Arial,8,clBlack,,False,False,False,False]Lefttruefalse80false0fincodefincodeTask1Character0falsetruetruefalsefalsefalseClwindow[Arial,8,clBlack,,False,False,False,False]Lefttruefalse80false0financial_yearcodedocument_shortdescription{financial_yearcode}FalseFalse0Client Documents DefaulttF Configuration : IviewcldocumeCustom CSStrueALLIviewcldocumeCustom JavaScripttrueALLIviewcldocumeFetchSize25ALL GlobalVars : {"globalVars":[{"n":"AxpAttachmentPath","v":"\\10.16.248.2\UAT_Attachment\UAT_TLReports"},{"n":"username","v":"rekhancia"}]} Created Time - 07/08/2024 10:32:00