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

Object Details

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

View Type

MultiLingual view (a language resolved view of the data.)

Translated view of HR_ITEM_PROPERTIES_B and HR_ITEM_PROPERTIES_TL

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Row ID
OBJECT_VERSION_NUMBER	NUMBER
ITEM_PROPERTY_ID	NUMBER	(15)	Yes	System-generated primary key using sequence HR_ITEM_PROPERTIES_B_S
FORM_ITEM_ID	NUMBER	(15)		Foreign key to HR_FORM_ITEMS_B.FORM_ITEM_ID.
TEMPLATE_ITEM_ID	NUMBER	(15)		Foreign key to HR_TEMPLATE_ITEMS_B.TEMPLATE_ITEM_ID.
TEMPLATE_ITEM_CONTEXT_ID	NUMBER	(15)		Foreign key to HR_TEMPLATE_ITEM_CONTEXTS_B.TEMPLATE_ITEM_CONTEXT_ID.
ALIGNMENT	NUMBER	(10)		The text alignment. Valid values are ALIGNMENT_START, ALIGNMENT_END, ALIGNMENT_LEFT, ALIGNMENT_ CENTER, ALIGNMENT_RIGHT. Applies to display item or text item.
BEVEL	NUMBER	(10)		The item border bevel. Valid values are RAISED, LOWERED or PLAIN. Applies to chart item, image item, custom item or text item.
CASE_RESTRICTION	NUMBER	(10)		Specifies the case restriction applied to any text entered in the indicated text item. Valid values are UPPERCASE, LOWERCASE, or NONE. Applies to text item.
DEFAULT_VALUE	VARCHAR2	(2000)		Specifies the default value for the item. If for a number or date item it must be in the canonical format.
ENABLED	NUMBER	(10)		Specifies whether end users should be able to manipulate an item. Valid values are PROPERTY_TRUE and PROPERTY_FALSE. Does not apply to button, chart item or display item.
FORMAT_MASK	VARCHAR2	(80)		Specifies the display format and input accepted. Applies to text item.
HEIGHT	NUMBER	(12)		Specifies the height of the item.
INFORMATION_FORMULA_ID	NUMBER	(15)		Foreign key to FF_FORMULAS.F_FORMULA_ID. Specifies the identifier of the formula to use to supply extra information about the item. The formula will return a text string which will be displayed to the user. Does not apply to button.
INFORMATION_PARAMETER_ITEM_ID1	NUMBER	(15)		Foreign key to HR_FORM_ITEMS_B.FORM_ITEM_ID. The second parameter to pass to the information formula. Applies only when an information formula has been specified.
INFORMATION_PARAMETER_ITEM_ID2	NUMBER	(15)		Foreign key to HR_FORM_ITEMS_B.FORM_ITEM_ID. The third parameter to pass to the information formula. Applies only when an information formula has been specified.
INFORMATION_PARAMETER_ITEM_ID3	NUMBER	(15)		Foreign key to HR_FORM_ITEMS_B.FORM_ITEM_ID. The fourth parameter to pass to the information formula. Applies only when an informationn formula has been specified.
INFORMATION_PARAMETER_ITEM_ID4	NUMBER	(15)		Foreign key to HR_FORM_ITEMS_B.FORM_ITEM_ID. The fifth parameter to pass to the information formula. Applies only when an information formula has been specified.
INFORMATION_PARAMETER_ITEM_ID5	NUMBER	(15)		Foreign key to HR_FORM_ITEMS_B.FORM_ITEM_ID. The sixth parameter to pass to the information formula. Applies only when an information formula has been specified.
INFORMATION_PROMPT	VARCHAR2	(80)		Specifies the text to show in the popup-menu to initiate the information formula. Applies only when an information formula is specified. Must be given in this case.
INSERT_ALLOWED	NUMBER	(10)		In a new record, allows end user to insert items normally when set to PROPERTY_TRUE. Specify PROPERTY_FALSE to specify that the item does not accept modification, but is displayed normally. Applies to check box, custom item, image item, radio button, list item or text item.
LABEL	VARCHAR2	(80)		Specifies the VARCHAR2 string that you want displayed as the label of the item. Applies to button, check box or radio group button.
PROMPT_ALIGNMENT_OFFSET	NUMBER	(12)		Determines the distance between the item and its prompt.
PROMPT_DISPLAY_STYLE	NUMBER	(10)		Determines the prompt's display style, either PROMPT_FIRST_RECORD, PROMPT_HIDDEN or PROMPT_ALL_RECORDS.
PROMPT_EDGE	NUMBER	(10)		Determines to which edge the prompt is attached. May be START_EDGE, END_EDGE, TOP_EDGE or BOTTOM_EDGE.
PROMPT_EDGE_ALIGNMENT	NUMBER	(10)		Determines to which edge the items prompt is aligned. May be ALIGNMENT_START, ALIGNMENT_END or ALIGNMENT_CENTER.
PROMPT_EDGE_OFFSET	NUMBER	(12)		Determines the distance between the item and its prompt.
PROMPT_TEXT	VARCHAR2	(80)		Determines the text label that displays for an item.
PROMPT_TEXT_ALIGNMENT	NUMBER	(10)		Determines how the prompt is justified. May be ALIGNMENT_START, ALIGNMENT_LEFT, ALIGNMENT_RIGHT, ALIGNMENT_CENTER or ALIGNMENT_END.
QUERY_ALLOWED	NUMBER	(10)		Specify the constant PROPERTY_TRUE if you want the end user to be able to initiate a query against the item. Specify the constant PROPERTY_FALSE if you want to disallow the use of the item in a query. Does not apply to button, chart item or image item.
TOOLTIP_TEXT	VARCHAR2	(80)		Determines the ballon text for an item
REQUIRED	NUMBER	(10)		Specify the constant PROPERTY_TRUE if you want to force the end user to enter a value for the item. Specify the constant PROPERTY_FALSE if the item is not to be required. Applies to list item or text item.
UPDATE_ALLOWED	NUMBER	(10)		Specify the constant PROPERTY_TRUE if you want the end user to be able to update the item. Specify the constant PROPERTY_FALSE if you want the item protected from update. Does not apply to button, chart item or image item.
VALIDATION_FORMULA_ID	NUMBER	(15)		Foreign key to FF_FORMULAS_F.FORMULA_ID. Specifies the identifier of the formula to use to augment the default validation of the item. This first parameter to the formula will always be the item it is associated with. Does not apply to button, chart item or image item.
VALIDATION_PARAMETER_ITEM_ID1	NUMBER	(15)		Foreign key to HR_FORM_ITEMS_B.FORM_ITEM_ID. The second parameter to pass to the validation formula. Applies only when a validation formula has been specified.
VALIDATION_PARAMETER_ITEM_ID2	NUMBER	(15)		Foreign key to HR_FORM_ITEMS_B.FORM_ITEM_ID. The third parameter to pass to the validation formula. Applies only when a validation formula has been specified.
VALIDATION_PARAMETER_ITEM_ID3	NUMBER	(15)		Foreign key to HR_FORM_ITEMS_B.FORM_ITEM_ID. The fourth parameter to pass to the validation formula. Applies only when a validation formula has been specified.
VALIDATION_PARAMETER_ITEM_ID4	NUMBER	(15)		Foreign key to HR_FORM_ITEMS_B.FORM_ITEM_ID. The fifth parameter to pass to the validation formula. Applies only when a validation formula has been specified.
VALIDATION_PARAMETER_ITEM_ID5	NUMBER	(15)		Foreign key to HR_FORM_ITEMS_B.FORM_ITEM_ID. The sixth parameter to pass to the validation formula. Applies only when a validation formula has been specified.
VISIBLE	NUMBER	(10)		Specifies whether the indicated item should be visible or hidden. Valid values are PROPERTY_TRUE and PROPERTY_FALSE.
WIDTH	NUMBER	(12)		Specifies the width of the item.
X_POSITION	NUMBER	(12)		Specifies the x coordinate of the item.
Y_POSITION	NUMBER	(12)		Specifies the y coordinate of the item.
INFORMATION_CATEGORY	VARCHAR2	(150)		Developer descriptive flexfield column
INFORMATION1	VARCHAR2	(150)		Developer descriptive flexfield column
INFORMATION2	VARCHAR2	(150)		Developer descriptive flexfield column
INFORMATION3	VARCHAR2	(150)		Developer descriptive flexfield column
INFORMATION4	VARCHAR2	(150)		Developer descriptive flexfield column
INFORMATION5	VARCHAR2	(150)		Developer descriptive flexfield column
INFORMATION6	VARCHAR2	(150)		Developer descriptive flexfield column
INFORMATION7	VARCHAR2	(150)		Developer descriptive flexfield column
INFORMATION8	VARCHAR2	(150)		Developer descriptive flexfield column
INFORMATION9	VARCHAR2	(150)		Developer descriptive flexfield column
INFORMATION10	VARCHAR2	(150)		Developer descriptive flexfield column
INFORMATION11	VARCHAR2	(150)		Developer descriptive flexfield column
INFORMATION12	VARCHAR2	(150)		Developer descriptive flexfield column
INFORMATION13	VARCHAR2	(150)		Developer descriptive flexfield column
INFORMATION14	VARCHAR2	(150)		Developer descriptive flexfield column
INFORMATION15	VARCHAR2	(150)		Developer descriptive flexfield column
INFORMATION16	VARCHAR2	(150)		Developer descriptive flexfield column
INFORMATION17	VARCHAR2	(150)		Developer descriptive flexfield column
INFORMATION18	VARCHAR2	(150)		Developer descriptive flexfield column
INFORMATION19	VARCHAR2	(150)		Developer descriptive flexfield column
INFORMATION20	VARCHAR2	(150)		Developer descriptive flexfield column
INFORMATION21	VARCHAR2	(150)		Developer descriptive flexfield column
INFORMATION22	VARCHAR2	(150)		Developer descriptive flexfield column
INFORMATION23	VARCHAR2	(150)		Developer descriptive flexfield column
INFORMATION24	VARCHAR2	(150)		Developer descriptive flexfield column
INFORMATION25	VARCHAR2	(150)		Developer descriptive flexfield column
INFORMATION26	VARCHAR2	(150)		Developer descriptive flexfield column
INFORMATION27	VARCHAR2	(150)		Developer descriptive flexfield column
INFORMATION28	VARCHAR2	(150)		Developer descriptive flexfield column
INFORMATION29	VARCHAR2	(150)		Developer descriptive flexfield column
INFORMATION30	VARCHAR2	(150)		Developer descriptive flexfield column
LAST_UPDATE_DATE	DATE			Standard Who column.
LAST_UPDATED_BY	NUMBER	(15)		Standard Who column.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column.
CREATED_BY	NUMBER	(15)		Standard Who column.
CREATION_DATE	DATE			Standard Who column.
NEXT_NAVIGATION_ITEM_ID	NUMBER	(15)		Foreign key to HR_TEMPLATE_ITEMS_B.
PREVIOUS_NAVIGATION_ITEM_ID	NUMBER	(15)		Foreign key to HR_TEMPLATE_ITEMS_B.

