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

Object Details

Object Name:	HRBV_PROPOSAL_QUESTIONS_ADV_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

Proposal questions advance (from PER_PROPOSAL_QUESTIONS_ADV table ).

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
REQUIRED	VARCHAR2	(30)		(Lookup code based on lookup type YES_NO).
REQUIRED_M	VARCHAR2	(4000)		(Lookup meaning based on lookup type YES_NO).
DATA_TYPE	VARCHAR2	(30)		(Lookup code based on lookup type WEB_DATA_TYPE).
DATA_TYPE_M	VARCHAR2	(4000)		(Lookup meaning based on lookup type WEB_DATA_TYPE).
ENABLE_VALIDATION	VARCHAR2	(30)		(Lookup code based on lookup type YES_NO).
ENABLE_VALIDATION_M	VARCHAR2	(4000)		(Lookup meaning based on lookup type YES_NO).
TYPE	VARCHAR2	(30)		Type.
PROPOSAL_QUESTION_ADV_ID	NUMBER	(15)	Yes	Primary key for PER_PROPOSAL_QUESTIONS_ADV
PROPOSAL_QUESTION_MEMBER_ID	NUMBER	(15)	Yes	Foreign key to PER_PROPOSAL_QUESTION_MEMBERS.
REQUIRED_QUESTION_MEMBER_ID	NUMBER	(15)		Foreign key to PER_PROPOSAL_QUESTION_MEMBERS.
EXCLUSIVE_QUESTION_MEMBER_ID	NUMBER	(15)		Foreign key to PER_PROPOSAL_QUESTION_MEMBERS.
LAST_UPDATED_BY	NUMBER	(15)		Standard who column
LAST_UPDATE_DATE	DATE			Standard who column
CREATION_DATE	DATE			Standard who column
CREATED_BY	NUMBER	(15)		Standard who column

Query Text

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


SELECT REQUIRED
,      REQUIRED_M
,      DATA_TYPE
,      DATA_TYPE_M
,      ENABLE_VALIDATION
,      ENABLE_VALIDATION_M
,      TYPE
,      PROPOSAL_QUESTION_ADV_ID
,      PROPOSAL_QUESTION_MEMBER_ID
,      REQUIRED_QUESTION_MEMBER_ID
,      EXCLUSIVE_QUESTION_MEMBER_ID
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      CREATION_DATE
,      CREATED_BY
FROM APPS.HRBV_PROPOSAL_QUESTIONS_ADV_V;

Dependencies

[top of page]

APPS.HRBV_PROPOSAL_QUESTIONS_ADV_V references the following:

APPS: HR_BIS - show dependent code; PER_PROPOSAL_QUESTIONS_ADV

APPS.HRBV_PROPOSAL_QUESTIONS_ADV_V is not referenced by any database object