Product: | AST - TeleSales |
---|---|
Description: | |
Implementation/DBA Data: | APPS.AST_RS_GRP_VALID_V |
SELECT RS.GROUP_ID
, RS.GROUP_NUMBER
, RS.EXCLUSIVE_FLAG
, RS.START_DATE_ACTIVE
, RS.END_DATE_ACTIVE
, RS.GROUP_NAME
, RS.GROUP_DESC
, ROL.ROLE_RELATE_ID
, ROL.ROLE_RESOURCE_TYPE
, ROL.ROLE_RESOURCE_ID
, ROL.ROLE_ID
, ROL.START_DATE_ACTIVE
, ROL.END_DATE_ACTIVE
, ROL.ROLE_NAME
, ROL.MEMBER_FLAG
, ROL.ADMIN_FLAG
, ROL.LEAD_FLAG
, ROL.MANAGER_FLAG
, ROL.ROLE_TYPE_CODE
, ROL.MEANING
FROM JTF_RS_ROLE_RELATIONS_VL ROL
, JTF_RS_GROUPS_VL RS
WHERE RS.GROUP_ID = ROL.ROLE_RESOURCE_ID
AND ROL.ROLE_RESOURCE_TYPE = 'RS_GROUP'AND ROL.ROLE_TYPE_CODE = 'TELESALES'
AND TRUNC(SYSDATE) BETWEEN NVL(RS.START_DATE_ACTIVE
, TRUNC(SYSDATE))
AND NVL(RS.END_DATE_ACTIVE
, TRUNC(SYSDATE))
AND TRUNC(SYSDATE) BETWEEN NVL(ROL.START_DATE_ACTIVE
, TRUNC(SYSDATE))
AND NVL(ROL.END_DATE_ACTIVE
, TRUNC(SYSDATE))