eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.AMS_ORG_SITE_USES_V

Source

View Text - Preformatted


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'

View Text - HTML Formatted

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'