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_YN_RESPONSES_V

Object Details

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

View Type

A Business Intelligence System view

IGW_PRPO_YN_RESPONSES_V displays answers to questions about individuals, the proposal, and the organization. This view is used in generating a flat file for Electronic Data Interchange.

[View Source]

Columns

Name	Datatype	Length
PROPOSAL_ID	NUMBER	(15)
ORGANIZATION_ID	NUMBER
PERSON_ID	NUMBER
PERSON_PARTY_ID	NUMBER
QUESTION_APPLIES_TO	CHAR	(1)
QUESTION_NUMBER	VARCHAR2	(5)
RESPONSE	VARCHAR2	(1)
EXPLANATION	VARCHAR2	(800)
REVIEW_DATE	DATE

Query Text

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


SELECT PROPOSAL_ID
,      ORGANIZATION_ID
,      PERSON_ID
,      PERSON_PARTY_ID
,      QUESTION_APPLIES_TO
,      QUESTION_NUMBER
,      RESPONSE
,      EXPLANATION
,      REVIEW_DATE
FROM APPS.IGW_PRPO_YN_RESPONSES_V;

Dependencies

[top of page]

APPS.IGW_PRPO_YN_RESPONSES_V references the following:

APPS: IGW_ORG_QUESTIONS; IGW_PROPOSALS; IGW_PROP_PERSON_QUESTIONS; IGW_PROP_QUESTIONS

APPS.IGW_PRPO_YN_RESPONSES_V is not referenced by any database object