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_V

Object Details

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

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)
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.
ORG_START_DT	DATE		Yes	This field describes the start date for a waitlist.
DESCRIPTION	VARCHAR2	(360)	Yes	this field describes the organization code.
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
CAL_DESC	VARCHAR2	(60)	Yes	Calendar type description
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
LAST_UPDATE_LOGIN	NUMBER	(15)		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_UNIT_WLST_ID
,      ORG_UNIT_CD
,      ORG_START_DT
,      DESCRIPTION
,      CAL_TYPE
,      SEQUENCE_NUMBER
,      CAL_DESC
,      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
,      LAST_UPDATE_LOGIN
,      CLOSED_FLAG
FROM APPS.IGS_EN_OR_UNIT_WLST_V;

Dependencies

[top of page]

APPS.IGS_EN_OR_UNIT_WLST_V references the following:

APPS: HZ_PARTIES; IGS_CA_TYPE; IGS_EN_OR_UNIT_WLST; IGS_PE_HZ_PARTIES

APPS.IGS_EN_OR_UNIT_WLST_V is referenced by following:

APPS: IGS_EN_SUA_API - show dependent code