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.
how about the query? can you use the query in your code ? If yes please use the query below.
SELECT distinct I.ACCESS_NAME,
FROM JTF.JTF_AMV_ATTACHMENTS A,
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