[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | Displays parties of type 'PERSON' and 'ORGANIZATION' and related context information. |
| Implementation/DBA Data: | Not implemented in this database |
SELECT P.ROWID
, P.PARTY_ID
, P.PARTY_NUMBER
, P.PARTY_TYPE
, SUBSTR(IGS_EN_GEN_003.ENRP_GET_ENCMBRD_IND(P.PARTY_ID)
, 1
, 1)
, P.PERSON_LAST_NAME
, P.PERSON_FIRST_NAME
, P.PERSON_TITLE
, P.KNOWN_AS
, PD.DECEASED_IND
, NVL(PP.PERSON_NAME
, P.PARTY_NAME)
, PP.GENDER
, L1.MEANING
, PP.DATE_OF_BIRTH
, PIT.PERSON_ID_TYPE
, PIT.API_PERSON_ID
, PD.FUND_AUTHORIZATION
, P.CREATED_BY
, P.CREATION_DATE
, P.LAST_UPDATED_BY
, P.LAST_UPDATE_DATE
, P.LAST_UPDATE_LOGIN
FROM HZ_PARTIES P
, IGS_PE_HZ_PARTIES PD
, HZ_PERSON_PROFILES PP
, IGS_PE_PERSON_ID_TYPE_V PIT
, FND_LOOKUP_VALUES_VL L1
WHERE P.PARTY_TYPE IN ('PERSON'
, 'ORGANIZATION')
AND P.STATUS NOT IN ('M'
, 'D')
AND P.PARTY_ID = PIT.PE_PERSON_ID (+)
AND P.PARTY_ID = PD.PARTY_ID (+)
AND P.PARTY_ID = PP.PARTY_ID (+)
AND PP.CONTENT_SOURCE_TYPE (+) = 'USER_ENTERED'
AND SYSDATE BETWEEN PP.EFFECTIVE_START_DATE (+)
AND NVL (PP.EFFECTIVE_END_DATE (+)
, SYSDATE)
AND PP.GENDER = L1.LOOKUP_CODE (+)
AND L1.LOOKUP_TYPE (+) = 'HZ_GENDER'
AND L1.VIEW_APPLICATION_ID (+) =222
AND L1.SECURITY_GROUP_ID (+) = 0