[Home] [Help]
[Dependency Information]
VIEW: APPS.IGS_PS_UNIT_OFR_OPT
Object Details
Object Name: | IGS_PS_UNIT_OFR_OPT |
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGS_PS_UNIT_OFR_OPT
|
---|
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.
[View Source]
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
ROW_ID |
ROWID |
(10) |
|
|
UNIT_CD |
VARCHAR2 |
(10) |
Yes |
|
VERSION_NUMBER |
NUMBER |
(3) |
Yes |
|
CAL_TYPE |
VARCHAR2 |
(10) |
Yes |
|
CI_SEQUENCE_NUMBER |
NUMBER |
(6) |
Yes |
|
LOCATION_CD |
VARCHAR2 |
(10) |
Yes |
|
UNIT_CLASS |
VARCHAR2 |
(10) |
Yes |
|
UOO_ID |
NUMBER |
(7) |
Yes |
|
IVRS_AVAILABLE_IND |
VARCHAR2 |
(1) |
Yes |
|
OFFERED_IND |
VARCHAR2 |
(1) |
Yes |
|
GRADING_SCHEMA_PRCDNCE_IND |
VARCHAR2 |
(1) |
Yes |
|
UNIT_QUOTA |
NUMBER |
(6) |
|
|
UNIT_QUOTA_RESERVED_PLACES |
NUMBER |
(6) |
|
|
UNIT_CONTACT |
NUMBER |
(15) |
|
|
GRADING_SCHEMA_CD |
VARCHAR2 |
(10) |
Yes |
|
GS_VERSION_NUMBER |
NUMBER |
(3) |
Yes |
|
CALL_NUMBER |
NUMBER |
|
|
|
UNIT_SECTION_STATUS |
VARCHAR2 |
(30) |
|
|
UNIT_SECTION_START_DATE |
DATE |
|
|
|
UNIT_SECTION_END_DATE |
DATE |
|
|
|
ENROLLMENT_ACTUAL |
NUMBER |
(6) |
|
|
WAITLIST_ACTUAL |
NUMBER |
(6) |
|
|
STATE_FINANCIAL_AID |
VARCHAR2 |
(1) |
|
|
FEDERAL_FINANCIAL_AID |
VARCHAR2 |
(1) |
|
|
INSTITUTIONAL_FINANCIAL_AID |
VARCHAR2 |
(1) |
|
|
OWNER_ORG_UNIT_CD |
VARCHAR2 |
(30) |
|
|
ATTENDANCE_REQUIRED_IND |
VARCHAR2 |
(1) |
|
|
NON_STD_USEC_IND |
VARCHAR2 |
(1) |
|
Indicates wether the Unit Section is Standard or Non Standard |
RESERVED_SEATING_ALLOWED |
VARCHAR2 |
(1) |
|
|
SPECIAL_PERMISSION_IND |
VARCHAR2 |
(1) |
|
|
SS_DISPLAY_IND |
VARCHAR2 |
(1) |
|
|
SS_ENROL_IND |
VARCHAR2 |
(1) |
|
Self Service Enrollment Indicator |
DIR_ENROLLMENT |
NUMBER |
(15) |
|
Direct enrollment |
ENR_FROM_WLST |
NUMBER |
(15) |
|
Enrolled from waitlist |
INQ_NOT_WLST |
NUMBER |
(15) |
|
Inquired but not waitlist |
REV_ACCOUNT_CD |
VARCHAR2 |
(40) |
|
|
ANON_UNIT_GRADING_IND |
VARCHAR2 |
(1) |
|
Anonymous Unit Grading Y / N |
ANON_ASSESS_GRADING_IND |
VARCHAR2 |
(1) |
|
Anonymous Assessment Item Grading Y / N |
CREATED_BY |
NUMBER |
(15) |
Yes |
|
CREATION_DATE |
DATE |
|
Yes |
|
LAST_UPDATED_BY |
NUMBER |
(15) |
Yes |
|
LAST_UPDATE_DATE |
DATE |
|
Yes |
|
LAST_UPDATE_LOGIN |
NUMBER |
(15) |
|
|
REQUEST_ID |
NUMBER |
(15) |
|
|
PROGRAM_APPLICATION_ID |
NUMBER |
(15) |
|
|
PROGRAM_ID |
NUMBER |
(15) |
|
|
PROGRAM_UPDATE_DATE |
DATE |
|
|
|
ORG_ID |
NUMBER |
(15) |
|
|
AUDITABLE_IND |
VARCHAR2 |
(1) |
|
Indicates if a unit can be audited |
AUDIT_PERMISSION_IND |
VARCHAR2 |
(1) |
|
Indicates if permission is required to audit |
NOT_MULTIPLE_SECTION_FLAG |
VARCHAR2 |
(1) |
|
Indicating whether this unit section should be excluded from multiple unit section. |
SUP_UOO_ID |
NUMBER |
|
|
The superior unit section's identifier for this unit section. |
RELATION_TYPE |
VARCHAR2 |
(30) |
|
Indicate whether this unit section is superior,subordinate or none of above. |
DEFAULT_ENROLL_FLAG |
VARCHAR2 |
(1) |
|
Indicate whether to enroll the subordinate unit section when the superior unit section is enrolled. |
ABORT_FLAG |
VARCHAR2 |
(1) |
Yes |
Flag to indicate whether the unit section is ABORTED. |
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, UNIT_CD
, VERSION_NUMBER
, CAL_TYPE
, CI_SEQUENCE_NUMBER
, LOCATION_CD
, UNIT_CLASS
, UOO_ID
, IVRS_AVAILABLE_IND
, OFFERED_IND
, GRADING_SCHEMA_PRCDNCE_IND
, UNIT_QUOTA
, UNIT_QUOTA_RESERVED_PLACES
, UNIT_CONTACT
, GRADING_SCHEMA_CD
, GS_VERSION_NUMBER
, CALL_NUMBER
, UNIT_SECTION_STATUS
, UNIT_SECTION_START_DATE
, UNIT_SECTION_END_DATE
, ENROLLMENT_ACTUAL
, WAITLIST_ACTUAL
, STATE_FINANCIAL_AID
, FEDERAL_FINANCIAL_AID
, INSTITUTIONAL_FINANCIAL_AID
, OWNER_ORG_UNIT_CD
, ATTENDANCE_REQUIRED_IND
, NON_STD_USEC_IND
, RESERVED_SEATING_ALLOWED
, SPECIAL_PERMISSION_IND
, SS_DISPLAY_IND
, SS_ENROL_IND
, DIR_ENROLLMENT
, ENR_FROM_WLST
, INQ_NOT_WLST
, REV_ACCOUNT_CD
, ANON_UNIT_GRADING_IND
, ANON_ASSESS_GRADING_IND
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, ORG_ID
, AUDITABLE_IND
, AUDIT_PERMISSION_IND
, NOT_MULTIPLE_SECTION_FLAG
, SUP_UOO_ID
, RELATION_TYPE
, DEFAULT_ENROLL_FLAG
, ABORT_FLAG
FROM APPS.IGS_PS_UNIT_OFR_OPT;
Dependencies
[top of page]
APPS.IGS_PS_UNIT_OFR_OPT references the following:
-
APPS
-
IGS_PS_UNIT_OFR_OPT_ALL
APPS.IGS_PS_UNIT_OFR_OPT is referenced by following:
-
APPS
-
IGF_SP_GEN_001
- show dependent code
-
IGF_SP_GEN_001
- show dependent code
-
IGS_AD_VAL_ACAIU
- show dependent code
-
IGS_AS_ADI_UPLD_AIO_PKG
- show dependent code
-
IGS_AS_ADI_UPLD_UG_PKG
- show dependent code
-
IGS_AS_ANON_GRD_PKG
- show dependent code
-
IGS_AS_APPR_GRD_SCH_PKG
- show dependent code
-
IGS_AS_ATT_WF_PKG
- show dependent code
-
IGS_AS_CALC_AWARD_MARK
- show dependent code
-
IGS_AS_CALC_AWARD_MARK
- show dependent code
-
IGS_AS_CGR_WF_PKG
- show dependent code
-
IGS_AS_FINALIZE_GRADE
- show dependent code
-
IGS_AS_GEN_003
- show dependent code
-
IGS_AS_GEN_004
- show dependent code
-
IGS_AS_GEN_005
- show dependent code
-
IGS_AS_GEN_006
- show dependent code
-
IGS_AS_GEN_007
- show dependent code
-
IGS_AS_GEN_008
- show dependent code
-
IGS_AS_GEN_008
- show dependent code
-
IGS_AS_GRD_ATT_BE_PKG
- show dependent code
-
IGS_AS_GRD_ATT_BE_PKG
- show dependent code
-
IGS_AS_NOTIFY_PKG
- show dependent code
-
IGS_AS_SUAAI_HIST_V
-
IGS_AS_SUAO_LGCY_PUB
- show dependent code
-
IGS_AS_SUARC_LGCY_PUB
- show dependent code
-
IGS_AS_SUA_ASS_V
-
IGS_AS_SUA_INQ_V
-
IGS_AS_SU_ATTEMPT_LKUP_V
-
IGS_AS_UNIT_ASSESSMENT_ITEM_V
-
IGS_AS_USECAI_SUA_V
-
IGS_AS_USEC_SESSNS_PKG
- show dependent code
-
IGS_AS_USEC_SESSNS_PKG
- show dependent code
-
IGS_AS_VAL_UAI
- show dependent code
-
IGS_AU_GEN_003
- show dependent code
-
IGS_DA_XML_PKG
- show dependent code
-
IGS_EN_ADD_UNITS_API
- show dependent code
-
IGS_EN_DROP_UNITS_API
- show dependent code
-
IGS_EN_ELGBL_PERSON
- show dependent code
-
IGS_EN_ELGBL_PROGRAM
- show dependent code
-
IGS_EN_ELGBL_UNIT
- show dependent code
-
IGS_EN_ELGB_OVR_UOO_PKG
- show dependent code
-
IGS_EN_ELGB_OVR_UOO_V
-
IGS_EN_ENROLL_WLST
- show dependent code
-
IGS_EN_ENROLL_WLST
- show dependent code
-
IGS_EN_GEN_004
- show dependent code
-
IGS_EN_GEN_005
- show dependent code
-
IGS_EN_GEN_008
- show dependent code
-
IGS_EN_GEN_009
- show dependent code
-
IGS_EN_GEN_010
- show dependent code
-
IGS_EN_GEN_011
- show dependent code
-
IGS_EN_GEN_015
- show dependent code
-
IGS_EN_GEN_016
- show dependent code
-
IGS_EN_GEN_017
- show dependent code
-
IGS_EN_GEN_018
- show dependent code
-
IGS_EN_GEN_LEGACY
- show dependent code
-
IGS_EN_IVR_PUB
- show dependent code
-
IGS_EN_NSC_PKG
- show dependent code
-
IGS_EN_OFR_WLST_OPT
- show dependent code
-
IGS_EN_OFR_WLST_OPT
- show dependent code
-
IGS_EN_PLAN_UNITS_PKG
- show dependent code
-
IGS_EN_PLAN_UTILS
- show dependent code
-
IGS_EN_PRC_LOAD
- show dependent code
-
IGS_EN_REINSTATE_PKG
- show dependent code
-
IGS_EN_SPL_PERM_V
-
IGS_EN_SUA_API
- show dependent code
-
IGS_EN_SUA_LGCY_PUB
- show dependent code
-
IGS_EN_SUA_PLACEMENT_DET_V
-
IGS_EN_SUA_RULCHK_V
-
IGS_EN_SU_ATTEMPT_PKG
- show dependent code
-
IGS_EN_TIMESLOTS
- show dependent code
-
IGS_EN_TRANSFER_APIS
- show dependent code
-
IGS_EN_VAL_BULKRULE
- show dependent code
-
IGS_EN_VAL_SUA
- show dependent code
-
IGS_EN_WLST_GEN_PROC
- show dependent code
-
IGS_EN_WLST_GEN_PROC
- show dependent code
-
IGS_FI_ACCT_STP_CNV
- show dependent code
-
IGS_FI_CHARGES_API_PVT
- show dependent code
-
IGS_FI_GEN_008
- show dependent code
-
IGS_FI_GEN_008
- show dependent code
-
IGS_FI_INVLN_INT_V
-
IGS_FI_PRC_SP_FEES
- show dependent code
-
IGS_FI_VAL_UFT
- show dependent code
-
IGS_HE_FTE_CALC_PKG
- show dependent code
-
IGS_PR_SUA_INQ_V
-
IGS_PS_CAL_RSR_VAL
- show dependent code
-
IGS_PS_CAL_RSR_VAL
- show dependent code
-
IGS_PS_FAC_CREDT_WRKLOAD
- show dependent code
-
IGS_PS_FAC_USEC_HIST_V
-
IGS_PS_FAC_USEC_TCH_HIST_V
-
IGS_PS_GEN_001
- show dependent code
-
IGS_PS_GEN_004
- show dependent code
-
IGS_PS_GEN_006
- show dependent code
-
IGS_PS_GEN_008
- show dependent code
-
IGS_PS_RLOVR_FAC_TSK
- show dependent code
-
IGS_PS_TCH_RESP_UOO_V
-
IGS_PS_TCH_RSOV_HIST_V
-
IGS_PS_UNITASS_ITEM_PKG
- show dependent code
-
IGS_PS_UNIT_OFR_OPT_ASS_PAT_V
-
IGS_PS_UNIT_OFR_OPT_ASS_V
-
IGS_PS_UNIT_OFR_OPT_GRD_SCHM_V
-
IGS_PS_UNIT_OFR_OPT_INQ_V
-
IGS_PS_UNIT_OFR_OPT_OFROPT_V
-
IGS_PS_UNIT_OFR_OPT_PE_V
-
IGS_PS_UNIT_OFR_OPT_PKG
- show dependent code
-
IGS_PS_UNIT_OFR_OPT_V
-
IGS_PS_USEC_CPS_V
-
IGS_PS_USEC_RU_V
-
IGS_PS_USEC_SCHEDULE
- show dependent code
-
IGS_PS_USEC_X_GRPMEM_V
-
IGS_PS_USEC_X_USEC_V
-
IGS_PS_USO_CLAS_MEET_V
-
IGS_PS_VALIDATE_GENERIC_PKG
- show dependent code
-
IGS_PS_VALIDATE_LGCY_PKG
- show dependent code
-
IGS_PS_VAL_POSU
- show dependent code
-
IGS_PS_VAL_UAI
- show dependent code
-
IGS_PS_VAL_UV
- show dependent code
-
IGS_RE_GEN_001
- show dependent code
-
IGS_RU_GEN_001
- show dependent code
-
IGS_SS_ENROLL_PKG
- show dependent code
-
IGS_SS_ENR_DETAILS
- show dependent code
-
IGS_SS_ENR_DETAILS
- show dependent code
-
IGS_SS_EN_RULE_CART_MAX_V
-
IGS_SS_EN_SUA_DTLS_V
-
IGS_SS_EN_USEC_EXAM_SCH_V
-
IGS_SS_EN_WRAPPERS
- show dependent code
-
IGS_SS_EN_WRAPPERS
- show dependent code
-
IGS_SS_USEC_V
-
IGS_ST_GEN_004
- show dependent code
-
IGS_ST_GEN_004
- show dependent code