[Home] [Help]
View: JTF_DSP_LGL_PHYS_MAP_V
View Text
SELECT JDLPM.LGL_PHYS_MAP_ID
, JDLPM.ATTACHMENT_ID
, JDLPM.ITEM_ID
, JDLPM.MSITE_ID
, JMV.MSITE_NAME
, JDLPM.DEFAULT_SITE
, JDLPM.LANGUAGE_CODE
, FLV.DESCRIPTION LANGUAGE_DESCRIPTION
, JDLPM.DEFAULT_LANGUAGE
FROM JTF_DSP_LGL_PHYS_MAP JDLPM
, JTF_MSITES_VL JMV
, FND_LANGUAGES_VL FLV
WHERE JMV.MSITE_ID = JDLPM.MSITE_ID
AND JMV.START_DATE_ACTIVE <= SYSDATE
AND NVL(JMV.END_DATE_ACTIVE
, SYSDATE) >= SYSDATE
AND FLV.LANGUAGE_CODE = JDLPM.LANGUAGE_CODE WITH READ ONLY
Columns
Name |
LGL_PHYS_MAP_ID |
ATTACHMENT_ID |
ITEM_ID |
MSITE_ID |
MSITE_NAME |
DEFAULT_SITE |
LANGUAGE_CODE |
LANGUAGE_DESCRIPTION |
DEFAULT_LANGUAGE |