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.PER_PROPOSAL_QUESTION_MEMBER_V

Object Details

Object Name:	PER_PROPOSAL_QUESTION_MEMBER_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PER.PER_PROPOSAL_QUESTION_MEMBER_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PROPOSAL_QUESTION_MEMBER_ID	NUMBER	(15)	Yes	Question member id
PROPOSAL_QUESTION_NAME	VARCHAR2	(60)	Yes	Question name
PROPOSAL_CATEGORY_MEMBER_ID	NUMBER	(15)	Yes	Category member id
APPROVAL_DISPLAY_STATUS	VARCHAR2	(30)	Yes	Approval display status
FULL_TEXT	VARCHAR2	(2000)		Full text
ALIGN	VARCHAR2	(30)		Alignment
QUESTION_HEADER	VARCHAR2	(2000)		Question heading
HELP_TEXT	VARCHAR2	(2000)		Help text for question
NOTE_TEXT	VARCHAR2	(2000)		Note text
DEFAULT_VALUE_TYPE	VARCHAR2	(30)		Default value for type question
DEFAULT_VALUE	VARCHAR2	(2000)
LOOKUP_TYPE	VARCHAR2	(80)		Lookup type
OPTION_SQL_TEXT	VARCHAR2	(2000)		Option sql text
PROVIDE_FIND	VARCHAR2	(1)
TYPE	VARCHAR2	(30)		Type
FIND_FILTER_COLUMN	VARCHAR2	(2000)
FIND_SELECT_SQL	VARCHAR2	(2000)
QUESTION_DISPLAY_ORDER	NUMBER	(5)	Yes

Query Text

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


SELECT PROPOSAL_QUESTION_MEMBER_ID
,      PROPOSAL_QUESTION_NAME
,      PROPOSAL_CATEGORY_MEMBER_ID
,      APPROVAL_DISPLAY_STATUS
,      FULL_TEXT
,      ALIGN
,      QUESTION_HEADER
,      HELP_TEXT
,      NOTE_TEXT
,      DEFAULT_VALUE_TYPE
,      DEFAULT_VALUE
,      LOOKUP_TYPE
,      OPTION_SQL_TEXT
,      PROVIDE_FIND
,      TYPE
,      FIND_FILTER_COLUMN
,      FIND_SELECT_SQL
,      QUESTION_DISPLAY_ORDER
FROM APPS.PER_PROPOSAL_QUESTION_MEMBER_V;

Dependencies

[top of page]

APPS.PER_PROPOSAL_QUESTION_MEMBER_V references the following:

APPS: PER_PROPOSAL_QUESTION_MEMBERS

APPS.PER_PROPOSAL_QUESTION_MEMBER_V is not referenced by any database object