View: JTF_DSP_LGL_PHYS_MAP_V

Product:	JTF - CRM Foundation
Description:
Implementation/DBA Data:	APPS.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