VIEW: APPS.IGS_FI_PARTIES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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