2 Replies Latest reply on Jul 12, 2019 12:56 AM by LeoOswald

    Oracle APEX | Image thumbnail issue

    LeoOswald

      Hey there!

       

      I have a problem with displaying an image on Oracle APEX as it shows "x" instead of the image itself.

       

      The query that I have is pasted below where detail_image2 is set as "Plain Text (based on List of Values).

       

       

      Thank you in advance!

       

      detail_image2.JPGthumbnail.JPG

       

       

       

              select classification,
                     productType,
                     description,
                     irn,
                     dbms_lob.getlength(sd_blob) sd_blobber,
                     comments,
                     to_char(uploadDate, 'MM-DD-YYYY HH24:MI:SS') uploadDate,
                     to_char(modifiedDate, 'MM-DD-YYYY HH24:MI:SS') modifiedDate,
                     username,
                     dbms_lob.getlength(image_blob) detail_image,
            decode(nvl(dbms_lob.getLength(image_blob), 0), 0, null,
            '<a href = "' || apex_util.get_blob_file_src('P201_IMAGE', irn) || '">' || '<img src="'
            || apex_util.get_blob_file_src('P201_IMAGE', irn) || '" height="75" width="75" />' || '</a>') detail_image2
                from pcu_file_upload
                where to_date(to_char(decode(:P3_UDFROM, '', to_date('01-01-1990', 'MM-DD-YYYY'), uploadDate), 'MM-DD-YYYY'), 'MM-DD-YYYY') between to_date(decode(:P3_UDFROM, '', '01-01-1990', :P3_UDFROM), 'MM-DD-YYYY') and to_date(decode(:P3_UDTO, '', '01-01-1990', :P3_UDTO), 'MM-DD-YYYY')
         and to_date(to_char(decode(:P3_MDFROM, '', to_date('01-01-1990', 'MM-DD-YYYY'), modifiedDate), 'MM-DD-YYYY'), 'MM-DD-YYYY') between to_date(decode(:P3_MDFROM, '', '01-01-1990', :P3_MDFROM), 'MM-DD-YYYY') and to_date(decode(:P3_MDTO, '', '01-01-1990', :P3_MDTO), 'MM-DD-YYYY')
                  and decode(:P3_HCLASSIFICATION, '', '1', classification) = decode(:P3_HCLASSIFICATION, '', '1', :P3_HCLASSIFICATION)
                  and decode(:P3_HPRODUCTTYPE, '', '1', productType) = decode(:P3_HPRODUCTTYPE, '', '1', :P3_HPRODUCTTYPE)
                  and decode(:P3_IRN, '', '1', irn) = decode(:P3_IRN, '', '1', :P3_IRN)
                  and trim(lower(decode(:P3_USERNAME, '', '1', username))) = trim(lower(decode(:P3_USERNAME, '', '1', :P3_USERNAME)))
      
        • 1. Re: Oracle APEX | Image thumbnail issue
          Mike Kutz

          show resulting HTML please.

           

          thanks.

           

          MK

          • 2. Re: Oracle APEX | Image thumbnail issue
            LeoOswald

            Hi Mike,

             

            Thanks for your time.

            BTW here's the resulting HTML. Not sure if this is the exact thing that you are looking for. I got it by clicking "view source".

             

            <!DOCTYPE html>
            <html class="no-js  page-3 app-F_205" lang="en" >
            <head>
              <meta http-equiv="x-ua-compatible" content="IE=edge" />
              <meta charset="utf-8">
              <title>Inquiry</title>
              <link rel="stylesheet" href="/i/app_ui/css/Core.min.css?v=5.1.2.00.09" type="text/css" />
            <link rel="stylesheet" href="/i/app_ui/css/Theme-Standard.min.css?v=5.1.2.00.09" type="text/css" />
            <link rel="stylesheet" href="/i/libraries/jquery-ui/1.10.4/themes/base/jquery-ui.min.css?v=5.1.2.00.09" type="text/css" />

              <link rel="stylesheet" href="/i/libraries/font-apex/1.0/css/font-apex.min.css?v=5.1.2.00.09" type="text/css" />
            <link rel="stylesheet" href="/i/themes/theme_42/1.1/css/Core.min.css?v=5.1.2.00.09" type="text/css" />

             
              <link rel="stylesheet" href="/i/themes/theme_42/1.1/css/Vita.min.css?v=5.1.2.00.09" type="text/css" />

             
              <style type="text/css">
            img{
            width:100px;
            height:75px;
            }
            </style>
             
              <link rel="shortcut icon" href="/i/favicon.ico">
            <link rel="icon" sizes="16x16" href="/i/favicon-16x16.png">
            <link rel="icon" sizes="32x32" href="/i/favicon-32x32.png">
            <link rel="apple-touch-icon" sizes="180x180" href="/i/favicon-180x180.png">
             
            <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
            <meta http-equiv="Pragma" content="no-cache" /><meta http-equiv="Expires" content="-1" /><meta http-equiv="Cache-Control" content="no-cache" />
              <meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0, user-scalable=no"/>
            </head>
            <body class="t-PageBody t-PageBody--hideLeft t-PageBody--hideActions no-anim   apex-side-nav apex-icons-fontapex"   id="t_PageBody">
            <form action="wwv_flow.accept" method="post" name="wwv_flow" id="wwvFlowForm" novalidate  autocomplete="off">
            <input type="hidden" name="p_flow_id" value="205" id="pFlowId" /><input type="hidden" name="p_flow_step_id" value="3" id="pFlowStepId" /><input type="hidden" name="p_instance" value="4390872671578" id="pInstance" /><input type="hidden" name="p_page_submission_id" value="222520358351197869429173711851318326635" id="pPageSubmissionId" /><input type="hidden" name="p_request" value="" id="pRequest" /><input type="hidden" name="p_reload_on_submit" value="S" id="pReloadOnSubmit" /><input type="hidden" value="222520358351197869429173711851318326635" id="pSalt" />
            <header class="t-Header" id="t_Header">
             
              <div class="t-Header-branding">
                <div class="t-Header-controls">
                  <button class="t-Button t-Button--icon t-Button--header t-Button--headerTree" title="Expand / Collapse Navigation" id="t_Button_navControl" type="button"><span class="t-Icon fa fa-bars" aria-hidden="true"></span></button>
                </div>
                <div class="t-Header-logo">
                  <a href="f?p=205:1:4390872671578:::::" class="t-Header-logo-link"><span >Picture Card Uploader</span></a>
                </div>
                <div class="t-Header-navBar">
                  <ul class="t-NavigationBar lto18647559657698885_0" id="18647559657698885"><li class="t-NavigationBar-item ">
              <a class="t-Button t-Button--icon t-Button--header t-Button--navBar" href="#" role="button">
                <span class="t-Icon "></span><span class="t-Button-label">LFBERDON</span><span class="t-Button-badge"></span>
              </a>
            </li><li class="t-NavigationBar-item ">
              <a class="t-Button t-Button--icon t-Button--header t-Button--navBar" href="apex_authentication.logout?p_app_id=205&p_session_id=4390872671578" role="button">
                <span class="t-Icon fa&#x20;fa-sign-out"></span><span class="t-Button-label">Log Out</span><span class="t-Button-badge"></span>
              </a>
            </li></ul>
                </div>
              </div>
              <div class="t-Header-nav">
               
               
              </div>
            </header>
                <div class="t-Body">
              <div class="t-Body-nav" id="t_Body_nav" role="navigation" aria-label="Picture Card Uploader">
            <div class="t-TreeNav lto18595407903698545_0" id="t_TreeNav" data-id="3_tree" aria-label="Picture Card Uploader"><ul style="display:none"><li data-id="" data-disabled="" data-icon="fa&#x20;fa-file-image-o"><a href="f?p=205:2:4390872671578::NO:3,4,5,6,201,202::" title="">Image Upload</a></li><li data-current="true" data-id="" data-disabled="" data-icon="fa&#x20;fa-info"><a href="f?p=205:3:4390872671578::NO:2,4,5,6,201,202::" title="">Inquiry</a></li><li data-id="" data-disabled="" data-icon="fa&#x20;fa-file-text-o"><a href="f?p=205:4:4390872671578::NO:2,3,5,6,201,202::" title="">Audit Trail Report</a></li><li data-id="" data-disabled="" data-icon="fa&#x20;fa-folder-edit"><a href="f?p=205:5:4390872671578::NO:2,3,4,6,201,202::" title="">Parameters</a></li><li data-id="" data-disabled="" data-icon="fa&#x20;fa-folder-check"><a href="f?p=205:6:4390872671578::NO:2,3,4,5,201,202::" title="">For Approval</a></li></ul></div></div>
              <div class="t-Body-main">
                  <div class="t-Body-title" id="t_Body_title">
                   
                  </div>
                  <div class="t-Body-content" id="t_Body_content">
                    <span id="APEX_SUCCESS_MESSAGE" data-template-id="18600916579698618_S" class="apex-page-success u-hidden"></span><span id="APEX_ERROR_MESSAGE" data-template-id="18600916579698618_E" class="apex-page-error u-hidden"></span>
                    <div class="t-Body-contentInner">
                      <div class="container">
            <div class="row">
            <div class="col col-12 " >
            <div id="R18896172291828524"  class="t-IRR-region lto18896172291828524_0" role="group" aria-labelledby="R18896172291828524_heading">
              <h2 class="u-VisuallyHidden" id="R18896172291828524_heading">Inquiry result</h2>
            <div class="container">
            <div class="row">
            <div class="col col-5 " >
            <div class="t-Form-fieldContainer rel-col lto19025472886583715_0" id="P3_UDFROM_CONTAINER"><div class="t-Form-labelContainer col col-2">
            <label for="P3_UDFROM" id="P3_UDFROM_LABEL" class="t-Form-label">Upload Date Range</label>
            </div>
            <div class="t-Form-inputContainer col col-3"><div class="t-Form-itemWrapper"><input type="text"  class="datepicker&#x20;apex-item-text&#x20;apex-item-datepicker"  id="P3_UDFROM" name="P3_UDFROM" maxlength="" size="30" value="" autocomplete="off"></div><span id="P3_UDFROM_error_placeholder" class="a-Form-error" data-template-id="18636343100698744_ET"></span></div></div><div class="t-Form-fieldContainer rel-col lto19025724718583718_0" id="P3_MDFROM_CONTAINER"><div class="t-Form-labelContainer col col-2">
            <label for="P3_MDFROM" id="P3_MDFROM_LABEL" class="t-Form-label">Modified Date Range</label>
            </div>
            <div class="t-Form-inputContainer col col-3"><div class="t-Form-itemWrapper"><input type="text"  class="datepicker&#x20;apex-item-text&#x20;apex-item-datepicker"  id="P3_MDFROM" name="P3_MDFROM" maxlength="" size="30" value="" autocomplete="off"></div><span id="P3_MDFROM_error_placeholder" class="a-Form-error" data-template-id="18636343100698744_ET"></span></div></div>
            </div><div class="col col-7 " >
            <div class="t-Form-fieldContainer rel-col lto19025508707583716_0" id="P3_UDTO_CONTAINER"><div class="t-Form-labelContainer col col-0">
            <label for="P3_UDTO" id="P3_UDTO_LABEL" class="t-Form-label"></label>
            </div>
            <div class="t-Form-inputContainer col col-7"><div class="t-Form-itemWrapper"><input type="text"  class="datepicker&#x20;apex-item-text&#x20;apex-item-datepicker"  id="P3_UDTO" name="P3_UDTO" maxlength="" size="30" value="" autocomplete="off"></div><span id="P3_UDTO_error_placeholder" class="a-Form-error" data-template-id="18636343100698744_ET"></span></div></div><div class="t-Form-fieldContainer rel-col lto19025896128583719_0" id="P3_MDTO_CONTAINER"><div class="t-Form-labelContainer col col-0">
            <label for="P3_MDTO" id="P3_MDTO_LABEL" class="t-Form-label"></label>
            </div>
            <div class="t-Form-inputContainer col col-7"><div class="t-Form-itemWrapper"><input type="text"  class="datepicker&#x20;apex-item-text&#x20;apex-item-datepicker"  id="P3_MDTO" name="P3_MDTO" maxlength="" size="30" value="" autocomplete="off"></div><span id="P3_MDTO_error_placeholder" class="a-Form-error" data-template-id="18636343100698744_ET"></span></div></div>
            </div>
            </div><div class="row">
            <div class="col col-12 " >
            <div class="t-Form-fieldContainer rel-col lto19077158513711309_0" id="P3_CLASSIFICATION_CONTAINER"><div class="t-Form-labelContainer col col-2">
            <label for="P3_CLASSIFICATION" id="P3_CLASSIFICATION_LABEL" class="t-Form-label">Classification</label>
            </div>
            <div class="t-Form-inputContainer col col-10"><div class="t-Form-itemWrapper"><select  id="P3_CLASSIFICATION" name="P3_CLASSIFICATION" class="selectlist&#x20;apex-item-select&#x20;js-ignoreChange" size="1" ><option value="" selected="selected" ></option>
            <option value="Corporate&#x20;Card">Corporate Card</option>
            <option value="White&#x20;Label&#x20;Card">White Label Card</option>
            <option value="VIP&#x20;Card">VIP Card</option>
            <option value="Others">Others</option>
            </select></div><span id="P3_CLASSIFICATION_error_placeholder" class="a-Form-error" data-template-id="18636343100698744_ET"></span></div></div>
            </div>
            </div><div class="row">
            <div class="col col-12 " >
            <div class="t-Form-fieldContainer rel-col lto19078431768721251_0" id="P3_PRODUCTTYPE_CONTAINER"><div class="t-Form-labelContainer col col-2">
            <label for="P3_PRODUCTTYPE" id="P3_PRODUCTTYPE_LABEL" class="t-Form-label">Product type</label>
            </div>
            <div class="t-Form-inputContainer col col-10"><div class="t-Form-itemWrapper"><select  id="P3_PRODUCTTYPE" name="P3_PRODUCTTYPE" class="selectlist&#x20;apex-item-select&#x20;js-ignoreChange" size="1" ><option value="" selected="selected" ></option>
            <option value="Classic&#x20;Mastercard&#x2F;Visa">Classic Mastercard&#x2F;Visa</option>
            <option value="Gold&#x20;Mastercard&#x2F;Visa">Gold Mastercard&#x2F;Visa</option>
            <option value="MFree&#x20;Mastercard">MFree Mastercard</option>
            <option value="MLite&#x20;Mastercard">MLite Mastercard</option>
            <option value="Femme&#x20;Visa">Femme Visa</option>
            <option value="Femme&#x20;Signature">Femme Signature</option>
            <option value="Platinum&#x20;Mastercard">Platinum Mastercard</option>
            <option value="Dollar&#x20;Master&#x20;card">Dollar Master card</option>
            </select></div><span id="P3_PRODUCTTYPE_error_placeholder" class="a-Form-error" data-template-id="18636343100698744_ET"></span></div></div>
            </div>
            </div><div class="row">
            <div class="col col-12 " >
            <div class="t-Form-fieldContainer rel-col lto19025906308583720_0" id="P3_IRN_CONTAINER"><div class="t-Form-labelContainer col col-2">
            <label for="P3_IRN" id="P3_IRN_LABEL" class="t-Form-label">Image Reference No. (IRN)</label>
            </div>
            <div class="t-Form-inputContainer col col-10"><div class="t-Form-itemWrapper"><input type="text"  id="P3_IRN" name="P3_IRN" class="text_field&#x20;apex-item-text" value="" size="30" maxlength=""  /></div><span id="P3_IRN_error_placeholder" class="a-Form-error" data-template-id="18636343100698744_ET"></span></div></div>
            </div>
            </div><div class="row">
            <div class="col col-12 " >
            <div class="t-Form-fieldContainer rel-col lto19026033154583721_0" id="P3_USERNAME_CONTAINER"><div class="t-Form-labelContainer col col-2">
            <label for="P3_USERNAME" id="P3_USERNAME_LABEL" class="t-Form-label">User Name</label>
            </div>
            <div class="t-Form-inputContainer col col-10"><div class="t-Form-itemWrapper"><input type="text"  id="P3_USERNAME" name="P3_USERNAME" class="text_field&#x20;apex-item-text" value="" size="30" maxlength=""  /></div><span id="P3_USERNAME_error_placeholder" class="a-Form-error" data-template-id="18636343100698744_ET"></span></div></div><button class="t-Button t-Button--icon t-Button--success&#x20;t-Button--iconLeft&#x20;t-Button--gapBottom&#x20;lto19025667272583717_0"  onclick="void(0);" type="button" id="B19025667272583717"><span class="t-Icon t-Icon--left fa&#x20;fa-search" aria-hidden="true"></span><span class="t-Button-label">Search</span><span class="t-Icon t-Icon--right fa&#x20;fa-search" aria-hidden="true"></span></button><input type="hidden" id="P3_HPRODUCTTYPE" name="P3_HPRODUCTTYPE" value=""><input type="hidden" id="P3_HCLASSIFICATION" name="P3_HCLASSIFICATION" value="White Label Card"><input type="hidden" id="P3_FILENAME" name="P3_FILENAME" value="PictureCard_07122019"><input type="hidden" data-for="P3_FILENAME" value="PCqqrzTwQq4tdkU87sbkQPM3GYo">
            </div>
            </div>
            </div><div id="report_18896172291828524_catch"><div class="t-Report t-Report--altRowsDefault t-Report--rowHighlight lto18896172291828524_1" id="report_R18896172291828524" >
              <div class="t-Report-wrap">
                <table class="t-Report-pagination" role="presentation"><tr><td></td></tr></table>
                <div class="t-Report-tableWrap">
                <table class="t-Report-report" summary="Inquiry result">
            <thead><tr><th class="t-Report-colHead"  align="center"  id="CLASSIFICATION" >Classification</th><th class="t-Report-colHead"  align="center"  id="PRODUCTTYPE" >Producttype</th><th class="t-Report-colHead"  align="center"  id="DESCRIPTION" >Description</th><th class="t-Report-colHead"  align="center"  id="IRN" >Image Reference No.</th><th class="t-Report-colHead"  align="center"  id="SD_BLOBBER" >Supporting Document</th><th class="t-Report-colHead"  align="center"  id="COMMENTS" >Comment</th><th class="t-Report-colHead"  align="center"  id="UPLOADDATE" >Upload Date</th><th class="t-Report-colHead"  align="center"  id="MODIFIEDDATE" >Modified Date</th><th class="t-Report-colHead"  align="center"  id="USERNAME" >User Name</th><th class="t-Report-colHead"  align="center"  id="DETAIL_IMAGE" >Image</th><th class="t-Report-colHead"  align="center"  id="DETAIL_IMAGE2" >Detail image2</th></tr></thead>
            <tbody>
            <tr><td class="t-Report-cell"  headers="CLASSIFICATION">White Label Card</td><td class="t-Report-cell"  headers="PRODUCTTYPE">Gold Mastercard&#x2F;Visa</td><td class="t-Report-cell"  headers="DESCRIPTION">The closer I get</td><td class="t-Report-cell"  headers="IRN">2019000000000342</td><td class="t-Report-cell"  headers="SD_BLOBBER"><a href="apex_util.get_blob?s=4390872671578&a=205&c=19024661928583707&p=3&k1=2019000000000342&k2=&ck=D6t-fnbvja1aQ4NQNuJcEUJ1-Ms&rt=CR" alt="Download" title="Download 137KB">Download</a></td><td class="t-Report-cell"  headers="COMMENTS">to you...</td><td class="t-Report-cell"  headers="UPLOADDATE">07-10-2019 22:38:43</td><td class="t-Report-cell"  headers="MODIFIEDDATE">-</td><td class="t-Report-cell"  headers="USERNAME">LFBERDON</td><td class="t-Report-cell"  headers="DETAIL_IMAGE"><img src="apex_util.get_blob?s=4390872671578&a=205&c=19025122038583712&p=3&k1=%32%30%31%39%30%30%30%30%30%30%30%30%30%33%34%32&k2=&ck=UU7cNjXTdzoa7kPgrvgOEVRFSxs&rt=CR"  /></td><td class="t-Report-cell"  headers="DETAIL_IMAGE2"><a href = "apex_util.get_blob_file?a=205&s=4390872671578&p=201&d=&i=18257802232555327&p_pk1=2019000000000342&p_pk2=&p_ck=pjx56LOjXgi_wqpQSSUQagiI1Ko"><img src="apex_util.get_blob_file?a=205&s=4390872671578&p=201&d=&i=18257802232555327&p_pk1=2019000000000342&p_pk2=&p_ck=pjx56LOjXgi_wqpQSSUQagiI1Ko" height="75" width="75" /></a></td></tr>
            <tr><td class="t-Report-cell"  headers="CLASSIFICATION">White Label Card</td><td class="t-Report-cell"  headers="PRODUCTTYPE">Femme Visa</td><td class="t-Report-cell"  headers="DESCRIPTION">Let me be</td><td class="t-Report-cell"  headers="IRN">2019000000000321</td><td class="t-Report-cell"  headers="SD_BLOBBER"><a href="apex_util.get_blob?s=4390872671578&a=205&c=19024661928583707&p=3&k1=2019000000000321&k2=&ck=x7-GoJA10xPZp81AeDkvx8SBvsQ&rt=CR" alt="Download" title="Download 763KB">Download</a></td><td class="t-Report-cell"  headers="COMMENTS">the one</td><td class="t-Report-cell"  headers="UPLOADDATE">07-09-2019 19:25:36</td><td class="t-Report-cell"  headers="MODIFIEDDATE">07-09-2019 21:48:40</td><td class="t-Report-cell"  headers="USERNAME">LFBERDON</td><td class="t-Report-cell"  headers="DETAIL_IMAGE"><img src="apex_util.get_blob?s=4390872671578&a=205&c=19025122038583712&p=3&k1=%32%30%31%39%30%30%30%30%30%30%30%30%30%33%32%31&k2=&ck=a4kSNWLaz9lEp_2hZpt1l3MFKhQ&rt=CR"  /></td><td class="t-Report-cell"  headers="DETAIL_IMAGE2"><a href = "apex_util.get_blob_file?a=205&s=4390872671578&p=201&d=&i=18257802232555327&p_pk1=2019000000000321&p_pk2=&p_ck=hj3PL0dM5pYsZa-HWNsb0ibgsDU"><img src="apex_util.get_blob_file?a=205&s=4390872671578&p=201&d=&i=18257802232555327&p_pk1=2019000000000321&p_pk2=&p_ck=hj3PL0dM5pYsZa-HWNsb0ibgsDU" height="75" width="75" /></a></td></tr>
            <tr><td class="t-Report-cell"  headers="CLASSIFICATION">White Label Card</td><td class="t-Report-cell"  headers="PRODUCTTYPE">Platinum Mastercard</td><td class="t-Report-cell"  headers="DESCRIPTION">Under</td><td class="t-Report-cell"  headers="IRN">2019000000000314</td><td class="t-Report-cell"  headers="SD_BLOBBER"><a href="apex_util.get_blob?s=4390872671578&a=205&c=19024661928583707&p=3&k1=2019000000000314&k2=&ck=ZAI3grOaiCSy4HlhdL5ipyQqfxQ&rt=CR" alt="Download" title="Download 60KB">Download</a></td><td class="t-Report-cell"  headers="COMMENTS">the Bridge</td><td class="t-Report-cell"  headers="UPLOADDATE">07-04-2019 18:50:47</td><td class="t-Report-cell"  headers="MODIFIEDDATE">07-09-2019 21:49:09</td><td class="t-Report-cell"  headers="USERNAME">LFBERDON</td><td class="t-Report-cell"  headers="DETAIL_IMAGE"><img src="apex_util.get_blob?s=4390872671578&a=205&c=19025122038583712&p=3&k1=%32%30%31%39%30%30%30%30%30%30%30%30%30%33%31%34&k2=&ck=TQrIjprAu3NaKCJPjtgY5y9ZdUY&rt=CR"  /></td><td class="t-Report-cell"  headers="DETAIL_IMAGE2"><a href = "apex_util.get_blob_file?a=205&s=4390872671578&p=201&d=&i=18257802232555327&p_pk1=2019000000000314&p_pk2=&p_ck=9M6xDU6M5lh1Np2eF76wRGJnw2w"><img src="apex_util.get_blob_file?a=205&s=4390872671578&p=201&d=&i=18257802232555327&p_pk1=2019000000000314&p_pk2=&p_ck=9M6xDU6M5lh1Np2eF76wRGJnw2w" height="75" width="75" /></a></td></tr>
                  </tbody>
                </table>
                </div>
                <div class="t-Report-links"><a href="javascript:window.location.href=apex.server.url({p_request: 'FLOW_EXCEL_OUTPUT_R18896172291828524_en'},3);">Export</a></div>
                <table class="t-Report-pagination t-Report-pagination--bottom" role="presentation"><tr><td colspan="11" align="right" ><table role="presentation" ><tr><td class="pagination"></td><td class="pagination"></td><td nowrap="nowrap" class="pagination"><span class="t-Report-paginationText">1 - 3</span></td><td class="pagination"></td><td class="pagination"></td></tr></table></td></tr></table>
              </div>
            </div></div>
            </div>
            </div>
            </div>
            </div>
                    </div>
                    <footer class="t-Footer">
                      <div class="t-Footer-body">
                        <div class="t-Footer-content"></div>
                        <div class="t-Footer-apex">
                          <div class="t-Footer-version">release 1.0</div> 
                          <div class="t-Footer-customize"></div>
                          <div class="t-Footer-srMode"><a href="f?p=205:3:4390872671578:SET_SESSION_SCREEN_READER_ON::::">Set Screen Reader Mode On</a></div>
                        </div>
                      </div>
                      <div class="t-Footer-top">
                        <a href="#top" class="t-Footer-topButton" id="t_Footer_topButton"><span class="a-Icon icon-up-chevron"></span></a>
                      </div>
                    </footer>
                  </div>
              </div>
            </div>
            <div class="t-Body-inlineDialogs">
             
            </div><input type="hidden" id="pPageItemsRowVersion" value="" /><input type="hidden" id="pPageItemsProtected" value="JnDD_wFIBFNTFSoFg2VCgg" /></form>
            <div id="apexDevToolbar" class="a-DevToolbar a-DevToolbar--bottom" style="display:none"><h1 class="u-VisuallyHidden">Developer Toolbar</h1><ul class="a-DevToolbar-list">
            <li><button id="apexDevToolbarHome" type="button" class="a-Button a-Button--devToolbar" title="Application Express Home Page" aria-label="Home" data-link="f?p=4500:1000:1107106382853">
            <span class="a-Icon icon-home" aria-hidden="true"></span>
            <span class="a-DevToolbar-buttonLabel">Home</span>
            </button></li>
            <li><button id="apexDevToolbarApp" type="button" class="a-Button a-Button--devToolbar" title="Application 205" aria-label="Application 205" data-link="f?p=4000:1:1107106382853::NO:1,4150,RP:FB_FLOW_ID,FB_FLOW_PAGE_ID,F4000_P1_FLOW,F4000_P4150_GOTO_PAGE,F4000_P1_PAGE:205,3,205,3,3">
            <span class="a-Icon icon-edit-app" aria-hidden="true"></span>
            <span class="a-DevToolbar-buttonLabel">Application 205</span>
            </button></li>
            <li><button id="apexDevToolbarPage" type="button" class="a-Button a-Button--devToolbar" title="Edit Page 3" aria-label="Edit Page 3" data-link="f?p=4000:4500:1107106382853::NO:1,4150:FB_FLOW_ID,FB_FLOW_PAGE_ID,F4000_P1_FLOW,F4000_P4150_GOTO_PAGE,F4000_P1_PAGE:205,3,205,3,3">
            <span class="a-Icon icon-edit-page-alt" aria-hidden="true"></span>
            <span class="a-DevToolbar-buttonLabel">Edit Page 3</span>
            </button></li>
            <li><button id="apexDevToolbarSession" type="button" class="a-Button a-Button--devToolbar" title="Session" aria-label="Session" data-link="f?p=4000:34:1107106382853:PAGE:NO:34:F4000_P34_SESSION,F4000_P34_FLOW,F4000_P34_PAGE,FB_FLOW_ID:4390872671578,205,3,205">
            <span class="a-Icon icon-page-session" aria-hidden="true"></span>
            <span class="a-DevToolbar-buttonLabel">Session</span>
            </button></li>
            <li><button id="apexDevToolbarViewDebug" type="button" class="a-Button a-Button--devToolbar" title="View Debug" aria-label="View Debug" data-link="f?p=4000:19:1107106382853:::RIR,19:IR_APPLICATION_ID,IR_PAGE_ID:205,3">
            <span class="a-Icon icon-page-debug" aria-hidden="true"></span>
            <span class="a-DevToolbar-buttonLabel">View Debug</span>
            </button></li>
            <li><button id="apexDevToolbarDebug" type="button" class="a-Button a-Button--devToolbar" title="Debug" aria-label="Debug" data-link="f?p=205:3:4390872671578::YES">
            <span class="a-Icon icon-debug" aria-hidden="true"></span>
            <span class="a-DevToolbar-buttonLabel">Debug</span>
            </button></li>
            <li><button id="grid_debug_on" type="button" class="a-Button a-Button--devToolbar" title="Show Layout Columns" aria-label="Show Layout Columns">
            <span class="a-Icon icon-grid-layout" aria-hidden="true"></span>
            <span class="a-DevToolbar-buttonLabel">Show Layout Columns</span>
            </button></li>
            <li><button id="grid_debug_off" type="button" class="a-Button a-Button--devToolbar is-active" title="Hide Layout Columns" aria-label="Hide Layout Columns">
            <span class="a-Icon icon-grid-layout" aria-hidden="true"></span>
            <span class="a-DevToolbar-buttonLabel">Hide Layout Columns</span>
            </button></li>
            <li><button id="apexDevToolbarQuickEdit" type="button" class="a-Button a-Button--devToolbar" title="Quick Edit" aria-label="Quick Edit" data-link="f?p=4000:4500:1107106382853::NO:1,4150,4500:FB_FLOW_ID,FB_FLOW_PAGE_ID,F4000_P1_FLOW,F4000_P4150_GOTO_PAGE,F4000_P1_PAGE:205,3,205,3,3">
            <span class="a-Icon icon-quick-edit" aria-hidden="true"></span>
            <span class="a-DevToolbar-buttonLabel">Quick Edit</span>
            </button></li>
            <li><button id="apexDevToolbarThemeRoller" type="button" class="a-Button a-Button--devToolbar" title="Theme Roller" aria-label="Theme Roller">
            <span class="a-Icon icon-theme-roller" aria-hidden="true"></span>
            <span class="a-DevToolbar-buttonLabel">Theme Roller</span>
            </button></li>
            <li><button id="apexDevToolbarOptions" type="button" class="a-Button a-Button--devToolbar js-menuButton" title="Developer Toolbar Options" aria-label="Developer Toolbar Options" data-menu="apexDevToolbarMenu">
            <span class="a-Icon icon-gear" aria-hidden="true"></span>
            </button></li>
            </ul></div>


            <script type="text/javascript">
            var apex_img_dir = "/i/", htmldb_Img_Dir = apex_img_dir;
            </script>
            <!--[if lt IE 9]><script type="text/javascript" src="/i/libraries/jquery/1.12.3/jquery-1.12.3.min.js?v=5.1.2.00.09"></script><![endif]-->
            <!--[if gte IE 9]><!--><script type="text/javascript" src="/i/libraries/jquery/2.2.3/jquery-2.2.3.min.js?v=5.1.2.00.09"></script><!--<![endif]-->
            <script type="text/javascript" src="/i/libraries/apex/minified/desktop.min.js?v=5.1.2.00.09"></script>
            <script type="text/javascript" src="wwv_flow.js_messages?p_app_id=205&p_lang=en&p_version=5.1.2.00.09-111653363499&p_builder=Y"></script>

             

            <script type="text/javascript">
            apex.da.initDaEventList = function(){
            apex.da.gEventList = [
            {"triggeringElementType":"BUTTON","triggeringButtonId":"B19025667272583717","bindType":"bind","bindEventType":"click","anyActionsFireOnInit":false,actionList:[{"eventResult":true,"executeOnPageInit":false,"stopExecutionOnError":false,"waitForResult":true,javascriptFunction:apex.da.executePlSqlCode,"ajaxIdentifier":"Amz_xFnfvWkkNQ7skHZ-ekCzdxWGJyqm9kOG0iwVkrw","attribute01":"#P3_CLASSIFICATION,#P3_PRODUCTTYPE","attribute02":"#P3_HCLASSIFICATION,#P3_HPRODUCTTYPE","attribute04":"N","action":"NATIVE_EXECUTE_PLSQL_CODE"},{"eventResult":true,"executeOnPageInit":false,"stopExecutionOnError":true,javascriptFunction:apex.da.submitPage,"attribute02":"Y","action":"NATIVE_SUBMIT_PAGE"}]},
            {"bindEventType":"ready","anyActionsFireOnInit":false,actionList:[{"eventResult":true,"executeOnPageInit":false,"stopExecutionOnError":true,"waitForResult":true,javascriptFunction:apex.da.executePlSqlCode,"ajaxIdentifier":"ILF3SWvVCMEwGxJ2Sw7zJIxxz6TiQC-PPGmLtSfaGwE","attribute01":"#P3_HCLASSIFICATION,#P3_HPRODUCTTYPE","attribute02":"#P3_CLASSIFICATION,#P3_PRODUCTTYPE","attribute04":"N","action":"NATIVE_EXECUTE_PLSQL_CODE"}]}];
            }
            </script>

            <script type="text/javascript" src="/i/libraries/hammer/2.0.4/hammer-2.0.4.min.js?v=5.1.2.00.09"></script>
            <script type="text/javascript" src="/i/libraries/apex/minified/widget.apexTabs.min.js?v=5.1.2.00.09"></script>
            <script type="text/javascript" src="/i/libraries/apex/minified/widget.stickyWidget.min.js?v=5.1.2.00.09"></script>
            <script type="text/javascript" src="/i/libraries/apex/minified/widget.stickyTableHeader.min.js?v=5.1.2.00.09"></script>
            <script type="text/javascript" src="/i/themes/theme_42/1.1/js/modernizr-custom.min.js?v=5.1.2.00.09"></script>
            <script type="text/javascript" src="/i/themes/theme_42/1.1/js/theme42.min.js?v=5.1.2.00.09"></script>

             

             
            <script type="text/javascript" src="/i/libraries/apex/minified/widget.treeView.min.js?v=5.1.2.00.09"></script>
            <script type="text/javascript" src="/i/libraries/jquery-ui/1.10.4/ui/i18n/oracle/jquery.ui.datepicker-en.js?v=5.1.2.00.09"></script>
            <script type="text/javascript" src="/i/libraries/apex/minified/widget.datepicker.min.js?v=5.1.2.00.09"></script>
            <script type="text/javascript" src="/i/libraries/apex/minified/widget.report.min.js?v=5.1.2.00.09"></script>
            <script type="text/javascript" src="/i/apex_ui/js/minified/devToolbar.min.js?v=5.1.2.00.09"></script>
            <script type="text/javascript">
            apex.jQuery( document ).ready( function() {
            (function(){apex.jQuery('body').addClass('t-PageBody--leftNav');})();
            (function(){apex.widget.datepicker("#P3_UDFROM",{"buttonImageOnly":false,"buttonText":"\u003Cspan class=\u0022a-Icon icon-calendar\u0022\u003E\u003C\u002Fspan\u003E\u003Cspan class=\u0022u-VisuallyHidden\u0022\u003EPopup Calendar: Upload Date Range\u003Cspan\u003E","showTime":false,"defaultDate":new Date(2019,6,12,16,15,16),"showOn":"button","showOtherMonths":false,"changeMonth":false,"changeYear":false},"mm-dd-yy","en"); apex.jQuery('#P3_UDFROM').next('button').addClass('a-Button a-Button--calendar');})();
            (function(){apex.widget.datepicker("#P3_MDFROM",{"buttonImageOnly":false,"buttonText":"\u003Cspan class=\u0022a-Icon icon-calendar\u0022\u003E\u003C\u002Fspan\u003E\u003Cspan class=\u0022u-VisuallyHidden\u0022\u003EPopup Calendar: Modified Date Range\u003Cspan\u003E","showTime":false,"defaultDate":new Date(2019,6,12,16,15,16),"showOn":"button","showOtherMonths":false,"changeMonth":false,"changeYear":false},"mm-dd-yy","en"); apex.jQuery('#P3_MDFROM').next('button').addClass('a-Button a-Button--calendar');})();
            (function(){apex.widget.datepicker("#P3_UDTO",{"buttonImageOnly":false,"buttonText":"\u003Cspan class=\u0022a-Icon icon-calendar\u0022\u003E\u003C\u002Fspan\u003E\u003Cspan class=\u0022u-VisuallyHidden\u0022\u003EPopup Calendar: \u003Cspan\u003E","showTime":false,"defaultDate":new Date(2019,6,12,16,15,16),"showOn":"button","showOtherMonths":false,"changeMonth":false,"changeYear":false},"mm-dd-yy","en"); apex.jQuery('#P3_UDTO').next('button').addClass('a-Button a-Button--calendar');})();
            (function(){apex.widget.datepicker("#P3_MDTO",{"buttonImageOnly":false,"buttonText":"\u003Cspan class=\u0022a-Icon icon-calendar\u0022\u003E\u003C\u002Fspan\u003E\u003Cspan class=\u0022u-VisuallyHidden\u0022\u003EPopup Calendar: \u003Cspan\u003E","showTime":false,"defaultDate":new Date(2019,6,12,16,15,16),"showOn":"button","showOtherMonths":false,"changeMonth":false,"changeYear":false},"mm-dd-yy","en"); apex.jQuery('#P3_MDTO').next('button').addClass('a-Button a-Button--calendar');})();
            (function(){apex.widget.selectList("#P3_CLASSIFICATION",{"nullValue":"","ajaxIdentifier":"GWuj3DROZ-sl1L9RT3rgfKqL3kQ0VY1UyXNIF5lb7K9b3HKDqS4luDyHn6wrW_Pd"});})();
            (function(){apex.widget.selectList("#P3_PRODUCTTYPE",{"nullValue":"","ajaxIdentifier":"GWuj3DROZ-sl1L9RT3rgfBRJORj9lI9hnvNxegMxS7NP1DIXZfKkrA3-m5udMZVa"});})();
            (function(){apex.widget.report.init("R18896172291828524",{"styleChecked":"#dddddd","internalRegionId":"18896172291828524"});})();
            (function(){apex.initDevToolbar([{"pageId":"3","typeId":"5110","id":"18896172291828524","domId":"R18896172291828524"},{"pageId":"3","typeId":"5120","id":"19025472886583715","domId":"P3_UDFROM"},{"pageId":"3","typeId":"5120","id":"19025724718583718","domId":"P3_MDFROM"},{"pageId":"3","typeId":"5120","id":"19025508707583716","domId":"P3_UDTO"},{"pageId":"3","typeId":"5120","id":"19025896128583719","domId":"P3_MDTO"},{"pageId":"3","typeId":"5120","id":"19077158513711309","domId":"P3_CLASSIFICATION"},{"pageId":"3","typeId":"5120","id":"19078431768721251","domId":"P3_PRODUCTTYPE"},{"pageId":"3","typeId":"5120","id":"19025906308583720","domId":"P3_IRN"},{"pageId":"3","typeId":"5120","id":"19026033154583721","domId":"P3_USERNAME"},{"pageId":"3","typeId":"5130","id":"19025667272583717","domId":"B19025667272583717"},{"pageId":"3","typeId":"7320","id":"19024286179583703","domId":"CLASSIFICATION"},{"pageId":"3","typeId":"7320","id":"19024347703583704","domId":"PRODUCTTYPE"},{"pageId":"3","typeId":"7320","id":"19024409217583705","domId":"DESCRIPTION"},{"pageId":"3","typeId":"7320","id":"19024509332583706","domId":"IRN"},{"pageId":"3","typeId":"7320","id":"19024661928583707","domId":"SD_BLOBBER"},{"pageId":"3","typeId":"7320","id":"19024783800583708","domId":"COMMENTS"},{"pageId":"3","typeId":"7320","id":"19024897886583709","domId":"UPLOADDATE"},{"pageId":"3","typeId":"7320","id":"19024953550583710","domId":"MODIFIEDDATE"},{"pageId":"3","typeId":"7320","id":"19025094171583711","domId":"USERNAME"},{"pageId":"3","typeId":"7320","id":"19025122038583712","domId":"DETAIL_IMAGE"},{"pageId":"3","typeId":"7320","id":"19027898720583739","domId":"DETAIL_IMAGE2"}],"FOCUS",{"autoHide":"Auto Hide","iconsOnly":"Show Icons Only","noBuilderMessage":"This functionality requires the Application Express App Builder window to be open. Do you want to open the Builder in this window?","display":"Display Position","displayTop":"Top","displayLeft":"Left","displayBottom":"Bottom","displayRight":"Right"},42);})();
            (function(){apex.da.initDaEventList();})();
            (function(){apex.da.init();})();
            apex.theme42.initializePage.noSideCol();

            apex.page.warnOnUnsavedChanges();
            });</script>

            </body>
            </html>