View: AMS_ORG_SITE_USES_V

Product:	AMS - Marketing
Description:
Implementation/DBA Data:	APPS.AMS_ORG_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
, HPS.LANGUAGE
FROM HZ_PARTY_SITE_USES HPSU
, HZ_PARTY_SITES HPS
, HZ_PARTIES HP
WHERE HPSU.PARTY_SITE_ID = HPS.PARTY_SITE_ID
AND HPS.PARTY_ID = HP.PARTY_ID
AND HPS.ACTUAL_CONTENT_SOURCE = 'USER_ENTERED'
AND HP.STATUS = 'A'
AND HP.PARTY_TYPE = 'ORGANIZATION'
AND HPS.IDENTIFYING_ADDRESS_FLAG = 'Y'
AND HPSU.PRIMARY_PER_TYPE = 'Y'

Columns