VIEW: APPS.CSL_HZ_PARTY_SITES_V

Source

View Text - Preformatted

SELECT A.ACCESS_ID , B.PARTY_SITE_ID , B.PARTY_SITE_NUMBER , B.PARTY_ID , B.LOCATION_ID , B.START_DATE_ACTIVE , B.END_DATE_ACTIVE , B.STATUS , B.PARTY_SITE_NAME FROM CSL_HZ_PARTY_SITES_ACC A , HZ_PARTY_SITES B WHERE A.PARTY_SITE_ID = B.PARTY_SITE_ID AND A.RESOURCE_ID = ASG_BASE.GET_RESOURCE_ID

View Text - HTML Formatted

SELECT A.ACCESS_ID
, B.PARTY_SITE_ID
, B.PARTY_SITE_NUMBER
, B.PARTY_ID
, B.LOCATION_ID
, B.START_DATE_ACTIVE
, B.END_DATE_ACTIVE
, B.STATUS
, B.PARTY_SITE_NAME
FROM CSL_HZ_PARTY_SITES_ACC A
, HZ_PARTY_SITES B
WHERE A.PARTY_SITE_ID = B.PARTY_SITE_ID
AND A.RESOURCE_ID = ASG_BASE.GET_RESOURCE_ID