eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: XNC_CUST_ACCT_SITES_V

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

View Text

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(+)

Columns

Name
CUST_ACCT_SITE_ID
CUST_ACCOUNT_ID
PARTY_SITE_ID
ORG_ID
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
PRIMARY_SPECIALIST_NAME
SECONDARY_SPECIALIST_NAME