VIEW: APPS.IBE_DSP_OBJ_LGL_CTNT_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 UNION ALL SELECT DISTINCT 'M','C',b.object_id, c.context_id, c.access_name, b.item_id, e.access_name from mtl_category_sets_b a , ibe_dsp_obj_lgl_ctnt b, ibe_dsp_context_b c,mtl_category_set_valid_cats d , jtf_amv_items_vl e where b.item_id = e.item_id and b.object_type = 'C' and b.context_id = c.context_id and c.context_type_code = 'MEDIA' and b.object_id = d.category_id and a.category_set_id = FND_PROFILE.value_specific('IBE_CATEGORY_SET', null, null, 671) and d.category_set_id = a.category_set_id

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 UNION ALL SELECT DISTINCT 'M'
, 'C'
, B.OBJECT_ID
, C.CONTEXT_ID
, C.ACCESS_NAME
, B.ITEM_ID
, E.ACCESS_NAME
FROM MTL_CATEGORY_SETS_B A
, IBE_DSP_OBJ_LGL_CTNT B
, IBE_DSP_CONTEXT_B C
, MTL_CATEGORY_SET_VALID_CATS D
, JTF_AMV_ITEMS_VL E
WHERE B.ITEM_ID = E.ITEM_ID
AND B.OBJECT_TYPE = 'C'
AND B.CONTEXT_ID = C.CONTEXT_ID
AND C.CONTEXT_TYPE_CODE = 'MEDIA'
AND B.OBJECT_ID = D.CATEGORY_ID
AND A.CATEGORY_SET_ID = FND_PROFILE.VALUE_SPECIFIC('IBE_CATEGORY_SET'
, NULL
, NULL
, 671)
AND D.CATEGORY_SET_ID = A.CATEGORY_SET_ID