[Home] [Help] [Dependency Information]
Object Name: | IGS_EN_UNIT_SET_RULE_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGS_EN_UNIT_SET_RULE_V |
Subobject Name: | |
Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
UNIT_SET_CD | VARCHAR2 | (10) | Unit set code | |
VERSION_NUMBER | NUMBER | (3) | Version number | |
S_RULE_CALL_CD | VARCHAR2 | (10) | The code of a system rule call, for example PRG-UFAIL (a systemrule used in the calculation of course progression rules based onunit failures) or PRG-GPA (a system rule used in the calculation ofcourse progression rules involving a grade point average). Institutiondefined rule categories are mapped to a system rule call code. Eachinstitution defined rule category may comprise many individualprogression rules. | |
RUL_SEQUENCE_NUMBER | NUMBER | Rule name rule sequence number | ||
RUD_SEQUENCE_NUMBER | NUMBER | (6) | The sequence number of a system rule | |
SELECT_GROUP | NUMBER | (6) | This field contains the rule group number. | |
S_RETURN_TYPE | VARCHAR2 | (20) | rule return type | |
RULE_DESCRIPTION | VARCHAR2 | (255) | Presently two unit set rule types can be defined-Unit Set which defines its composition and Unit SetPre-requsitie rule. An existing rule is displayed in the Rule Text field. A red 'UNDEFINED' lamp is illuminated to indicate that a rule does not exist. | |
RULE_TEXT | VARCHAR2 | (4000) | This field displays the text of an existing rule.If the field is empty, a rule has not been created. Are UNDEFINED lamp is displayed adjacent to the context rule description. | |
DEFINED_LAMP | VARCHAR2 | (9) | ||
CREATED_BY | NUMBER | (15) | Standard Who column | |
CREATION_DATE | DATE | Standard Who column | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard Who column | |
LAST_UPDATE_DATE | DATE | Standard Who column | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column |
Cut, paste (and edit) the following text to query this object:
SELECT UNIT_SET_CD
, VERSION_NUMBER
, S_RULE_CALL_CD
, RUL_SEQUENCE_NUMBER
, RUD_SEQUENCE_NUMBER
, SELECT_GROUP
, S_RETURN_TYPE
, RULE_DESCRIPTION
, RULE_TEXT
, DEFINED_LAMP
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM APPS.IGS_EN_UNIT_SET_RULE_V;
APPS.IGS_EN_UNIT_SET_RULE_V is not referenced by any database object
|
|
|