eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: IGS.IGS_AD_APL_REV_PRF_ALL

Object Details

Object Name:	IGS_AD_APL_REV_PRF_ALL
Object Type:	TABLE
Owner:	IGS
FND Design Data:	IGS.IGS_AD_APL_REV_PRF_ALL
Subobject Name:
Status:	VALID

IGS_AD_APL_REV_PRF_ALL is the table where all Application Review Profile related information will be recorded. Here the Application Review Profile IDs will be generated and information like Review Profile Name, Start Date, End Date, whether program approval is required or not will be stored. This is not expected to be a 'high transaction' table. Hence it can be classed as 'CLASS3' table as per the storage clause.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_AD_APL_REV_PRF_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	APPL_REV_PROFILE_ID
IGS_AD_APL_REV_PRF_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	REVIEW_PROFILE_NAME ORG_ID

Columns

Name	Datatype	Length	Mandatory	Comments
APPL_REV_PROFILE_ID	NUMBER	(15)	Yes	Unique Identifier of a Application Review Profile Group.
ORG_ID	NUMBER			Operating unit identifier
REVIEW_PROFILE_NAME	VARCHAR2	(80)	Yes	User defined Application Review Profile Name.
START_DATE	DATE		Yes	Start Date for an Application Review Profile. Default value should be system date.
END_DATE	DATE			End Date for an Application Review Profile.
MIN_EVALUATOR	NUMBER	(5)	Yes	Minimum number of evaluator for Application Review Profile Group.
MAX_EVALUATOR	NUMBER	(5)		Maximum number of evaluator for Application Review Profile Group.
PROG_APPROVAL_REQUIRED	VARCHAR2	(1)	Yes	Indicator to designate whether Program Approval is required or not. Valid values can be Yes - 'Y' or No - 'N'.
SEQUENTIAL_CONCURRENT_IND	VARCHAR2	(1)	Yes	Indicator to designate whether Application instance evaluation will be sequential or concurrent in the Application Review Profile Group. Valid values can be Sequential - 'S' or Concurrent - 'C'.
APPL_REV_PROFILE_GR_CD	VARCHAR2	(30)	Yes	Applications will be divided into Review Groups codes. User can select only one for each Application Review Profile Group.
SITE_USE_CODE	VARCHAR2	(30)		The user will establish an Application Review Profile Group and specify which institutional address usage they wish to have the system look at.
CLOSED_IND	VARCHAR2	(1)	Yes	Closed indicator for Application Review Profile Group. Valid values can be Yes - 'Y' or No - 'N'.
CREATED_BY	NUMBER	(15)	Yes	Standard WHO column
CREATION_DATE	DATE		Yes	Standard WHO column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO column
LAST_UPDATE_DATE	DATE		Yes	Standard WHO column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO column

Query Text

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


SELECT APPL_REV_PROFILE_ID
,      ORG_ID
,      REVIEW_PROFILE_NAME
,      START_DATE
,      END_DATE
,      MIN_EVALUATOR
,      MAX_EVALUATOR
,      PROG_APPROVAL_REQUIRED
,      SEQUENTIAL_CONCURRENT_IND
,      APPL_REV_PROFILE_GR_CD
,      SITE_USE_CODE
,      CLOSED_IND
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM IGS.IGS_AD_APL_REV_PRF_ALL;

Dependencies

[top of page]

IGS.IGS_AD_APL_REV_PRF_ALL does not reference any database object

IGS.IGS_AD_APL_REV_PRF_ALL is referenced by following:

APPS: IGS_AD_APL_REV_PRF_ALL