VIEW: APPS.AST_SALESREP_LOV_V

Source

View Text - Preformatted

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','FIELDSALES') AND rrel.start_date_active <= sysdate AND nvl(rrel.end_date_active ,sysdate) >= sysdate AND rrel.delete_flag != 'Y' )

View Text - HTML Formatted

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'
, 'FIELDSALES')
AND RREL.START_DATE_ACTIVE <= SYSDATE
AND NVL(RREL.END_DATE_ACTIVE
, SYSDATE) >= SYSDATE
AND RREL.DELETE_FLAG != 'Y' )