VIEW: APPS.IEU_WP_TASK_OWNR_LOV_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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