View: CSI_HZPTY_CONTACTS_V

Product:	CSI - Install Base
Description:	Customer Party Contacts View for the record groups.
Implementation/DBA Data:	APPS.CSI_HZPTY_CONTACTS_V

View Text

SELECT HP.PARTY_NAME PARTY_NAME
, HP.PARTY_NUMBER PARTY_NUMBER
, HP.PARTY_ID PARTY_ID
, HP.PARTY_TYPE PARTY_TYPE
, AL1.MEANING MEANING
, DECODE(PARTY_TYPE
, 'PERSON'
, 'AAAA'
, PARTY_TYPE ) SORT_ORDER
, HPR.OBJECT_ID ORIGINAL_PARTY_ID
, HPR.PARTY_RELATIONSHIP_TYPE RELATIONSHIP_TYPE
, AL2.MEANING RELATIONSHIP_MEANING
, HOC.STATUS ORG_CONTACT_STATUS
, HPR.STATUS RELATIONSHIP_STATUS
, HPR.START_DATE RELATIONSHIP_START_DATE
, HPR.END_DATE RELATIONSHIP_END_DATE
, HP.ADDRESS1 || ' ' || HP.ADDRESS2 || ' ' || HP.ADDRESS3 || ' ' || HP.ADDRESS4 || ' ' || HP.CITY || ' ' || HP.STATE || ' ' || HP.POSTAL_CODE || ' ' || HP.COUNTRY ADDRESS
FROM HZ_PARTIES HP
, HZ_PARTY_RELATIONSHIPS HPR
, HZ_ORG_CONTACTS HOC
, AR_LOOKUPS AL1
, AR_LOOKUPS AL2
WHERE HPR.SUBJECT_ID = HP.PARTY_ID AND HOC.PARTY_RELATIONSHIP_ID = HPR.PARTY_RELATIONSHIP_ID AND HP.PARTY_TYPE = AL1.LOOKUP_CODE (+) AND AL1.LOOKUP_TYPE (+) = 'PARTY_TYPE' AND HPR.PARTY_RELATIONSHIP_TYPE = AL2.LOOKUP_CODE (+) AND AL2.LOOKUP_TYPE (+) = 'PARTY_RELATIONS_TYPE'

Columns