View: IEU_UWQM_WORKLIST_V

View Text

SELECT DECODE( UWQM.SOURCE_OBJECT_TYPE_CODE
, 'TASK'
, DECODE( NVL(JTFO.ENTER_FROM_TASK
, 'N')
, 'N'
, JTFO.OBJECT_FUNCTION
, 'Y'
, JTFO1.OBJECT_FUNCTION )
, JTFO.OBJECT_FUNCTION) IEU_OBJECT_FUNCTION
, DECODE( UWQM.WORKITEM_OBJ_CODE
, 'TASK'
, DECODE( NVL(JTFO.ENTER_FROM_TASK
, 'N')
, 'N'
, JTFO.OBJECT_PARAMETERS
, 'Y'
, JTFO1.OBJECT_PARAMETERS )
, JTFO.OBJECT_PARAMETERS) IEU_OBJECT_PARAMETERS
, '' IEU_MEDIA_TYPE_UUID
, '' IEU_PARAM_PK_COL
, UWQM.SOURCE_OBJECT_ID IEU_PARAM_PK_VALUE
, ENUM.ENUM_TYPE_UUID IEU_ENUM_TYPE_UUID
, UWQM.WORK_ITEM_ID
, UWQM.WORK_ITEM_NUMBER
, UWQM.WORKITEM_OBJ_CODE
, UWQM.WORKITEM_PK_ID
, UWQM.STATUS_ID
, UWQM.PRIORITY_ID
, UWQM.PRIORITY_LEVEL
, PR.NAME PRIORITY
, UWQM.DUE_DATE
, UWQM.TITLE
, UWQM.PARTY_ID
, UWQM.OWNER_TYPE
, UWQM.OWNER_ID
, UWQM.ASSIGNEE_TYPE
, UWQM.ASSIGNEE_ID
, UWQM.OWNER_TYPE_ACTUAL
, UWQM.ASSIGNEE_TYPE_ACTUAL
, UWQM.APPLICATION_ID
, LKUPS.MEANING WORK_TYPE
, DECODE (STATUS_ID
, 0
, ''
, 1
, LKUPS1.MEANING
, 2
, LKUPS1.MEANING) STATUS_CODE
, DECODE( UWQM.SOURCE_OBJECT_TYPE_CODE
, 'TASK'
, DECODE( NVL(JTFO.ENTER_FROM_TASK
, 'N')
, 'N'
, JTFO.OBJECT_CODE
, 'Y'
, JTFO1.OBJECT_CODE )
, JTFO.OBJECT_CODE) IEU_ACTION_OBJECT_CODE
FROM IEU_UWQM_ITEMS UWQM
, JTF_OBJECTS_B JTFO
, JTF_OBJECTS_B JTFO1
, IEU_UWQ_SEL_ENUMERATORS ENUM
, IEU_UWQM_PRIORITIES_TL PR
, FND_LOOKUP_VALUES_VL LKUPS
, FND_LOOKUP_VALUES_VL LKUPS1
WHERE JTFO.OBJECT_CODE = UWQM.SOURCE_OBJECT_TYPE_CODE
AND JTFO1.OBJECT_CODE = 'TASK'
AND ENUM.ENUM_TYPE_UUID = UWQM.IEU_ENUM_TYPE_UUID AND PR.PRIORITY_ID = UWQM.PRIORITY_ID
AND LKUPS.LOOKUP_TYPE(+) = ENUM.WORK_Q_LABEL_LU_TYPE
AND LKUPS.VIEW_APPLICATION_ID(+) = ENUM.APPLICATION_ID
AND LKUPS.LOOKUP_CODE(+) = WORK_Q_LABEL_LU_CODE
AND LKUPS1.LOOKUP_TYPE = 'IEU_NODE_LABELS'
AND LKUPS1.VIEW_APPLICATION_ID = ENUM.APPLICATION_ID
AND LKUPS1.LOOKUP_CODE = 'IN_USE'

Columns