VIEW: APPS.ASF_PERSON_DUPLICATE_V

Source

View Text - Preformatted

SELECT PARTY.PARTY_ID , PARTY.PARTY_NAME , ARP_ADDR_LABEL_PKG.FORMAT_ADDRESS_LABEL ( Null, PARTY.ADDRESS1, PARTY.ADDRESS2, PARTY.ADDRESS3, PARTY.ADDRESS4, PARTY.CITY, PARTY.COUNTY, PARTY.STATE, PARTY.PROVINCE, PARTY.POSTAL_CODE, PARTY.COUNTRY, FTT.TERRITORY_SHORT_NAME, Null, Null, Null, Null, Null, FND_PROFILE.Value('AST_DEFAULT_COUNTRY'), NULL, NULL, 2000, 1, 1 ), NVL(CPTS.PHONE_COUNTRY_CODE, '   ')||'-'|| NVL(CPTS.PHONE_AREA_CODE, '  ')||'-'|| CPTS.PHONE_NUMBER ||''|| CPTS.PHONE_EXTENSION PHONE_NUMBER, PARTY.URL, PARTY.EMAIL_ADDRESS, sites.party_site_id, sites.location_id, SCORE, partygt.search_context_id FROM HZ_PARTIES PARTY , HZ_PARTY_SITES sites, HZ_CONTACT_POINTS cpts, HZ_MATCHED_PARTIES_GT partygt, FND_TERRITORIES_TL FTT WHERE PARTY.PARTY_TYPE = 'PERSON' AND PARTY.COUNTRY = FTT.TERRITORY_CODE(+) AND FTT.LANGUAGE(+) = userenv('LANG') AND FTT.SOURCE_LANG(+) = userenv('LANG') AND PARTY.STATUS IN ('A','I') AND partygt.party_id=party.party_id AND cpts.owner_table_id(+)=party.party_id AND cpts.owner_table_name(+)='HZ_PARTIES' AND cpts.contact_point_type(+)='PHONE' AND cpts.primary_flag(+)='Y' AND sites.party_id(+)=party.party_id AND sites.identifying_address_flag(+)='Y'

View Text - HTML Formatted

SELECT PARTY.PARTY_ID
, PARTY.PARTY_NAME
, ARP_ADDR_LABEL_PKG.FORMAT_ADDRESS_LABEL ( NULL
, PARTY.ADDRESS1
, PARTY.ADDRESS2
, PARTY.ADDRESS3
, PARTY.ADDRESS4
, PARTY.CITY
, PARTY.COUNTY
, PARTY.STATE
, PARTY.PROVINCE
, PARTY.POSTAL_CODE
, PARTY.COUNTRY
, FTT.TERRITORY_SHORT_NAME
, NULL
, NULL
, NULL
, NULL
, NULL
, FND_PROFILE.VALUE('AST_DEFAULT_COUNTRY')
, NULL
, NULL
, 2000
, 1
, 1 )
, NVL(CPTS.PHONE_COUNTRY_CODE
, ' ')||'-'|| NVL(CPTS.PHONE_AREA_CODE
, ' ')||'-'|| CPTS.PHONE_NUMBER ||''|| CPTS.PHONE_EXTENSION PHONE_NUMBER
, PARTY.URL
, PARTY.EMAIL_ADDRESS
, SITES.PARTY_SITE_ID
, SITES.LOCATION_ID
, SCORE
, PARTYGT.SEARCH_CONTEXT_ID
FROM HZ_PARTIES PARTY
, HZ_PARTY_SITES SITES
, HZ_CONTACT_POINTS CPTS
, HZ_MATCHED_PARTIES_GT PARTYGT
, FND_TERRITORIES_TL FTT
WHERE PARTY.PARTY_TYPE = 'PERSON'
AND PARTY.COUNTRY = FTT.TERRITORY_CODE(+)
AND FTT.LANGUAGE(+) = USERENV('LANG')
AND FTT.SOURCE_LANG(+) = USERENV('LANG')
AND PARTY.STATUS IN ('A'
, 'I')
AND PARTYGT.PARTY_ID=PARTY.PARTY_ID
AND CPTS.OWNER_TABLE_ID(+)=PARTY.PARTY_ID
AND CPTS.OWNER_TABLE_NAME(+)='HZ_PARTIES'
AND CPTS.CONTACT_POINT_TYPE(+)='PHONE'
AND CPTS.PRIMARY_FLAG(+)='Y'
AND SITES.PARTY_ID(+)=PARTY.PARTY_ID
AND SITES.IDENTIFYING_ADDRESS_FLAG(+)='Y'