View: AST_ORG_DUPLICATE_V

Product:	AST - TeleSales
Description:
Implementation/DBA Data:	APPS.AST_ORG_DUPLICATE_V

View Text

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
, SCORE
, PARTYGT.SEARCH_CONTEXT_ID
FROM HZ_PARTIES PARTY
, HZ_CONTACT_POINTS CPTS
, HZ_MATCHED_PARTIES_GT PARTYGT
, FND_TERRITORIES_TL FTT
WHERE PARTY.PARTY_TYPE = 'ORGANIZATION'
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'

Columns