View: IEU_WP_TASK_OWNR_LOV_V

Product:	IEU - Universal Work Queue
Description:	Resource list for task owner and assignees.
Implementation/DBA Data:	APPS.IEU_WP_TASK_OWNR_LOV_V

View Text

SELECT RESOURCE_NAME IEU_LOV_COL1
, RESOURCE_NAME || ' [' || RESOURCE_TYPE || ']' IEU_LOV_COL2
, RESOURCE_ID || '[' || RESOURCE_TYPE || ']' IEU_LOV_COL3
, RESOURCE_NUMBER || '[' || RESOURCE_TYPE || ']' IEU_LOV_COL4
FROM ( SELECT RESOURCE_ID RESOURCE_ID
, RESOURCE_NUMBER RESOURCE_NUMBER
, 'RS_EMPLOYEE' RESOURCE_TYPE
, RESOURCE_NAME RESOURCE_NAME
, SOURCE_EMAIL EMAIL
, START_DATE_ACTIVE START_DATE_ACTIVE
, END_DATE_ACTIVE END_DATE_ACTIVE
, SOURCE_PHONE PHONE
FROM JTF_RS_RESOURCE_EXTNS_VL
WHERE CATEGORY = 'EMPLOYEE'
AND TRUNC(SYSDATE) >= NVL(START_DATE_ACTIVE
, TRUNC( SYSDATE))
AND TRUNC(SYSDATE) <= NVL(END_DATE_ACTIVE
, TRUNC(SYSDATE)) UNION ALL SELECT GRP.GROUP_ID RESOURCE_ID
, GRP.GROUP_NUMBER RESOURCE_NUMBER
, 'RS_GROUP' RESOURCE_TYPE
, GRP.GROUP_NAME RESOURCE_NAME
, GRP.EMAIL_ADDRESS EMAIL
, GRP.START_DATE_ACTIVE START_DATE_ACTIVE
, GRP.END_DATE_ACTIVE END_DATE_ACTIVE
, NULL PHONE
FROM JTF_RS_GROUPS_VL GRP
WHERE TRUNC(SYSDATE) >= NVL(START_DATE_ACTIVE
, TRUNC( SYSDATE))
AND TRUNC(SYSDATE) <= NVL(END_DATE_ACTIVE
, TRUNC(SYSDATE)) ) ORDER BY RESOURCE_NAME
, RESOURCE_TYPE

Columns