VIEW: APPS.IEX_LS_ACC_QUICK_NR_V

Source

View Text - Preformatted

SELECT party.party_id party_id, party.party_name party_name, party.address1 || party.address2 || party.address3 || party.address4 address, party.city city, 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, acc.status status, alk.meaning status_mean, party.url url, acc.cust_account_id cust_account_id, party.person_first_name first_name, party.person_last_name last_name, acc.account_number account_number, acc.orig_system_reference orig_system_reference, party.jgzz_fiscal_code jgzz_fiscal_code FROM hz_parties party, fnd_territories_tl ftt, ar_lookups alk, hz_cust_accounts acc, hz_cust_acct_sites ca, hz_cust_site_uses su WHERE (party.party_type = 'ORGANIZATION' OR party.party_type = 'PERSON') AND party.country = ftt.territory_code(+) AND party.party_id = acc.party_id AND ftt.LANGUAGE(+) = userenv('LANG') AND ftt.source_lang(+) = userenv('LANG') AND alk.lookup_type = 'CODE_STATUS' AND alk.lookup_code = acc.status AND acc.cust_account_id = ca.cust_account_id AND ca.cust_acct_site_id = su.cust_acct_site_id GROUP BY party.party_id, party.party_name, party.address1, party.address2, party.address3, party.address4, party.city, party.state, party.postal_code, party.province, party.country, ftt.territory_short_name, party.email_address, acc.status, alk.meaning, party.url, acc.cust_account_id, party.person_first_name, party.person_last_name, acc.account_number, acc.orig_system_reference, party.jgzz_fiscal_code

View Text - HTML Formatted

SELECT PARTY.PARTY_ID PARTY_ID
, PARTY.PARTY_NAME PARTY_NAME
, PARTY.ADDRESS1 || PARTY.ADDRESS2 || PARTY.ADDRESS3 || PARTY.ADDRESS4 ADDRESS
, PARTY.CITY CITY
, 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
, ACC.STATUS STATUS
, ALK.MEANING STATUS_MEAN
, PARTY.URL URL
, ACC.CUST_ACCOUNT_ID CUST_ACCOUNT_ID
, PARTY.PERSON_FIRST_NAME FIRST_NAME
, PARTY.PERSON_LAST_NAME LAST_NAME
, ACC.ACCOUNT_NUMBER ACCOUNT_NUMBER
, ACC.ORIG_SYSTEM_REFERENCE ORIG_SYSTEM_REFERENCE
, PARTY.JGZZ_FISCAL_CODE JGZZ_FISCAL_CODE
FROM HZ_PARTIES PARTY
, FND_TERRITORIES_TL FTT
, AR_LOOKUPS ALK
, HZ_CUST_ACCOUNTS ACC
, HZ_CUST_ACCT_SITES CA
, HZ_CUST_SITE_USES SU
WHERE (PARTY.PARTY_TYPE = 'ORGANIZATION' OR PARTY.PARTY_TYPE = 'PERSON')
AND PARTY.COUNTRY = FTT.TERRITORY_CODE(+)
AND PARTY.PARTY_ID = ACC.PARTY_ID
AND FTT.LANGUAGE(+) = USERENV('LANG')
AND FTT.SOURCE_LANG(+) = USERENV('LANG')
AND ALK.LOOKUP_TYPE = 'CODE_STATUS'
AND ALK.LOOKUP_CODE = ACC.STATUS
AND ACC.CUST_ACCOUNT_ID = CA.CUST_ACCOUNT_ID
AND CA.CUST_ACCT_SITE_ID = SU.CUST_ACCT_SITE_ID GROUP BY PARTY.PARTY_ID
, PARTY.PARTY_NAME
, PARTY.ADDRESS1
, PARTY.ADDRESS2
, PARTY.ADDRESS3
, PARTY.ADDRESS4
, PARTY.CITY
, PARTY.STATE
, PARTY.POSTAL_CODE
, PARTY.PROVINCE
, PARTY.COUNTRY
, FTT.TERRITORY_SHORT_NAME
, PARTY.EMAIL_ADDRESS
, ACC.STATUS
, ALK.MEANING
, PARTY.URL
, ACC.CUST_ACCOUNT_ID
, PARTY.PERSON_FIRST_NAME
, PARTY.PERSON_LAST_NAME
, ACC.ACCOUNT_NUMBER
, ACC.ORIG_SYSTEM_REFERENCE
, PARTY.JGZZ_FISCAL_CODE