VIEW: APPS.IEX_CUST_SITE_USES_V

Source

View Text - Preformatted

SELECT SITE_USES.LOCATION LOCATION ,PARTY_SITE.PARTY_SITE_NUMBER PARTY_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 ,SITE_USES.SITE_USE_ID CUSTOMER_SITE_USE_ID ,SITE_USES.CUST_ACCT_SITE_ID ADDRESS_ID ,SITE_USES.PRIMARY_SALESREP_ID PRIMARY_SALESREP_ID ,LOC.LOCATION_ID LOCATION_ID ,ACCT_SITE.CUST_ACCOUNT_ID CUST_ACCOUNT_ID ,LOC.ADDRESS1 ADDRESS1 ,LOC.ADDRESS2 ADDRESS2 ,LOC.CITY CITY ,LOC.STATE STATE ,LOC.PROVINCE PROVINCE ,LOC.COUNTY COUNTY ,LOC.POSTAL_CODE POSTAL_CODE ,T.TERRITORY_SHORT_NAME COUNTRY_NAME ,LOC.COUNTRY COUNTRY ,SITE_USES.TERRITORY_ID TERRITORY_ID ,LP.MEANING BUSINESS_PURPOSE ,LP2.MEANING PRIMARY_FLAG_DSP ,PARTY_SITE.PARTY_SITE_ID PARTY_SITE_ID ,SITE_USES.STATUS SITE_STATUS ,ACCT_SITE.STATUS ACCT_STATUS FROM HZ_CUST_ACCT_SITES ACCT_SITE ,HZ_PARTY_SITES PARTY_SITE ,HZ_LOCATIONS LOC ,HZ_CUST_SITE_USES SITE_USES ,FND_TERRITORIES_VL T ,AR_LOOKUPS LP ,AR_LOOKUPS LP2 WHERE 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 SITE_USES.SITE_USE_CODE = LP.LOOKUP_CODE AND LP.LOOKUP_TYPE = 'SITE_USE_CODE' AND SITE_USES.SITE_USE_CODE = 'BILL_TO' AND SITE_USES.PRIMARY_FLAG = LP2.LOOKUP_CODE AND LP2.LOOKUP_TYPE = 'YES/NO'

View Text - HTML Formatted

SELECT SITE_USES.LOCATION LOCATION
, PARTY_SITE.PARTY_SITE_NUMBER PARTY_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
, SITE_USES.SITE_USE_ID CUSTOMER_SITE_USE_ID
, SITE_USES.CUST_ACCT_SITE_ID ADDRESS_ID
, SITE_USES.PRIMARY_SALESREP_ID PRIMARY_SALESREP_ID
, LOC.LOCATION_ID LOCATION_ID
, ACCT_SITE.CUST_ACCOUNT_ID CUST_ACCOUNT_ID
, LOC.ADDRESS1 ADDRESS1
, LOC.ADDRESS2 ADDRESS2
, LOC.CITY CITY
, LOC.STATE STATE
, LOC.PROVINCE PROVINCE
, LOC.COUNTY COUNTY
, LOC.POSTAL_CODE POSTAL_CODE
, T.TERRITORY_SHORT_NAME COUNTRY_NAME
, LOC.COUNTRY COUNTRY
, SITE_USES.TERRITORY_ID TERRITORY_ID
, LP.MEANING BUSINESS_PURPOSE
, LP2.MEANING PRIMARY_FLAG_DSP
, PARTY_SITE.PARTY_SITE_ID PARTY_SITE_ID
, SITE_USES.STATUS SITE_STATUS
, ACCT_SITE.STATUS ACCT_STATUS
FROM HZ_CUST_ACCT_SITES ACCT_SITE
, HZ_PARTY_SITES PARTY_SITE
, HZ_LOCATIONS LOC
, HZ_CUST_SITE_USES SITE_USES
, FND_TERRITORIES_VL T
, AR_LOOKUPS LP
, AR_LOOKUPS LP2
WHERE 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 SITE_USES.SITE_USE_CODE = LP.LOOKUP_CODE
AND LP.LOOKUP_TYPE = 'SITE_USE_CODE'
AND SITE_USES.SITE_USE_CODE = 'BILL_TO'
AND SITE_USES.PRIMARY_FLAG = LP2.LOOKUP_CODE
AND LP2.LOOKUP_TYPE = 'YES/NO'