[Home] [Help] [Dependency Information]
Object Name: | IGS_SS_USEC_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGS_SS_USEC_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
UNIT_CD | VARCHAR2 | (10) | Yes | |
VERSION_NUMBER | NUMBER | (3) | Yes | |
UNIT_STATUS | VARCHAR2 | (10) | Yes | |
TITLE | VARCHAR2 | (90) | Yes | |
SHORT_TITLE | VARCHAR2 | (40) | Yes | |
TITLE_OVERRIDE_IND | VARCHAR2 | (1) | Yes | |
ABBREVIATION | VARCHAR2 | (20) | Yes | |
ORG_UNIT_CD | VARCHAR2 | (30) | Yes | |
UOO_ID | NUMBER | (7) | Yes | |
CAL_TYPE | VARCHAR2 | (10) | Yes | |
CI_SEQUENCE_NUMBER | NUMBER | (6) | Yes | |
CALL_NUMBER | NUMBER | |||
UNIT_SECTION_STATUS | VARCHAR2 | (30) | ||
UNIT_CLASS | VARCHAR2 | (10) | Yes | |
LOCATION_CD | VARCHAR2 | (10) | Yes | |
ENROLLMENT_ACTUAL | NUMBER | (6) | ||
WAITLIST_ACTUAL | NUMBER | (6) | ||
UNIT_SECTION_START_DT | DATE | Unit Section Start Date | ||
UNIT_SECTION_END_DT | DATE | Unit Section End Date | ||
START_DATE | VARCHAR2 | (11) | ||
END_DATE | VARCHAR2 | (11) | ||
TEACH_CAL_DESCRIPTION | VARCHAR2 | (30) | Teaching Calendar Instance Description | |
ENROLLMENT_MINIMUM | NUMBER | Enrollment Minimum | ||
ENROLLMENT_MAXIMUM | NUMBER | |||
MAX_STUDENTS_PER_WAITLIST | NUMBER | |||
SS_DISPLAY_IND | VARCHAR2 | (1) | ||
SS_ENROL_IND | VARCHAR2 | (1) | ||
AUDITABLE_IND | VARCHAR2 | (1) | Indicates whether the unit can be attempted for Audit. | |
SUP_UOO_ID | NUMBER | Superior unit section identifier | ||
RELATION_TYPE | VARCHAR2 | (30) | Relation type. Superior, subordinate or none | |
PRACTICAL_IND | VARCHAR2 | (1) | Yes | Placement Indicator |
NON_STD_USEC_FLAG | VARCHAR2 | (1) | Flag indicates whether the unit section is non standard unit section or not. |
Cut, paste (and edit) the following text to query this object:
SELECT UNIT_CD
, VERSION_NUMBER
, UNIT_STATUS
, TITLE
, SHORT_TITLE
, TITLE_OVERRIDE_IND
, ABBREVIATION
, ORG_UNIT_CD
, UOO_ID
, CAL_TYPE
, CI_SEQUENCE_NUMBER
, CALL_NUMBER
, UNIT_SECTION_STATUS
, UNIT_CLASS
, LOCATION_CD
, ENROLLMENT_ACTUAL
, WAITLIST_ACTUAL
, UNIT_SECTION_START_DT
, UNIT_SECTION_END_DT
, START_DATE
, END_DATE
, TEACH_CAL_DESCRIPTION
, ENROLLMENT_MINIMUM
, ENROLLMENT_MAXIMUM
, MAX_STUDENTS_PER_WAITLIST
, SS_DISPLAY_IND
, SS_ENROL_IND
, AUDITABLE_IND
, SUP_UOO_ID
, RELATION_TYPE
, PRACTICAL_IND
, NON_STD_USEC_FLAG
FROM APPS.IGS_SS_USEC_V;
|
|
|