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_MAND_MULTI_ENR_REQUESTS

Object Details

Object Name:	OTA_MAND_MULTI_ENR_REQUESTS
Object Type:	TABLE
Owner:	OTA
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
MANDATORY_ENR_REQUEST_ID	NUMBER	(15)	Yes	Mandatory Enr Request Id is used to uniquely identify the concurrent program request.
REQUESTOR_ID	NUMBER	(15)		A person who requested the mandatory enrollment concurrent program.
EVENT_ID	NUMBER	(15)		Id of the class for which the mandatry enrollment request need to be processed.
ENR_PREREQ_TYPE	VARCHAR2	(1)	Yes	Required Prerequisites type for the mandatory enrollment in a class.
PERSON_ID	NUMBER	(15)		Person id of the learner for whom mandatory enrollment need to be processed.
ORGANIZATION_ID	NUMBER	(15)		Organization id for which the mandatory enrollment need to be processed.
ORG_STRUCTURE_VERSION_ID	NUMBER	(15)		Organization Hierarchy to be processed.
JOB_ID	NUMBER	(15)		Job id for which the mandatory enrollment need to be processed.
POSITION_ID	VARCHAR2	(15)		Position Id for which the mandatory enrollment need to be processed.
USERGROUP_ID	NUMBER	(15)		Learner Group Id for which the mandatory enrollment need to be processed.
CONC_PROGRAM_REQUEST_ID	NUMBER	(15)		Concurrent Program Request Id which processes the current mandatory enrollment request.
CERTIFICATION_ID	NUMBER	(15)		Certification Id for which the automatic subscription need to be processed.

Query Text

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


SELECT MANDATORY_ENR_REQUEST_ID
,      REQUESTOR_ID
,      EVENT_ID
,      ENR_PREREQ_TYPE
,      PERSON_ID
,      ORGANIZATION_ID
,      ORG_STRUCTURE_VERSION_ID
,      JOB_ID
,      POSITION_ID
,      USERGROUP_ID
,      CONC_PROGRAM_REQUEST_ID
,      CERTIFICATION_ID
FROM OTA.OTA_MAND_MULTI_ENR_REQUESTS;

Dependencies

[top of page]

OTA.OTA_MAND_MULTI_ENR_REQUESTS does not reference any database object

OTA.OTA_MAND_MULTI_ENR_REQUESTS is referenced by following:

OTA: OTA_MAND_MULTI_ENR_REQUESTS#