VIEW: APPS.CSC_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.Organization_id org_id ,acct_sites.status ,bill_to_flag ,market_flag ,ship_to_flag ,service_territory_id ,territory_id ,rtrim(ADDRESS1|| ';' || ADDRESS2 || ';' || ADDRESS3 || ';' || ADDRESS4,';') ,ADDRESS2 ,ADDRESS3 ,ADDRESS4 ,CITY ,POSTAL_CODE ,STATE ,PROVINCE ,COUNTY ,COUNTRY ,territory.territory_short_name ,org.name Operating_unit ,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.object_version_number ,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.language ,party_sites.party_site_name FROM HZ_CUST_ACCT_SITES acct_sites ,HZ_LOCATIONS locations ,HZ_PARTY_SITES party_sites ,FND_TERRITORIES_VL territory , HR_OPERATING_UNITS ORG 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 acct_sites.org_id = org.organization_id

View Text - HTML Formatted

SELECT ACCT_SITES.ROWID
, CUST_ACCT_SITE_ID
, CUST_ACCOUNT_ID
, ACCT_SITES.PARTY_SITE_ID
, ORG.ORGANIZATION_ID ORG_ID
, ACCT_SITES.STATUS
, BILL_TO_FLAG
, MARKET_FLAG
, SHIP_TO_FLAG
, SERVICE_TERRITORY_ID
, TERRITORY_ID
, RTRIM(ADDRESS1|| ';' || ADDRESS2 || ';' || ADDRESS3 || ';' || ADDRESS4
, ';')
, ADDRESS2
, ADDRESS3
, ADDRESS4
, CITY
, POSTAL_CODE
, STATE
, PROVINCE
, COUNTY
, COUNTRY
, TERRITORY.TERRITORY_SHORT_NAME
, ORG.NAME OPERATING_UNIT
, 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.OBJECT_VERSION_NUMBER
, 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.LANGUAGE
, PARTY_SITES.PARTY_SITE_NAME
FROM HZ_CUST_ACCT_SITES ACCT_SITES
, HZ_LOCATIONS LOCATIONS
, HZ_PARTY_SITES PARTY_SITES
, FND_TERRITORIES_VL TERRITORY
, HR_OPERATING_UNITS ORG
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 ACCT_SITES.ORG_ID = ORG.ORGANIZATION_ID