VIEW: APPS.AST_LM_ORG_QUICK_V

Source

View Text - Preformatted

SELECT PARTY.PARTY_ID , party.party_number , PARTY.PARTY_NAME , null, to_number(null) 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 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 PARTY.STATUS IN ('A','I') and ALK1.LOOKUP_TYPE(+) = 'HZ_PARTY_CERT_LEVEL' and ALK1.LOOKUP_CODE(+) = PARTY.CERTIFICATION_LEVEL

View Text - HTML Formatted

SELECT PARTY.PARTY_ID
, PARTY.PARTY_NUMBER
, PARTY.PARTY_NAME
, NULL
, TO_NUMBER(NULL) 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
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 PARTY.STATUS IN ('A'
, 'I')
AND ALK1.LOOKUP_TYPE(+) = 'HZ_PARTY_CERT_LEVEL'
AND ALK1.LOOKUP_CODE(+) = PARTY.CERTIFICATION_LEVEL