[Home] [Help]
View: JTF_DSP_OBJ_LGL_CTNT_V
View Text
SELECT JDOLC.OBJ_LGL_CTNT_ID
, JDOLC.CONTEXT_ID
, JDCV.NAME
, JDCV.CONTEXT_TYPE_CODE
, JDOLC.OBJECT_ID
, JDOLC.OBJECT_TYPE
, JAIV.ITEM_ID
, JAIV.ITEM_NAME
, JDOLC.OBJECT_VERSION_NUMBER
FROM JTF_DSP_CONTEXT_VL JDCV
, JTF_DSP_OBJ_LGL_CTNT JDOLC
, JTF_AMV_ITEMS_VL JAIV
WHERE JDOLC.CONTEXT_ID = JDCV.CONTEXT_ID
AND JAIV.ITEM_ID(+) = JDOLC.ITEM_ID WITH READ ONLY
Columns
Name |
OBJ_LGL_CTNT_ID |
CONTEXT_ID |
NAME |
CONTEXT_TYPE_CODE |
OBJECT_ID |
OBJECT_TYPE |
ITEM_ID |
ITEM_NAME |
OBJECT_VERSION_NUMBER |