[Home] [Help]
View: AMV_RS_ALL_RES_EXTNS_VL
View Text
SELECT RSC.RESOURCE_ID RESOURCE_ID
, RSC.CATEGORY CATEGORY
, RSC.RESOURCE_NUMBER RESOURCE_NUMBER
, RSC.RESOURCE_NAME RESOURCE_NAME
, RSC.SOURCE_ID SOURCE_ID
, RSC.SOURCE_NAME FULL_NAME
, RSC.SOURCE_FIRST_NAME FIRST_NAME
, RSC.SOURCE_MIDDLE_NAME MIDDLE_NAME
, RSC.SOURCE_LAST_NAME LAST_NAME
, RSC.SOURCE_EMAIL EMAIL
, RSC.START_DATE_ACTIVE START_DATE_ACTIVE
, RSC.END_DATE_ACTIVE END_DATE_ACTIVE
, RSC.SOURCE_PHONE PHONE
, RSC.USER_ID USER_ID
FROM JTF_RS_RESOURCE_EXTNS_VL RSC
WHERE RSC.CATEGORY IN ('EMPLOYEE'
, 'PARTY'
, 'PARTNER'
, 'SUPPLIER_CONTACT')
AND RSC.START_DATE_ACTIVE < SYSDATE
AND NVL(RSC.END_DATE_ACTIVE
, SYSDATE+1) > SYSDATE
Columns
Name |
RESOURCE_ID |
CATEGORY |
RESOURCE_NUMBER |
RESOURCE_NAME |
SOURCE_ID |
FULL_NAME |
FIRST_NAME |
MIDDLE_NAME |
LAST_NAME |
EMAIL |
START_DATE_ACTIVE |
END_DATE_ACTIVE |
PHONE |
USER_ID |