VIEW: APPS.IEU_UWQ_BLENDED_V

Source

View Text - Preformatted

SELECT '' IEU_OBJECT_FUNCTION, '' IEU_OBJECT_PARAMETERS, b.media_type_uuid IEU_MEDIA_TYPE_UUID, '' IEU_PARAM_PK_COL, to_char(0) IEU_PARAM_PK_VALUE, 1 ieu_display_order, a.resource_id RESOURCE_ID, 'RS_INDIVIDUAL' RESOURCE_TYPE, c.media_type_name QUEUE_TYPE, a.queue_name QUEUE_NAME, a.queue_count QUEUE_COUNT FROM IEU_UWQ_SEL_MRT_DATA a, IEU_UWQ_MEDIA_TYPES_B b, IEU_UWQ_MEDIA_TYPES_TL c WHERE a.Media_Type_Id = b.Media_Type_Id and nvl(a.not_valid,'N') <> 'Y' and b.Media_Type_UUID = '28DE0ECA16D411d4AED100C04F601AB2' and c.Media_Type_Id = b.Media_Type_Id and c.language = USERENV('LANG')

View Text - HTML Formatted

SELECT '' IEU_OBJECT_FUNCTION
, '' IEU_OBJECT_PARAMETERS
, B.MEDIA_TYPE_UUID IEU_MEDIA_TYPE_UUID
, '' IEU_PARAM_PK_COL
, TO_CHAR(0) IEU_PARAM_PK_VALUE
, 1 IEU_DISPLAY_ORDER
, A.RESOURCE_ID RESOURCE_ID
, 'RS_INDIVIDUAL' RESOURCE_TYPE
, C.MEDIA_TYPE_NAME QUEUE_TYPE
, A.QUEUE_NAME QUEUE_NAME
, A.QUEUE_COUNT QUEUE_COUNT
FROM IEU_UWQ_SEL_MRT_DATA A
, IEU_UWQ_MEDIA_TYPES_B B
, IEU_UWQ_MEDIA_TYPES_TL C
WHERE A.MEDIA_TYPE_ID = B.MEDIA_TYPE_ID
AND NVL(A.NOT_VALID
, 'N') <> 'Y'
AND B.MEDIA_TYPE_UUID = '28DE0ECA16D411D4AED100C04F601AB2'
AND C.MEDIA_TYPE_ID = B.MEDIA_TYPE_ID
AND C.LANGUAGE = USERENV('LANG')