VIEW: APPS.IGS_PE_PERSID_GROUP

Source

View Text - Preformatted

SELECT tab.rowid row_id, tab.org_id org_id, tab.created_by created_by, tab.creation_date creation_date, tab.last_updated_by last_updated_by, tab.last_update_date last_update_date, tab.last_update_login last_update_login, tab.group_id group_id, tab.group_cd group_cd, tab.creator_person_id creator_person_id, tab.description description, tab.create_dt create_dt, tab.closed_ind closed_ind, tab.comments comments, pe.full_name, pe.person_number creator_person_number, tab.request_id request_id, tab.program_application_id program_application_id, tab.program_id program_id, tab.program_update_date program_update_date, tab.attribute_category, tab.attribute1, tab.attribute2, tab.attribute3, tab.attribute4, tab.attribute5, tab.attribute6, tab.attribute7, tab.attribute8, tab.attribute9, tab.attribute10, tab.attribute11, tab.attribute12, tab.attribute13, tab.attribute14, tab.attribute15, tab.attribute16, tab.attribute17, tab.attribute18, tab.attribute19, tab.attribute20 FROM igs_pe_persid_group_all tab, igs_pe_person_base_v pe WHERE NVL (tab.org_id , NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',NULL,SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',NULL,SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99) AND pe.PERSON_ID = tab.CREATOR_PERSON_ID AND tab.file_name is NULL

View Text - HTML Formatted

SELECT TAB.ROWID ROW_ID
, TAB.ORG_ID ORG_ID
, TAB.CREATED_BY CREATED_BY
, TAB.CREATION_DATE CREATION_DATE
, TAB.LAST_UPDATED_BY LAST_UPDATED_BY
, TAB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, TAB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, TAB.GROUP_ID GROUP_ID
, TAB.GROUP_CD GROUP_CD
, TAB.CREATOR_PERSON_ID CREATOR_PERSON_ID
, TAB.DESCRIPTION DESCRIPTION
, TAB.CREATE_DT CREATE_DT
, TAB.CLOSED_IND CLOSED_IND
, TAB.COMMENTS COMMENTS
, PE.FULL_NAME
, PE.PERSON_NUMBER CREATOR_PERSON_NUMBER
, TAB.REQUEST_ID REQUEST_ID
, TAB.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, TAB.PROGRAM_ID PROGRAM_ID
, TAB.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, TAB.ATTRIBUTE_CATEGORY
, TAB.ATTRIBUTE1
, TAB.ATTRIBUTE2
, TAB.ATTRIBUTE3
, TAB.ATTRIBUTE4
, TAB.ATTRIBUTE5
, TAB.ATTRIBUTE6
, TAB.ATTRIBUTE7
, TAB.ATTRIBUTE8
, TAB.ATTRIBUTE9
, TAB.ATTRIBUTE10
, TAB.ATTRIBUTE11
, TAB.ATTRIBUTE12
, TAB.ATTRIBUTE13
, TAB.ATTRIBUTE14
, TAB.ATTRIBUTE15
, TAB.ATTRIBUTE16
, TAB.ATTRIBUTE17
, TAB.ATTRIBUTE18
, TAB.ATTRIBUTE19
, TAB.ATTRIBUTE20
FROM IGS_PE_PERSID_GROUP_ALL TAB
, IGS_PE_PERSON_BASE_V PE
WHERE NVL (TAB.ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)
AND PE.PERSON_ID = TAB.CREATOR_PERSON_ID
AND TAB.FILE_NAME IS NULL