Product: | AST - TeleSales |
---|---|
Description: | |
Implementation/DBA Data: | APPS.AST_LM_PER_QUICK_V |
SELECT PARTY.PARTY_ID
, NULL
, TO_NUMBER(NULL) CUST_ACCOUNT_ID
, PARTY.PERSON_FIRST_NAME
, PARTY.PERSON_MIDDLE_NAME
, PARTY.PERSON_LAST_NAME
, PARTY.ADDRESS1||PARTY.ADDRESS2||PARTY.ADDRESS3||PARTY.ADDRESS4
, PARTY.CITY
, PARTY.STATE
, PARTY.POSTAL_CODE
, PARTY.PROVINCE
, PARTY.COUNTRY
, FTT.TERRITORY_SHORT_NAME
, PARTY.EMAIL_ADDRESS
, PARTY.STATUS
, ALK.MEANING
, PRIMARY_PHONE_COUNTRY_CODE
, PRIMARY_PHONE_AREA_CODE
, PRIMARY_PHONE_NUMBER
, PRIMARY_PHONE_EXTENSION
, NVL(PRIMARY_PHONE_COUNTRY_CODE
, ' ')||'-'|| NVL(PRIMARY_PHONE_AREA_CODE
, ' ')||'-'|| PRIMARY_PHONE_NUMBER ||''|| PRIMARY_PHONE_EXTENSION
, PRIMARY_PHONE_AREA_CODE||PRIMARY_PHONE_NUMBER
FROM HZ_PARTIES PARTY
, AR_LOOKUPS ALK
, FND_TERRITORIES_TL FTT
WHERE PARTY_TYPE = 'PERSON'
AND ALK.LOOKUP_TYPE = 'CODE_STATUS'
AND ALK.LOOKUP_CODE = PARTY.STATUS
AND FTT.LANGUAGE(+) = USERENV('LANG')
AND FTT.SOURCE_LANG(+) = USERENV('LANG')
AND PARTY.COUNTRY = FTT.TERRITORY_CODE(+)
AND PARTY.STATUS IN ('A'
, 'I')