VIEW: APPS.IGS_PE_PERSID_GROUP_V

Source

View Text - Preformatted

SELECT PG.ROWID ROW_ID, PG.GROUP_ID, PG.GROUP_CD, DECODE(PG.FILE_NAME,NULL,'STATIC','DYNAMIC') GROUP_TYPE, PG.CREATOR_PERSON_ID, PG.DESCRIPTION, PG.CLOSED_IND, PG.COMMENTS, PE.FULL_NAME, PE.PERSON_NUMBER CREATOR_PERSON_NUMBER, PG.FILE_NAME, PG.CREATE_DT, PG.CREATED_BY, PG.CREATION_DATE, PG.LAST_UPDATED_BY, PG.LAST_UPDATE_DATE, PG.LAST_UPDATE_LOGIN, PG.ATTRIBUTE_CATEGORY, PG.ATTRIBUTE1, PG.ATTRIBUTE2, PG.ATTRIBUTE3, PG.ATTRIBUTE4, PG.ATTRIBUTE5, PG.ATTRIBUTE6, PG.ATTRIBUTE7, PG.ATTRIBUTE8, PG.ATTRIBUTE9, PG.ATTRIBUTE10, PG.ATTRIBUTE11, PG.ATTRIBUTE12, PG.ATTRIBUTE13, PG.ATTRIBUTE14, PG.ATTRIBUTE15, PG.ATTRIBUTE16, PG.ATTRIBUTE17, PG.ATTRIBUTE18, PG.ATTRIBUTE19, PG.ATTRIBUTE20 FROM IGS_PE_PERSID_GROUP_ALL PG, IGS_PE_PERSON_BASE_V PE WHERE PE.PERSON_ID = PG.CREATOR_PERSON_ID

View Text - HTML Formatted

SELECT PG.ROWID ROW_ID
, PG.GROUP_ID
, PG.GROUP_CD
, DECODE(PG.FILE_NAME
, NULL
, 'STATIC'
, 'DYNAMIC') GROUP_TYPE
, PG.CREATOR_PERSON_ID
, PG.DESCRIPTION
, PG.CLOSED_IND
, PG.COMMENTS
, PE.FULL_NAME
, PE.PERSON_NUMBER CREATOR_PERSON_NUMBER
, PG.FILE_NAME
, PG.CREATE_DT
, PG.CREATED_BY
, PG.CREATION_DATE
, PG.LAST_UPDATED_BY
, PG.LAST_UPDATE_DATE
, PG.LAST_UPDATE_LOGIN
, PG.ATTRIBUTE_CATEGORY
, PG.ATTRIBUTE1
, PG.ATTRIBUTE2
, PG.ATTRIBUTE3
, PG.ATTRIBUTE4
, PG.ATTRIBUTE5
, PG.ATTRIBUTE6
, PG.ATTRIBUTE7
, PG.ATTRIBUTE8
, PG.ATTRIBUTE9
, PG.ATTRIBUTE10
, PG.ATTRIBUTE11
, PG.ATTRIBUTE12
, PG.ATTRIBUTE13
, PG.ATTRIBUTE14
, PG.ATTRIBUTE15
, PG.ATTRIBUTE16
, PG.ATTRIBUTE17
, PG.ATTRIBUTE18
, PG.ATTRIBUTE19
, PG.ATTRIBUTE20
FROM IGS_PE_PERSID_GROUP_ALL PG
, IGS_PE_PERSON_BASE_V PE
WHERE PE.PERSON_ID = PG.CREATOR_PERSON_ID