Mapping the iStore JSP files to the Templates

Oracle iStore Administrator can find out the name of the JSP file that is mapped to a template. I have always wondered when Oracle iStore was being developed why they never thought of a UI wherein we can give the JSP file name and it shows up the template name.

Here is a query that can be very useful for Oracle iStore developers.

SELECT I.ACCESS_NAME,A.FILE_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 i.access_name like ‘STORE_CART%ADD%%’

or you can give the name of the file to get back the Programmatic Access name (or the Template name)

SELECT I.ACCESS_NAME,A.FILE_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 ‘%ViewA%’