VIEW: APPS.CCT_BASIC_WEBCALLBACK_V

Source

View Text - Preformatted

SELECT '' IEU_OBJECT_FUNCTION, '' IEU_OBJECT_PARAMETERS, 'AGENT_QUEUE_ID' IEU_PARAM_PK_COL, decode(a.classification, null, null, a.agent_queue_id) IEU_PARAM_PK_VALUE, b.media_type_uuid IEU_MEDIA_TYPE_UUID, a.agent_id RESOURCE_ID, 'RS_INDIVIDUAL' RESOURCE_TYPE, decode(a.classification, null, l.meaning,a.classification) CLASSIFICATION, c.MEDIA_TYPE_NAME MEDIA_TYPE, a.count QUEUE_COUNT FROM CCT_qde_AGENT_QUEUES a, IEU_UWQ_MEDIA_TYPES_B b, IEU_UWQ_MEDIA_TYPES_TL c, fnd_lookup_values_vl l WHERE a.item_type = b.Media_Type_Id and b.Media_Type_UUID='78ADCG20B6F511D3A05000C04FAAAAAA' and c.Media_Type_Id = b.Media_Type_Id and c.language = USERENV('LANG') and l.lookup_type = 'IEU_NODE_LABELS' and l.view_application_id = 696 and l.lookup_code = 'IEU_ANY_LBL'

View Text - HTML Formatted

SELECT '' IEU_OBJECT_FUNCTION
, '' IEU_OBJECT_PARAMETERS
, 'AGENT_QUEUE_ID' IEU_PARAM_PK_COL
, DECODE(A.CLASSIFICATION
, NULL
, NULL
, A.AGENT_QUEUE_ID) IEU_PARAM_PK_VALUE
, B.MEDIA_TYPE_UUID IEU_MEDIA_TYPE_UUID
, A.AGENT_ID RESOURCE_ID
, 'RS_INDIVIDUAL' RESOURCE_TYPE
, DECODE(A.CLASSIFICATION
, NULL
, L.MEANING
, A.CLASSIFICATION) CLASSIFICATION
, C.MEDIA_TYPE_NAME MEDIA_TYPE
, A.COUNT QUEUE_COUNT
FROM CCT_QDE_AGENT_QUEUES A
, IEU_UWQ_MEDIA_TYPES_B B
, IEU_UWQ_MEDIA_TYPES_TL C
, FND_LOOKUP_VALUES_VL L
WHERE A.ITEM_TYPE = B.MEDIA_TYPE_ID
AND B.MEDIA_TYPE_UUID='78ADCG20B6F511D3A05000C04FAAAAAA'
AND C.MEDIA_TYPE_ID = B.MEDIA_TYPE_ID
AND C.LANGUAGE = USERENV('LANG')
AND L.LOOKUP_TYPE = 'IEU_NODE_LABELS'
AND L.VIEW_APPLICATION_ID = 696
AND L.LOOKUP_CODE = 'IEU_ANY_LBL'