VIEW: APPS.ASF_ACCOUNT_SITES_LOV_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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