VIEW: APPS.IEX_LM_ORG_QUICK_W_ACC_V

Source

View Text - Preformatted

SELECT PARTY.PARTY_ID PARTY_ID, party.party_number party_number, PARTY.PARTY_NAME PARTY_NAME, hca.account_number account_number, hca.cust_account_id 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_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 party.party_id = hca.party_id

View Text - HTML Formatted

SELECT PARTY.PARTY_ID PARTY_ID
, PARTY.PARTY_NUMBER PARTY_NUMBER
, PARTY.PARTY_NAME PARTY_NAME
, HCA.ACCOUNT_NUMBER ACCOUNT_NUMBER
, HCA.CUST_ACCOUNT_ID 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_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 PARTY.PARTY_ID = HCA.PARTY_ID