VIEW: APPS.IGC_CC_GROUP_USERS_V

Source

View Text - Preformatted

SELECT icgu.rowid row_id, icg.cc_group_id, icgu.user_id, u.user_name, u.start_date, u.end_date, u.description, icgu.last_update_date, icgu.last_update_login, icgu.last_updated_by, icgu.creation_date, icgu.created_by, icgu.context, icgu.attribute1, icgu.attribute2, icgu.attribute3, icgu.attribute4, icgu.attribute5, icgu.attribute6, icgu.attribute7, icgu.attribute8, icgu.attribute9, icgu.attribute10, icgu.attribute11, icgu.attribute12, icgu.attribute13, icgu.attribute14, icgu.attribute15 From igc_cc_group_users icgu, igc_cc_groups icg, fnd_user u Where icg.cc_group_id = icgu.cc_group_id and icgu.user_id = u.user_id

View Text - HTML Formatted

SELECT ICGU.ROWID ROW_ID
, ICG.CC_GROUP_ID
, ICGU.USER_ID
, U.USER_NAME
, U.START_DATE
, U.END_DATE
, U.DESCRIPTION
, ICGU.LAST_UPDATE_DATE
, ICGU.LAST_UPDATE_LOGIN
, ICGU.LAST_UPDATED_BY
, ICGU.CREATION_DATE
, ICGU.CREATED_BY
, ICGU.CONTEXT
, ICGU.ATTRIBUTE1
, ICGU.ATTRIBUTE2
, ICGU.ATTRIBUTE3
, ICGU.ATTRIBUTE4
, ICGU.ATTRIBUTE5
, ICGU.ATTRIBUTE6
, ICGU.ATTRIBUTE7
, ICGU.ATTRIBUTE8
, ICGU.ATTRIBUTE9
, ICGU.ATTRIBUTE10
, ICGU.ATTRIBUTE11
, ICGU.ATTRIBUTE12
, ICGU.ATTRIBUTE13
, ICGU.ATTRIBUTE14
, ICGU.ATTRIBUTE15
FROM IGC_CC_GROUP_USERS ICGU
, IGC_CC_GROUPS ICG
, FND_USER U
WHERE ICG.CC_GROUP_ID = ICGU.CC_GROUP_ID
AND ICGU.USER_ID = U.USER_ID