View: JTF_DSP_AMV_ITEMS_V

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

View Text

SELECT JAIV.ITEM_ID
, JAIV.ACCESS_NAME
, JAIV.ITEM_NAME
, JAIV.APPLICATION_ID
, JAIV.DELIVERABLE_TYPE_CODE
, JAIV.APPLICABLE_TO_CODE
, JAIV.DESCRIPTION
, JAIKV.KEYWORD
, JAAV.FILE_NAME
, JAIV.OBJECT_VERSION_NUMBER
, JAAV.FILE_ID
FROM JTF_AMV_ITEMS_VL JAIV
, JTF_AMV_ITEM_KEYWORDS_V JAIKV
, JTF_AMV_ATTACHMENTS JAAV
, JTF_DSP_LGL_PHYS_MAP JDLPM
WHERE JAIKV.ITEM_ID(+) = JAIV.ITEM_ID
AND JDLPM.ITEM_ID(+) = JAIV.ITEM_ID
AND JDLPM.DEFAULT_SITE(+) = 'Y'
AND JDLPM.DEFAULT_LANGUAGE(+) = 'Y'
AND JDLPM.ATTACHMENT_ID = JAAV.ATTACHMENT_ID(+) WITH READ ONLY

Columns