VIEW: APPS.IEX_LS_SIT_QUICK_V

Source

View Text - Preformatted

SELECT site_uses.location location, party_site.party_site_number site_number, SUBSTR(loc.address1,1,25) ||' ' || SUBSTR(loc.address2,1,25) ||' ' || SUBSTR(loc.address3,1,25) ||' ' || SUBSTR(loc.address4,1,25) ||' ' || loc.city || ',' || ' ' || NVL(loc.state, loc.province) ||' ' || t.territory_short_name address, site_uses.primary_flag primary_flag, loc.city city, loc.province province, loc.state state, loc.country country, t.territory_short_name country_name, loc.postal_code postal_code, loc.location_id location_id, site_uses.site_use_id customer_site_use_id, site_uses.cust_acct_site_id address_id, site_uses.bill_to_site_use_id bill_to_site_use_id, site_uses.primary_salesrep_id primary_salesrep_id, site_uses.orig_system_reference orig_system_reference, site_uses.status status, arpt_sql_func_util.get_lookup_meaning ('CODE_STATUS', site_uses.status) status_meaning, site_uses.territory_id territory_id, arpt_sql_func_util.get_lookup_meaning('SITE_USE_CODE', site_uses.site_use_code) business_purpose, arpt_sql_func_util.get_lookup_meaning('YES/NO', site_uses.primary_flag) primary_flag_meaning, ca.cust_account_id cust_account_id, ca.account_number account_number, owner_party.person_first_name person_first_name, owner_party.person_last_name person_last_name, owner_party.party_id party_id, owner_party.party_name party_name, owner_party.url url FROM hz_cust_acct_sites acct_site, hz_party_sites party_site, hz_cust_accounts ca, hz_locations loc, hz_cust_site_uses site_uses, fnd_territories_vl t, hz_parties owner_party WHERE acct_site.cust_account_id = ca.cust_account_id AND acct_site.party_site_id = party_site.party_site_id AND loc.location_id = party_site.location_id AND acct_site.cust_acct_site_id = site_uses.cust_acct_site_id AND loc.country = t.territory_code AND acct_site.bill_to_flag IN ('P','Y') AND site_uses.site_use_code = 'BILL_TO' AND owner_party.party_id = ca.party_id

View Text - HTML Formatted

SELECT SITE_USES.LOCATION LOCATION
, PARTY_SITE.PARTY_SITE_NUMBER SITE_NUMBER
, SUBSTR(LOC.ADDRESS1
, 1
, 25) ||' ' || SUBSTR(LOC.ADDRESS2
, 1
, 25) ||' ' || SUBSTR(LOC.ADDRESS3
, 1
, 25) ||' ' || SUBSTR(LOC.ADDRESS4
, 1
, 25) ||' ' || LOC.CITY || '
, ' || ' ' || NVL(LOC.STATE
, LOC.PROVINCE) ||' ' || T.TERRITORY_SHORT_NAME ADDRESS
, SITE_USES.PRIMARY_FLAG PRIMARY_FLAG
, LOC.CITY CITY
, LOC.PROVINCE PROVINCE
, LOC.STATE STATE
, LOC.COUNTRY COUNTRY
, T.TERRITORY_SHORT_NAME COUNTRY_NAME
, LOC.POSTAL_CODE POSTAL_CODE
, LOC.LOCATION_ID LOCATION_ID
, SITE_USES.SITE_USE_ID CUSTOMER_SITE_USE_ID
, SITE_USES.CUST_ACCT_SITE_ID ADDRESS_ID
, SITE_USES.BILL_TO_SITE_USE_ID BILL_TO_SITE_USE_ID
, SITE_USES.PRIMARY_SALESREP_ID PRIMARY_SALESREP_ID
, SITE_USES.ORIG_SYSTEM_REFERENCE ORIG_SYSTEM_REFERENCE
, SITE_USES.STATUS STATUS
, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING ('CODE_STATUS'
, SITE_USES.STATUS) STATUS_MEANING
, SITE_USES.TERRITORY_ID TERRITORY_ID
, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('SITE_USE_CODE'
, SITE_USES.SITE_USE_CODE) BUSINESS_PURPOSE
, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('YES/NO'
, SITE_USES.PRIMARY_FLAG) PRIMARY_FLAG_MEANING
, CA.CUST_ACCOUNT_ID CUST_ACCOUNT_ID
, CA.ACCOUNT_NUMBER ACCOUNT_NUMBER
, OWNER_PARTY.PERSON_FIRST_NAME PERSON_FIRST_NAME
, OWNER_PARTY.PERSON_LAST_NAME PERSON_LAST_NAME
, OWNER_PARTY.PARTY_ID PARTY_ID
, OWNER_PARTY.PARTY_NAME PARTY_NAME
, OWNER_PARTY.URL URL
FROM HZ_CUST_ACCT_SITES ACCT_SITE
, HZ_PARTY_SITES PARTY_SITE
, HZ_CUST_ACCOUNTS CA
, HZ_LOCATIONS LOC
, HZ_CUST_SITE_USES SITE_USES
, FND_TERRITORIES_VL T
, HZ_PARTIES OWNER_PARTY
WHERE ACCT_SITE.CUST_ACCOUNT_ID = CA.CUST_ACCOUNT_ID
AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID
AND ACCT_SITE.CUST_ACCT_SITE_ID = SITE_USES.CUST_ACCT_SITE_ID
AND LOC.COUNTRY = T.TERRITORY_CODE
AND ACCT_SITE.BILL_TO_FLAG IN ('P'
, 'Y')
AND SITE_USES.SITE_USE_CODE = 'BILL_TO'
AND OWNER_PARTY.PARTY_ID = CA.PARTY_ID