View: JTF_DSP_LGL_TEMPLATES_V

Product:	JTF - CRM Foundation
Description:
Implementation/DBA Data:	APPS.JTF_DSP_LGL_TEMPLATES_V

View Text

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

Columns