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_VENUES_V

Object Details

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

View Type

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

This view retrives venue information

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Unique identifier generated by the database
VENUE_ID	NUMBER		Yes	Unique identifier
CREATION_DATE	DATE		Yes	Standard WHO Column
CREATED_BY	NUMBER	(15)	Yes	Standard WHO Column
LAST_UPDATE_DATE	DATE		Yes	Standard WHO Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO Column
OBJECT_VERSION_NUMBER	NUMBER	(9)		Used for optimistic locking.
DIRECT_PHONE_FLAG	VARCHAR2	(1)	Yes	Whether the venue has a direct phone.
INTERNAL_FLAG	VARCHAR2	(1)	Yes	Internal Venue?
ENABLED_FLAG	VARCHAR2	(1)	Yes	Is the target market still in use?
RATING_CODE	VARCHAR2	(30)		What is the rating for this Venue.
CAPACITY	NUMBER	(15)		Venue capacity.
AREA_SIZE	NUMBER			Area of the Venue.
AREA_SIZE_UOM_CODE	VARCHAR2	(3)		UOM for Area.
CEILING_HEIGHT	NUMBER	(15)		Ceiling Height of the Venue.
CEILING_HEIGHT_UOM_CODE	VARCHAR2	(3)		UOM for the ceiling height.
USAGE_COST	NUMBER			Cost of usage.
USAGE_COST_UOM_CODE	VARCHAR2	(30)		UOM for the usage cost.
USAGE_COST_CURRENCY_CODE	VARCHAR2	(15)		Currency code for the cost of usage.
PARENT_VENUE_ID	NUMBER			Venue ID of the parent if parent exists.
LOCATION_ID	NUMBER	(15)		Location ID as in HZ_LOCATIONS.
DIRECTIONS	VARCHAR2	(4000)		Driving Directions.
VENUE_CODE	VARCHAR2	(30)		For OSM upgrade
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Desciptive Flexfield structure defining column.
ATTRIBUTE1	VARCHAR2	(150)		Desciptive Flexfield structure
ATTRIBUTE2	VARCHAR2	(150)		Desciptive Flexfield structure
ATTRIBUTE3	VARCHAR2	(150)		Desciptive Flexfield structure
ATTRIBUTE4	VARCHAR2	(150)		Desciptive Flexfield structure
ATTRIBUTE5	VARCHAR2	(150)		Desciptive Flexfield structure
ATTRIBUTE6	VARCHAR2	(150)		Desciptive Flexfield structure
ATTRIBUTE7	VARCHAR2	(150)		Desciptive Flexfield structure
ATTRIBUTE8	VARCHAR2	(150)		Desciptive Flexfield structure
ATTRIBUTE9	VARCHAR2	(150)		Desciptive Flexfield structure
ATTRIBUTE10	VARCHAR2	(150)		Desciptive Flexfield structure
ATTRIBUTE11	VARCHAR2	(150)		Desciptive Flexfield structure
ATTRIBUTE12	VARCHAR2	(150)		Desciptive Flexfield structure
ATTRIBUTE13	VARCHAR2	(150)		Desciptive Flexfield structure
ATTRIBUTE14	VARCHAR2	(150)		Desciptive Flexfield structure
ATTRIBUTE15	VARCHAR2	(150)		Desciptive Flexfield structure
VENUE_TYPE_CODE	VARCHAR2	(30)	Yes	Type of Venue.
ROOM_NAME	VARCHAR2	(120)	Yes	Name of the Room
DESCRIPTION	VARCHAR2	(4000)		Venue Description.
CITY	VARCHAR2	(60)		City Name
STATE	VARCHAR2	(60)		State Name
COUNTRY	VARCHAR2	(60)		Country Name
POSTAL_CODE	VARCHAR2	(60)		Postal Code
ADDRESS1	VARCHAR2	(240)		Address line 1
ADDRESS2	VARCHAR2	(240)		Address line2
ADDRESS3	VARCHAR2	(240)		Address line3
ADDRESS4	VARCHAR2	(240)		Address line4
VENUE_NAME	VARCHAR2	(360)		Name of the Venue.
CUSTOM_SETUP_ID	NUMBER			Identifier for the setup of the venue.
PARTY_ID	NUMBER			Identifier of the Organization created for the venue
TELECOM_CODE	VARCHAR2	(30)		Code for telecom facility available in the room.
OBJECT_TYPE	VARCHAR2	(30)		Code to indicate if the object is venue or room.

Query Text

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


SELECT ROW_ID
,      VENUE_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      DIRECT_PHONE_FLAG
,      INTERNAL_FLAG
,      ENABLED_FLAG
,      RATING_CODE
,      CAPACITY
,      AREA_SIZE
,      AREA_SIZE_UOM_CODE
,      CEILING_HEIGHT
,      CEILING_HEIGHT_UOM_CODE
,      USAGE_COST
,      USAGE_COST_UOM_CODE
,      USAGE_COST_CURRENCY_CODE
,      PARENT_VENUE_ID
,      LOCATION_ID
,      DIRECTIONS
,      VENUE_CODE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      VENUE_TYPE_CODE
,      ROOM_NAME
,      DESCRIPTION
,      CITY
,      STATE
,      COUNTRY
,      POSTAL_CODE
,      ADDRESS1
,      ADDRESS2
,      ADDRESS3
,      ADDRESS4
,      VENUE_NAME
,      CUSTOM_SETUP_ID
,      PARTY_ID
,      TELECOM_CODE
,      OBJECT_TYPE
FROM APPS.AMS_VENUES_V;

Dependencies

[top of page]

APPS.AMS_VENUES_V references the following:

APPS: AMS_VENUES_VL; HZ_PARTIES; HZ_PARTY_SITES

APPS.AMS_VENUES_V is referenced by following:

APPS: AST_LM_EVENTS_SRC_V; AST_LM_EVENTS_V