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: ASF_ACCOUNT_SITES_LOV_V

Product:	ASF - Sales Online
Description:	Contains active account sites record
Implementation/DBA Data:	APPS.ASF_ACCOUNT_SITES_LOV_V

View Text

SELECT ASITE.CUST_ACCT_SITE_ID
, ASITE.CUST_ACCOUNT_ID
, ASITE.PARTY_SITE_ID
, NULL
, ASITE.STATUS
, USE.PRIMARY_FLAG
, USE.SITE_USE_CODE
, LOC.ADDRESS1
, LOC.ADDRESS2
, LOC.ADDRESS3
, LOC.ADDRESS4
, LOC.CITY
, LOC.STATE
, LOC.COUNTRY
, LOC.COUNTY
, LOC.POSTAL_CODE
, LOC.PROVINCE
, 'Y'
FROM HZ_LOCATIONS LOC
, HZ_PARTY_SITES PSITE
, HZ_CUST_SITE_USES USE
, HZ_CUST_ACCT_SITES ASITE
WHERE USE.CUST_ACCT_SITE_ID (+) = ASITE.CUST_ACCT_SITE_ID
AND LOC.LOCATION_ID = PSITE.LOCATION_ID
AND PSITE.PARTY_SITE_ID = ASITE.PARTY_SITE_ID
AND ASITE.STATUS IN ('A'
, 'I')
AND PSITE.STATUS IN ('A'
, 'I')
AND DECODE(USE.STATUS(+)
, 'A'
, 1
, 'I'
, 1
, NULL
, 1
, -99) = 1

Columns

Name
CUST_ACCT_SITE_ID
CUST_ACCOUNT_ID
PARTY_SITE_ID
PARTY_ID
STATUS
PRIMARY_FLAG
SITE_USE_CODE
ADDRESS1
ADDRESS2
ADDRESS3
ADDRESS4
CITY
STATE
COUNTRY
COUNTY
POSTAL_CODE
PROVINCE
VALID_ADDR_FLAG