1 Reply Latest reply: Jul 3, 2013 2:02 PM by 906826 RSS

    How to get iStore template name from jsp filename?

    944726

      Hi,

       

      We have implemented Oracle iStore R12.

       

      We have a requirement where we want to get template access name based on jsp file name. e.g. If jsp is ibeCCkdBHdrShip.jsp it should return STORE_CHKOUT_B2B_SHIP_HEADER.

       

      Is there any java API available for the same?

       

      We know we can get jsp filename from template access name as follows:

      --

      String jspFilename = DisplayManager.getTemplate("STORE_CHKOUT_B2B_SHIP_HEADER").getFileName()

      --

       

       

      However our requirement is other way round..getting access name based on jsp filename.

       

      Any prompt help/suggestion in this regard is appreciated.

       

      Thanks,

      Vivek

        • 1. Re: How to get iStore template name from jsp filename?
          906826

          Hi Vivek,

                                  how about the query? can you use the query in your code ? If yes please use the query below.

           

          SELECT distinct I.ACCESS_NAME,

          A.FILE_NAME,i.description,I.Item_Name

            FROM JTF.JTF_AMV_ATTACHMENTS A,

            APPS.JTF_AMV_ITEMS_VL I,

            IBE.IBE_DSP_LGL_PHYS_MAP M,

            IBE.IBE_MSITES_TL S

            WHERE

            A.ATTACHMENT_ID = M.ATTACHMENT_ID

            AND I.ITEM_ID = M.ITEM_ID

            AND M.MSITE_ID = S.MSITE_ID

            AND A.File_Name like 'ibeCCtdStBlSuStI.jsp'

            Order by A.File_Name

           

          Thanks

           

          Shahzad Qamer