VIEW: APPS.AST_CUSTOMER_UWQ_LOV_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)