Product: | XNC - Sales for Communications (Obsolete) |
---|---|
Description: | XNC_CUST_ACCT_SITES_V retrieves sites or locations for a customer account. |
Implementation/DBA Data: | Not implemented in this database |
SELECT CUST_ACCT_SITE_ID
, CUST_ACCOUNT_ID
, ACCT_SITES.PARTY_SITE_ID
, ORG_ID
, ACCT_SITES.LAST_UPDATE_DATE
, STATUS
, BILL_TO_FLAG
, MARKET_FLAG
, SHIP_TO_FLAG
, SERVICE_TERRITORY_ID
, TERRITORY_ID
, PRIMARY_SPECIALIST_ID
, SECONDARY_SPECIALIST_ID
, ADDRESS1
, ADDRESS2
, ADDRESS3
, ADDRESS4
, CITY
, POSTAL_CODE
, STATE
, PROVINCE
, COUNTRY
, PRIM_SPECIALIST.FULL_NAME PRIMARY_SPECIALIST_NAME
, SECOND_SPECIALIST.FULL_NAME SECONDARY_SPECIALIST_NAME
FROM JTF_CUST_ACCT_SITES_V ACCT_SITES
, JTF_HZ_PARTY_LOCATIONS_V LOCATIONS
, PER_PEOPLE PRIM_SPECIALIST
, PER_PEOPLE SECOND_SPECIALIST
WHERE LOCATIONS.PARTY_SITE_ID = ACCT_SITES.PARTY_SITE_ID
AND PRIMARY_SPECIALIST_ID = PRIM_SPECIALIST.PERSON_ID(+)
AND SECONDARY_SPECIALIST_ID = SECOND_SPECIALIST.PERSON_ID(+)