VIEW: APPS.IBE_DSP_AMV_ITEMS_V

Source

View Text - Preformatted

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 ,IBE_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(+) AND JDLPM.content_item_key is NULL WITH READ ONLY

View Text - HTML Formatted

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
, IBE_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(+)
AND JDLPM.CONTENT_ITEM_KEY IS NULL WITH READ ONLY