[Home] [Help]
View: AMS_PERSON_SITE_USES_V
Product: | AMS - Marketing |
Description: | The way that a person uses a particular site or address |
Implementation/DBA Data: |
APPS.AMS_PERSON_SITE_USES_V
|
View Text
SELECT HPSU.PARTY_SITE_USE_ID
, HPSU.PARTY_SITE_ID
, HPSU.SITE_USE_TYPE
, HPSU.BEGIN_DATE
, HPSU.END_DATE
, HPSU.PRIMARY_PER_TYPE
, HPS.REGION
, HPS.MAILSTOP
, HL.LANGUAGE LANGUAGE
FROM HZ_PARTY_SITE_USES HPSU
, HZ_PARTY_SITES HPS
, HZ_PARTIES HP
, HZ_LOCATIONS HL
WHERE HPSU.PARTY_SITE_ID = HPS.PARTY_SITE_ID
AND HPS.LOCATION_ID = HL.LOCATION_ID
AND HPS.PARTY_ID = HP.PARTY_ID
AND HPS.ACTUAL_CONTENT_SOURCE = 'USER_ENTERED'
AND HPS.IDENTIFYING_ADDRESS_FLAG = 'Y'
AND HPSU.PRIMARY_PER_TYPE = 'Y'
AND HP.STATUS = 'A'
AND HP.PARTY_TYPE = 'PERSON'
Columns
Name |
PARTY_SITE_USE_ID |
PARTY_SITE_ID |
SITE_USE_TYPE |
BEGIN_DATE |
END_DATE |
PRIMARY_PER_TYPE |
REGION |
MAILSTOP |
LANGUAGE |