VIEW: APPS.AST_CUST_ACCT_SITES_V

Source

View Text - Preformatted

SELECT acct_sites.rowid ,cust_acct_site_id ,cust_account_id ,acct_sites.party_site_id ,org_id ,acct_sites.status ,bill_to_flag ,market_flag ,ship_to_flag ,service_territory_id ,territory_id ,ADDRESS1 ,ADDRESS2 ,ADDRESS3 ,ADDRESS4 ,CITY ,POSTAL_CODE ,STATE ,PROVINCE ,COUNTY ,COUNTRY ,territory.territory_short_name ,acct_sites.last_update_date ,acct_sites.last_updated_by ,acct_sites.creation_date ,acct_sites.created_by ,acct_sites.last_update_login ,acct_sites.attribute_category ,acct_sites.attribute1 ,acct_sites.attribute2 ,acct_sites.attribute3 ,acct_sites.attribute4 ,acct_sites.attribute5 ,acct_sites.attribute6 ,acct_sites.attribute7 ,acct_sites.attribute8 ,acct_sites.attribute9 ,acct_sites.attribute10 ,acct_sites.attribute11 ,acct_sites.attribute12 ,acct_sites.attribute13 ,acct_sites.attribute14 ,acct_sites.attribute15 ,acct_sites.attribute16 ,acct_sites.attribute17 ,acct_sites.attribute18 ,acct_sites.attribute19 ,acct_sites.attribute20 ,acct_sites.object_version_number ,acct_sites.created_by_module ,acct_sites.application_id ,ALK.MEANING status_mean FROM HZ_CUST_ACCT_SITES acct_sites ,HZ_LOCATIONS locations ,HZ_PARTY_SITES party_sites ,FND_TERRITORIES_TL territory , AR_LOOKUPS ALK WHERE party_sites.party_site_id = acct_sites.party_site_id AND locations.location_id = party_sites.location_id AND locations.country = territory.territory_code(+) AND ALK.LOOKUP_TYPE = 'CODE_STATUS' AND ALK.LOOKUP_CODE = acct_sites.STATUS AND acct_sites.STATUS IN ('A','I') AND territory.language(+) = userenv('LANG')

View Text - HTML Formatted

SELECT ACCT_SITES.ROWID
, CUST_ACCT_SITE_ID
, CUST_ACCOUNT_ID
, ACCT_SITES.PARTY_SITE_ID
, ORG_ID
, ACCT_SITES.STATUS
, BILL_TO_FLAG
, MARKET_FLAG
, SHIP_TO_FLAG
, SERVICE_TERRITORY_ID
, TERRITORY_ID
, ADDRESS1
, ADDRESS2
, ADDRESS3
, ADDRESS4
, CITY
, POSTAL_CODE
, STATE
, PROVINCE
, COUNTY
, COUNTRY
, TERRITORY.TERRITORY_SHORT_NAME
, ACCT_SITES.LAST_UPDATE_DATE
, ACCT_SITES.LAST_UPDATED_BY
, ACCT_SITES.CREATION_DATE
, ACCT_SITES.CREATED_BY
, ACCT_SITES.LAST_UPDATE_LOGIN
, ACCT_SITES.ATTRIBUTE_CATEGORY
, ACCT_SITES.ATTRIBUTE1
, ACCT_SITES.ATTRIBUTE2
, ACCT_SITES.ATTRIBUTE3
, ACCT_SITES.ATTRIBUTE4
, ACCT_SITES.ATTRIBUTE5
, ACCT_SITES.ATTRIBUTE6
, ACCT_SITES.ATTRIBUTE7
, ACCT_SITES.ATTRIBUTE8
, ACCT_SITES.ATTRIBUTE9
, ACCT_SITES.ATTRIBUTE10
, ACCT_SITES.ATTRIBUTE11
, ACCT_SITES.ATTRIBUTE12
, ACCT_SITES.ATTRIBUTE13
, ACCT_SITES.ATTRIBUTE14
, ACCT_SITES.ATTRIBUTE15
, ACCT_SITES.ATTRIBUTE16
, ACCT_SITES.ATTRIBUTE17
, ACCT_SITES.ATTRIBUTE18
, ACCT_SITES.ATTRIBUTE19
, ACCT_SITES.ATTRIBUTE20
, ACCT_SITES.OBJECT_VERSION_NUMBER
, ACCT_SITES.CREATED_BY_MODULE
, ACCT_SITES.APPLICATION_ID
, ALK.MEANING STATUS_MEAN
FROM HZ_CUST_ACCT_SITES ACCT_SITES
, HZ_LOCATIONS LOCATIONS
, HZ_PARTY_SITES PARTY_SITES
, FND_TERRITORIES_TL TERRITORY
, AR_LOOKUPS ALK
WHERE PARTY_SITES.PARTY_SITE_ID = ACCT_SITES.PARTY_SITE_ID
AND LOCATIONS.LOCATION_ID = PARTY_SITES.LOCATION_ID
AND LOCATIONS.COUNTRY = TERRITORY.TERRITORY_CODE(+)
AND ALK.LOOKUP_TYPE = 'CODE_STATUS'
AND ALK.LOOKUP_CODE = ACCT_SITES.STATUS
AND ACCT_SITES.STATUS IN ('A'
, 'I')
AND TERRITORY.LANGUAGE(+) = USERENV('LANG')