VIEW: APPS.HZ_DQM_P_PS_V

Source

View Text - Preformatted

SELECT ps.party_site_id dqparty_site_id, ps.party_id dqparty_id, l.address1 || DECODE(l.address2,NULL,NULL,'-'||l.address2) dqaddress, t.territory_short_name dqcountry, l.city dqcity, l.state dqstate, l.postal_code dqpostal_code, l.province dqprovince, l.county dqcounty, ps.identifying_address_flag dqiden_flag, ps.status dqstatus, NVL(arpt_sql_func_util.get_lookup_meaning ('REGISTRY_STATUS',ps.status),ps.status) dqstatusm FROM hz_party_sites ps, hz_locations l, fnd_territories_vl t, hz_matched_party_sites_gt g WHERE ps.location_id = l.location_id AND l.country = t.territory_code(+) AND g.party_id(+) = ps.party_id AND g.party_site_id(+) = ps.party_site_id AND g.search_context_id(+)= arh_dqm_tree_helper.ctxmax AND NVL(ps.status,'A') NOT IN ('M') ORDER BY DECODE(g.score,NULL,-1,g.score) DESC

View Text - HTML Formatted

SELECT PS.PARTY_SITE_ID DQPARTY_SITE_ID
, PS.PARTY_ID DQPARTY_ID
, L.ADDRESS1 || DECODE(L.ADDRESS2
, NULL
, NULL
, '-'||L.ADDRESS2) DQADDRESS
, T.TERRITORY_SHORT_NAME DQCOUNTRY
, L.CITY DQCITY
, L.STATE DQSTATE
, L.POSTAL_CODE DQPOSTAL_CODE
, L.PROVINCE DQPROVINCE
, L.COUNTY DQCOUNTY
, PS.IDENTIFYING_ADDRESS_FLAG DQIDEN_FLAG
, PS.STATUS DQSTATUS
, NVL(ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING ('REGISTRY_STATUS'
, PS.STATUS)
, PS.STATUS) DQSTATUSM
FROM HZ_PARTY_SITES PS
, HZ_LOCATIONS L
, FND_TERRITORIES_VL T
, HZ_MATCHED_PARTY_SITES_GT G
WHERE PS.LOCATION_ID = L.LOCATION_ID
AND L.COUNTRY = T.TERRITORY_CODE(+)
AND G.PARTY_ID(+) = PS.PARTY_ID
AND G.PARTY_SITE_ID(+) = PS.PARTY_SITE_ID
AND G.SEARCH_CONTEXT_ID(+)= ARH_DQM_TREE_HELPER.CTXMAX
AND NVL(PS.STATUS
, 'A') NOT IN ('M') ORDER BY DECODE(G.SCORE
, NULL
, -1
, G.SCORE) DESC