HHR_VLTR_TEAM_CHLG_VL

Details

• Schema: FUSION

• Object owner: HHR

• Object type: VIEW

Columns

Name
ID PROJECT_ID TEAM_ID OTHER_TEAM_ID CHALLENGE CHALLENGE_STATUS CREATION_DATE

Query

SQL_Statement

SELECT ID, PROJECT_ID, TEAM_CHALLENGES.TEAM_ID, OTHER_TEAM_ID, CHALLENGE, CHALLENGE_STATUS, TEAM_CHALLENGES.CREATION_DATE FROM ( Select TEAM_CHALLENGES.ID, TEAM.TEAM_ID, TEAM_CHALLENGES.CHALLENGE_STATUS, (CASE WHEN TEAM_CHALLENGES.CHALLENGED_TEAM_ID = TEAM.TEAM_ID THEN CHALLENGING_TEAM_ID ELSE CHALLENGED_TEAM_ID END) OTHER_TEAM_ID, TEAM_CHALLENGES.CREATION_DATE ,TEAM_CHALLENGES.PROJECT_ID, PROJECT_START_DATE, (CASE WHEN TEAM_CHALLENGES.CHALLENGED_TEAM_ID = TEAM.TEAM_ID THEN 'INCOMING' ELSE 'OUTGOING' END) CHALLENGE FROM HWR_TEAM TEAM, HHR_VLTR_TEAM_CHALLENGES TEAM_CHALLENGES, HWR_VLTR_PROJECT_VL PROJECT WHERE (TEAM.STATUS = 'ACTIVE' OR (TEAM.STATUS = 'INACTIVE' AND TEAM.LAST_UPDATE_DATE > PROJECT.PROJECT_START_DATE)) AND (TEAM.TEAM_ID = TEAM_CHALLENGES.CHALLENGED_TEAM_ID OR TEAM.TEAM_ID = TEAM_CHALLENGES.CHALLENGING_TEAM_ID) AND TEAM_CHALLENGES.PROJECT_ID = PROJECT.PROJECT_ID) TEAM_CHALLENGES, HWR_TEAM TEAM WHERE TEAM_CHALLENGES.OTHER_TEAM_ID = TEAM.TEAM_ID AND (TEAM.STATUS = 'ACTIVE' OR (TEAM.STATUS = 'INACTIVE' AND TEAM.LAST_UPDATE_DATE > PROJECT_START_DATE))