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: IGW.IGW_QUESTIONS

Object Details

Object Name:	IGW_QUESTIONS
Object Type:	TABLE
Owner:	IGW
FND Design Data:	IGW.IGW_QUESTIONS
Subobject Name:
Status:	VALID

IGW_QUESTIONS stores information about all questions pertaining to individuals, proposals, and organizations. It also contains information about which questions need an explanation and
review date to accompany the answer. For example, if the EXPLANATION_FOR_YES_FLAG is Y
and the answer to the question is Yes, the user must provide an explanation for the
answer.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGW_QUESTIONS_U1	NORMAL	UNIQUE	APPS_TS_SEED	QUESTION_NUMBER

Columns

Name	Datatype	Length	Mandatory	Comments
QUESTION_NUMBER	VARCHAR2	(5)	Yes	Question number
APPLIES_TO	VARCHAR2	(1)	Yes	Identifies to whom the question applies. Possible choices are I for Individual, P for Proposal, and O for Organization.
EXPLANATION_FOR_YES_FLAG	VARCHAR2	(1)	Yes	Flag determines whether an explanation is required if the answer to the question is Yes. Possible values are Y or N.
EXPLANATION_FOR_NO_FLAG	VARCHAR2	(1)	Yes	Flag determines whether an explanation is required if the answer to the question is No. Possible values are Y or N.
DATE_FOR_YES_FLAG	VARCHAR2	(1)	Yes	Flag determines whether a date is required if the answer to the question is Yes. Possible values are Y or N.
DATE_FOR_NO_FLAG	VARCHAR2	(1)	Yes	Flag determines whether a date is required if the answer to the question is No. Possible values are Y or N.
START_DATE_ACTIVE	DATE		Yes	First effective date for the question
END_DATE_ACTIVE	DATE			Last effective date for the question
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	Standard Who column

Query Text

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


SELECT QUESTION_NUMBER
,      APPLIES_TO
,      EXPLANATION_FOR_YES_FLAG
,      EXPLANATION_FOR_NO_FLAG
,      DATE_FOR_YES_FLAG
,      DATE_FOR_NO_FLAG
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
FROM IGW.IGW_QUESTIONS;

Dependencies

[top of page]

IGW.IGW_QUESTIONS does not reference any database object

IGW.IGW_QUESTIONS is referenced by following:

APPS: IGW_QUESTIONS