View: JTF_DSP_TPL_ITEM_CTG_V

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

View Text

SELECT JDTC.TPL_CTG_ID
, JDTC.ITEM_ID
, JAIV.ITEM_NAME
, JAIV.DESCRIPTION ITEM_DESCRIPTION
, JAIV.FILE_NAME
, MSIV.INVENTORY_ITEM_ID
, MSIV.DESCRIPTION INV_ITEM_DESCRIPTION
FROM JTF_DSP_TPL_CTG JDTC
, JTF_DSP_AMV_ITEMS_V JAIV
, MTL_CATEGORIES_VL MCV
, MTL_SYSTEM_ITEMS_VL MSIV
, MTL_ITEM_CATEGORIES MIC
WHERE MCV.CATEGORY_ID = JDTC.CATEGORY_ID
AND MIC.CATEGORY_ID = MCV.CATEGORY_ID
AND MSIV.INVENTORY_ITEM_ID = MIC.INVENTORY_ITEM_ID
AND JAIV.ITEM_ID = JDTC.ITEM_ID WITH READ ONLY

Columns