eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: JTF_DSP_TPL_CTG_V

Product:	JTF - CRM Foundation
Description:
Implementation/DBA Data:	APPS.JTF_DSP_TPL_CTG_V

View Text

SELECT JDTC.TPL_CTG_ID
, JDTC.ITEM_ID
, JAIV.ITEM_NAME
, JAIV.DESCRIPTION ITEM_DESCRIPTION
, JAIV.FILE_NAME
, JDTC.CATEGORY_ID
, MCV.CATEGORY_CONCAT_SEGS CATEGORY_NAME
, MCV.DESCRIPTION CATEGORY_DESCRIPTION
FROM JTF_DSP_TPL_CTG JDTC
, JTF_DSP_AMV_ITEMS_V JAIV
, MTL_CATEGORIES_V MCV
WHERE MCV.CATEGORY_ID = JDTC.CATEGORY_ID
AND JAIV.ITEM_ID = JDTC.ITEM_ID WITH READ ONLY

Columns

Name
TPL_CTG_ID
ITEM_ID
ITEM_NAME
ITEM_DESCRIPTION
FILE_NAME
CATEGORY_ID
CATEGORY_NAME
CATEGORY_DESCRIPTION