[Home] [Help] [Dependency Information]
Object Name: | HRBV_PROPOSAL_QUESTION_MEMBE_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
Proposal question member (from PER_PROPOSAL_QUESTION_MEMBERS table ).
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PROPOSAL_QUESTION_NAME | VARCHAR2 | (60) | Yes | Proposal question name. |
APPROVAL_DISPLAY_STATUS | VARCHAR2 | (30) | Yes | Approval display status. |
FULL_TEXT | VARCHAR2 | (2000) | Full text. | |
ALIGN | VARCHAR2 | (30) | Align. | |
QUESTION_HEADER | VARCHAR2 | (2000) | Question header. | |
HELP_TEXT | VARCHAR2 | (2000) | Help text. | |
NOTE_TEXT | VARCHAR2 | (2000) | Note text. | |
DEFAULT_VALUE_TYPE | VARCHAR2 | (30) | Default value type. | |
DEFAULT_VALUE | VARCHAR2 | (2000) | Default value. | |
LOOKUP_TYPE | VARCHAR2 | (80) | Lookup type. | |
OPTION_SQL_TEXT | VARCHAR2 | (2000) | Option sql text. | |
PROVIDE_FIND | VARCHAR2 | (1) | Provide find. | |
FIND_FILTER_COLUMN | VARCHAR2 | (2000) | Find filter column. | |
FIND_SELECT_SQL | VARCHAR2 | (2000) | Find select sql. | |
QUESTION_DISPLAY_ORDER | NUMBER | (5) | Yes | Question display order. |
TYPE | VARCHAR2 | (30) | Type. | |
PROPOSAL_QUESTION_MEMBER_ID | NUMBER | (15) | Yes | Primary key for PER_PROPOSAL_QUESTION_MEMBERS. |
PROPOSAL_CATEGORY_MEMBER_ID | NUMBER | (15) | Yes | Foreign key to PER_PROPOSAL_CATEGORY_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 |
Cut, paste (and edit) the following text to query this object:
SELECT PROPOSAL_QUESTION_NAME
, APPROVAL_DISPLAY_STATUS
, FULL_TEXT
, ALIGN
, QUESTION_HEADER
, HELP_TEXT
, NOTE_TEXT
, DEFAULT_VALUE_TYPE
, DEFAULT_VALUE
, LOOKUP_TYPE
, OPTION_SQL_TEXT
, PROVIDE_FIND
, FIND_FILTER_COLUMN
, FIND_SELECT_SQL
, QUESTION_DISPLAY_ORDER
, TYPE
, PROPOSAL_QUESTION_MEMBER_ID
, PROPOSAL_CATEGORY_MEMBER_ID
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, CREATION_DATE
, CREATED_BY
FROM APPS.HRBV_PROPOSAL_QUESTION_MEMBE_V;
|
|
|