[Home] [Help]
View: IGS_AD_RVGR_INC_EXC_V
Product: | IGS - Student System |
Description: | View where all Application Review Group Include Exclude related information will be recorded. |
Implementation/DBA Data: |
APPS.IGS_AD_RVGR_INC_EXC_V
|
View Text
SELECT IE.ROWID
, IE.REVGR_INCL_EXCL_ID
, IE.APPL_REVPROF_REVGR_ID
, IE.INCL_EXCL_IND
, IE.START_VALUE
, IE.END_VALUE
, FTV.TERRITORY_CODE
, FTV.TERRITORY_SHORT_NAME
, IE. POSTAL_INCL_EXCL_IND
, IE.POSTAL_START_VALUE
, IE.POSTAL_END_VALUE
, IE.CREATED_BY
, IE.CREATION_DATE
, IE.LAST_UPDATED_BY
, IE.LAST_UPDATE_DATE
, IE.LAST_UPDATE_LOGIN
FROM IGS_AD_RVGR_INC_EXC IE
, FND_TERRITORIES_VL FTV
WHERE FTV.TERRITORY_CODE = IE.COUNTRY
Columns
Name |
ROW_ID |
REVGR_INCL_EXCL_ID |
APPL_REVPROF_REVGR_ID |
INCL_EXCL_IND |
START_VALUE |
END_VALUE |
COUNTRY |
COUNTRY_SHORT_NAME |
POSTAL_INCL_EXCL_IND |
POSTAL_START_VALUE |
POSTAL_END_VALUE |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |