VIEW: APPS.IBE_DSP_LGL_TEMPLATES_V

Source

View Text - Preformatted

SELECT 'M', 'D', a.context_id , -1, a.access_name, a.item_id, b.access_name from ibe_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 ibe_dsp_obj_lgl_ctnt a, ibe_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 ibe_dsp_obj_lgl_ctnt a, ibe_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 ibe_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

View Text - HTML Formatted

SELECT 'M'
, 'D'
, A.CONTEXT_ID
, -1
, A.ACCESS_NAME
, A.ITEM_ID
, B.ACCESS_NAME
FROM IBE_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 IBE_DSP_OBJ_LGL_CTNT A
, IBE_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 IBE_DSP_OBJ_LGL_CTNT A
, IBE_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 IBE_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