View: HZ_DQM_P_PS_V

Product:	AR - Receivables
Description:
Implementation/DBA Data:	APPS.HZ_DQM_P_PS_V

View Text

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

Columns