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_HIER

Object Details

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

View Type

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

BIM_DIMV_EVENT_HIER is a view showing relationship between events and event offerings.
.

[View Source]

Columns

Name	Datatype	Length	Comments
EVENT_ID	VARCHAR2	(44)	event id
EVENT_NAME	VARCHAR2	(240)	event name
EVENT_DESCRIPTION	VARCHAR2	(4000)	event description
EVENT_TYPE_CODE	VARCHAR2	(30)	event type code
EVENT_TYPE_NAME	VARCHAR2	(80)	event type name
EVENT_LEVEL	VARCHAR2	(30)	event level
EVENT_STATUS_CODE	VARCHAR2	(30)	event status code
EVENT_STATUS_DATE	DATE		event status date
EVENT_SOURCE_CODE	VARCHAR2	(30)	event source code
EVENT_STANDALONE_FLAG	VARCHAR2	(1)	event standalone flag
ACTIVE_FROM_DATE	DATE		active from date
ACTIVE_TO_DATE	DATE		active to date
EVENT_ACTIVE_FLAG	VARCHAR2	(1)	event active flag
EVENT_ITEM_ID	NUMBER		event item id
PARENT_EVENT_HEADER_ID	VARCHAR2	(44)	parent event header id
ORG_ID	VARCHAR2	(0)	organization id
EVENT_OFFER_ID	VARCHAR2	(44)	event offer id
EVENT_OFFER_NAME	VARCHAR2	(240)	event offer name
EVENT_OFFER_DESCRIPTION	VARCHAR2	(4000)	event offer description
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)	event offer status code
EVENT_OFFER_STATUS_DATE	DATE		event offer status date
EVENT_OFFER_ACTIVE_FLAG	VARCHAR2	(1)	event offer active flag
EVENT_OFFER_DURATION	NUMBER		event offer duration
EVENT_OFFER_START_DATE	DATE		event offer start date
EVENT_OFFER_END_DATE	DATE		event offer end date
EVENT_OFFER_REG_START_DATE	DATE		event offer reg start date
EVENT_OFFER_REG_END_DATE	DATE		event offer reg end date
EVENT_OFFER_ITEM_ID	NUMBER		event offer item id

Query Text

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


SELECT EVENT_ID
,      EVENT_NAME
,      EVENT_DESCRIPTION
,      EVENT_TYPE_CODE
,      EVENT_TYPE_NAME
,      EVENT_LEVEL
,      EVENT_STATUS_CODE
,      EVENT_STATUS_DATE
,      EVENT_SOURCE_CODE
,      EVENT_STANDALONE_FLAG
,      ACTIVE_FROM_DATE
,      ACTIVE_TO_DATE
,      EVENT_ACTIVE_FLAG
,      EVENT_ITEM_ID
,      PARENT_EVENT_HEADER_ID
,      ORG_ID
,      EVENT_OFFER_ID
,      EVENT_OFFER_NAME
,      EVENT_OFFER_DESCRIPTION
,      PARENT_EVENT_OFFER_ID
,      EVENT_OFFER_SOURCE_CODE
,      EVENT_OFFER_STATUS_CODE
,      EVENT_OFFER_STATUS_DATE
,      EVENT_OFFER_ACTIVE_FLAG
,      EVENT_OFFER_DURATION
,      EVENT_OFFER_START_DATE
,      EVENT_OFFER_END_DATE
,      EVENT_OFFER_REG_START_DATE
,      EVENT_OFFER_REG_END_DATE
,      EVENT_OFFER_ITEM_ID
FROM APPS.BIM_DIMV_EVENT_HIER;

Dependencies

[top of page]

APPS.BIM_DIMV_EVENT_HIER references the following:

APPS: AMS_EVENT_HEADERS_VL; AMS_EVENT_OFFERS_VL; AMS_LOOKUPS; FND_GLOBAL - show dependent code; FND_LOOKUPS

APPS.BIM_DIMV_EVENT_HIER is referenced by following:

APPS: BIM_SUMV_EVENT_PERF; BIM_SUMV_EVENT_REV; BIM_SUMV_EVENT_RSLTS