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.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.AMS_EVENT_OFFERS_REG_V

Object Details

Object Name:	AMS_EVENT_OFFERS_REG_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AMS.AMS_EVENT_OFFERS_REG_V
Subobject Name:
Status:	VALID

View Type

A Web view designed to simplify access from Oracle Self-Service Web Applications.

This view returns registration information about event schedules

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Unique identifier generated by database
EVENT_TYPE_CODE	VARCHAR2	(30)		Unique code
EVENT_TYPE	VARCHAR2	(80)		Quick code meaning
REG_MINIMUM_CAPACITY	NUMBER	(15)		Minimum Capacity Required for Event
REG_MINIMUM_REQ_BY_DATE	DATE			Date By which Minimum qty of registration should be attained
ORGANIZATION_ID	NUMBER	(32)		Operating unit identifier.
INVENTORY_ITEM_ID	NUMBER	(38)		Inventory Item Id
PRICELIST_HEADER_ID	NUMBER			Pricelist Header Id
PRICELIST_LINE_ID	NUMBER			Price List Line id
WAITLIST_ACTION_TYPE_CODE	VARCHAR2	(30)		Code of Wait list action Type. Seeded value
STREAM_TYPE_CODE	VARCHAR2	(30)		Unique code used across systems
OWNER_USER_ID	NUMBER		Yes	The person who took the registration. This is the user ID of the person who recorded the registration in the System.
EVENT_FULL_FLAG	VARCHAR2	(1)		Flag to indicate that Event is full.
EVENT_OFFER_ID	NUMBER		Yes	Event Offer Id
SETUP_TYPE_ID	NUMBER			Custom Setup Type Id
LAST_UPDATE_DATE	DATE		Yes	standard Who Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	standard Who Column
CREATION_DATE	DATE		Yes	standard Who Column
CREATED_BY	NUMBER	(15)	Yes	standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)		standard Who Column
OBJECT_VERSION_NUMBER	NUMBER	(9)		Unique number used for locking purposes
APPLICATION_ID	NUMBER	(15)	Yes	Application Id
PRIVATE_FLAG	VARCHAR2	(1)	Yes	Indicates if the event is confidential
ACTIVE_FLAG	VARCHAR2	(1)	Yes	Indicates the state of the event
SOURCE_CODE	VARCHAR2	(30)		Unique code identifying event source
EVENT_LEVEL	VARCHAR2	(30)	Yes	Level of the event
USER_STATUS_ID	NUMBER		Yes	User Status id
USER_STATUS	VARCHAR2	(120)		Name of the user status
LAST_STATUS_DATE	DATE		Yes	Date When User status Changed
SYSTEM_STATUS_CODE	VARCHAR2	(30)	Yes	System Status Code
OVERFLOW_FLAG	VARCHAR2	(1)	Yes	Indicates if registration overflow is allowed on this event.
EVENT_STANDALONE_FLAG	VARCHAR2	(1)	Yes	Indicates if the event is standalone.
REG_FROZEN_FLAG	VARCHAR2	(1)	Yes	Flag to indicate no more registration
REG_REQUIRED_FLAG	VARCHAR2	(1)	Yes	Flag to indicate Registration required to attend this Event
REG_CHARGE_FLAG	VARCHAR2	(1)	Yes	Flag to indicate Pay event
REG_INVITED_ONLY_FLAG	VARCHAR2	(1)	Yes	Flag to indicate This event is for the people who got invitation
REG_WAITLIST_ALLOWED_FLAG	VARCHAR2	(1)	Yes	Flag to indicate Waitlist is allowed while registering
REG_OVERBOOK_ALLOWED_FLAG	VARCHAR2	(1)	Yes	Flag to indicate Over booking allowed while registering
EVENT_DURATION	NUMBER	(15)		Event Duration
EVENT_DURATION_UOM_CODE	VARCHAR2	(3)		Unit of Measure for the Event Duration
EVENT_START_DATE	DATE			Event Start Date
EVENT_START_DATE_TIME	DATE			Event start date with time component
EVENT_END_DATE	DATE			event end date
EVENT_END_DATE_TIME	DATE			event end date with time component
REG_START_DATE	DATE			Registration for the event start date
REG_START_TIME	DATE			Registration for the event start time
REG_END_DATE	DATE			Registration for the event end date
REG_END_TIME	DATE			Registration for the event end time
REG_MAXIMUM_CAPACITY	NUMBER	(15)		Maximum capacity for registration
REG_OVERBOOK_PCT	NUMBER	(15)		Over book Percentage
REG_EFFECTIVE_CAPACITY	NUMBER	(15)		Effective capacity
REG_WAITLIST_PCT	NUMBER	(15)		Wait list percentage
CURRENCY_CODE_TC	VARCHAR2	(15)		Transactional currency code
CURRENCY_CODE_FC	VARCHAR2	(15)		Functional currency code
CERTIFICATION_CREDIT_TYPE	VARCHAR2	(30)		Credit Type
CERTIFICATION_CREDITS	NUMBER	(15)		Certification credits
COORDINATOR_ID	NUMBER			Coordinator id
PRIORITY_CODE	VARCHAR2	(30)		Priority code
TIMEZONE_ID	NUMBER	(15)		Time zone id
TIMEZONE_NAME	VARCHAR2	(80)		Time zone name
EVENT_OFFER_NAME	VARCHAR2	(240)	Yes	Event offer name
START_PERIOD_NAME	VARCHAR2	(15)		Start period Name
END_PERIOD_NAME	VARCHAR2	(15)		End Period Name
GLOBAL_FLAG	VARCHAR2	(1)		Flag to indicate how to generate source code
PARENT_TYPE	VARCHAR2	(30)		Type of parent of this event
PARENT_ID	NUMBER			Id of the parent
CREATE_ATTENDANT_LEAD_FLAG	VARCHAR2	(1)		Flag to indicate that the attendee as lead
CREATE_REGISTRANT_LEAD_FLAG	VARCHAR2	(1)		flag to indicate that the registrant as lead
EVO_PRICELIST_NAME	NUMBER			Price list name
EVO_PRICELIST_CURRENCY_CODE	VARCHAR2	(240)		Price list currency code
EVO_LIST_PRICE	VARCHAR2	(30)		Event price list name
EVO_INV_ITEM_NUMBER	NUMBER			Event's inventory Number
EVO_COORDINATOR_NAME	VARCHAR2	(360)		Event's coordinator name

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ROW_ID
,      EVENT_TYPE_CODE
,      EVENT_TYPE
,      REG_MINIMUM_CAPACITY
,      REG_MINIMUM_REQ_BY_DATE
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      PRICELIST_HEADER_ID
,      PRICELIST_LINE_ID
,      WAITLIST_ACTION_TYPE_CODE
,      STREAM_TYPE_CODE
,      OWNER_USER_ID
,      EVENT_FULL_FLAG
,      EVENT_OFFER_ID
,      SETUP_TYPE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      APPLICATION_ID
,      PRIVATE_FLAG
,      ACTIVE_FLAG
,      SOURCE_CODE
,      EVENT_LEVEL
,      USER_STATUS_ID
,      USER_STATUS
,      LAST_STATUS_DATE
,      SYSTEM_STATUS_CODE
,      OVERFLOW_FLAG
,      EVENT_STANDALONE_FLAG
,      REG_FROZEN_FLAG
,      REG_REQUIRED_FLAG
,      REG_CHARGE_FLAG
,      REG_INVITED_ONLY_FLAG
,      REG_WAITLIST_ALLOWED_FLAG
,      REG_OVERBOOK_ALLOWED_FLAG
,      EVENT_DURATION
,      EVENT_DURATION_UOM_CODE
,      EVENT_START_DATE
,      EVENT_START_DATE_TIME
,      EVENT_END_DATE
,      EVENT_END_DATE_TIME
,      REG_START_DATE
,      REG_START_TIME
,      REG_END_DATE
,      REG_END_TIME
,      REG_MAXIMUM_CAPACITY
,      REG_OVERBOOK_PCT
,      REG_EFFECTIVE_CAPACITY
,      REG_WAITLIST_PCT
,      CURRENCY_CODE_TC
,      CURRENCY_CODE_FC
,      CERTIFICATION_CREDIT_TYPE
,      CERTIFICATION_CREDITS
,      COORDINATOR_ID
,      PRIORITY_CODE
,      TIMEZONE_ID
,      TIMEZONE_NAME
,      EVENT_OFFER_NAME
,      START_PERIOD_NAME
,      END_PERIOD_NAME
,      GLOBAL_FLAG
,      PARENT_TYPE
,      PARENT_ID
,      CREATE_ATTENDANT_LEAD_FLAG
,      CREATE_REGISTRANT_LEAD_FLAG
,      EVO_PRICELIST_NAME
,      EVO_PRICELIST_CURRENCY_CODE
,      EVO_LIST_PRICE
,      EVO_INV_ITEM_NUMBER
,      EVO_COORDINATOR_NAME
FROM APPS.AMS_EVENT_OFFERS_REG_V;

Dependencies

[top of page]

APPS.AMS_EVENT_OFFERS_REG_V references the following:

APPS: AMS_EVENT_OFFERS_VL; AMS_JTF_RS_EMP_V; AMS_LOOKUPS; AMS_USER_STATUSES_VL; HZ_TIMEZONES_VL; MTL_SYSTEM_ITEMS_KFV; QP_PRICE_LISTS_V; QP_PRICE_LIST_LINES_V; QP_PRICE_LIST_PVT - show dependent code; QP_UTIL - show dependent code

APPS.AMS_EVENT_OFFERS_REG_V is not referenced by any database object