VIEW: APPS.HZ_DQM_PS_U_V

Source

View Text - Preformatted

SELECT a.PARTY_SITE_USE_ID dqparty_site_use_id, a.BEGIN_DATE dqbegin_date, a.COMMENTS dqcomments, a.END_DATE dqend_date, a.PARTY_SITE_ID dqparty_site_id, a.SITE_USE_TYPE dqsite_use_type, a.PRIMARY_PER_TYPE dqprimary_per_type, a.STATUS dqstatus, NVL(arpt_sql_func_util.get_lookup_meaning ('REGISTRY_STATUS',a.status),a.status) dqstatusm, f.meaning dqmeaning FROM hz_party_site_uses a, ar_lookups f WHERE f.lookup_type(+) = 'PARTY_SITE_USE_CODE' AND NVL(a.status,'A') NOT IN ('M') AND f.lookup_code(+) = a.site_use_type

View Text - HTML Formatted

SELECT A.PARTY_SITE_USE_ID DQPARTY_SITE_USE_ID
, A.BEGIN_DATE DQBEGIN_DATE
, A.COMMENTS DQCOMMENTS
, A.END_DATE DQEND_DATE
, A.PARTY_SITE_ID DQPARTY_SITE_ID
, A.SITE_USE_TYPE DQSITE_USE_TYPE
, A.PRIMARY_PER_TYPE DQPRIMARY_PER_TYPE
, A.STATUS DQSTATUS
, NVL(ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING ('REGISTRY_STATUS'
, A.STATUS)
, A.STATUS) DQSTATUSM
, F.MEANING DQMEANING
FROM HZ_PARTY_SITE_USES A
, AR_LOOKUPS F
WHERE F.LOOKUP_TYPE(+) = 'PARTY_SITE_USE_CODE'
AND NVL(A.STATUS
, 'A') NOT IN ('M')
AND F.LOOKUP_CODE(+) = A.SITE_USE_TYPE