VIEW: APPS.JTF_RS_DEFRESTEAMS_VL

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'