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

VIEW: APPS.IGSBV_USEC_WLST_PREFERENCES

Object Details
Object Name: IGSBV_USEC_WLST_PREFERENCES
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGS.IGSBV_USEC_WLST_PREFERENCES
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


This is the base view which captures the Waitlist Preferences for a Unit Section.


[View Source]

Columns
Name Datatype Length Mandatory Comments
UNIT_SEC_WAITLIST_PREF_ID NUMBER (10) Yes Unique identifier for the waitlist preferences for a unit section.
UNIT_SEC_WAITLIST_PRIORITY_ID NUMBER (10) Yes Unique identifier for the unit section waitlist priority.
PREFERENCE_ORDER NUMBER (6) Yes Order of preference.
PREFERENCE_CODE VARCHAR2 (30) Yes Unit section waitlist preference code.
PREFERENCE_VERSION VARCHAR2 (3)
Unit section waitlist preference version.
_LA:USEC_WLST_PRIORITY_VALUE CHAR (62)
Unit section priority value.
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.
Query Text

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


SELECT UNIT_SEC_WAITLIST_PREF_ID
,      UNIT_SEC_WAITLIST_PRIORITY_ID
,      PREFERENCE_ORDER
,      PREFERENCE_CODE
,      PREFERENCE_VERSION
,      _LA:USEC_WLST_PRIORITY_VALUE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSBV_USEC_WLST_PREFERENCES;

Dependencies

[top of page]

APPS.IGSBV_USEC_WLST_PREFERENCES references the following:

SchemaAPPS
SynonymIGS_PS_USEC_WLST_PRF
SynonymIGS_PS_USEC_WLST_PRI

APPS.IGSBV_USEC_WLST_PREFERENCES is not referenced by any database object