[Home] [Help]
View: 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 |