VIEW: APPS.IGS_PE_ID_GROUP_V

Source

View Text - Preformatted

SELECT GM.ROWID ROW_ID, GM.PERSON_ID, GM.GROUP_ID, PG.GROUP_CD, PG.DESCRIPTION, PG.FULL_NAME, PG.CREATE_DT, PG.CLOSED_IND, GM.START_DATE, GM.END_DATE , GM.CREATED_BY, GM.CREATION_DATE, GM.LAST_UPDATED_BY, GM.LAST_UPDATE_DATE, GM.LAST_UPDATE_LOGIN FROM IGS_PE_PRSID_GRP_MEM GM, IGS_PE_PERSID_GROUP_V PG WHERE GM.GROUP_ID = PG.GROUP_ID

View Text - HTML Formatted

SELECT GM.ROWID ROW_ID
, GM.PERSON_ID
, GM.GROUP_ID
, PG.GROUP_CD
, PG.DESCRIPTION
, PG.FULL_NAME
, PG.CREATE_DT
, PG.CLOSED_IND
, GM.START_DATE
, GM.END_DATE
, GM.CREATED_BY
, GM.CREATION_DATE
, GM.LAST_UPDATED_BY
, GM.LAST_UPDATE_DATE
, GM.LAST_UPDATE_LOGIN
FROM IGS_PE_PRSID_GRP_MEM GM
, IGS_PE_PERSID_GROUP_V PG
WHERE GM.GROUP_ID = PG.GROUP_ID