Product: | AMS - Marketing |
---|---|
Description: | This view returns registration information about event schedules |
Implementation/DBA Data: | APPS.AMS_EVENT_OFFERS_REG_V |
SELECT EVO.ROW_ID
, EVO.EVENT_TYPE_CODE
, LKUP4.MEANING EVENT_TYPE
, EVO.REG_MINIMUM_CAPACITY
, EVO.REG_MINIMUM_REQ_BY_DATE
, EVO.ORGANIZATION_ID
, EVO.INVENTORY_ITEM_ID
, EVO.PRICELIST_HEADER_ID
, EVO.PRICELIST_LINE_ID
, EVO.WAITLIST_ACTION_TYPE_CODE
, EVO.STREAM_TYPE_CODE
, EVO.OWNER_USER_ID
, EVO.EVENT_FULL_FLAG
, EVO.EVENT_OFFER_ID
, EVO.SETUP_TYPE_ID
, EVO.LAST_UPDATE_DATE
, EVO.LAST_UPDATED_BY
, EVO.CREATION_DATE
, EVO.CREATED_BY
, EVO.LAST_UPDATE_LOGIN
, EVO.OBJECT_VERSION_NUMBER
, EVO.APPLICATION_ID
, EVO.PRIVATE_FLAG
, EVO.ACTIVE_FLAG
, EVO.SOURCE_CODE
, EVO.EVENT_LEVEL
, EVO.USER_STATUS_ID
, AUS.NAME
, EVO.LAST_STATUS_DATE
, EVO.SYSTEM_STATUS_CODE
, EVO.OVERFLOW_FLAG
, EVO.EVENT_STANDALONE_FLAG
, EVO.REG_FROZEN_FLAG
, EVO.REG_REQUIRED_FLAG
, EVO.REG_CHARGE_FLAG
, EVO.REG_INVITED_ONLY_FLAG
, EVO.REG_WAITLIST_ALLOWED_FLAG
, EVO.REG_OVERBOOK_ALLOWED_FLAG
, EVO.EVENT_DURATION
, EVO.EVENT_DURATION_UOM_CODE
, EVO.EVENT_START_DATE
, EVO.EVENT_START_DATE_TIME
, EVO.EVENT_END_DATE
, EVO.EVENT_END_DATE_TIME
, EVO.REG_START_DATE
, EVO.REG_START_TIME
, EVO.REG_END_DATE
, EVO.REG_END_TIME
, EVO.REG_MAXIMUM_CAPACITY
, EVO.REG_OVERBOOK_PCT
, EVO.REG_EFFECTIVE_CAPACITY
, EVO.REG_WAITLIST_PCT
, EVO.CURRENCY_CODE_TC
, EVO.CURRENCY_CODE_FC
, EVO.CERT_CREDIT_TYPE_CODE
, EVO.CERTIFICATION_CREDITS
, EVO.COORDINATOR_ID
, EVO.PRIORITY_TYPE_CODE
, EVO.TIMEZONE_ID
, HTZ.NAME
, EVO.EVENT_OFFER_NAME
, EVO.START_PERIOD_NAME
, EVO.END_PERIOD_NAME
, EVO.GLOBAL_FLAG
, EVO.PARENT_TYPE
, EVO.PARENT_ID
, EVO.CREATE_ATTENDANT_LEAD_FLAG
, EVO.CREATE_REGISTRANT_LEAD_FLAG
, EVO.PRICELIST_HEADER_ID
, QPH.NAME
, QPH.CURRENCY_CODE
, QPL.LIST_PRICE
, JTFR.FULL_NAME
FROM AMS_EVENT_OFFERS_VL EVO
, AMS_USER_STATUSES_VL AUS
, HZ_TIMEZONES_VL HTZ
, AMS_JTF_RS_EMP_V JTFR
, MTL_SYSTEM_ITEMS_KFV ITEM
, QP_PRICE_LISTS_V QPH
, QP_PRICE_LIST_LINES_V QPL
, AMS_LOOKUPS LKUP4
WHERE EVO.EVENT_LEVEL='MAIN'
AND EVO.ACTIVE_FLAG = 'Y'
AND LKUP4.LOOKUP_TYPE(+)='AMS_EVENT_TYPE'
AND LKUP4.LOOKUP_CODE(+)=EVO.EVENT_TYPE_CODE
AND EVO.USER_STATUS_ID=AUS.USER_STATUS_ID
AND EVO.TIMEZONE_ID=HTZ.TIMEZONE_ID(+)
AND EVO.COORDINATOR_ID= JTFR.RESOURCE_ID(+)
AND EVO.INVENTORY_ITEM_ID=ITEM.INVENTORY_ITEM_ID(+)
AND EVO.ORGANIZATION_ID=ITEM.ORGANIZATION_ID(+)
AND EVO.PRICELIST_HEADER_ID=QPH.PRICE_LIST_ID(+)
AND EVO.PRICELIST_LINE_ID=QPL.PRICE_LIST_LINE_ID(+)