[Home] [Help] [Dependency Information]
Object Name: | BIM_DIMV_EVENT_OFFERS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | BIM.BIM_DIMV_EVENT_OFFERS |
Subobject Name: | |
Status: | VALID |
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.
.
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 |
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;
APPS.BIM_DIMV_EVENT_OFFERS is not referenced by any database object
|
|
|