[Home] [Help] [Dependency Information]
Object Name: | AMS_EVENT_OFFERS_AGENDA_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | AMS.AMS_EVENT_OFFERS_AGENDA_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Unique identifier generated by the database | |
INBOUND_SCRIPT_NAME | VARCHAR2 | (240) | Name of the inbound script | |
STREAM_TYPE_CODE | VARCHAR2 | (30) | Unique code used across systems | |
OWNER_USER_ID | NUMBER | Yes | Unique identifier | |
EVENT_OFFER_ID | NUMBER | Yes | Unique identifier | |
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) | This column is used for locking purposes | |
APPLICATION_ID | NUMBER | (15) | Yes | Unique identifier |
EVENT_HEADER_ID | NUMBER | Unique identifier | ||
EVENT_HEADER_NAME | VARCHAR2 | (240) | Name of the event header | |
PRIVATE_FLAG | VARCHAR2 | (1) | Yes | Flag to indicate the event's accessibility |
ACTIVE_FLAG | VARCHAR2 | (1) | Yes | Flag to indicate the event state |
EVENT_LEVEL | VARCHAR2 | (30) | Yes | Indicates event offering level |
USER_STATUS_ID | NUMBER | Yes | Unique identifier | |
USER_STATUS | VARCHAR2 | (120) | Information about the event user status | |
LAST_STATUS_DATE | DATE | Yes | Date to indicate the last time status changed. | |
SYSTEM_STATUS_CODE | VARCHAR2 | (30) | Yes | Unique identifier used across systems |
EVENT_DELIVERY_METHOD_ID | NUMBER | Unique identifier | ||
EVENT_DELIVERY_METHOD_NAME | VARCHAR2 | (80) | Name of the mode of delivery for this event | |
EVENT_REQUIRED_FLAG | VARCHAR2 | (1) | Flag to indicate if this event is mandatory | |
EVENT_LANGUAGE_CODE | VARCHAR2 | (30) | Language code of the event. | |
EVENT_LANGUAGE | VARCHAR2 | (30) | Language of the event. | |
EVENT_VENUE_ID | NUMBER | Unique identifier | ||
EVENT_VENUE_NAME | VARCHAR2 | (120) | Name of the event venue | |
EVENT_LOCATION_ID | NUMBER | Unique identifier | ||
EVENT_LOCATION | VARCHAR2 | (184) | Describes event location | |
CITY | VARCHAR2 | (60) | Event city | |
STATE | VARCHAR2 | (60) | Event state | |
PROVINCE | VARCHAR2 | (60) | Event location details | |
COUNTRY | VARCHAR2 | (60) | Event location details | |
PARTNER_FLAG | VARCHAR2 | (1) | Yes | Flag to indicate if a partner is taking part in the event |
EVENT_STANDALONE_FLAG | VARCHAR2 | (1) | Yes | Flag to indicate if this event is one time only |
PARENT_EVENT_OFFER_ID | NUMBER | Unique identifier | ||
PARENT_EVENT_OFFER_NAME | VARCHAR2 | (240) | Name of the parent event offer | |
EVENT_START_DATE | DATE | Start date of the event | ||
EVENT_START_DATE_TIME | DATE | Start time of the event | ||
EVENT_END_DATE | DATE | End date of the event | ||
EVENT_END_DATE_TIME | DATE | End time of the event | ||
CERTIFICATION_CREDIT_TYPE | VARCHAR2 | (30) | Credits applicable towards registration fee | |
CERTIFICATION_CREDITS | NUMBER | (15) | Details of certification credits | |
COORDINATOR_ID | NUMBER | Unique identifier | ||
URL | VARCHAR2 | (4000) | Internet address of the event | |
PHONE | VARCHAR2 | (25) | Contact details | |
VARCHAR2 | (120) | Contact details | ||
TIMEZONE_ID | NUMBER | (15) | Unique identifier | |
TIMEZONE_NAME | VARCHAR2 | (80) | Timezone name this event is held in. | |
EVENT_OFFER_NAME | VARCHAR2 | (240) | Yes | Name of event being offered. |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, INBOUND_SCRIPT_NAME
, STREAM_TYPE_CODE
, OWNER_USER_ID
, EVENT_OFFER_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
, APPLICATION_ID
, EVENT_HEADER_ID
, EVENT_HEADER_NAME
, PRIVATE_FLAG
, ACTIVE_FLAG
, EVENT_LEVEL
, USER_STATUS_ID
, USER_STATUS
, LAST_STATUS_DATE
, SYSTEM_STATUS_CODE
, EVENT_DELIVERY_METHOD_ID
, EVENT_DELIVERY_METHOD_NAME
, EVENT_REQUIRED_FLAG
, EVENT_LANGUAGE_CODE
, EVENT_LANGUAGE
, EVENT_VENUE_ID
, EVENT_VENUE_NAME
, EVENT_LOCATION_ID
, EVENT_LOCATION
, CITY
, STATE
, PROVINCE
, COUNTRY
, PARTNER_FLAG
, EVENT_STANDALONE_FLAG
, PARENT_EVENT_OFFER_ID
, PARENT_EVENT_OFFER_NAME
, EVENT_START_DATE
, EVENT_START_DATE_TIME
, EVENT_END_DATE
, EVENT_END_DATE_TIME
, CERTIFICATION_CREDIT_TYPE
, CERTIFICATION_CREDITS
, COORDINATOR_ID
, URL
, PHONE
, EMAIL
, TIMEZONE_ID
, TIMEZONE_NAME
, EVENT_OFFER_NAME
FROM APPS.AMS_EVENT_OFFERS_AGENDA_V;
APPS.AMS_EVENT_OFFERS_AGENDA_V is not referenced by any database object
|
|
|