[Home] [Help]
View: JTF_DSP_ATTACHMENTS_V
View Text
SELECT V1.FILE_NAME
, V2.DESCRIPTION
, A.LANGUAGE_CODE
, V2.ITEM_ID
, V2.ACCESS_NAME
, A.MSITE_ID
, A.DEFAULT_SITE
, A.DEFAULT_LANGUAGE
, V1.FILE_ID
FROM JTF_AMV_ATTACHMENTS V1
, JTF_AMV_ITEMS_VL V2
, JTF_DSP_LGL_PHYS_MAP A
WHERE A.ATTACHMENT_ID = V1.ATTACHMENT_ID
AND A.ITEM_ID = V2.ITEM_ID
AND V1.APPLICATION_ID = 671
AND V2.APPLICATION_ID = 671
Columns
| Name |
| FILE_NAME |
| DESCRIPTION |
| LANGUAGE_CODE |
| LOGICAL_ID |
| ACCESS_NAME |
| SITE_ID |
| DEFAULT_MSITE |
| DEFAULT_LANGUAGE |
| FILE_ID |
APPS.JTF_DSP_ATTACHMENTS_V