[Home] [Help]
View: IEU_UWQ_WEB_CALLBACK_V
Product: | IEU - Universal Work Queue |
Description: | View used for UWQ selector SpreadTable. |
Implementation/DBA Data: |
APPS.IEU_UWQ_WEB_CALLBACK_V
|
View Text
SELECT '' IEU_OBJECT_FUNCTION
, '' IEU_OBJECT_PARAMETERS
, B.MEDIA_TYPE_UUID IEU_MEDIA_TYPE_UUID
, 'QUEUE_NAME' IEU_PARAM_PK_COL
, A.QUEUE_NAME IEU_PARAM_PK_VALUE
, A.RESOURCE_ID RESOURCE_ID
, 'RS_INDIVIDUAL' RESOURCE_TYPE
, C.MEDIA_TYPE_NAME QUEUE_TYPE
, DECODE(A.QUEUE_NAME
, NULL
, L.MEANING
, 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
, FND_LOOKUP_VALUES_VL L
WHERE A.MEDIA_TYPE_ID = B.MEDIA_TYPE_ID
AND NVL(A.NOT_VALID
, 'N') = 'N'
AND B.MEDIA_TYPE_UUID = '7F7FB3A0B6F511D3A05000C04F53FBA6'
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'
Columns
Name |
IEU_OBJECT_FUNCTION |
IEU_OBJECT_PARAMETERS |
IEU_MEDIA_TYPE_UUID |
IEU_PARAM_PK_COL |
IEU_PARAM_PK_VALUE |
RESOURCE_ID |
RESOURCE_TYPE |
QUEUE_TYPE |
QUEUE_NAME |
QUEUE_COUNT |