[Home] [Help]
View: HZ_DQM_PS_V
Product: | AR - Receivables |
Description: | |
Implementation/DBA Data: |
APPS.HZ_DQM_PS_V
|
View Text
SELECT B.PARTY_SITE_ID DQPARTY_SITE_ID
, B.PARTY_ID DQPARTY_ID
, DECODE(B.STATUS
, 'A'
, 'ACTIVE'
, 'I'
, 'INACTIVE'
, NULL) DQSTATUS
, NVL(ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING ('REGISTRY_STATUS'
, B.STATUS)
, B.STATUS) DQSTATUSM
, C.ADDRESS1||DECODE(C.ADDRESS2
, NULL
, NULL
, '-'||C.ADDRESS2) DQADDRESS
, C.COUNTY DQCOUNTY
, C.PROVINCE DQPROVINCE
, C.CITY DQCITY
, C.STATE DQSTATE
, C.POSTAL_CODE DQPOSTAL_CODE
, T.TERRITORY_SHORT_NAME DQCOUNTRY
FROM HZ_PARTY_SITES B
, HZ_LOCATIONS C
, FND_TERRITORIES_VL T
WHERE B.LOCATION_ID = C.LOCATION_ID
AND NVL(B.STATUS
, 'A') NOT IN ('M')
AND C.COUNTRY = T.TERRITORY_CODE(+)
Columns
Name |
DQPARTY_SITE_ID |
DQPARTY_ID |
DQSTATUS |
DQSTATUSM |
DQADDRESS |
DQCOUNTY |
DQPROVINCE |
DQCITY |
DQSTATE |
DQPOSTAL_CODE |
DQCOUNTRY |