VIEW: APPS.RLM_CUM_SITE_USES_V

Source

View Text - Preformatted

SELECT cust_site.rowid row_id, cust_site.site_use_id, ACCT_SITE.CUST_ACCOUNT_ID , ACCT_SITE.CUST_ACCT_SITE_ID , cust_site.location, loc.city, loc.state, cust_site.SITE_USE_CODE, arl.meaning site_use_meaning, terms.cum_org_level_code, terms.ORG_ID FROM rlm_cust_shipto_terms terms, ar_lookups arl, HZ_PARTY_SITES PARTY_SITE, HZ_LOCATIONS LOC, HZ_CUST_ACCT_SITES_ALL ACCT_SITE, HZ_CUST_SITE_USES_ALL CUST_SITE WHERE terms.address_id = ACCT_SITE.CUST_ACCT_SITE_ID AND terms.cum_org_level_code in ( 'SHIP_TO_SHIP_FROM', 'BILL_TO_SHIP_FROM', 'DELIVER_TO_SHIP_FROM' ) AND cust_site.status = 'A' AND cust_site.site_use_code = arl.lookup_code AND arl.lookup_type = 'SITE_USE_CODE' 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 = cust_site.CUST_ACCT_SITE_ID AND terms.ORG_ID = ACCT_SITE.ORG_ID AND ACCT_SITE.ORG_ID = CUST_SITE.ORG_ID

View Text - HTML Formatted

SELECT CUST_SITE.ROWID ROW_ID
, CUST_SITE.SITE_USE_ID
, ACCT_SITE.CUST_ACCOUNT_ID
, ACCT_SITE.CUST_ACCT_SITE_ID
, CUST_SITE.LOCATION
, LOC.CITY
, LOC.STATE
, CUST_SITE.SITE_USE_CODE
, ARL.MEANING SITE_USE_MEANING
, TERMS.CUM_ORG_LEVEL_CODE
, TERMS.ORG_ID
FROM RLM_CUST_SHIPTO_TERMS TERMS
, AR_LOOKUPS ARL
, HZ_PARTY_SITES PARTY_SITE
, HZ_LOCATIONS LOC
, HZ_CUST_ACCT_SITES_ALL ACCT_SITE
, HZ_CUST_SITE_USES_ALL CUST_SITE
WHERE TERMS.ADDRESS_ID = ACCT_SITE.CUST_ACCT_SITE_ID
AND TERMS.CUM_ORG_LEVEL_CODE IN ( 'SHIP_TO_SHIP_FROM'
, 'BILL_TO_SHIP_FROM'
, 'DELIVER_TO_SHIP_FROM' )
AND CUST_SITE.STATUS = 'A'
AND CUST_SITE.SITE_USE_CODE = ARL.LOOKUP_CODE
AND ARL.LOOKUP_TYPE = 'SITE_USE_CODE'
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 = CUST_SITE.CUST_ACCT_SITE_ID
AND TERMS.ORG_ID = ACCT_SITE.ORG_ID
AND ACCT_SITE.ORG_ID = CUST_SITE.ORG_ID