View: AST_LM_ORG_QUICK_W_ACC_V

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

View Text

SELECT PARTY.PARTY_ID
, PARTY.PARTY_NUMBER
, PARTY.PARTY_NAME
, HCA.ACCOUNT_NUMBER
, HCA.CUST_ACCOUNT_ID
, PARTY.ADDRESS1||PARTY.ADDRESS2||PARTY.ADDRESS3||PARTY.ADDRESS4 ADDRESS
, PARTY.CITY
, PARTY.COUNTY
, PARTY.STATE
, PARTY.POSTAL_CODE
, PARTY.PROVINCE
, PARTY.COUNTRY
, FTT.TERRITORY_SHORT_NAME COUNTRY_NAME
, PARTY.EMAIL_ADDRESS
, PARTY.STATUS
, ALK.MEANING STATUS_MEAN
, PARTY.URL
, PARTY.CERTIFICATION_LEVEL
, ALK1.MEANING CERT_LEVEL_MEAN
, 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
, FND_TERRITORIES_TL FTT
, AR_LOOKUPS ALK
, AR_LOOKUPS ALK1
, HZ_CUST_ACCOUNTS HCA
WHERE PARTY.PARTY_TYPE = 'ORGANIZATION'
AND PARTY.COUNTRY = FTT.TERRITORY_CODE(+)
AND FTT.LANGUAGE(+) = USERENV('LANG')
AND FTT.SOURCE_LANG(+) = USERENV('LANG')
AND ALK.LOOKUP_TYPE = 'CODE_STATUS'
AND ALK.LOOKUP_CODE = PARTY.STATUS
AND HCA.STATUS(+)='A'
AND PARTY.PARTY_ID = HCA.PARTY_ID(+)
AND PARTY.STATUS IN ('I'
, 'A')
AND ALK1.LOOKUP_TYPE(+) = 'HZ_PARTY_CERT_LEVEL'
AND ALK1.LOOKUP_CODE(+) = PARTY.CERTIFICATION_LEVEL

Columns