VIEW: APPS.AST_RESOURCE_TEAM_V

Source

View Text - Preformatted

SELECT B.ROWID ROW_ID, B.TEAM_ID, B.TEAM_NUMBER, B.EMAIL_ADDRESS, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.EXCLUSIVE_FLAG, B.START_DATE_ACTIVE, B.END_DATE_ACTIVE, B.OBJECT_VERSION_NUMBER, B.ATTRIBUTE1, B.ATTRIBUTE2, B.ATTRIBUTE3, B.ATTRIBUTE4, B.ATTRIBUTE5, B.ATTRIBUTE6, B.ATTRIBUTE7, B.ATTRIBUTE8, B.ATTRIBUTE9, B.ATTRIBUTE10, B.ATTRIBUTE11, B.ATTRIBUTE12, B.ATTRIBUTE13, B.ATTRIBUTE14, B.ATTRIBUTE15, B.ATTRIBUTE_CATEGORY, T.TEAM_NAME, T.TEAM_DESC from JTF_RS_TEAMS_TL T, JTF_RS_TEAMS_B B WHERE B.TEAM_ID = T.TEAM_ID AND T.LANGUAGE = userenv('LANG') AND SYSDATE BETWEEN B.START_DATE_ACTIVE AND NVL(B.END_DATE_ACTIVE,SYSDATE) AND EXISTS (select null from AST_RES_TEAM_MEMBERS_V MM where MM.team_id = T.team_id)

View Text - HTML Formatted

SELECT B.ROWID ROW_ID
, B.TEAM_ID
, B.TEAM_NUMBER
, B.EMAIL_ADDRESS
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
, B.EXCLUSIVE_FLAG
, B.START_DATE_ACTIVE
, B.END_DATE_ACTIVE
, B.OBJECT_VERSION_NUMBER
, B.ATTRIBUTE1
, B.ATTRIBUTE2
, B.ATTRIBUTE3
, B.ATTRIBUTE4
, B.ATTRIBUTE5
, B.ATTRIBUTE6
, B.ATTRIBUTE7
, B.ATTRIBUTE8
, B.ATTRIBUTE9
, B.ATTRIBUTE10
, B.ATTRIBUTE11
, B.ATTRIBUTE12
, B.ATTRIBUTE13
, B.ATTRIBUTE14
, B.ATTRIBUTE15
, B.ATTRIBUTE_CATEGORY
, T.TEAM_NAME
, T.TEAM_DESC
FROM JTF_RS_TEAMS_TL T
, JTF_RS_TEAMS_B B
WHERE B.TEAM_ID = T.TEAM_ID
AND T.LANGUAGE = USERENV('LANG')
AND SYSDATE BETWEEN B.START_DATE_ACTIVE
AND NVL(B.END_DATE_ACTIVE
, SYSDATE)
AND EXISTS (SELECT NULL
FROM AST_RES_TEAM_MEMBERS_V MM
WHERE MM.TEAM_ID = T.TEAM_ID)