Product: | IGC - Contract Commitment |
---|---|
Description: | |
Implementation/DBA Data: | APPS.IGC_CC_GROUP_USERS_V |
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