View: IBE_DSP_OBJ_LGL_CTNT_V

Product:	IBE - iStore
Description:
Implementation/DBA Data:	APPS.IBE_DSP_OBJ_LGL_CTNT_V

View Text

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

Columns