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]

TABLE: OTA.OTA_PROGRAM_MEMBERSHIPS

Object Details

Object Name:	OTA_PROGRAM_MEMBERSHIPS
Object Type:	TABLE
Owner:	OTA
FND Design Data:	OTA.OTA_PROGRAM_MEMBERSHIPS
Subobject Name:
Status:	VALID

Program membership records which scheduled events are within a
program.
It is possible to specify whether the scheduled event is a required
member of the program. You can also group scheduled events within the
program.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: OTA_PROGRAM_MEMBERSHIPS_PK

PROGRAM_MEMBERSHIP_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
OTA_PROGRAM_MEMBERSHIPS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	PROGRAM_MEMBERSHIP_ID
OTA_PROGRAM_MEMBERSHIPS_FK1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EVENT_ID
OTA_PROGRAM_MEMBERSHIPS_FK2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROGRAM_EVENT_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
OTA_PROGRAM_MEMBERSHIPS		OTA_EVENTS	OTA_PROGRAM_MEMBERSHIPS PROGRAM_EVENT_ID
OTA_PROGRAM_MEMBERSHIPS		OTA_EVENTS	OTA_PROGRAM_MEMBERSHIPS EVENT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PROGRAM_MEMBERSHIP_ID	NUMBER	(9)	Yes	The unique identifier of Program Membership
EVENT_ID	NUMBER	(9)	Yes	Foreign key to OTA_EVENTS
PROGRAM_EVENT_ID	NUMBER	(9)	Yes	Foreign key to OTA_EVENTS
OBJECT_VERSION_NUMBER	NUMBER	(5)	Yes	Version control parameter
COMMENTS	VARCHAR2	(2000)		Comments
GROUP_NAME	VARCHAR2	(30)		The group or set of events to which the evnt belongs in program
REQUIRED_FLAG	VARCHAR2	(30)		An indicaiton of whether event is required as part of the program
ROLE	VARCHAR2	(30)		A description of the type of membership within the program
SEQUENCE	NUMBER	(9)		An indicaition of order in which events should be taken
LAST_UPDATE_DATE	DATE			Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)		Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who Column
CREATED_BY	NUMBER	(15)		Standard Who Column
CREATION_DATE	DATE			Standard Who Column
PMM_INFORMATION_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure defining column
PMM_INFORMATION1	VARCHAR2	(150)		Descriptive flexfield segment column
PMM_INFORMATION2	VARCHAR2	(150)		Descriptive flexfield segment column
PMM_INFORMATION3	VARCHAR2	(150)		Descriptive flexfield segment column
PMM_INFORMATION4	VARCHAR2	(150)		Descriptive flexfield segment column
PMM_INFORMATION5	VARCHAR2	(150)		Descriptive flexfield segment column
PMM_INFORMATION6	VARCHAR2	(150)		Descriptive flexfield segment column
PMM_INFORMATION7	VARCHAR2	(150)		Descriptive flexfield segment column
PMM_INFORMATION8	VARCHAR2	(150)		Descriptive flexfield segment column
PMM_INFORMATION9	VARCHAR2	(150)		Descriptive flexfield segment column
PMM_INFORMATION10	VARCHAR2	(150)		Descriptive flexfield segment column
PMM_INFORMATION11	VARCHAR2	(150)		Descriptive flexfield segment column
PMM_INFORMATION12	VARCHAR2	(150)		Descriptive flexfield segment column
PMM_INFORMATION13	VARCHAR2	(150)		Descriptive flexfield segment column
PMM_INFORMATION14	VARCHAR2	(150)		Descriptive flexfield segment column
PMM_INFORMATION15	VARCHAR2	(150)		Descriptive flexfield segment column
PMM_INFORMATION16	VARCHAR2	(150)		Descriptive flexfield segment column
PMM_INFORMATION17	VARCHAR2	(150)		Descriptive flexfield segment column
PMM_INFORMATION18	VARCHAR2	(150)		Descriptive flexfield segment column
PMM_INFORMATION19	VARCHAR2	(150)		Descriptive flexfield segment column
PMM_INFORMATION20	VARCHAR2	(150)		Descriptive flexfield segment column

Query Text

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


SELECT PROGRAM_MEMBERSHIP_ID
,      EVENT_ID
,      PROGRAM_EVENT_ID
,      OBJECT_VERSION_NUMBER
,      COMMENTS
,      GROUP_NAME
,      REQUIRED_FLAG
,      ROLE
,      SEQUENCE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      PMM_INFORMATION_CATEGORY
,      PMM_INFORMATION1
,      PMM_INFORMATION2
,      PMM_INFORMATION3
,      PMM_INFORMATION4
,      PMM_INFORMATION5
,      PMM_INFORMATION6
,      PMM_INFORMATION7
,      PMM_INFORMATION8
,      PMM_INFORMATION9
,      PMM_INFORMATION10
,      PMM_INFORMATION11
,      PMM_INFORMATION12
,      PMM_INFORMATION13
,      PMM_INFORMATION14
,      PMM_INFORMATION15
,      PMM_INFORMATION16
,      PMM_INFORMATION17
,      PMM_INFORMATION18
,      PMM_INFORMATION19
,      PMM_INFORMATION20
FROM OTA.OTA_PROGRAM_MEMBERSHIPS;

Dependencies

[top of page]

OTA.OTA_PROGRAM_MEMBERSHIPS does not reference any database object

OTA.OTA_PROGRAM_MEMBERSHIPS is referenced by following:

APPS: OTA_PROGRAM_MEMBERSHIPS; OTA_PROGRAM_MEMBERSHIPS_WHO