Product: | JTF - CRM Foundation |
---|---|
Description: | This view is used by Define Resource FormTeams block |
Implementation/DBA Data: | APPS.JTF_RS_DEFRESTEAMS_VL |
SELECT MEMBER.ROWID ROW_ID
, MEMBER.TEAM_MEMBER_ID
, MEMBER.TEAM_ID
, MEMBER.TEAM_RESOURCE_ID
, MEMBER.PERSON_ID
, MEMBER.RESOURCE_TYPE
, MEMBER.CREATED_BY
, MEMBER.CREATION_DATE
, MEMBER.LAST_UPDATED_BY
, MEMBER.LAST_UPDATE_DATE
, MEMBER.LAST_UPDATE_LOGIN
, MEMBER.ATTRIBUTE1
, MEMBER.ATTRIBUTE2
, MEMBER.ATTRIBUTE3
, MEMBER.ATTRIBUTE4
, MEMBER.ATTRIBUTE5
, MEMBER.ATTRIBUTE6
, MEMBER.ATTRIBUTE7
, MEMBER.ATTRIBUTE8
, MEMBER.ATTRIBUTE9
, MEMBER.ATTRIBUTE10
, MEMBER.ATTRIBUTE11
, MEMBER.ATTRIBUTE12
, MEMBER.ATTRIBUTE13
, MEMBER.ATTRIBUTE14
, MEMBER.ATTRIBUTE15
, MEMBER.ATTRIBUTE_CATEGORY
, TEM.TEAM_NAME
, TEM.TEAM_DESC
, TEM.EXCLUSIVE_FLAG
, TEM.START_DATE_ACTIVE TEAM_START_DATE
, TEM.END_DATE_ACTIVE TEAM_END_DATE
, MEMBER.DELETE_FLAG
, MEMBER.OBJECT_VERSION_NUMBER
FROM JTF_RS_TEAM_MEMBERS MEMBER
, JTF_RS_TEAMS_VL TEM
WHERE MEMBER.TEAM_ID = TEM.TEAM_ID
AND MEMBER.RESOURCE_TYPE = 'INDIVIDUAL'