VIEW: APPS.CSI_HZPTY_CONTACTS_V

Source

View Text - Preformatted

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.RELATIONSHIP_TYPE RELATIONSHIP_TYPE, AL2.MEANING RELATIONSHIP_MEANING, NULL 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_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.RELATIONSHIP_ID AND HP.PARTY_TYPE = AL1.LOOKUP_CODE (+) AND AL1.LOOKUP_TYPE (+) = 'PARTY_TYPE' AND HPR.RELATIONSHIP_CODE = AL2.LOOKUP_CODE (+) AND AL2.LOOKUP_TYPE (+) = 'PARTY_RELATIONS_TYPE'

View Text - HTML Formatted

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.RELATIONSHIP_TYPE RELATIONSHIP_TYPE
, AL2.MEANING RELATIONSHIP_MEANING
, NULL 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_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.RELATIONSHIP_ID
AND HP.PARTY_TYPE = AL1.LOOKUP_CODE (+)
AND AL1.LOOKUP_TYPE (+) = 'PARTY_TYPE'
AND HPR.RELATIONSHIP_CODE = AL2.LOOKUP_CODE (+)
AND AL2.LOOKUP_TYPE (+) = 'PARTY_RELATIONS_TYPE'