VIEW: APPS.HZ_DQM_CS_U_V

Source

View Text - Preformatted

SELECT a.cust_acct_site_id dqcust_acct_site_id, e.site_use_id dqsite_use_id, e.site_use_code dqsite_use_code, e.primary_flag dqprimary_flag, f.meaning dqmeaning, e.status dqstatus, NVL(arpt_sql_func_util.get_lookup_meaning ('REGISTRY_STATUS',e.status),e.status) dqstatusm, e.location dqlocation, a.org_id dqorg_id FROM hz_cust_acct_sites_all a, hz_cust_site_uses_all e, ar_lookups f WHERE a.cust_acct_site_id = e.cust_acct_site_id AND f.lookup_type(+) = 'SITE_USE_CODE' AND NVL(e.status,'A') NOT IN ('M') AND f.lookup_code(+) = e.site_use_code

View Text - HTML Formatted

SELECT A.CUST_ACCT_SITE_ID DQCUST_ACCT_SITE_ID
, E.SITE_USE_ID DQSITE_USE_ID
, E.SITE_USE_CODE DQSITE_USE_CODE
, E.PRIMARY_FLAG DQPRIMARY_FLAG
, F.MEANING DQMEANING
, E.STATUS DQSTATUS
, NVL(ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING ('REGISTRY_STATUS'
, E.STATUS)
, E.STATUS) DQSTATUSM
, E.LOCATION DQLOCATION
, A.ORG_ID DQORG_ID
FROM HZ_CUST_ACCT_SITES_ALL A
, HZ_CUST_SITE_USES_ALL E
, AR_LOOKUPS F
WHERE A.CUST_ACCT_SITE_ID = E.CUST_ACCT_SITE_ID
AND F.LOOKUP_TYPE(+) = 'SITE_USE_CODE'
AND NVL(E.STATUS
, 'A') NOT IN ('M')
AND F.LOOKUP_CODE(+) = E.SITE_USE_CODE