VIEW: APPS.AST_RS_GRP_VALID_V

Source

View Text - Preformatted

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))

View Text - HTML Formatted

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))