SELECT PGA.GROUP_CD, PGA.DESCRIPTION, PGA.CREATE_DT, PGA.CLOSED_IND, PGA.COMMENTS, PGA.FILE_NAME, '_DF:IGS:IGS_PE_PERS_GRP_ID:PGA', HZP.PARTY_NUMBER, PGA.GROUP_ID, PGA.CREATOR_PERSON_ID, PGA.CREATION_DATE, PGA.CREATED_BY, PGA.LAST_UPDATED_BY, PGA.LAST_UPDATE_DATE FROM IGS_PE_PERSID_GROUP_ALL PGA, HZ_PARTIES HZP WHERE PGA.CREATOR_PERSON_ID=HZP.PARTY_ID(+) WITH READ ONLY
SELECT PGA.GROUP_CD
, PGA.DESCRIPTION
, PGA.CREATE_DT
, PGA.CLOSED_IND
, PGA.COMMENTS
, PGA.FILE_NAME
, '_DF:IGS:IGS_PE_PERS_GRP_ID:PGA'
, HZP.PARTY_NUMBER
, PGA.GROUP_ID
, PGA.CREATOR_PERSON_ID
, PGA.CREATION_DATE
, PGA.CREATED_BY
, PGA.LAST_UPDATED_BY
, PGA.LAST_UPDATE_DATE
FROM IGS_PE_PERSID_GROUP_ALL PGA
, HZ_PARTIES HZP
WHERE PGA.CREATOR_PERSON_ID=HZP.PARTY_ID(+) WITH READ ONLY
|
|
|