VIEW: APPS.HZ_DQM_AC_CS_V

Source

View Text - Preformatted

SELECT a.cust_account_id dqcust_account_id, a.cust_acct_site_id dqcust_acct_site_id, a.status dqstatus, NVL(arpt_sql_func_util.get_lookup_meaning ('REGISTRY_STATUS',a.status),a.status) dqstatusm, b.party_site_id dqparty_site_id, b.party_id dqparty_id, c.address1||DECODE(c.address2,NULL,NULL,'-'||c.address2) dqaddress, c.city dqcity, c.state dqstate, c.postal_code dqpostal_code, t.territory_short_name dqcountry, c.province dqprovince, c.county dqcounty, a.org_id dqorg_id FROM hz_cust_acct_sites_all a, hz_party_sites b, hz_locations c, fnd_territories_vl t WHERE a.party_site_id = b.party_site_id AND NVL(a.status,'A') NOT IN ('M') AND b.location_id = c.location_id AND c.country = t.territory_code(+)

View Text - HTML Formatted

SELECT A.CUST_ACCOUNT_ID DQCUST_ACCOUNT_ID
, A.CUST_ACCT_SITE_ID DQCUST_ACCT_SITE_ID
, A.STATUS DQSTATUS
, NVL(ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING ('REGISTRY_STATUS'
, A.STATUS)
, A.STATUS) DQSTATUSM
, B.PARTY_SITE_ID DQPARTY_SITE_ID
, B.PARTY_ID DQPARTY_ID
, C.ADDRESS1||DECODE(C.ADDRESS2
, NULL
, NULL
, '-'||C.ADDRESS2) DQADDRESS
, C.CITY DQCITY
, C.STATE DQSTATE
, C.POSTAL_CODE DQPOSTAL_CODE
, T.TERRITORY_SHORT_NAME DQCOUNTRY
, C.PROVINCE DQPROVINCE
, C.COUNTY DQCOUNTY
, A.ORG_ID DQORG_ID
FROM HZ_CUST_ACCT_SITES_ALL A
, HZ_PARTY_SITES B
, HZ_LOCATIONS C
, FND_TERRITORIES_VL T
WHERE A.PARTY_SITE_ID = B.PARTY_SITE_ID
AND NVL(A.STATUS
, 'A') NOT IN ('M')
AND B.LOCATION_ID = C.LOCATION_ID
AND C.COUNTRY = T.TERRITORY_CODE(+)