DBA Data[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: ViewIGS.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:

SchemaAPPS
SynonymIGS_PS_UNIT_OFR_OPT_ALL
APPS.IGS_PS_UNIT_OFR_OPT is referenced by following:

SchemaAPPS
Package BodyIGF_SP_GEN_001 - show dependent code
PL/SQL PackageIGF_SP_GEN_001 - show dependent code
Package BodyIGS_AD_VAL_ACAIU - show dependent code
Package BodyIGS_AS_ADI_UPLD_AIO_PKG - show dependent code
Package BodyIGS_AS_ADI_UPLD_UG_PKG - show dependent code
Package BodyIGS_AS_ANON_GRD_PKG - show dependent code
Package BodyIGS_AS_APPR_GRD_SCH_PKG - show dependent code
Package BodyIGS_AS_ATT_WF_PKG - show dependent code
Package BodyIGS_AS_CALC_AWARD_MARK - show dependent code
PL/SQL PackageIGS_AS_CALC_AWARD_MARK - show dependent code
Package BodyIGS_AS_CGR_WF_PKG - show dependent code
Package BodyIGS_AS_FINALIZE_GRADE - show dependent code
Package BodyIGS_AS_GEN_003 - show dependent code
Package BodyIGS_AS_GEN_004 - show dependent code
Package BodyIGS_AS_GEN_005 - show dependent code
Package BodyIGS_AS_GEN_006 - show dependent code
Package BodyIGS_AS_GEN_007 - show dependent code
PL/SQL PackageIGS_AS_GEN_008 - show dependent code
Package BodyIGS_AS_GEN_008 - show dependent code
Package BodyIGS_AS_GRD_ATT_BE_PKG - show dependent code
PL/SQL PackageIGS_AS_GRD_ATT_BE_PKG - show dependent code
Package BodyIGS_AS_NOTIFY_PKG - show dependent code
ViewIGS_AS_SUAAI_HIST_V
Package BodyIGS_AS_SUAO_LGCY_PUB - show dependent code
Package BodyIGS_AS_SUARC_LGCY_PUB - show dependent code
ViewIGS_AS_SUA_ASS_V
ViewIGS_AS_SUA_INQ_V
ViewIGS_AS_SU_ATTEMPT_LKUP_V
ViewIGS_AS_UNIT_ASSESSMENT_ITEM_V
ViewIGS_AS_USECAI_SUA_V
Package BodyIGS_AS_USEC_SESSNS_PKG - show dependent code
PL/SQL PackageIGS_AS_USEC_SESSNS_PKG - show dependent code
Package BodyIGS_AS_VAL_UAI - show dependent code
Package BodyIGS_AU_GEN_003 - show dependent code
Package BodyIGS_DA_XML_PKG - show dependent code
Package BodyIGS_EN_ADD_UNITS_API - show dependent code
Package BodyIGS_EN_DROP_UNITS_API - show dependent code
Package BodyIGS_EN_ELGBL_PERSON - show dependent code
Package BodyIGS_EN_ELGBL_PROGRAM - show dependent code
Package BodyIGS_EN_ELGBL_UNIT - show dependent code
Package BodyIGS_EN_ELGB_OVR_UOO_PKG - show dependent code
ViewIGS_EN_ELGB_OVR_UOO_V
Package BodyIGS_EN_ENROLL_WLST - show dependent code
PL/SQL PackageIGS_EN_ENROLL_WLST - show dependent code
Package BodyIGS_EN_GEN_004 - show dependent code
Package BodyIGS_EN_GEN_005 - show dependent code
Package BodyIGS_EN_GEN_008 - show dependent code
Package BodyIGS_EN_GEN_009 - show dependent code
Package BodyIGS_EN_GEN_010 - show dependent code
Package BodyIGS_EN_GEN_011 - show dependent code
Package BodyIGS_EN_GEN_015 - show dependent code
Package BodyIGS_EN_GEN_016 - show dependent code
Package BodyIGS_EN_GEN_017 - show dependent code
Package BodyIGS_EN_GEN_018 - show dependent code
Package BodyIGS_EN_GEN_LEGACY - show dependent code
Package BodyIGS_EN_IVR_PUB - show dependent code
Package BodyIGS_EN_NSC_PKG - show dependent code
PL/SQL PackageIGS_EN_OFR_WLST_OPT - show dependent code
Package BodyIGS_EN_OFR_WLST_OPT - show dependent code
Package BodyIGS_EN_PLAN_UNITS_PKG - show dependent code
Package BodyIGS_EN_PLAN_UTILS - show dependent code
Package BodyIGS_EN_PRC_LOAD - show dependent code
Package BodyIGS_EN_REINSTATE_PKG - show dependent code
ViewIGS_EN_SPL_PERM_V
Package BodyIGS_EN_SUA_API - show dependent code
Package BodyIGS_EN_SUA_LGCY_PUB - show dependent code
ViewIGS_EN_SUA_PLACEMENT_DET_V
ViewIGS_EN_SUA_RULCHK_V
Package BodyIGS_EN_SU_ATTEMPT_PKG - show dependent code
Package BodyIGS_EN_TIMESLOTS - show dependent code
Package BodyIGS_EN_TRANSFER_APIS - show dependent code
Package BodyIGS_EN_VAL_BULKRULE - show dependent code
Package BodyIGS_EN_VAL_SUA - show dependent code
PL/SQL PackageIGS_EN_WLST_GEN_PROC - show dependent code
Package BodyIGS_EN_WLST_GEN_PROC - show dependent code
Package BodyIGS_FI_ACCT_STP_CNV - show dependent code
Package BodyIGS_FI_CHARGES_API_PVT - show dependent code
PL/SQL PackageIGS_FI_GEN_008 - show dependent code
Package BodyIGS_FI_GEN_008 - show dependent code
ViewIGS_FI_INVLN_INT_V
Package BodyIGS_FI_PRC_SP_FEES - show dependent code
Package BodyIGS_FI_VAL_UFT - show dependent code
Package BodyIGS_HE_FTE_CALC_PKG - show dependent code
ViewIGS_PR_SUA_INQ_V
PL/SQL PackageIGS_PS_CAL_RSR_VAL - show dependent code
Package BodyIGS_PS_CAL_RSR_VAL - show dependent code
Package BodyIGS_PS_FAC_CREDT_WRKLOAD - show dependent code
ViewIGS_PS_FAC_USEC_HIST_V
ViewIGS_PS_FAC_USEC_TCH_HIST_V
Package BodyIGS_PS_GEN_001 - show dependent code
Package BodyIGS_PS_GEN_004 - show dependent code
Package BodyIGS_PS_GEN_006 - show dependent code
Package BodyIGS_PS_GEN_008 - show dependent code
Package BodyIGS_PS_RLOVR_FAC_TSK - show dependent code
ViewIGS_PS_TCH_RESP_UOO_V
ViewIGS_PS_TCH_RSOV_HIST_V
Package BodyIGS_PS_UNITASS_ITEM_PKG - show dependent code
ViewIGS_PS_UNIT_OFR_OPT_ASS_PAT_V
ViewIGS_PS_UNIT_OFR_OPT_ASS_V
ViewIGS_PS_UNIT_OFR_OPT_GRD_SCHM_V
ViewIGS_PS_UNIT_OFR_OPT_INQ_V
ViewIGS_PS_UNIT_OFR_OPT_OFROPT_V
ViewIGS_PS_UNIT_OFR_OPT_PE_V
Package BodyIGS_PS_UNIT_OFR_OPT_PKG - show dependent code
ViewIGS_PS_UNIT_OFR_OPT_V
ViewIGS_PS_USEC_CPS_V
ViewIGS_PS_USEC_RU_V
Package BodyIGS_PS_USEC_SCHEDULE - show dependent code
ViewIGS_PS_USEC_X_GRPMEM_V
ViewIGS_PS_USEC_X_USEC_V
ViewIGS_PS_USO_CLAS_MEET_V
Package BodyIGS_PS_VALIDATE_GENERIC_PKG - show dependent code
Package BodyIGS_PS_VALIDATE_LGCY_PKG - show dependent code
Package BodyIGS_PS_VAL_POSU - show dependent code
Package BodyIGS_PS_VAL_UAI - show dependent code
Package BodyIGS_PS_VAL_UV - show dependent code
Package BodyIGS_RE_GEN_001 - show dependent code
Package BodyIGS_RU_GEN_001 - show dependent code
Package BodyIGS_SS_ENROLL_PKG - show dependent code
PL/SQL PackageIGS_SS_ENR_DETAILS - show dependent code
Package BodyIGS_SS_ENR_DETAILS - show dependent code
ViewIGS_SS_EN_RULE_CART_MAX_V
ViewIGS_SS_EN_SUA_DTLS_V
ViewIGS_SS_EN_USEC_EXAM_SCH_V
Package BodyIGS_SS_EN_WRAPPERS - show dependent code
PL/SQL PackageIGS_SS_EN_WRAPPERS - show dependent code
ViewIGS_SS_USEC_V
PL/SQL PackageIGS_ST_GEN_004 - show dependent code
Package BodyIGS_ST_GEN_004 - show dependent code