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.BIM_DIMV_EVENT_OFFERS

Object Details

Object Name:	BIM_DIMV_EVENT_OFFERS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	BIM.BIM_DIMV_EVENT_OFFERS
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

BIM_DIMV_EVENT_OFFERS is a view showing all event offers.
.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ID	VARCHAR2	(44)		id
VALUE	VARCHAR2	(80)		value
EVENT_OFFER_ID	VARCHAR2	(44)		event offer id
EVENT_OFFER_NAME	VARCHAR2	(240)	Yes	event offer name
EVENT_OFFER_DESCRIPTION	VARCHAR2	(4000)		event offer description
EVENT_HEADER_ID	VARCHAR2	(44)		event header id
PARENT_EVENT_OFFER_ID	VARCHAR2	(44)		parent event offer id
EVENT_OFFER_SOURCE_CODE	VARCHAR2	(30)		event offer source code
EVENT_OFFER_STATUS_CODE	VARCHAR2	(30)	Yes	event offer status code
EVENT_OFFER_STATUS_DATE	DATE		Yes	event offer status date
EVENT_OFFER_ACTIVE_FLAG	VARCHAR2	(1)	Yes	event offer active flag
REG_REQUIRED_FLAG	VARCHAR2	(1)	Yes	reg requested flag
EVENT_LANGUAGE_CODE	VARCHAR2	(30)		event language code
EVENT_LOCATION_CODE	VARCHAR2	(246)		event location code
EVENT_STAND_ALONE_FLAG	VARCHAR2	(1)	Yes	event stand alone flag
MAIN_EVENT_OFFER_ID	VARCHAR2	(44)		main event offer id
EVENT_OFFER_DURATION	NUMBER	(15)		event offer duration
EVENT_OFFER_START_DATE	DATE			event offer start date
EVENT_OFFER_END_DATE	DATE			event offer end date
REG_START_DATE	DATE			reg start date
REG_END_DATE	DATE			reg end date
INVENTORY_ITEM_ID	NUMBER	(38)		inventorry item id
ORG_ID	VARCHAR2	(0)		organization id

Query Text

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


SELECT ID
,      VALUE
,      EVENT_OFFER_ID
,      EVENT_OFFER_NAME
,      EVENT_OFFER_DESCRIPTION
,      EVENT_HEADER_ID
,      PARENT_EVENT_OFFER_ID
,      EVENT_OFFER_SOURCE_CODE
,      EVENT_OFFER_STATUS_CODE
,      EVENT_OFFER_STATUS_DATE
,      EVENT_OFFER_ACTIVE_FLAG
,      REG_REQUIRED_FLAG
,      EVENT_LANGUAGE_CODE
,      EVENT_LOCATION_CODE
,      EVENT_STAND_ALONE_FLAG
,      MAIN_EVENT_OFFER_ID
,      EVENT_OFFER_DURATION
,      EVENT_OFFER_START_DATE
,      EVENT_OFFER_END_DATE
,      REG_START_DATE
,      REG_END_DATE
,      INVENTORY_ITEM_ID
,      ORG_ID
FROM APPS.BIM_DIMV_EVENT_OFFERS;

Dependencies

[top of page]

APPS.BIM_DIMV_EVENT_OFFERS references the following:

APPS: AMS_EVENT_OFFERS_VL; HZ_LOCATIONS

APPS.BIM_DIMV_EVENT_OFFERS is not referenced by any database object