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]

VIEW: APPS.IGS_EN_OR_UNIT_WLST

Object Details

Object Name:	IGS_EN_OR_UNIT_WLST
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGS_EN_OR_UNIT_WLST
Subobject Name:
Status:	VALID

View Type

A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.

This view describes the various organization unit wait list options.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)
ORG_ID	NUMBER	(15)		Operating Unit Identifier.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
ORG_UNIT_WLST_ID	NUMBER		Yes	A unique number which identifies an organisation unit waitlist
ORG_UNIT_CD	VARCHAR2	(30)	Yes	This field represents organisation unit code.
START_DT	DATE		Yes	This field describes the start date for a waitlist.
CAL_TYPE	VARCHAR2	(10)	Yes	The name of a load calendar type associated with the specified waitlist
SEQUENCE_NUMBER	VARCHAR2	(0)		This is a number that holds the waitlist sequence for a specific unit for internal processing -Obsolete
WAITLIST_ALWD	VARCHAR2	(0)		An indicator which specifies whether waitlist is allowed over a specific calendar instance. If not checked then no waitlists can be recorded for the corresponding calendar instance. -Obsolete
MAX_WLST_PER_STUD	VARCHAR2	(0)		This identifies the maximum number of waitlists a student can be in for a given calendar instance. -Obsolete
MAX_STUD_PER_WLST	NUMBER	(10)		This field represents the maximum number of students who can be in a waitlist.
SMTANUS_WLST_UNIT_ENR_ALWD	VARCHAR2	(1)	Yes	An indicator which identifies whether more than one student can be allowed waiting for a unit enrolment in the given calendar instance.
ASSES_CHRG_FOR_WLST_STUD	VARCHAR2	(1)	Yes	An indicator which identifies whether unit or course charges should be assessed for a student in the waitlist.
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
CLOSED_FLAG	VARCHAR2	(1)	Yes	Indicates if the record is closed or active. Allowable values are N and Y.

Query Text

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


SELECT ROW_ID
,      ORG_ID
,      LAST_UPDATE_LOGIN
,      ORG_UNIT_WLST_ID
,      ORG_UNIT_CD
,      START_DT
,      CAL_TYPE
,      SEQUENCE_NUMBER
,      WAITLIST_ALWD
,      MAX_WLST_PER_STUD
,      MAX_STUD_PER_WLST
,      SMTANUS_WLST_UNIT_ENR_ALWD
,      ASSES_CHRG_FOR_WLST_STUD
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      CLOSED_FLAG
FROM APPS.IGS_EN_OR_UNIT_WLST;

Dependencies

[top of page]

APPS.IGS_EN_OR_UNIT_WLST references the following:

APPS: IGS_EN_OR_UNIT_WLST_ALL

APPS.IGS_EN_OR_UNIT_WLST is referenced by following:

APPS: IGS_EN_ENROLL_WLST - show dependent code; IGS_EN_OR_UNIT_WLST_V; IGS_EN_PRC_LOAD - show dependent code; IGS_EN_SUA_API - show dependent code; IGS_EN_WLST_GEN_PROC - show dependent code; IGS_SS_ENR_DETAILS - show dependent code