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_PRPO_SUBJECT_INFO_V

Object Details

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

View Type

A Business Intelligence System view

IGW_PRPO_SUBJECT_INFO_V displays details about human subjects involved in the proposal. This view is used in generating a flat file for Electronic Data Interchange.

[View Source]

Columns

Name	Datatype	Length	Mandatory
PROPOSAL_ID	NUMBER	(15)	Yes
STUDY_TITLE	VARCHAR2	(240)
AMERICAN_INDIAN_FEMALES	NUMBER
ASIAN_FEMALES	NUMBER
BLACK_FEMALES	NUMBER
HISPANIC_FEMALES	NUMBER
WHITE_FEMALES	NUMBER
OTHER_FEMALES	NUMBER
AMERICAN_INDIAN_MALES	NUMBER
ASIAN_MALES	NUMBER
BLACK_MALES	NUMBER
HISPANIC_MALES	NUMBER
WHITE_MALES	NUMBER
OTHER_MALES	NUMBER

Query Text

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


SELECT PROPOSAL_ID
,      STUDY_TITLE
,      AMERICAN_INDIAN_FEMALES
,      ASIAN_FEMALES
,      BLACK_FEMALES
,      HISPANIC_FEMALES
,      WHITE_FEMALES
,      OTHER_FEMALES
,      AMERICAN_INDIAN_MALES
,      ASIAN_MALES
,      BLACK_MALES
,      HISPANIC_MALES
,      WHITE_MALES
,      OTHER_MALES
FROM APPS.IGW_PRPO_SUBJECT_INFO_V;

Dependencies

[top of page]

APPS.IGW_PRPO_SUBJECT_INFO_V references the following:

APPS: IGW_REPORT_PROCESSING - show dependent code; IGW_STUDY_TITLES

APPS.IGW_PRPO_SUBJECT_INFO_V is not referenced by any database object