[Home] [Help]
View: 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
Name |
ITEM_ID |
ACCESS_NAME |
ITEM_NAME |
APPLICATION_ID |
DELIVERABLE_TYPE_CODE |
APPLICABLE_TO_CODE |
DESCRIPTION |
KEYWORD |
FILE_NAME |
OBJECT_VERSION_NUMBER |
FILE_ID |