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]

VIEW: APPS.IGW_SPECIAL_REVIEWS_V

Object Details

Object Name:	IGW_SPECIAL_REVIEWS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGW.IGW_SPECIAL_REVIEWS_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

IGW_SPECIAL_REVIEWS_V displays details about special reviews of human subjects and animal subjects conducted for the proposal. A value of X for a field indicates True and NULL indicates False.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PROPOSAL_ID	NUMBER	(15)	Yes	Proposal identifier
PROPOSAL_NUMBER	VARCHAR2	(30)	Yes	Proposal number
HUMAN_SUBJECTS_YES	VARCHAR2	(1)		Proposal has human subjects. X indicates Yes and Null indicates No.
HUMAN_SUBJECTS_NO	VARCHAR2	(1)		Proposal does not have human subjects. X indicates Yes and Null indicates No.
HUMAN_REVIEW_PENDING	VARCHAR2	(1)		Human subjects review pending
HUMAN_REVIEW_APPROVED	VARCHAR2	(1)		Human subjects review approved
HUMAN_REVIEW_REJECTED	VARCHAR2	(1)		Human subjects review rejected
HUMAN_REVIEW_FULL	VARCHAR2	(1)		Human subjects review full
HUMAN_REVIEW_EXPEDITED	VARCHAR2	(1)		Human subjects review expedited
HUMAN_APPROVAL_DATE	DATE			Human subjects review approval date
ANIMAL_SUBJECTS_YES	VARCHAR2	(1)		Proposal has animal subjects. X indicates Yes and Null indicates No.
ANIMAL_SUBJECTS_NO	VARCHAR2	(1)		Proposal does not have animal subjects. X indicates Yes and Null indicates No.
ANIMAL_REVIEW_PENDING	VARCHAR2	(1)		Animal subjects review pending
ANIMAL_REVIEW_APPROVED	VARCHAR2	(1)		Animal subjects review approved
ANIMAL_REVIEW_REJECTED	VARCHAR2	(1)		Animal subjects review rejected
ANIMAL_REVIEW_FULL	VARCHAR2	(1)		Animal subjects review full
ANIMAL_REVIEW_EXPEDITED	VARCHAR2	(1)		Animal subjects review expedited
ANIMAL_APPROVAL_DATE	DATE			Animal subjects review approval date

Query Text

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


SELECT PROPOSAL_ID
,      PROPOSAL_NUMBER
,      HUMAN_SUBJECTS_YES
,      HUMAN_SUBJECTS_NO
,      HUMAN_REVIEW_PENDING
,      HUMAN_REVIEW_APPROVED
,      HUMAN_REVIEW_REJECTED
,      HUMAN_REVIEW_FULL
,      HUMAN_REVIEW_EXPEDITED
,      HUMAN_APPROVAL_DATE
,      ANIMAL_SUBJECTS_YES
,      ANIMAL_SUBJECTS_NO
,      ANIMAL_REVIEW_PENDING
,      ANIMAL_REVIEW_APPROVED
,      ANIMAL_REVIEW_REJECTED
,      ANIMAL_REVIEW_FULL
,      ANIMAL_REVIEW_EXPEDITED
,      ANIMAL_APPROVAL_DATE
FROM APPS.IGW_SPECIAL_REVIEWS_V;

Dependencies

[top of page]

APPS.IGW_SPECIAL_REVIEWS_V references the following:

APPS: IGW_PROPOSALS_ALL; IGW_PROP_SPECIAL_REVIEWS

APPS.IGW_SPECIAL_REVIEWS_V is not referenced by any database object