Query Text

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


SELECT ROW_ID
,      OBJECT_VERSION_NUMBER
,      ITEM_PROPERTY_ID
,      FORM_ITEM_ID
,      TEMPLATE_ITEM_ID
,      TEMPLATE_ITEM_CONTEXT_ID
,      ALIGNMENT
,      BEVEL
,      CASE_RESTRICTION
,      DEFAULT_VALUE
,      ENABLED
,      FORMAT_MASK
,      HEIGHT
,      INFORMATION_FORMULA_ID
,      INFORMATION_PARAMETER_ITEM_ID1
,      INFORMATION_PARAMETER_ITEM_ID2
,      INFORMATION_PARAMETER_ITEM_ID3
,      INFORMATION_PARAMETER_ITEM_ID4
,      INFORMATION_PARAMETER_ITEM_ID5
,      INFORMATION_PROMPT
,      INSERT_ALLOWED
,      LABEL
,      PROMPT_ALIGNMENT_OFFSET
,      PROMPT_DISPLAY_STYLE
,      PROMPT_EDGE
,      PROMPT_EDGE_ALIGNMENT
,      PROMPT_EDGE_OFFSET
,      PROMPT_TEXT
,      PROMPT_TEXT_ALIGNMENT
,      QUERY_ALLOWED
,      TOOLTIP_TEXT
,      REQUIRED
,      UPDATE_ALLOWED
,      VALIDATION_FORMULA_ID
,      VALIDATION_PARAMETER_ITEM_ID1
,      VALIDATION_PARAMETER_ITEM_ID2
,      VALIDATION_PARAMETER_ITEM_ID3
,      VALIDATION_PARAMETER_ITEM_ID4
,      VALIDATION_PARAMETER_ITEM_ID5
,      VISIBLE
,      WIDTH
,      X_POSITION
,      Y_POSITION
,      INFORMATION_CATEGORY
,      INFORMATION1
,      INFORMATION2
,      INFORMATION3
,      INFORMATION4
,      INFORMATION5
,      INFORMATION6
,      INFORMATION7
,      INFORMATION8
,      INFORMATION9
,      INFORMATION10
,      INFORMATION11
,      INFORMATION12
,      INFORMATION13
,      INFORMATION14
,      INFORMATION15
,      INFORMATION16
,      INFORMATION17
,      INFORMATION18
,      INFORMATION19
,      INFORMATION20
,      INFORMATION21
,      INFORMATION22
,      INFORMATION23
,      INFORMATION24
,      INFORMATION25
,      INFORMATION26
,      INFORMATION27
,      INFORMATION28
,      INFORMATION29
,      INFORMATION30
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      NEXT_NAVIGATION_ITEM_ID
,      PREVIOUS_NAVIGATION_ITEM_ID
FROM APPS.HR_ITEM_PROPERTIES_VL;

Dependencies

[top of page]

APPS.HR_ITEM_PROPERTIES_VL references the following:

APPS: HR_ITEM_PROPERTIES_B; HR_ITEM_PROPERTIES_TL

APPS.HR_ITEM_PROPERTIES_VL is referenced by following:

APPS: HR_FORM_ITEMS; HR_ITEM_PROPERTIES_PKG - show dependent code; HR_TEMPLATE_ITEMS; HR_TEMPLATE_ITEM_CONTEXTS