[Home] [Help]
[Dependency Information]
VIEW: APPS.IGS_AD_PS_APPL
Object Details
Object Name: | IGS_AD_PS_APPL |
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGS_AD_PS_APPL
|
---|
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) |
|
|
ORG_ID |
NUMBER |
(15) |
|
|
PERSON_ID |
NUMBER |
(15) |
Yes |
|
ADMISSION_APPL_NUMBER |
NUMBER |
(2) |
Yes |
|
NOMINATED_COURSE_CD |
VARCHAR2 |
(6) |
Yes |
|
TRANSFER_COURSE_CD |
VARCHAR2 |
(6) |
|
|
BASIS_FOR_ADMISSION_TYPE |
VARCHAR2 |
(10) |
|
|
ADMISSION_CD |
VARCHAR2 |
(10) |
|
|
COURSE_RANK_SET |
VARCHAR2 |
(30) |
|
|
COURSE_RANK_SCHEDULE |
VARCHAR2 |
(10) |
|
|
REQ_FOR_RECONSIDERATION_IND |
VARCHAR2 |
(1) |
Yes |
|
REQ_FOR_ADV_STANDING_IND |
VARCHAR2 |
(1) |
Yes |
|
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 |
|
|
|
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, ORG_ID
, PERSON_ID
, ADMISSION_APPL_NUMBER
, NOMINATED_COURSE_CD
, TRANSFER_COURSE_CD
, BASIS_FOR_ADMISSION_TYPE
, ADMISSION_CD
, COURSE_RANK_SET
, COURSE_RANK_SCHEDULE
, REQ_FOR_RECONSIDERATION_IND
, REQ_FOR_ADV_STANDING_IND
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
FROM APPS.IGS_AD_PS_APPL;
Dependencies
[top of page]
APPS.IGS_AD_PS_APPL references the following:
-
APPS
-
IGS_AD_PS_APPL_ALL
APPS.IGS_AD_PS_APPL is referenced by following:
-
APPS
-
IGS_ADMAPPLICATION_PUB
- show dependent code
-
IGS_AD_APPL_EVAL_PKG
- show dependent code
-
IGS_AD_CANCEL_RECONSIDER
- show dependent code
-
IGS_AD_DEF_APPL_PKG
- show dependent code
-
IGS_AD_DEF_APPL_PKG
- show dependent code
-
IGS_AD_GEN_002
- show dependent code
-
IGS_AD_GEN_004
- show dependent code
-
IGS_AD_GEN_008
- show dependent code
-
IGS_AD_GEN_011
- show dependent code
-
IGS_AD_GEN_012
- show dependent code
-
IGS_AD_GEN_014
- show dependent code
-
IGS_AD_IMP_004
- show dependent code
-
IGS_AD_IMP_ADM_DES
- show dependent code
-
IGS_AD_INT_RECONSIDER
- show dependent code
-
IGS_AD_INT_RECONSIDER
- show dependent code
-
IGS_AD_PS_APLINSTHST_HISTORY_V
-
IGS_AD_PS_APPL_APLCNTX_V
-
IGS_AD_PS_APPL_INST_APLINST_V
-
IGS_AD_PS_APPL_INST_PKG
- show dependent code
-
IGS_AD_VAL_ACAI
- show dependent code
-
IGS_AD_VAL_ACAI_FTR_OFFER
- show dependent code
-
IGS_AD_VAL_ACAI_FTR_OFFER
- show dependent code
-
IGS_AD_VAL_ACAI_STATUS
- show dependent code
-
IGS_EN_GEN_002
- show dependent code
-
IGS_EN_GEN_006
- show dependent code
-
IGS_EN_TRANSFER_APIS
- show dependent code
-
IGS_EN_VAL_SCA
- show dependent code
-
IGS_RE_GEN_001
- show dependent code
-
IGS_RE_VAL_RSUP
- show dependent code
-
IGS_ST_GEN_003
- show dependent code
-
IGS_UC_EXPORT_DECISION_REPLY
- show dependent code