VIEW: APPS.AST_RS_VALID_V

Source

View Text - Preformatted

SELECT RES.RESOURCE_ID, RES.RESOURCE_NUMBER, RES.SOURCE_ID, RES.START_DATE_ACTIVE, RES.END_DATE_ACTIVE, RES.PRIMARY_LANGUAGE, RES.SECONDARY_LANGUAGE, RES.SOURCE_FIRST_NAME, RES.SOURCE_LAST_NAME, RES.SOURCE_MIDDLE_NAME, RES.SOURCE_NAME, RES.START_DATE_ACTIVE, RES.END_DATE_ACTIVE, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL FROM JTF_RS_RESOURCE_EXTNS RES WHERE RES.CATEGORY = 'EMPLOYEE' AND RES.START_DATE_ACTIVE <= SYSDATE AND SYSDATE <= NVL(RES.END_DATE_ACTIVE,SYSDATE) AND EXISTS (SELECT null FROM JTF_RS_ROLE_RELATIONS RREL, JTF_RS_ROLES_B ROLE WHERE RREL.ROLE_ID = ROLE.ROLE_ID AND RREL.DELETE_FLAG != 'Y' AND SYSDATE BETWEEN NVL(RREL.START_DATE_ACTIVE,SYSDATE) AND NVL(RREL.END_DATE_ACTIVE,SYSDATE) AND ROLE.ROLE_TYPE_CODE IN ('SALES','TELESALES','FIELDSALES','PRM','COLLECTIONS','CONTRACTS','SUPPORT') AND ROLE.ACTIVE_FLAG = 'Y' AND RREL.ROLE_RESOURCE_ID = RES.RESOURCE_ID AND RREL.ROLE_RESOURCE_TYPE = 'RS_INDIVIDUAL')

View Text - HTML Formatted

SELECT RES.RESOURCE_ID
, RES.RESOURCE_NUMBER
, RES.SOURCE_ID
, RES.START_DATE_ACTIVE
, RES.END_DATE_ACTIVE
, RES.PRIMARY_LANGUAGE
, RES.SECONDARY_LANGUAGE
, RES.SOURCE_FIRST_NAME
, RES.SOURCE_LAST_NAME
, RES.SOURCE_MIDDLE_NAME
, RES.SOURCE_NAME
, RES.START_DATE_ACTIVE
, RES.END_DATE_ACTIVE
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
FROM JTF_RS_RESOURCE_EXTNS RES
WHERE RES.CATEGORY = 'EMPLOYEE'
AND RES.START_DATE_ACTIVE <= SYSDATE
AND SYSDATE <= NVL(RES.END_DATE_ACTIVE
, SYSDATE)
AND EXISTS (SELECT NULL
FROM JTF_RS_ROLE_RELATIONS RREL
, JTF_RS_ROLES_B ROLE
WHERE RREL.ROLE_ID = ROLE.ROLE_ID
AND RREL.DELETE_FLAG != 'Y'
AND SYSDATE BETWEEN NVL(RREL.START_DATE_ACTIVE
, SYSDATE)
AND NVL(RREL.END_DATE_ACTIVE
, SYSDATE)
AND ROLE.ROLE_TYPE_CODE IN ('SALES'
, 'TELESALES'
, 'FIELDSALES'
, 'PRM'
, 'COLLECTIONS'
, 'CONTRACTS'
, 'SUPPORT')
AND ROLE.ACTIVE_FLAG = 'Y'
AND RREL.ROLE_RESOURCE_ID = RES.RESOURCE_ID
AND RREL.ROLE_RESOURCE_TYPE = 'RS_INDIVIDUAL')