Table: IGS_PS_OFR_PAT | Oracle EBS ETRM Search

Table: IGS_PS_OFR_PAT 12.1.1 satellite-leaning

owner IGS·IGS - Student System·34 columns

This entity describes the offering pattern of a program offering option. This is related to a calendar instance, nominating when each option is available.

IGS.IGS_PS_OFR_PAT·Explore IGS module →

SYNONYM: APPS.IGS_PS_OFR_PAT 12.1.1

TABLE: IGS.IGS_PS_OFR_PAT 12.1.1

owner IGS

Table: IGS_PS_OFR_PAT 12.2.2

IGS - Student System (Obsolete)

This entity describes the offering pattern of a program offering option. This is related to a calendar instance, nominating when each option is available.

Not implemented in this database·Explore IGS module →

APPS.IGS_PS_GEN_001 dependencies on IGS_PS_OFR_PAT 12.1.1

APPS.IGS_AD_INS_ADMPERD dependencies on IGS_PS_OFR_PAT 12.1.1

APPS.IGS_PS_OFR_PAT_PKG dependencies on IGS_PS_OFR_PAT 12.1.1

APPS.IGS_AS_PRC_TRANSCRPT dependencies on IGS_PS_OFR_PAT 12.1.1

APPS.IGS_EN_VAL_SCA dependencies on IGS_PS_OFR_PAT 12.1.1

APPS.IGS_AS_SUAO_LGCY_PUB dependencies on IGS_PS_OFR_PAT 12.1.1

APPS.IGS_EN_GEN_010 dependencies on IGS_PS_OFR_PAT 12.1.1

APPS.IGS_AS_FINALIZE_GRADE dependencies on IGS_PS_OFR_PAT 12.1.1

APPS.IGS_AS_PRC_TRANSCRPT dependencies on IGS_PS_OFR_PAT 12.1.1

APPS.IGF_AW_COA_GEN dependencies on IGS_PS_OFR_PAT 12.1.1

APPS.IGS_AD_VAL_APCOOD dependencies on IGS_PS_OFR_PAT 12.1.1

APPS.IGS_PS_GEN_003 dependencies on IGS_PS_OFR_PAT 12.1.1

APPS.IGS_AD_VAL_SCFT dependencies on IGS_PS_OFR_PAT 12.1.1

APPS.IGS_EN_ELGBL_PROGRAM dependencies on IGS_PS_OFR_PAT 12.1.1

APPS.IGS_AD_VAL_APCOO dependencies on IGS_PS_OFR_PAT 12.1.1

APPS.IGS_EN_GEN_006 dependencies on IGS_PS_OFR_PAT 12.1.1

APPS.IGS_AS_GEN_005 dependencies on IGS_PS_OFR_PAT 12.1.1

APPS.IGS_AD_VAL_ACAI dependencies on IGS_PS_OFR_PAT 12.1.1

APPS.IGS_PS_OFR_PAT_PKG SQL Statements 12.1.1

Table: IGS_PS_OFR_PAT_NOTE 12.2.2

IGS - Student System (Obsolete)

This table describes the notes associated with a Program Offering Pattern.

Not implemented in this database·Explore IGS module →

PACKAGE BODY: APPS.IGS_AD_VAL_SCFT 12.1.1

used by 1

View: IGS_PS_OFR_PAT_V 12.1.1

IGS - Student System·27 columns

View of the program offering pattern table. Required for program offering pattern LOV in ADMF1200

APPS.IGS_PS_OFR_PAT_V·↳ IGS_CA_INST·↳ IGS_PS_OFR_PAT·↳ IGS_PS_VER·Explore IGS module →

PACKAGE: APPS.IGS_AD_VAL_SCFT 12.1.1

used by 1

View: IGS_PS_OFR_PAT_CRSVRSN_V 12.1.1

IGS - Student System·13 columns

This view describes the offering pattern of a program offering option. It also describes the relationship between admission periods, admission process types and admission categories.

APPS.IGS_PS_OFR_PAT_CRSVRSN_V·↳ IGS_AD_PRD_AD_PRC_CA·↳ IGS_CA_INST_REL·↳ IGS_PS_OFR_PAT·Explore IGS module →

View: IGS_PS_OFR_PAT_OFERPAT_V 12.1.1

IGS - Student System·18 columns

View of the program offering pattern table. Required for program offering pattern LOV in ADMF3240

APPS.IGS_PS_OFR_PAT_OFERPAT_V·↳ IGS_AD_PRD_AD_PRC_CA·↳ IGS_CA_INST_REL·↳ IGS_PS_OFR_PAT·Explore IGS module →

View: IGS_PS_OFR_PAT_ADM_PERD_V 12.1.1

