[Home] [Help]
[Dependency Information]
Object Name: | IGS_PR_RU_APPL |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | ![]() |
Subobject Name: | |
Status: | VALID |
A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.
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) | ||
ORG_ID | 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) |
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
, ORG_ID
, MIN_CP
, MAX_CP
, POSITIVE_RULE_IND
, IGS_PR_CLASS_STD_ID
, CLASS_STANDING
FROM APPS.IGS_PR_RU_APPL;
|
|
|