[Home] [Help]
[Dependency Information]
VIEW: APPS.IGS_AD_CAT
Object Details
Object Name: | IGS_AD_CAT |
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGS_AD_CAT
|
---|
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) |
|
|
ADMISSION_CAT |
VARCHAR2 |
(10) |
Yes |
|
DESCRIPTION |
VARCHAR2 |
(60) |
Yes |
|
S_CITIZENSHIP_TYPE |
VARCHAR2 |
(10) |
Yes |
|
CLOSED_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) |
|
|
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, ORG_ID
, ADMISSION_CAT
, DESCRIPTION
, S_CITIZENSHIP_TYPE
, CLOSED_IND
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM APPS.IGS_AD_CAT;
Dependencies
[top of page]
APPS.IGS_AD_CAT references the following:
-
APPS
-
IGS_AD_CAT_ALL
APPS.IGS_AD_CAT is referenced by following:
-
APPS
-
IGS_AD_ADM_REQ
- show dependent code
-
IGS_AD_GEN_011
- show dependent code
-
IGS_AD_PERD_AD_CAT_V
-
IGS_AD_PRCS_CAT_AC_V
-
IGS_AD_PRCS_CAT_ADMPRCS_V
-
IGS_AD_PRCS_CAT_V
-
IGS_AD_PRC_TAC_OFFER
- show dependent code
-
IGS_AD_SS_APPL_TYP_V
-
IGS_AD_SS_APPL_UPD_PAGE
- show dependent code
-
IGS_AD_SS_PRC_CAT_V
-
IGS_AD_VAL_AA
- show dependent code
-
IGS_AD_VAL_AC
- show dependent code
-
IGS_AD_VAL_ACCT
- show dependent code
-
IGS_GE_VAL_PARAM
- show dependent code
-
IGS_GE_VAL_PARAM
- show dependent code
-
IGS_PE_SRC_TYPES_V
-
IGS_PS_VAL_POS
- show dependent code
-
IGS_PS_VAL_POS
- show dependent code