VIEW: APPS.AMS_P_EVENT_REG_ROSTER_V

Source

View Text - Preformatted

SELECT EVO.EVENT_OFFER_ID, EVO.EVENT_OFFER_NAME, EVO.EVENT_LOCATION_ID, HZL.CITY, HZL.STATE, HZL.PROVINCE, HZL.COUNTRY, EVO.EVENT_START_DATE, EVO.EVENT_START_DATE_TIME, EVO.EVENT_END_DATE, EVO.EVENT_END_DATE_TIME, REG.REGISTRANT_PARTY_ID, HZP.PARTY_NAME, REG.REGISTRANT_ACCOUNT_ID, REG.REGISTRANT_CONTACT_ID, NULL, REG.EVENT_REGISTRATION_ID, REG.CONFIRMATION_CODE, REG.CANCELLATION_CODE, REG.WAITLISTED_PRIORITY, REG.USER_STATUS_ID, AUS.SYSTEM_STATUS_CODE, AUS.NAME, REG.REGISTRATION_GROUP_ID, EVO.INVENTORY_ITEM_ID, REG.ORDER_HEADER_ID, REG.ORDER_LINE_ID FROM AMS_EVENT_OFFERS_VL EVO, AMS_EVENT_REGISTRATIONS REG, HZ_LOCATIONS HZL, AMS_USER_STATUSES_VL AUS, HZ_PARTIES HZP WHERE EVO.EVENT_OFFER_ID=REG.EVENT_OFFER_ID AND EVO.USER_STATUS_ID=AUS.USER_STATUS_ID AND EVO.EVENT_LOCATION_ID=HZL.LOCATION_ID AND REG.REGISTRANT_PARTY_ID=HZP.PARTY_ID

View Text - HTML Formatted

SELECT EVO.EVENT_OFFER_ID
, EVO.EVENT_OFFER_NAME
, EVO.EVENT_LOCATION_ID
, HZL.CITY
, HZL.STATE
, HZL.PROVINCE
, HZL.COUNTRY
, EVO.EVENT_START_DATE
, EVO.EVENT_START_DATE_TIME
, EVO.EVENT_END_DATE
, EVO.EVENT_END_DATE_TIME
, REG.REGISTRANT_PARTY_ID
, HZP.PARTY_NAME
, REG.REGISTRANT_ACCOUNT_ID
, REG.REGISTRANT_CONTACT_ID
, NULL
, REG.EVENT_REGISTRATION_ID
, REG.CONFIRMATION_CODE
, REG.CANCELLATION_CODE
, REG.WAITLISTED_PRIORITY
, REG.USER_STATUS_ID
, AUS.SYSTEM_STATUS_CODE
, AUS.NAME
, REG.REGISTRATION_GROUP_ID
, EVO.INVENTORY_ITEM_ID
, REG.ORDER_HEADER_ID
, REG.ORDER_LINE_ID
FROM AMS_EVENT_OFFERS_VL EVO
, AMS_EVENT_REGISTRATIONS REG
, HZ_LOCATIONS HZL
, AMS_USER_STATUSES_VL AUS
, HZ_PARTIES HZP
WHERE EVO.EVENT_OFFER_ID=REG.EVENT_OFFER_ID
AND EVO.USER_STATUS_ID=AUS.USER_STATUS_ID
AND EVO.EVENT_LOCATION_ID=HZL.LOCATION_ID
AND REG.REGISTRANT_PARTY_ID=HZP.PARTY_ID