VIEW: APPS.IEU_UWQ_MEDIA_V

Source

View Text - Preformatted

SELECT '' IEU_OBJECT_FUNCTION, '' IEU_OBJECT_PARAMETERS, b.media_type_uuid IEU_MEDIA_TYPE_UUID, 'QUEUE_NAME' IEU_PARAM_PK_COL, a.node_id IEU_PARAM_PK_VALUE, a.node_weight IEU_DISPLAY_ORDER, a.resource_id RESOURCE_ID, 'RS_INDIVIDUAL' RESOURCE_TYPE, c.media_type_name QUEUE_TYPE, a.node_label QUEUE_NAME, a.count QUEUE_COUNT FROM IEU_UWQ_SEL_RT_NODES 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') = 'N') and (a.node_pid = 4000) 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
, 'QUEUE_NAME' IEU_PARAM_PK_COL
, A.NODE_ID IEU_PARAM_PK_VALUE
, A.NODE_WEIGHT IEU_DISPLAY_ORDER
, A.RESOURCE_ID RESOURCE_ID
, 'RS_INDIVIDUAL' RESOURCE_TYPE
, C.MEDIA_TYPE_NAME QUEUE_TYPE
, A.NODE_LABEL QUEUE_NAME
, A.COUNT QUEUE_COUNT
FROM IEU_UWQ_SEL_RT_NODES 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') = 'N')
AND (A.NODE_PID = 4000)
AND (C.MEDIA_TYPE_ID = B.MEDIA_TYPE_ID)
AND (C.LANGUAGE = USERENV('LANG'))