SELECT 'M' , 'D' , A.CONTEXT_ID , -1 , A.ACCESS_NAME , A.ITEM_ID , B.ACCESS_NAME FROM JTF_DSP_CONTEXT_B A , JTF_AMV_ITEMS_VL B WHERE A.ITEM_ID = B.ITEM_ID AND A.CONTEXT_TYPE_CODE = 'MEDIA' AND A.ITEM_ID IS NOT NULL UNION ALL SELECT 'T' , 'P' , A.OBJECT_ID , A.CONTEXT_ID , B.ACCESS_NAME , A.ITEM_ID , C.ACCESS_NAME FROM JTF_DSP_OBJ_LGL_CTNT A , JTF_DSP_CONTEXT_B B , JTF_AMV_ITEMS_VL C WHERE A.ITEM_ID = C.ITEM_ID AND A.CONTEXT_ID = B.CONTEXT_ID AND B.CONTEXT_TYPE_CODE = 'TEMPLATE' AND A.ITEM_ID IS NOT NULL AND A.OBJECT_TYPE = 'I' UNION ALL SELECT 'T' , 'C' , A.OBJECT_ID , A.CONTEXT_ID , B.ACCESS_NAME , A.ITEM_ID , C.ACCESS_NAME FROM JTF_DSP_OBJ_LGL_CTNT A , JTF_DSP_CONTEXT_B B , JTF_AMV_ITEMS_VL C WHERE A.ITEM_ID = C.ITEM_ID AND A.CONTEXT_ID = B.CONTEXT_ID AND B.CONTEXT_TYPE_CODE = 'TEMPLATE' AND A.ITEM_ID IS NOT NULL AND A.OBJECT_TYPE = 'C' UNION ALL SELECT 'T' , 'D' , A.CONTEXT_ID , -1 , A.ACCESS_NAME , A.ITEM_ID , B.ACCESS_NAME FROM JTF_DSP_CONTEXT_B A , JTF_AMV_ITEMS_VL B WHERE A.ITEM_ID = B.ITEM_ID AND A.CONTEXT_TYPE_CODE = 'TEMPLATE' AND A.ITEM_ID IS NOT NULL