openiview-dev-cldocvie --------------------------------------------------- Calling Function - Call Params Plus Access Structure Config - GetParams Session ID - fevgag5szj4b24cs5phvx0ut Current User - rekhancia Inputs - IView Name : cldocvie Output - Success --cldocvie ParamXML : Task1pfinancialyearFinancial YearCharacterfalsefalseselect a.financialyear_code from financial_years a where a.cancel = 'F' and a.active = 'T' order by a.createdon desc0truefalseSelect325false2024-252023-24Task1pfundcodeFund CodeCharacterfalse{PMS}false 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}falseselect 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}falseselect 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 PathCharacterfalseAxpAttachmentPathtrue0truefalseAccept325falseTask1paxusergroupUser RolesCharacterfalseusergrouptrue0truefalseAcceptpclientname325falseTask1pusernameUser NameCharacterfalseusernametrue0truefalseAcceptpclientname325falseTask1pclientnameClient NameCharacterfalsefalseselect 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 : cldocvieClient Documents0true0falsefalseEnabledfalsefalseselect rowfalsefalsefalsecldocviefalseCenterCenter1falsefalse0falsefalsefalsefalseclskyblue[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$00E2E8E91810ClassicNonefalsefalselistmaterial-iconsvideo_labelmaterial-iconssearchmaterial-iconsfact_checkmaterial-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.client_name,a2.fund_code, a2.scheme_code, a2.report_type, a2.subreport_type,:mAxpAttachmentPath as AxZIPFilePath, a1.axpfile_documentupload as AxZIPFiles, concat(a1.miles_account_code, '-', a2.report_type ,'-', current_date) as AxZipFileName,a2.document_shortdescription, 'rekhancia@agile-labs.com' as Axp_EMailFrom,a3.primary_emailid as Axp_EMailTo,concat('Trustline PMS App : ','FY ', a2.fincode,' ', a2.notation, ' ', a2.subreport_type,' ', a2.scheme_code) as Axp_EMailSub,a3.cc_mailid1 as Axp_EMailCC,a3.cc_mailid2 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,a1.createdon,a2.date_published desc reportsqlTask1pfinancialyearFinancial YearCharacterfalsefalseselect a.financialyear_code from financial_years a where a.cancel = 'F' and a.active = 'T' order by a.createdon desc0truefalseSelect325falseTask1pfundcodeFund CodeCharacterfalse{PMS}false 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}falseselect 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}falseselect 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 PathCharacterfalseAxpAttachmentPathtrue0truefalseAccept325falseTask1paxusergroupUser RolesCharacterfalseusergrouptrue0truefalseAcceptpclientname325falseTask1pusernameUser NameCharacterfalseusernametrue0truefalseAcceptpclientname325falseTask1pclientnameClient NameCharacterfalsefalseselect 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_yearcodeTask1Character0falsetruetruefalsefalsefalseClwindow[Arial,8,clBlack,,False,False,False,False]Lefttruefalse115false0financialyear_codefinancialyear_codeTask1Numeric0falsetruetruefalsefalsefalseClwindow[Arial,8,clBlack,,False,False,False,False]Righttruefalse115false0miles_account_codeMILES Account CodeTask1Character0falsetruetruefalsefalsefalseClwindow[Arial,8,clBlack,,False,False,False,False]Lefttruefalse76false0ucc_codeUCC CodeTask1Character0falsetruefalsefalsefalsefalseClwindow[Arial,8,clBlack,,False,False,False,False]Lefttruefalse112false0client_codeClient Code/NameTask1Character0falsetruetruefalsefalsefalseClwindow[Arial,8,clBlack,,False,False,False,False]Lefttruefalse76false0fund_codeFund CodeTask1Character0falsetruetruefalsefalsefalseClwindow[Arial,8,clBlack,,False,False,False,False]Lefttruefalse52false0scheme_codeScheme CodeTask1Character0falsetruefalsefalsefalsefalseClwindow[Arial,8,clBlack,,False,False,False,False]Lefttruefalse133false0report_typeReport TypeTask1Character0falsetruetruefalsefalsefalseClwindow[Arial,8,clBlack,,False,False,False,False]Lefttruefalse63false0subreport_typeSub Report TypeTask1Character0falsetruetruefalsefalsefalseClwindow[Arial,8,clBlack,,False,False,False,False]Lefttruefalse80false0document_shortdescriptionReport DescriptionTask1Character0falsetruefalsefalsefalsefalseClwindow[Arial,8,clBlack,,False,False,False,False]Lefttruefalse271false0client_nameClient NameTask1Character0falsetruefalsefalsefalsefalseClwindow[Arial,8,clBlack,,False,False,False,False]Lefttruefalse185false0mfundcodemfundcodeTask1Character0falsetruetruefalsefalsefalseClwindow[Arial,8,clBlack,,False,False,False,False]Lefttruefalse72false0docidDocument#Task1Character0falsetruetruefalsefalsefalseClwindow[Arial,8,clBlack,,False,False,False,False]Lefttruefalse74false0axzipfilepathaxzipfilepathTask1Character0falsetruetruefalsefalsefalseClwindow[Arial,8,clBlack,,False,False,False,False]Lefttruefalse80false0axzipfilesaxzipfilesTask1Character0falsetruetruefalsefalsefalseClwindow[Arial,8,clBlack,,False,False,False,False]Lefttruefalse57false0axzipfilenameaxzipfilenameTask1Character0falsetruetruefalsefalsefalseClwindow[Arial,8,clBlack,,False,False,False,False]Lefttruefalse86false0recordidrecordidTask1Numeric0falsetruetruefalsefalsefalseClwindow[Arial,8,clBlack,,False,False,False,False]Righttruefalse53false0date_publishedPublished OnTask1Date/Time0falsetruefalsefalsefalsefalseClwindow[Arial,8,clBlack,,False,False,False,False]Lefttruefalse144false0axpfilepath_documentuploadaxpfilepath_documentuploadTask1Character0falsetruetruefalsefalsefalseClwindow[Arial,8,clBlack,,False,False,False,False]Lefttruefalse182false0axpfile_documentuploadDownloadTask1Character0falsetruefalsefalsefalsefalseClwindow[Arial,8,clBlack,,False,False,False,False]Lefttruefalse64false0filedocumentuploadfiledocumentuploadTask1Character0falsetruetruefalsefalsefalseClwindow[Arial,8,clBlack,,False,False,False,False]Lefttruefalse126false0axp_emailfromaxp_emailfromTask1Character0falsetruetruefalsefalsefalseClwindow[Arial,8,clBlack,,False,False,False,False]Lefttruefalse92false0axp_emailtoaxp_emailtoTask1Character0falsetruetruefalsefalsefalseClwindow[Arial,8,clBlack,,False,False,False,False]Lefttruefalse75false0axp_emailsubaxp_emailsubTask1Character0falsetruetruefalsefalsefalseClwindow[Arial,8,clBlack,,False,False,False,False]Lefttruefalse84false0axp_emailccaxp_emailccTask1Character0falsetruetruefalsefalsefalseClwindow[Arial,8,clBlack,,False,False,False,False]Lefttruefalse75false0axp_emailbccaxp_emailbccTask1Character0falsetruetruefalsefalsefalseClwindow[Arial,8,clBlack,,False,False,False,False]Lefttruefalse84false0axpemailtemplateaxpemailtemplateTask1Character0falsetruetruefalsefalsefalseClwindow[Arial,8,clBlack,,False,False,False,False]Lefttruefalse112false0emailEmailTask1Character0falsetruefalsefalsefalsefalseClwindow[Arial,8,clBlack,,False,False,False,False]Lefttruefalse63false0Client DocumentsDefaulttF Configuration : IviewcldocvieCustom CSStrueALLIviewcldocvieCustom JavaScripttrueALLIviewcldocvieFetchSize25ALL GlobalVars : {"globalVars":[{"n":"AxpAttachmentPath","v":"\\10.16.248.2\UAT_Attachment\UAT_TLReports"},{"n":"username","v":"rekhancia"}]} Created Time - 07/08/2024 10:34:45