VIEW: APPS.ASO_SALESREP_ROLES_V

Source

View Text - Preformatted

SELECT ROLE.Role_Id, ROLE.Role_Name, ROLE.Role_Desc, ROLE.Role_Code, SREP.Salesrep_Id FROM JTF_RS_ROLES_VL ROLE, JTF_RS_ROLE_RELATIONS RLTN, JTF_RS_SALESREPS_MO_V SREP WHERE ROLE.Role_Id = RLTN.Role_Id AND RLTN.Role_Resource_Id = SREP.Resource_Id AND trunc(nvl(RLTN.Start_Date_Active, sysdate)) <= trunc(sysdate) AND trunc(nvl(RLTN.End_Date_Active, sysdate)) >= trunc(sysdate) AND trunc(nvl(SREP.Start_Date_Active, sysdate)) <= trunc(sysdate) AND trunc(nvl(SREP.End_Date_Active, sysdate)) >= trunc(sysdate) AND SREP.Status = 'A'

View Text - HTML Formatted

SELECT ROLE.ROLE_ID
, ROLE.ROLE_NAME
, ROLE.ROLE_DESC
, ROLE.ROLE_CODE
, SREP.SALESREP_ID
FROM JTF_RS_ROLES_VL ROLE
, JTF_RS_ROLE_RELATIONS RLTN
, JTF_RS_SALESREPS_MO_V SREP
WHERE ROLE.ROLE_ID = RLTN.ROLE_ID
AND RLTN.ROLE_RESOURCE_ID = SREP.RESOURCE_ID
AND TRUNC(NVL(RLTN.START_DATE_ACTIVE
, SYSDATE)) <= TRUNC(SYSDATE)
AND TRUNC(NVL(RLTN.END_DATE_ACTIVE
, SYSDATE)) >= TRUNC(SYSDATE)
AND TRUNC(NVL(SREP.START_DATE_ACTIVE
, SYSDATE)) <= TRUNC(SYSDATE)
AND TRUNC(NVL(SREP.END_DATE_ACTIVE
, SYSDATE)) >= TRUNC(SYSDATE)
AND SREP.STATUS = 'A'