DBA Data[Home] [Help] [Dependency Information]

TABLE: AMS.AMS_AGENDAS_B

Object Details
Object Name: AMS_AGENDAS_B
Object Type: TABLE
Owner: AMS
FND Design Data: TableAMS.AMS_AGENDAS_B
Subobject Name:
Status: VALID


Stores all the agenda information contains track and sessions.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AMS_AGENDAS_B_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnAGENDA_ID
AMS_AGENDAS_B_N17 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSTART_DATE_TIME
AMS_AGENDAS_B_N18 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnEND_DATE_TIME
AMS_AGENDAS_B_N20 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnROOM_ID
AMS_AGENDAS_B_N21 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPARENT_TYPE
ColumnPARENT_ID
Columns
Name Datatype Length Mandatory Comments
AGENDA_ID NUMBER
Yes Unique Id
LAST_UPDATE_DATE DATE

Standard Who Column
SETUP_TYPE_ID NUMBER

Holds custom setup id
CREATION_DATE DATE

Standard Who Column
LAST_UPDATED_BY NUMBER (15)
Standard Who Column
CREATED_BY NUMBER (15)
Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15) Yes Standard Who Column
OBJECT_VERSION_NUMBER NUMBER (9)
This column is used for locking purposes
APPLICATION_ID NUMBER

Holds Application ID
ACTIVE_FLAG VARCHAR2 (1)
used for soft delete . If the value is 'N' then the record is deleted.
DEFAULT_TRACK_FLAG VARCHAR2 (1)
holds the value 'Y" if the trtack got created by default.
AGENDA_TYPE VARCHAR2 (30)
Holds the value of the agenda type.
ROOM_ID NUMBER

holds the venue Id of a room attahed to this agenda.
START_DATE_TIME DATE

holds the start date and time of the agenda.
END_DATE_TIME DATE

holds the end date and time of the agenda
COORDINATOR_ID NUMBER

holds the primery coordinator's party id
TIMEZONE_ID VARCHAR2 (240)
holds the time zone id , teels the time zone of the time recorded.
SECURITY_GROUP_ID NUMBER

for vertual database
ATTRIBUTE_CATEGORY VARCHAR2 (240)
Descriptive flexfiled structure defining column.
PARENT_TYPE VARCHAR2 (30)
Agenda type of the parent of the agenda
PARENT_ID NUMBER

holds the parent _id of the agenda.
ATTRIBUTE1 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (240)
Descriptive flexfield segment
Query Text

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


SELECT AGENDA_ID
,      LAST_UPDATE_DATE
,      SETUP_TYPE_ID
,      CREATION_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      APPLICATION_ID
,      ACTIVE_FLAG
,      DEFAULT_TRACK_FLAG
,      AGENDA_TYPE
,      ROOM_ID
,      START_DATE_TIME
,      END_DATE_TIME
,      COORDINATOR_ID
,      TIMEZONE_ID
,      SECURITY_GROUP_ID
,      ATTRIBUTE_CATEGORY
,      PARENT_TYPE
,      PARENT_ID
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
FROM AMS.AMS_AGENDAS_B;

Dependencies

[top of page]

AMS.AMS_AGENDAS_B does not reference any database object

AMS.AMS_AGENDAS_B is referenced by following:

SchemaAPPS
SynonymAMS_AGENDAS_B