VIEW: APPS.JTF_RS_DEFRESGROUPS_VL

Source

View Text - Preformatted

SELECT MEMBER.GROUP_MEMBER_ID ,MEMBER.GROUP_ID ,MEMBER.RESOURCE_ID ,MEMBER.PERSON_ID ,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 ,GRP.group_name ,grp.group_desc ,grp.exclusive_flag ,grp.start_date_active group_start_date ,grp.end_date_active group_end_date ,member.delete_flag ,MEMBER.object_version_number from jtf_rs_group_members MEMBER , jtf_rs_groups_vl GRP WHERE MEMBER.GROUP_ID = GRP.group_id

View Text - HTML Formatted

SELECT MEMBER.GROUP_MEMBER_ID
, MEMBER.GROUP_ID
, MEMBER.RESOURCE_ID
, MEMBER.PERSON_ID
, 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
, GRP.GROUP_NAME
, GRP.GROUP_DESC
, GRP.EXCLUSIVE_FLAG
, GRP.START_DATE_ACTIVE GROUP_START_DATE
, GRP.END_DATE_ACTIVE GROUP_END_DATE
, MEMBER.DELETE_FLAG
, MEMBER.OBJECT_VERSION_NUMBER
FROM JTF_RS_GROUP_MEMBERS MEMBER
, JTF_RS_GROUPS_VL GRP
WHERE MEMBER.GROUP_ID = GRP.GROUP_ID