DBA Data[Home] [Help] [Dependency Information]


VIEW: APPS.IGS_PR_RU_APPL_V

Object Details
Object Name: IGS_PR_RU_APPL_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGS.IGS_PR_RU_APPL_V
Subobject Name:
Status: VALID

View Type

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.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
PROGRESSION_RULE_CAT VARCHAR2 (10) Yes
SEQUENCE_NUMBER NUMBER (6) Yes
S_RELATION_TYPE VARCHAR2 (10) Yes
PROGRESSION_RULE_CD VARCHAR2 (10)
REFERENCE_CD VARCHAR2 (30)
RUL_SEQUENCE_NUMBER NUMBER (6)
ATTENDANCE_TYPE VARCHAR2 (2)
OU_ORG_UNIT_CD VARCHAR2 (30)
OU_START_DT DATE

COURSE_TYPE VARCHAR2 (10)
CRV_COURSE_CD VARCHAR2 (6)
CRV_VERSION_NUMBER NUMBER (3)
SCA_PERSON_ID NUMBER (15)
SCA_COURSE_CD VARCHAR2 (6)
PRO_PROGRESSION_RULE_CAT VARCHAR2 (10)
PRO_PRA_SEQUENCE_NUMBER NUMBER (6)
PRO_SEQUENCE_NUMBER NUMBER (6)
SPO_PERSON_ID NUMBER (15)
SPO_COURSE_CD VARCHAR2 (6)
SPO_SEQUENCE_NUMBER NUMBER (6)
LOGICAL_DELETE_DT DATE

MESSAGE VARCHAR2 (2000)
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)
MIN_CP NUMBER (6)
MAX_CP NUMBER (6)
POSITIVE_RULE_IND VARCHAR2 (1)
IGS_PR_CLASS_STD_ID NUMBER (15)
CLASS_STANDING VARCHAR2 (50)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ROW_ID
,      PROGRESSION_RULE_CAT
,      SEQUENCE_NUMBER
,      S_RELATION_TYPE
,      PROGRESSION_RULE_CD
,      REFERENCE_CD
,      RUL_SEQUENCE_NUMBER
,      ATTENDANCE_TYPE
,      OU_ORG_UNIT_CD
,      OU_START_DT
,      COURSE_TYPE
,      CRV_COURSE_CD
,      CRV_VERSION_NUMBER
,      SCA_PERSON_ID
,      SCA_COURSE_CD
,      PRO_PROGRESSION_RULE_CAT
,      PRO_PRA_SEQUENCE_NUMBER
,      PRO_SEQUENCE_NUMBER
,      SPO_PERSON_ID
,      SPO_COURSE_CD
,      SPO_SEQUENCE_NUMBER
,      LOGICAL_DELETE_DT
,      MESSAGE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      MIN_CP
,      MAX_CP
,      POSITIVE_RULE_IND
,      IGS_PR_CLASS_STD_ID
,      CLASS_STANDING
FROM APPS.IGS_PR_RU_APPL_V;

Dependencies

[top of page]

APPS.IGS_PR_RU_APPL_V references the following:

SchemaAPPS
ViewIGS_PR_RU_APPL

APPS.IGS_PR_RU_APPL_V is not referenced by any database object