View: AST_SALESREP_LOV_V

Product:	AST - TeleSales
Description:
Implementation/DBA Data:	APPS.AST_SALESREP_LOV_V

View Text

SELECT TO_CHAR(RES.RESOURCE_ID) || ' - ' || TO_CHAR(GROUPS.GROUP_ID) || ' - ' || TO_CHAR(RES.SOURCE_ID) OWNER_ID
, RES.SOURCE_NAME
, GROUPS.GROUP_NAME
, NULL
, GROUPS.GROUP_NAME
, GROUPS.GROUP_ID
, RES.SOURCE_NAME
, RES.SOURCE_LAST_NAME
, RES.SOURCE_FIRST_NAME
, RES.SOURCE_ID
, RES.RESOURCE_ID
, RES.SOURCE_PHONE
, RES.SOURCE_EMAIL
FROM JTF_RS_RESOURCE_EXTNS RES
, JTF_RS_GROUPS_VL GROUPS
, JTF_RS_GROUP_MEMBERS MEM
WHERE MEM.GROUP_ID = GROUPS.GROUP_ID
AND RES.RESOURCE_ID = MEM.RESOURCE_ID
AND RES.CATEGORY = 'EMPLOYEE'
AND RES.START_DATE_ACTIVE <= TRUNC(SYSDATE)
AND TRUNC(SYSDATE) <= NVL(RES.END_DATE_ACTIVE
, SYSDATE)
AND NVL(GROUPS.START_DATE_ACTIVE
, SYSDATE) <= TRUNC(SYSDATE)
AND TRUNC(SYSDATE) <= NVL(GROUPS.END_DATE_ACTIVE
, SYSDATE)
AND MEM.DELETE_FLAG != 'Y'
AND EXISTS (SELECT NULL
FROM JTF_RS_ROLE_RELATIONS RREL
, JTF_RS_ROLES_B ROLE
WHERE MEM.GROUP_MEMBER_ID = RREL.ROLE_RESOURCE_ID
AND RREL.ROLE_RESOURCE_TYPE = 'RS_GROUP_MEMBER'
AND RREL.ROLE_ID = ROLE.ROLE_ID
AND ROLE.MEMBER_FLAG = 'Y'
AND ROLE.ROLE_TYPE_CODE IN ('SALES'
, 'TELESALES'
, 'PRM'
, 'FIELDSALES')
AND RREL.START_DATE_ACTIVE <= SYSDATE
AND NVL(RREL.END_DATE_ACTIVE
, SYSDATE) >= SYSDATE
AND RREL.DELETE_FLAG != 'Y' )

Columns