View: AST_CUSTOMER_UWQ_LOV_V

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

View Text

SELECT /*+ ORDERED USE_NL(P) */ P.PARTY_NAME IEU_LOV_COL1
, P.PARTY_NUMBER IEU_LOV_COL2
, P.PARTY_ID IEU_LOV_COL3
, P.ADDRESS1 || ' ' || P.ADDRESS2 || P.ADDRESS3 || ' ' || P.ADDRESS4 IEU_LOV_COL4
, P.EMAIL_ADDRESS EMAIL_ADDRESS
, P.CITY CITY
, P.STATE STATE
, P.POSTAL_CODE POSTAL_CODE
, P.COUNTY COUNTY
, P.PROVINCE PROVINCE
, FND.TERRITORY_CODE COUNTRY_CODE
, FND.TERRITORY_SHORT_NAME COUNTRY_NAME
, P.ADDRESS1 || ' ' || P.ADDRESS2 || ' ' || P.ADDRESS3 || ' ' || P.ADDRESS4 || ' ' || P.CITY || ' ' || P.STATE || ' ' || P.POSTAL_CODE || ' ' || P.COUNTY || ' ' || FND.TERRITORY_SHORT_NAME LOCATION
, CERTIFICATION_LEVEL
, MEANING CERTIFICATION_MEANING
FROM HZ_PARTIES P
, FND_TERRITORIES_TL FND
, AR_LOOKUPS
WHERE P.PARTY_TYPE IN ('ORGANIZATION'
, 'PERSON')
AND P.STATUS = 'A'
AND P.COUNTRY = FND.TERRITORY_CODE(+)
AND FND.LANGUAGE(+) = USERENV('LANG')
AND LOOKUP_TYPE(+)='HZ_PARTY_CERT_LEVEL'
AND LOOKUP_CODE(+)=CERTIFICATION_LEVEL ORDER BY DECODE(NVL(FND_PROFILE.VALUE('HZ_DISPLAY_CERT_LEVEL')
, 'N')
, 'Y'
, CERTIFICATION_LEVEL
, P.PARTY_NAME)
, DECODE(NVL(FND_PROFILE.VALUE('HZ_DISPLAY_CERT_LEVEL')
, 'N')
, 'Y'
, P.PARTY_NAME
, CERTIFICATION_LEVEL)

Columns