IGS - Student System·19 columns

This view is used to display for the admission period Program Offering Pattern in form ADMF2M61.

APPS.IGS_PS_OFR_PAT_ADM_PERD_V·↳ IGS_AD_PRD_AD_PRC_CA·↳ IGS_CA_INST_REL·↳ IGS_PS_OFR_PAT·Explore IGS module →

View: IGS_PS_OFR_PATTERN_V 12.1.1

IGS - Student System·37 columns

APPS.IGS_PS_OFR_PATTERN_V·↳ HZ_PARTIES·↳ IGS_PS_OFR_PAT·Explore IGS module →

Table: IGS_PS_OFR_OPT_ALL 12.2.2

IGS - Student System (Obsolete)

This entity describes the available options for each program offering.

Not implemented in this database·Explore IGS module →

View: IGS_PS_OFR_PAT_APCOO_V 12.1.1

IGS - Student System·15 columns

This view is used to display for the admission period program offering option - Program Offering LOV in form ADMF2M61.

APPS.IGS_PS_OFR_PAT_APCOO_V·↳ IGS_AD_PRD_AD_PRC_CA·↳ IGS_CA_INST_REL·↳ IGS_PS_OFR_PAT·Explore IGS module →

View: IGS_PS_OFR_PAT_APCOOD_V 12.1.1

IGS - Student System·15 columns

This view describes the offering pattern of a program offering option. It also describes the relationship between admission periods, admission process types and admission categories.

APPS.IGS_PS_OFR_PAT_APCOOD_V·↳ IGS_AD_GEN_013·↳ IGS_AD_PRD_AD_PRC_CA·↳ IGS_CA_INST_REL·Explore IGS module →

PACKAGE BODY: APPS.IGS_PS_GEN_003 12.1.1

used by 13

PACKAGE: APPS.IGS_PS_GEN_003 12.1.1

used by 13

View: IGS_PS_OFR_PAT_APCOOD_PAT_V 12.1.1

IGS - Student System·21 columns

This view is used to display the admission period program offering pattern dates in ADMF2M62.

APPS.IGS_PS_OFR_PAT_APCOOD_PAT_V·↳ IGS_AD_GEN_003·↳ IGS_AD_GEN_013·↳ IGS_AD_PRD_AD_PRC_CA·Explore IGS module →

View: IGSFV_PGM_OFR_PATTERN_ADM_PERD 12.1.1

IGS - Student System·25 columns

APPS.IGSFV_PGM_OFR_PATTERN_ADM_PERD·↳ IGS_AD_CAT_ALL·↳ IGS_AD_LOCATION_ALL·↳ IGS_AD_PRD_AD_PRC_CA·Explore IGS module →

View: IGSBV_PROG_OFFERING_PATTERNS 12.1.1

IGS - Student System·35 columns

This is a base view, which describes the Offering Pattern of a program offering option. This is related to a calendar instance, nominating when each option is available.

APPS.IGSBV_PROG_OFFERING_PATTERNS·↳ IGS_AD_LOCATION_ALL·↳ IGS_CA_INST_ALL·↳ IGS_CA_TYPE·Explore IGS module →

VIEW: APPS.IGS_PS_OFR_PAT_V 12.1.1

APPS.IGS_AD_VAL_SCFT SQL Statements 12.1.1

View: IGSFV_PROG_OFFERING_PATTERNS 12.1.1

IGS - Student System·40 columns

This is a full view, which describes the Offering Pattern of a program offering option. This is related to a calendar instance, nominating when each option is available.

APPS.IGSFV_PROG_OFFERING_PATTERNS·↳ HZ_PARTIES·↳ IGS_AD_LOCATION_ALL·↳ IGS_AS_GRD_SCHEMA·Explore IGS module →

Table: IGS_PS_OFR_PAT_NOTE 12.1.1 link

owner IGS·IGS - Student System·15 columns

This table describes the notes associated with a Program Offering Pattern.

IGS.IGS_PS_OFR_PAT_NOTE·Explore IGS module →

View: IGS_PS_OFR_PAT_UNITSET_V 12.1.1

IGS - Student System·18 columns

This view describes the offering pattern of a program offering option. It also describes a unit-set, being a logical sub-grouping of program.

APPS.IGS_PS_OFR_PAT_UNITSET_V·↳ IGS_AD_PRD_AD_PRC_CA·↳ IGS_CA_INST_REL·↳ IGS_EN_GEN_008·Explore IGS module →

VIEW: APPS.IGS_PS_OFR_PATTERN_V 12.1.1

PACKAGE BODY: APPS.IGS_PS_OFR_PAT_PKG 12.1.1

used by 6