Product: | AST - TeleSales |
---|---|
Description: | |
Implementation/DBA Data: | APPS.AST_RS_VALID_V |
SELECT RES.RESOURCE_ID
, RES.RESOURCE_NUMBER
, RES.SOURCE_ID
, RES.START_DATE_ACTIVE
, RES.END_DATE_ACTIVE
, RES.PRIMARY_LANGUAGE
, RES.SECONDARY_LANGUAGE
, RES.SOURCE_FIRST_NAME
, RES.SOURCE_LAST_NAME
, RES.SOURCE_MIDDLE_NAME
, RES.SOURCE_NAME
, RES.START_DATE_ACTIVE
, RES.END_DATE_ACTIVE
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
FROM JTF_RS_RESOURCE_EXTNS RES
WHERE RES.CATEGORY = 'EMPLOYEE'
AND RES.START_DATE_ACTIVE <= SYSDATE
AND SYSDATE <= NVL(RES.END_DATE_ACTIVE
, SYSDATE)
AND EXISTS (SELECT NULL FROM JTF_RS_ROLE_RELATIONS RREL
, JTF_RS_ROLES_B ROLE WHERE RREL.ROLE_ID = ROLE.ROLE_ID AND RREL.DELETE_FLAG != 'Y' AND SYSDATE BETWEEN NVL(RREL.START_DATE_ACTIVE
, SYSDATE)
AND NVL(RREL.END_DATE_ACTIVE
, SYSDATE) AND ROLE.ROLE_TYPE_CODE IN ('SALES'
, 'TELESALES'
, 'FIELDSALES'
, 'PRM'
, 'COLLECTIONS'
, 'CONTRACTS'
, 'SUPPORT') AND ROLE.ACTIVE_FLAG = 'Y' AND RREL.ROLE_RESOURCE_ID = RES.RESOURCE_ID AND RREL.ROLE_RESOURCE_TYPE = 'RS_INDIVIDUAL')