VIEW: APPS.IEX_LM_ORG_QUICK_V

Source

View Text - Preformatted

SELECT PARTY.PARTY_ID PARTY_ID, party.party_number party_number, PARTY.PARTY_NAME PARTY_NAME, to_char(null) ACCOUNT_NUMBER, to_number(null) CUST_ACCOUNT_ID, PARTY.ADDRESS1||PARTY.ADDRESS2||PARTY.ADDRESS3||PARTY.ADDRESS4 ADDRESS , PARTY.CITY CITY, PARTY.COUNTY COUNTY, PARTY.STATE STATE, PARTY.POSTAL_CODE POSTAL_CODE, PARTY.PROVINCE PROVINCE, PARTY.COUNTRY COUNTRY, FTT.TERRITORY_SHORT_NAME country_name , PARTY.EMAIL_ADDRESS EMAIL_ADDRESS, PARTY.STATUS STATUS, ALK.MEANING status_mean, PARTY.URL URL FROM HZ_PARTIES PARTY , FND_TERRITORIES_TL FTT , AR_LOOKUPS ALK, hz_party_usg_assignments USAGE 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.PARTY_ID = USAGE.PARTY_ID AND upper(USAGE.party_usage_code) IN ('CUSTOMER','ORG_CONTACT')

View Text - HTML Formatted

SELECT PARTY.PARTY_ID PARTY_ID
, PARTY.PARTY_NUMBER PARTY_NUMBER
, PARTY.PARTY_NAME PARTY_NAME
, TO_CHAR(NULL) ACCOUNT_NUMBER
, TO_NUMBER(NULL) CUST_ACCOUNT_ID
, PARTY.ADDRESS1||PARTY.ADDRESS2||PARTY.ADDRESS3||PARTY.ADDRESS4 ADDRESS
, PARTY.CITY CITY
, PARTY.COUNTY COUNTY
, PARTY.STATE STATE
, PARTY.POSTAL_CODE POSTAL_CODE
, PARTY.PROVINCE PROVINCE
, PARTY.COUNTRY COUNTRY
, FTT.TERRITORY_SHORT_NAME COUNTRY_NAME
, PARTY.EMAIL_ADDRESS EMAIL_ADDRESS
, PARTY.STATUS STATUS
, ALK.MEANING STATUS_MEAN
, PARTY.URL URL
FROM HZ_PARTIES PARTY
, FND_TERRITORIES_TL FTT
, AR_LOOKUPS ALK
, HZ_PARTY_USG_ASSIGNMENTS USAGE
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.PARTY_ID = USAGE.PARTY_ID
AND UPPER(USAGE.PARTY_USAGE_CODE) IN ('CUSTOMER'
, 'ORG_CONTACT')