View: JTF_DSP_FEATURED_MEDIA_V

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

View Text

SELECT 'P'
, D.OBJECT_ID
, E.ACCESS_NAME
, F.ACCESS_NAME
, C.MINI_SITE_ID
FROM JTF_DSP_SECTION_ITEMS A
, JTF_DSP_SECTIONS_B B
, JTF_DSP_MSITE_SCT_ITEMS C
, JTF_DSP_OBJ_LGL_CTNT D
, JTF_DSP_CONTEXT_B E
, JTF_AMV_ITEMS_VL F
WHERE D.ITEM_ID = F.ITEM_ID
AND D.ITEM_ID IS NOT NULL
AND D.OBJECT_TYPE = 'I'
AND E.CONTEXT_TYPE_CODE = 'MEDIA'
AND D.CONTEXT_ID = E.CONTEXT_ID
AND D.OBJECT_ID = A.INVENTORY_ITEM_ID
AND A.SECTION_ITEM_ID = C.SECTION_ITEM_ID
AND A.SECTION_ID = B.SECTION_ID
AND B.SECTION_TYPE_CODE = 'F' UNION ALL SELECT DISTINCT 'C'
, D.OBJECT_ID
, E.ACCESS_NAME
, H.ACCESS_NAME
, C.MINI_SITE_ID
FROM JTF_DSP_SECTION_ITEMS A
, JTF_DSP_SECTIONS_B B
, JTF_DSP_MSITE_SCT_ITEMS C
, JTF_DSP_OBJ_LGL_CTNT D
, JTF_DSP_CONTEXT_B E
, MTL_ITEM_CATEGORIES F
, JTF_AMV_ITEMS_VL H
WHERE D.ITEM_ID IS NOT NULL
AND D.ITEM_ID = H.ITEM_ID
AND D.OBJECT_TYPE = 'C'
AND D.CONTEXT_ID = E.CONTEXT_ID
AND E.CONTEXT_TYPE_CODE = 'MEDIA'
AND D.OBJECT_ID = F.CATEGORY_ID
AND F.CATEGORY_SET_ID = FND_PROFILE.VALUE('IBE_CATEGORY_SET')
AND F.INVENTORY_ITEM_ID = A.INVENTORY_ITEM_ID
AND A.SECTION_ITEM_ID = C.SECTION_ITEM_ID
AND A.SECTION_ID = B.SECTION_ID
AND B.SECTION_TYPE_CODE = 'F' UNION ALL SELECT DISTINCT 'S'
, A.OBJECT_ID
, B.ACCESS_NAME
, C.ACCESS_NAME
, E.MINI_SITE_ID
FROM JTF_DSP_OBJ_LGL_CTNT A
, JTF_DSP_CONTEXT_B B
, JTF_AMV_ITEMS_VL C
, JTF_DSP_SECTION_ITEMS D
, JTF_DSP_MSITE_SCT_ITEMS E
WHERE A.ITEM_ID = C.ITEM_ID
AND A.CONTEXT_ID = B.CONTEXT_ID
AND B.CONTEXT_TYPE_CODE = 'MEDIA'
AND A.ITEM_ID IS NOT NULL
AND A.OBJECT_TYPE = 'S'AND A.OBJECT_ID = D.SECTION_ID
AND E.SECTION_ITEM_ID = D.SECTION_ITEM_ID

Columns